CData Software - Knowledge Base
Recent Articles
-
Connect to Discourse Data in DBeaver
Use the CData ODBC Driver to connect to Discourse in DBeaver.
-
Connect to PabblySubscriptions Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PabblySubscriptions and the SQL Gateway to access PabblySubscriptions from Google Apps Script.
-
Action Required: Salesforce Connected App Usage Changes (September 2025)
A guide for CData Customers to prepare for the Salesforce Connected App usage changes rolling out in September 2025.
-
DataBind Charts to ClickUp Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ClickUp 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 Access Live MailChimp Data in Visual Studio Code via Cline
Run CData MCP Server for MailChimp on Windows Subsytem for Linux (WSL) and connect to live MailChimp from the Cline extension in Visual Studio Code.
-
Automate Microsoft Planner Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Planner replication to SAP HANA.
-
Replicate Multiple Vault CRM Accounts via the CData Sync CLI
Replicate multiple Vault CRM accounts to one or many databases.
-
Integrating Dataiku with Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Certinia.
-
Query Quickbase Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Quickbase and perform CRUD operations on Quickbase from Node.js.
-
How to Connect to & Open BambooHR Data in Microsoft Excel
This article uses the CData ODBC driver for BambooHR to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Oracle Data to Multiple Databases via the CData Sync CLI
Replicate Oracle Database to disparate databases with a single configuration.
-
Connect to Exa Data in Aqua Data Studio
Access Exa from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Amazon S3 Data in HULFT Integrate
Connect to Amazon S3 as a JDBC data source in HULFT Integrate
-
Replicate Databricks Data to Multiple Databases
Replicate Databricks to disparate databases with a point-and-click configuration.
-
Visualize Shortcut Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Shortcut.
-
Automated Continuous YouTube Analytics Replication to Snowflake
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Snowflake.
-
Model, Search, and Visualize Live Oracle Financials Cloud Data in ThoughtSpot
Use CData Connect AI to connect to live Oracle Financials Cloud for modeling, searching, and visualizing.
-
Access Live SAP Fieldglass Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP Fieldglass from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Live LinkedIn Data in PostGresSQL Interface through CData Connect AI
Create a live connection to LinkedIn in CData Connect AI and connect to your LinkedIn from PostgreSQL.
-
Use the CData Software JDBC Driver for GitLab in MicroStrategy Web
Connect to GitLab in MicroStrategy Web using the CData Software JDBC Driver for GitLab.
-
Integrate with Stack Exchange Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Stack Exchange to a JSON file on disk.
-
Integrate with Live Procore Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Procore from the MuleSoft Anypoint Platform to integrate live Procore into custom reports and dashboards.
-
Integrating GitHub Copilot CLI with Mocean 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.
-
Connect to Live SAP Hybris C4C Data in MicroStrategy through CData Connect AI
Create a live connection to SAP Hybris C4C Data in CData Connect AI and connect to your SAP Hybris C4C from MicroStrategy.
-
Use Agno to Talk to Your EnterpriseDB 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 EnterpriseDB for you.
-
Connect to Intercom Data in DBeaver
Use the CData ODBC Driver to connect to Intercom in DBeaver.
-
Use the CData SSIS Components to Insert New or Update Existing MarkLogic Records from SQL Server
Easily push SQL Server data to MarkLogic using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into MarkLogic or update existing records with data from a SQL Server database.
-
Connect to Amazon S3 Data in Ruby
Connect to Amazon S3 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to use SQLAlchemy ORM to access FreeAgent Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of FreeAgent.
-
How to integrate ZohoDesk with Apache Airflow
Access and process ZohoDesk in Apache Airflow using the CData JDBC Driver.
-
Use the CData API Server to Access HubSpot Data in Microsoft PowerPivot
Use the CData API Server to connect to live HubSpot in the Power Pivot business intelligence tool.
-
Query Zoho Books Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zoho Books from Node.js.
-
Build a Simple VCL Application for ZarMoney Data
How to build a simple VCL Application to view ZarMoney in RAD Studio using the CData ODBC Driver for ZarMoney.
-
Automated Continuous Retently Replication to SingleStore
Use CData Sync for automated, continuous, customizable Retently replication to SingleStore.
-
A PostgreSQL Interface for XML Data using the CData ODBC Driver
Use the SQL Gateway and XML ODBC Driver to create a PostgreSQL entry-point for data access.
-
Edit and Search SurveyMonkey External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SurveyMonkey to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SurveyMonkey objects that you can access from apps and the dashboard.
-
Create Dynamic Helpscout Grids Using the Infragistics XamDataGrid
Learn how you can connect Helpscout to Infragistics XamDataGrid to build dynamic grids.
-
Use Biml to Build SSIS Tasks to Replicate Freshdesk Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Freshdesk to SQL Server.
-
Integrate Open WebUI with Live Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Apollo from within the chat interface.
-
Replicate Xero Data in Heroku for Use in Salesforce Connect
Replicate Xero Accounting to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating Dataiku with CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live CSV/TSV Files.
-
Visualize Google Directory Data in TIBCO Spotfire through ADO.NET
Integrate Google Directory into dashboards in TIBCO Spotfire.
-
Connect to Google Drive Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Drive using standard SQL.
-
How to connect PolyBase to Insightly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Insightly.
-
Connect to SharePoint Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft SharePoint in Airbyte.
-
DataBind Charts to Zoho Recruit Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Recruit 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.
-
Build a PostgreSQL Interface for Avaza Data using the CData JDBC Driver
Use the Remoting features of the Avaza JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to DocuSign Data in Aqua Data Studio
Access DocuSign from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate AlloyDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate AlloyDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google AlloyDB.
-
Analyze LinkedIn Ads Data in Looker
Use CData Connect AI to connect to LinkedIn Ads Data from Looker and build custom apps using live LinkedIn Ads.
-
Access WooCommerce Data from MySQL in PHP
Connect to WooCommerce through the standard MySQL libraries in PHP.
-
Viewing Auth0 Data in RAD Studio Data Explorer
How to view Auth0 in RAD Studio Data Explorer using the CData ODBC Driver for Auth0.
-
Create Dynamic SAP Ariba Source Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Ariba Source to Infragistics XamDataGrid to build dynamic grids.
-
Build Avalara AvaTax-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Avalara AvaTax and build Avalara AvaTax-connected web apps with Axios.
-
Automated Continuous Google Search Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Search replication to Azure SQL Database.
-
Getting Started with the CData SSIS Components for SAP Concur
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Concur.
-
Getting Started with the CData ADO.NET Provider for QuickBooks
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for QuickBooks.
-
Create Data Visualizations in Cognos BI with RSS Feeds
Access RSS Feeds as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Rapidly Develop xBase-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 xBase.
-
Integrating Codex CLI with Webex 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.
-
Using the CData Software ODBC Driver for Freshsales in PyCharm
Connect to Freshsales as an ODBC data source in PyCharm using the CData Software ODBC Driver for Freshsales.
-
How to Connect to Live Active Directory Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Active Directory for you.
-
Access Salesforce Data from MySQL in PHP
Connect to Salesforce through the standard MySQL libraries in PHP.
-
Connect to MarkLogic Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MarkLogic to connect to MarkLogic and execute queries in PowerBuilder.
-
How to connect and process Autopilot from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Autopilot.
-
Getting Started with the CData ODBC Driver for Sentry
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sentry.
-
Connect Klaviyo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Klaviyo using the CData Python MCP Server.
-
Connect to Live Cvent Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Cvent in CData Connect AI and connect to your Cvent from PostgreSQL.
-
Excel Spreadsheet Automation on GitLab Data with the QUERY Formula
Pull data from GitLab, automate spreadsheets, and more with the QUERY formula.
-
Import and Visualize Google Translate Data in Power View
Create data visualizations based on Google Translate in Excel.
-
Process & Analyze DB2 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live DB2 Data.
-
Integrate Open WebUI with Live ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ActiveCampaign from within the chat interface.
-
Natively Connect to Accelo Data in PHP
The CData ODBC driver for Accelo enables you to create PHP applications with connectivity to Accelo. Leverage the native support for ODBC in PHP.
-
Query Highrise Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Highrise entities in PHP by modeling them as objects.
-
Create GraphQL-Connected Business Apps in AppSheet
Connect to GraphQL Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to GraphQL.
-
Viewing Bitbucket Data in RAD Studio Data Explorer
How to view Bitbucket in RAD Studio Data Explorer using the CData ODBC Driver for Bitbucket.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Odoo
Provide connectivity to Odoo ERP through an SAP BusinessObjects universe.
-
Connect SAS xpt to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAS XPORT using the CData Python MCP Server.
-
Build a Simple VCL Application for Cohere Data
How to build a simple VCL Application to view Cohere in RAD Studio using the CData ODBC Driver for Cohere.
-
Connect to Qualaroo Data from a Connection Pool in JBoss
Integrate Qualaroo into Java servlets: Use the Management Console in JBoss to install the Qualaroo JDBC Driver.
-
DataBind Tickspot Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Tickspot to a chart.
-
Use the NetSuite ODBC Driver by CData in MicroStrategy for the Web
Connect to NetSuite data in MicroStrategy Web using the CData ODBC Driver for NetSuite.
-
Stream Vercel Data into Apache Kafka Topics
Access and stream Vercel in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect Bugsnag to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Bugsnag with IBM WebSphere for seamless data integration and connectivity.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Stripe actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automate Nethunt Data Replication to Couchbase
Use CData Sync to Customize and automate Nethunt replication to Couchbase.
-
Import Tally Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Tally ERP. In this article, you will use the OData format to import Tally ERP into Microsoft Power Query.
-
Connect to Tavily Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Tavily to connect to Tavily and execute queries in PowerBuilder.
-
Connecting Moonlit Workflow with MYOB AccountRight Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your MYOB AccountRight in real time.
-
Connect to Xero Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Xero Accounting.
-
Use Azure AI Foundry to Talk to Your Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Sage Intacct for you.
-
Access Live SQL Analysis Services Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SQL Analysis Services in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Excel Online Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Excel Online from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to update Salesforce from Excel
This article explains how to transfer data from Excel to Salesforce using the Excel Add-In for Salesforce.
-
Connect and Query Live ShipStation Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ShipStation into Databricks
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sage 200 using the Model Context Protocol.
-
Automated Continuous DB2 for i Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable DB2 for i replication to Azure SQL Database.
-
Connect to Access Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Access from PowerBuilder using the Access JDBC Driver.
-
Import Real-Time Figshare Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Figshare in ColdFusion.
-
Integrate Coinbase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Coinbase with External Services.