CData Software - Knowledge Base
Recent Articles
-
Automated Freshservice Data Replication to Teradata
Use CData Sync to Customize and automate Freshservice replication to Teradata.
-
Create Shopify-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Shopify Data from OutSystems and build custom enterprise apps using live Shopify.
-
Query SAP BusinessObjects BI Data in DataGrip
Create a Data Source for SAP BusinessObjects BI in DataGrip and use SQL to query live SAP BusinessObjects BI.
-
Getting Started with the CData ODBC Driver for SFTP
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SFTP.
-
Visualize MessageBird Data in Sisense
Create an ElastiCube in Sisense app with access to MessageBird.
-
Natively Connect to Telegram Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Telegram. Leverage the native support for ODBC in PHP.
-
How to connect to EmailOctopus Data from Spring Boot
Connect to EmailOctopus in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze Facebook Ads Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Facebook Ads in Microsoft R Open.
-
Connect ZohoExpense to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZohoExpense with IBM WebSphere for seamless data integration and connectivity.
-
Connect to SQL Server Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Microsoft Ads Data in RazorSQL
Connect to Microsoft Ads from wizards and query Microsoft Ads from the GUI in the RazorSQL database management tool.
-
How to Query Splunk Data in MySQL Workbench
Execute MySQL queries against live Splunk from MySQL Workbench.
-
Query Pingdom Data in DataGrip
Create a Data Source for Pingdom in DataGrip and use SQL to query live Pingdom.
-
Access Azure Data Lake Storage Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Data Lake Storage from your Oracle system.
-
Rapidly Develop Gumroad-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Gumroad.
-
Consume ActiveCampaign OData Feeds in PowerBuilder
This article demonstrates how to consume ActiveCampaign as OData feeds from PowerBuilder using the API Server.
-
Model Salesforce CRM Analytics Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Salesforce CRM Analytics, enabling the direct import of real-time Salesforce CRM Analytics.
-
Automated Continuous Notion Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Notion replication to Google Cloud SQL.
-
How to create Visio diagrams from Paylocity Data
Automatically update Paylocity with the changes you make to Visio master shapes.
-
Create SSAS Tabular Models from Azure DevOps Data
How to build a SQL Server Analysis Service Tabular Model from Azure DevOps using CData drivers.
-
Create Power BI Reports on Real-Time WooCommerce Data
Use the CData ODBC Driver for WooCommerce to visualize WooCommerce in Power BI Desktop.
-
Query Chargebee Data as a MySQL Database in Node.js
Execute MySQL queries against Chargebee from Node.js.
-
Automate MYOB AccountRight Data Replication to Couchbase
Use CData Sync to Customize and automate MYOB AccountRight replication to Couchbase.
-
Establish a Live Connection with Microsoft Entra ID Data using Tableau Bridge
The CData ODBC Driver for Microsoft Entra ID enables you to integrate live Microsoft Entra ID into Tableau Cloud dashboards using the Tableau Bridge.
-
Create a Data Access Object for Google Ad Manager Data using JDBI
A brief overview of creating a SQL Object API for Google Ad Manager in JDBI.
-
Connect to Attio Data from a Connection Pool in Jetty
The Attio JDBC Driver supports connection pooling: This article shows how to connect faster to Attio from Web apps in Jetty.
-
Create Informatica Mappings From/To an ODBC Data Source for Optimizely
Create an ODBC connection to Optimizely in Informatica and browse and transfer Optimizely.
-
Integrating Todoist Data in Talend Cloud Data Management Platform
Connect Todoist Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Apollo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apollo in the Denodo Virtual DataPort Administrator.
-
Connect to Factorial Data from a Connection Pool in JBoss
Integrate Factorial into Java servlets: Use the Management Console in JBoss to install the Factorial JDBC Driver.
-
Analyze FreshBooks Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze FreshBooks with the CData JDBC Driver for FreshBooks.
-
Access Live Presto Data in TIBCO Data Virtualization
Use the Presto Tibco DV Adapter to create a Presto data source in TIBCO Data Virtualization Studio and gain access to live Presto from your TDV Server.
-
Build Agents in Relevance AI with Access to Live PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on PostgreSQL within intelligent agent workflows.
-
Automate Presto Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Presto and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to connect to SharePoint Data in DBVisualizer
Integrate Microsoft SharePoint with visual data analysis tools and data connection wizards in DBVisualizer
-
Choosing the Best Method to Connect Timely to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Timely from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData Excel Add-In for GitHub
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for GitHub.
-
Automated Continuous Adobe Commerce Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to OneLake in Microsoft Fabric.
-
Connect to NetSuite Data from AWS Glue
Use CData Connect AI to gain access to live NetSuite CRM & ERP from your AWS Glue jobs.
-
DataBind Charts to Azure Synapse Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Synapse from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Create Salesforce CRM Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce CRM Analytics data access from reports, embedded analytics, and more.
-
Bidirectional Access to Exa Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Exa in Filemaker Pro for Mac or Windows.
-
Access Live Shippo Data in AWS Lambda
Connect to live Shippo in AWS Lambda using the CData JDBC Driver.
-
Integrate Theia IDE with Live Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Connect to Live Facebook Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Facebook for you.
-
How to create an RPA flow for Landbot Data in UiPath Studio
Use the Landbot ODBC Driver to create workflows that access real-time Landbot without any coding.
-
Use Agno to Talk to Your Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Databricks for you.
-
Create Highrise Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Highrise data access from reports, embedded analytics, and more.
-
Object-Relational Mapping (ORM) with Datadog Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Datadog into a Java-based ORM framework, Hibernate.
-
Query, Visualize, and Share live Instagram Data in Redash
Use CData Connect AI to connect to live Instagram in Redash for querying, visualizing, and sharing.
-
Automated Continuous Access Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Access replication to Amazon Redshift.
-
How to create QuickBooks Time federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for QuickBooks Time in MySQL .
-
Import Real-Time Pipeliner CRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Pipeliner CRM in ColdFusion.
-
Integrating OpenCode Terminal with OnePageCrm Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Use Biml to Build SSIS Tasks to Replicate Deel Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Deel to SQL Server.
-
Natively Connect to Onfleet Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Onfleet. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Exact Online Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Exact Online for you.
-
Create a Data Access Object for Shortcut Data using JDBI
A brief overview of creating a SQL Object API for Shortcut in JDBI.
-
Getting Started with the CData Power BI Connector for ZohoDesk
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Access Live Cassandra Data in Visual Studio Code via Cline
Run CData MCP Server for Cassandra on Windows Subsytem for Linux (WSL) and connect to live Apache Cassandra from the Cline extension in Visual Studio Code.
-
Connect NASA Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your NASA using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating Claude Code with IBM Informix Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on IBM Informix within assisted coding and automated development workflows.
-
How to Connect to & Open LaunchDarkly Data in Microsoft Excel
This article uses the CData ODBC driver for LaunchDarkly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Azure Data Lake Storage Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Azure Data Lake Storage and visualize live Azure Data Lake Storage in Infragistics Reveal.
-
Use the CData Software ODBC Driver for Browserless in MicroStrategy Web
Connect to Browserless in MicroStrategy Web using the CData Software ODBC Driver for Browserless.
-
Connect to Live Email Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Email in CData Connect AI and connect to your Email from PostgreSQL.
-
Analyze MarkLogic Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MarkLogic and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use Biml to Build SSIS Tasks to Replicate SAP HANA Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP HANA to SQL Server.
-
Build Voice Agents in ElevenLabs with access to Live SQL Server Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft SQL Server.
-
Operational Reporting on Pipedrive Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pipedrive.
-
Automated Continuous MarkLogic Replication to Snowflake
Use CData Sync for automated, continuous, customizable MarkLogic replication to Snowflake.
-
Getting Started with the CData Tableau Connector for Stack Exchange
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Access Live SAP Fieldglass Data in Visual Studio Code via Cline
Run CData MCP Server for SAP Fieldglass on Windows Subsytem for Linux (WSL) and connect to live SAP Fieldglass from the Cline extension in Visual Studio Code.
-
Viewing SAP Business Warehouse Data in RAD Studio Data Explorer
How to view SAP Business Warehouse in RAD Studio Data Explorer using the CData ODBC Driver for SAP Business Warehouse.
-
Connect to Campaigner Data in Aqua Data Studio
Access Campaigner from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Prepare, Blend, and Analyze Apify Data in Alteryx Designer (ODBC)
Build workflows to access live Apify for self-service data analytics.
-
Create Power BI Reports on Real-Time FreshBooks Data
Use the CData ODBC Driver for FreshBooks to visualize FreshBooks in Power BI Desktop.
-
Create Apps from Amazon DynamoDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to Amazon DynamoDB Data and build apps from live Amazon DynamoDB in Qlik Sense Cloud.
-
Visualize Live Tickspot Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Tickspot.
-
Consume SAP Ariba Source OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Ariba Source feeds that reflect any changes in SAP Lumira.
-
Integrate Freshdesk with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Freshdesk with External Services.
-
Build Charts with Eventbrite Data in Clear Analytics
Create dynamic charts and perform analytics based on Eventbrite in Clear Analytics.
-
Automated Continuous Harvest Replication to Databricks
Use CData Sync for automated, continuous, customizable Harvest replication to Databricks.
-
Analyze Mixpanel Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Mixpanel from Power Pivot. You will use the Table Import Wizard to load Mixpanel. You can visually build the import query or use any SQL supported by the driver.
-
Access Dynamics CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dynamics CRM from HeidiSQL.
-
Configure the CData JDBC Driver for Tally in a Connection Pool in Tomcat
Connect to Tally ERP from a connection pool in Tomcat.
-
Analyze Zoho Recruit Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Recruit from Power Pivot. You will use the Table Import Wizard to load Zoho Recruit. You can visually build the import query or use any SQL supported by the driver.
-
Working with Discord Data in LINQPad
Execute LINQ queries to Discord in LINQPad.
-
Build Microsoft Entra ID-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Entra ID and build web apps with connectivity to live Microsoft Entra ID.
-
Integrating Kiro CLI with Coda Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Visualize Optimizely Data in Tableau
The CData ODBC driver for Optimizely enables you integrate Optimizely into Tableau dashboards.
-
How to Query Live Microsoft OneDrive Data in Perplexity MacOS Desktop
Connect to and query live Microsoft OneDrive Data in Perplexity Desktop using CData MCP Server.
-
Deploy the ADO.NET Provider for Spark on an SSRS Report Server
Connect to Apache Spark SQL from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use Biml to Build SSIS Tasks to Replicate ZeroBounce Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZeroBounce to SQL Server.
-
Integrating Dataiku with Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Sage 200.
-
Automated Continuous ZohoInvoice Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to AlloyDB.
-
How to Query Live Tickspot Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Tickspot data in natural language using Python.
-
How to connect Amazon QuickSight to OneNote Data
Create a connection to Microsoft OneNote in CData Connect AI and insert Microsoft OneNote into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Azure Synapse Data in Claris FileMaker Pro
Use the CData ODBC Driver for Azure Synapse in FileMaker Pro to connect to Azure Synapse and work with Azure Synapse in your FileMaker applications.
-
How to Connect to Live Klaviyo Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Klaviyo securely in real time.