CData Software - Knowledge Base
Recent Articles
-
Integrating OpenCode with FTP 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.
-
How to connect Amazon QuickSight to Yelp Data
Create a connection to Yelp data in CData Connect AI and insert Yelp data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate GraphQL Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to GraphQL data and integrate live GraphQL data into your Power Automate tasks.
-
Connect to Live Oracle Service Cloud Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle Service Cloud in CData Connect AI and connect to your Oracle Service Cloud data from PostgreSQL.
-
Analyze Raisers Edge NXT Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Raisers Edge NXT from Power Pivot. You will use the Table Import Wizard to load Raisers Edge NXT data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Pipedrive Replication to SQL Server
Use CData Sync for automated, continuous, customizable Pipedrive replication to SQL Server.
-
Moving Data from ZohoMarketingHub to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZohoMarketingHub data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Manus AI to Talk to Your Bright Data Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Bright Data data.
-
Integrating Claude Code CLI with Gong 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.
-
Automated Continuous Instagram Replication to MongoDB
Use CData Sync for automated, continuous, customizable Instagram replication to MongoDB.
-
Automated Continuous Intercom Replication to SQL Server
Use CData Sync for automated, continuous, customizable Intercom replication to SQL Server.
-
Publish Reports with SFTP Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SFTP data.
-
Easily Integrate MariaDB Data in Lazarus Pascal IDE
Learn how to easily integrate live MariaDB data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Publish Google Ad Manager-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Ad Manager data.
-
Validate Todoist Data with QuerySurge
Access and validate Todoist data in QuerySurge using the CData JDBC Driver.
-
Create Vertica-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Vertica Data from Klipfolio and build custom visualizations using live Vertica data.
-
Build MVC Applications with Connectivity to Typeform Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Typeform from an ASP.NET MVC application.
-
Connect to Microsoft Exchange Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Exchange data from your AWS Glue jobs.
-
How to create Outreach.io federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Outreach.io data in MySQL .
-
How to connect and process Certinia data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Certinia data.
-
How to connect and process Float data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Float data.
-
Build Google Ad Manager Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Ad Manager data and build visualizations in Tableau.
-
Use the CData Software JDBC Driver for Couchbase in MicroStrategy
Connect to Couchbase data in MicroStrategy Developer using the CData Software JDBC Driver for Couchbase.
-
How to Easily Query Drip Data in OpenOffice Base
Connect to Drip data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build Telegram-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Telegram data.
-
DataBind Dotmailer Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Dotmailer data to a chart.
-
Build a Simple VCL Application for Planio Data
How to build a simple VCL Application to view Planio data in RAD Studio using the CData ODBC Driver for Planio.
-
Connect to CockroachDB Data in JRuby
Create a simple JRuby app with access to live CockroachDB data.
-
Access ConvertKit Data from MySQL in PHP
Connect to ConvertKit through the standard MySQL libraries in PHP.
-
Create Basecamp-Connected Applications in Appsmith
Connect to Basecamp Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Basecamp data.
-
Integrate GitLab Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to GitLab data and integrate live GitLab data into your Power Automate tasks.
-
Connect to Real-Time Guru Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Guru data in Power Apps.
-
Automated Continuous Sybase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sybase replication to Apache Cassandra.
-
How to Work with CockroachDB Data in ETL Validator JDBC
Connect to CockroachDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Flowlu Replication to Oracle
Use CData Sync for automated, continuous, customizable Flowlu replication to Oracle.
-
Query Live GitLab Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live GitLab data through a conversational interface.
-
Build Automated Workflows with Live Power BI XMLA Data in Workato
Use CData Connect AI to connect to live Power BI XMLA data and build automated workflows in Workato.
-
Integrate Theia IDE with Live CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live CouchDB data from within the development environment.
-
How to Connect to & Open Cosmos DB Data in Microsoft Excel
This article uses the CData ODBC driver for Cosmos DB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Operational Reporting on Azure Synapse Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Azure Synapse data.
-
Integrate Accelo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Accelo data from Informatica Cloud.
-
Amazon DynamoDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Amazon DynamoDB facts in real time.
-
Create Dynamic Microsoft Entra ID Grids Using the Infragistics XamDataGrid
Learn how you can connect Microsoft Entra ID to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Live GitLab Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live GitLab data from within the IDE.
-
Connect to QuickBooks Data from HeidiSQL
Use CData Connect AI to connect to and query live QuickBooks data from HeidiSQL.
-
Build SAS Data Sets-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAS Data Sets Data from Zoho Analytics and import live SAS Data Sets data.
-
Connect to Oracle Financials Cloud Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle Financials Cloud data in Airbyte.
-
Access Live Foursquare Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Foursquare data into the statistical analysis tools available in SAS JMP. This article shows how to use Foursquare data in the Graph Builder and Query Builder.
-
Stream Zoho Recruit Data into Apache Kafka Topics
Access and stream Zoho Recruit data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Model Couchbase Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Couchbase, enabling the direct import of real-time Couchbase data.
-
Integrate Dynamics 365 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Dynamics 365 with External Services.
-
Connect to Tally Data in Aqua Data Studio
Access Tally data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Campaign Manager 360
Create an ODBC connection to Google Campaign Manager 360 in Informatica and browse and transfer Google Campaign Manager 360 data.
-
How to use SQLAlchemy ORM to access Snowflake Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Snowflake data.
-
Load Freshsales Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Freshsales data to a database.
-
Create Reports with Exact Online Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Exact Online data.
-
Use the CData Software JDBC Driver for Figshare in MicroStrategy Desktop
Connect to Figshare data in MicroStrategy Desktop using the CData Software JDBC Driver for Figshare.
-
Use the CData Software ODBC Driver for ZarMoney in SAS for Real-Time Reporting and Analytics
Connect to real-time ZarMoney data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZarMoney.
-
Access Live Acumatica Data in TIBCO Data Virtualization
Use the Acumatica Tibco DV Adapter to create a Acumatica data data source in TIBCO Data Virtualization Studio and gain access to live Acumatica data from your TDV Server.
-
Object-Relational Mapping (ORM) with LightSpeedRetail 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 LightSpeedRetail data into a Java-based ORM framework, Hibernate.
-
Use Biml to Build SSIS Tasks to Replicate Teamgate Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Teamgate data to SQL Server.
-
DataBind Charts to MYOB AccountRight Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MYOB AccountRight data 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.
-
How to Connect the Power BI Service to Samanage: Complete Guide
Connect to the CData Software Power BI Connector for Samanage from PowerBI.com to provide real-time Samanage data across the organization.
-
How to Work with Perigon Data in ETL Validator JDBC
Connect to Perigon from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect PolyBase to Dynamics 365
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Dynamics 365 data.
-
Use the CData SSIS Components to Insert New or Update Existing Cassandra Records from SQL Server
Easily push SQL Server data to Cassandra using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Cassandra or update existing records with data from a SQL Server database.
-
Connect to SAP ByDesign Data from a Connection Pool in Jetty
The SAP ByDesign JDBC Driver supports connection pooling: This article shows how to connect faster to SAP ByDesign data from Web apps in Jetty.
-
Object-Relational Mapping (ORM) with Freshdesk 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 Freshdesk data into a Java-based ORM framework, Hibernate.
-
Integrate with live Oracle Sales Data in Jitterbit
Use CData Connect AI to connect to and integrate live Oracle Sales data in Jitterbit.
-
Use the CData Software ODBC Driver for Customer.io in SAS for Real-Time Reporting and Analytics
Connect to real-time Customer.io data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Customer.io.
-
Integrating OpenCode with Authorize.Net 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.
-
Integrate Asana Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Asana data and integrate live Asana data into your Power Automate tasks.
-
How to Build an ETL App for MYOB AccountRight Data in Python with CData Connect AI
Build ETL pipelines that read and write live MYOB AccountRight data in Python with petl and the CData Connect AI Python SDK.
-
Integrating Antigravity CLI with Supabase data via CData CLI
Connect Supabase data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Reports with QuickBooks Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date QuickBooks data.
-
Connect to Miro Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Miro as an External Source in Dremio.
-
How to update EnterpriseDB from Excel
This article explains how to transfer data from Excel to EnterpriseDB using the Excel Add-In for EnterpriseDB.
-
Connect to Workable Data in DBArtisan
Use wizards in DBArtisan to configure Workable data as a data source.
-
Access Live ZohoDesk Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live ZohoDesk data through MCP integration.
-
Connect and Query Live ActiveCampaign Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ActiveCampaign data into Databricks and enable direct, live querying and analysis without replication.
-
Automate OneNote Data Replication to Azure Data Lake
Use CData Sync to customize and automate OneNote data replication to Azure Data Lake.
-
Automated Continuous ZohoPeople Replication to SQL Server
Use CData Sync for automated, continuous, customizable ZohoPeople replication to SQL Server.
-
Integrate SharePoint Data in the Pentaho Report Designer
Publish reports based on SharePoint data in the Pentaho BI tool.
-
How to Connect the Power BI Service to Zoho Inventory: Complete Guide
Connect to the CData Software Power BI Connector for Zoho Inventory from PowerBI.com to provide real-time Zoho Inventory data across the organization.
-
Create BigQuery-Connected Applications in Appsmith
Connect to BigQuery Data via CData Connect AI in Appsmith and create custom business applications with real-time access to BigQuery data.
-
Access Live DocuSign Data in AWS Lambda
Connect to live DocuSign data in AWS Lambda using the CData JDBC Driver.
-
Prepare, Blend, and Analyze Recurly Data in Alteryx Designer (ODBC)
Build workflows to access live Recurly data for self-service data analytics.
-
Automated Continuous Avaza Replication to Vertica
Use CData Sync for automated, continuous, customizable Avaza replication to Vertica.
-
How to Access Live ZohoSubscriptions Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ZohoSubscriptions enables you to integrate ZohoSubscriptions data into workflows built using Microsoft Power Automate Desktop.
-
Moving Data from Discord to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Discord data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connecting Mastra with DocuSign Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time DocuSign data, no replication required.
-
Use CData Connect AI to Access Certinia Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Certinia data in the Power Pivot business intelligence tool.
-
Connect to Sage Intacct Data in Google Apps Script via Connect AI
Use CData Connect AI to access Sage Intacct data in Google Apps Script.
-
Edit and Search External Office 365 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Office 365 data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Office 365 Data objects that you can access from apps and the dashboard.
-
Use Biml to Build SSIS Tasks to Replicate Jira Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Jira data to SQL Server.
-
Build Zoho CRM-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zoho CRM Data from Zoho Analytics and import live Zoho CRM data.
-
Connect to and Visualize Live GraphQL Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live GraphQL data.
-
How to connect to Samanage Data with Squirrel SQL client
Connect to Samanage data and execute queries in the Squirrel SQL Client.
-
Connect to XML from a Connection Pool in WebLogic
Use the CData JDBC Driver for XML to connect to XML data from Web applications running on WebLogic.
-
Automated Continuous Twilio Replication to MongoDB
Use CData Sync for automated, continuous, customizable Twilio replication to MongoDB.