CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Codat in MicroStrategy Web
Connect to Codat in MicroStrategy Web using the CData Software JDBC Driver for Codat.
-
Replicate Autopilot Data from PowerShell
Write a quick PowerShell script to query Autopilot. Use connectivity to the live data to replicate Autopilot to SQL Server.
-
Back Up ZohoInvoice to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ZohoInvoice data.
-
Replicate Multiple Helpscout Accounts
Replicate multiple Helpscout accounts to one or many databases.
-
How to Work with MongoDB Data in AWS Glue Jobs Using JDBC
Connect to MongoDB from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access ConstantContact Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ConstantContact from your Oracle system.
-
How to Connect the Power BI Service to Vault CRM: Complete Guide
Connect to the CData Software Power BI Connector for Vault CRM from PowerBI.com to provide real-time Veeva Vault & Vault CRM across the organization.
-
Connect to and Query Oracle SCM Data in QlikView over ODBC
Create data visualizations with Oracle SCM in QlikView.
-
Automated Continuous Google Calendar Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Calendar replication to Google BigQuery.
-
Integrating OpenCode Terminal with CapsuleCRM 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 PolyBase to Templated
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Templated.
-
Using the CData Software ODBC Driver for Google Translate in PyCharm
Connect to Google Translate as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Translate.
-
Connect to Excel Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Excel using standard SQL.
-
Build a PostgreSQL Interface for Tally Data using the CData JDBC Driver
Use the Remoting features of the Tally JDBC Driver to create a PostgreSQL entry-point for data access.
-
Work with Invoiced Data in FoxPro
Load Invoiced into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Zoom Data in Talend Cloud Data Management Platform
Connect Zoom Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize HubDB Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load HubDB into TIBCO Spotfire.
-
Connect to Smartsheet Data from a Connection Pool in JBoss
Integrate Smartsheet into Java servlets: Use the Management Console in JBoss to install the Smartsheet JDBC Driver.
-
Automate SendPulse Data Replication to Azure Synapse
Use CData Sync to customize and automate SendPulse replication to Azure Synapse.
-
How to Connect to Live Jira Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Atlassian Jira for you.
-
Integrate Cline with Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Oracle Service Cloud from within your IDE.
-
Integrate Dynamics 365 Business Central Data in the Pentaho Report Designer
Publish reports based on Dynamics 365 Business Central in the Pentaho BI tool.
-
Automated Continuous Pipeliner CRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Apache Cassandra.
-
How to Visualize Google Campaign Manager 360 Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Google Campaign Manager 360 in Python.
-
Create Google Drive-Connected Applications in Appsmith
Connect to Google Drive Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Drive.
-
Back Up MarkLogic to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MarkLogic. In this article, we will employ an SSIS workflow to populate a database with MarkLogic data.
-
How to Visualize Jumpseller Data in Python with pandas
Use pandas and other modules to analyze and visualize live Jumpseller in Python.
-
How to integrate Amazon S3 with Apache Airflow
Access and process Amazon S3 in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Outreach.io Replication to Vertica
Use CData Sync for automated, continuous, customizable Outreach.io replication to Vertica.
-
How to Work with BigCommerce Data in ETL Validator JDBC
Connect to BigCommerce from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Certinia from a Connection Pool in WebLogic
Use the CData JDBC Driver for Certinia to connect to Certinia from Web applications running on WebLogic.
-
Create Power BI Reports on Real-Time ZohoPeople Data
Use the CData ODBC Driver for ZohoPeople to visualize ZohoPeople in Power BI Desktop.
-
Integrating OpenCode Terminal with Oracle Service Cloud 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.
-
Consume Klaviyo OData Feeds in PowerBuilder
This article demonstrates how to consume Klaviyo as OData feeds from PowerBuilder using the API Server.
-
Changelog: Driver Release 2025
Review the driver-specific changes from the 2025 CData Driver release.
-
Connect to Google Cloud Storage Data from a Connection Pool in Jetty
The Google Cloud Storage JDBC Driver supports connection pooling: This article shows how to connect faster to Google Cloud Storage from Web apps in Jetty.
-
How to connect and process SFTP from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SFTP.
-
Deploy the ADO.NET Provider for Hacker News on an SSRS Report Server
Connect to Hacker News 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 the CData Software ODBC Driver for EnterpriseDB in MicroStrategy Desktop
Connect to EnterpriseDB in MicroStrategy Desktop using the CData Software ODBC Driver for EnterpriseDB.
-
Connect SingleStore to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SingleStore using the CData Python MCP Server.
-
Connect BenchmarkEmail Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your BenchmarkEmail using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Object-Relational Mapping (ORM) with SQL Analysis Services 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 SQL Analysis Services into a Java-based ORM framework, Hibernate.
-
Build a Singer.io Tap for Attio With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Attio data using
-
DataBind xBase Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for xBase with the DevExpress Windows Forms and Web controls to provide xBase to a chart.
-
Connecting Mastra with Google Spanner 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 Google Spanner, no replication required.
-
Publish PabblySubscriptions-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live PabblySubscriptions.
-
Integrate Cline with Live SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Netweaver Gateway from within your IDE.
-
Access BigQuery Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google BigQuery.
-
Access Live Redshift Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Amazon Redshift from your Excel spreadsheets.
-
Replicate Dynamics 365 Business Central Data to Multiple Databases via the CData Sync CLI
Replicate Dynamics 365 Business Central to disparate databases with a single configuration.
-
Natively Connect to SpaceX Data in PHP
The CData ODBC driver for SpaceX enables you to create PHP applications with connectivity to SpaceX. Leverage the native support for ODBC in PHP.
-
Connect to Coda in SpagoBI
Create reports featuring live Coda in SpagoBI Studio. Host Coda reports on SpagoBI Server.
-
Automated Continuous Pingdom Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Pingdom replication to PostgreSQL.
-
Analyze Live Blackbaud FE NXT Data in SAS Viya
Use CData Connect AI to connect to Blackbaud FE NXT from SAS Viya and deploy self-service analytics using live Blackbaud FE NXT.
-
Replicate SparkPost Data to Multiple Databases
Replicate SparkPost to disparate databases with a point-and-click configuration.
-
How to connect PolyBase to HubSpot
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HubSpot.
-
Automated Mailgun Data Replication to Teradata
Use CData Sync to Customize and automate Mailgun replication to Teradata.
-
Use the CData Software JDBC Driver for QuickBooks Online in MicroStrategy Desktop
Connect to QuickBooks Online in MicroStrategy Desktop using the CData Software JDBC Driver for QuickBooks Online.
-
Visualize Live Cvent Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Cvent.
-
Build MVC Applications with Connectivity to eBay Analytics Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access eBay Analytics from an ASP.NET MVC application.
-
Stream Oracle Service Cloud Data into Apache Kafka Topics
Access and stream Oracle Service Cloud in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Freshteam Reporting in OBIEE with the Freshteam JDBC Driver
Deploy the Freshteam JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Calendly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Calendly using standard SQL.
-
How to connect and process Active Directory from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Active Directory.
-
Explore Geographical Relationships in Tavily Data with Power Map
Create data visualizations with Tavily in Power Map.
-
Access Everhour Data from MySQL in Amazon QuickSight
Connect to Everhour and build visualizations of Everhour using a MySQL Connection in Amazon QuickSight.
-
Connect to SAS Data Sets Data from AWS Glue
Use CData Connect AI to gain access to live SAS Data Sets from your AWS Glue jobs.
-
Integrate with Blackbaud FE NXT Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Blackbaud FE NXT in SnapLogic.
-
Connecting GenSpark with OData Services via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to OData without any replication or custom integration required.
-
Build Agents in Relevance AI with Access to Live SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SurveyMonkey within intelligent agent workflows.
-
Integrate SAP Hybris C4C Data in the Pentaho Report Designer
Publish reports based on SAP Hybris C4C in the Pentaho BI tool.
-
Enable the Google Search JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Search.
-
Connect to ChargeOver Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ChargeOver using standard SQL.
-
Visualize PivotalTracker Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PivotalTracker.
-
Import Real-Time Gumroad Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Gumroad in ColdFusion.
-
Video: Connecting with MongoDB Data from Microsoft Excel
This video shows how to use the CData ODBC Driver for MongoDB to connect to MongoDB. You will create a DSN and then use the Data Connection Wizard in Excel to retrieve MongoDB data.
-
Connect to Vault CRM Data from HeidiSQL
Use CData Connect AI to connect to and query live Veeva Vault & Vault CRM from HeidiSQL.
-
Automated Continuous Bannerbear Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Bannerbear replication to delimited files (CSV/TSV).
-
How to Visualize Typeform Data in Python with pandas
Use pandas and other modules to analyze and visualize live Typeform in Python.
-
Integrating Kiro CLI with LinkedIn 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.
-
Manage Codat Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Codat.
-
Getting Started with the CData SSIS Components for iContact
Complete guide to installing, licensing, and connecting with the CData SSIS Components for iContact.
-
Import Real-Time Splunk Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Splunk in ColdFusion.
-
Viewing Instantly Data in RAD Studio Data Explorer
How to view Instantly in RAD Studio Data Explorer using the CData ODBC Driver for Instantly.
-
How to Connect Sage Intacct Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Sage Intacct data in real time using natural language.
-
Build a PostgreSQL Interface for SendPulse Data using the CData JDBC Driver
Use the Remoting features of the SendPulse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Zoho Books Data Using Azure Data Factory
Use CData Connect AI to connect to Zoho Books Data from Azure Data Factory and import live Zoho Books.
-
Connect to and Query Apollo Data in QlikView over ODBC
Create data visualizations with Apollo in QlikView.
-
Access Live Notion Data in Coginiti Pro
Connect to and query live Notion from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Google Sheets-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Sheets Data from Zoho Analytics and import live Google Sheets.
-
Integrating Boomi Agentstudio with Asana Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Asana, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate Multiple SharePoint Accounts
Replicate multiple SharePoint accounts to one or many databases.
-
Access Simplesat Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Simplesat.
-
Access Freshdesk Data from MySQL in Amazon QuickSight
Connect to Freshdesk and build visualizations of Freshdesk using a MySQL Connection in Amazon QuickSight.
-
Connect Flowlu to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Flowlu using the CData Python MCP Server.
-
Visualize Live Oracle Data in the Power BI Service
Use CData Connect AI to connect to live Oracle Database and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to WooCommerce Data in JRuby
Create a simple JRuby app with access to live WooCommerce.
-
Integrate Open WebUI with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Business ByDesign from within the chat interface.
-
DataBind Charts to Spark Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Spark SQL 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 Charts with Samanage Data in Clear Analytics
Create dynamic charts and perform analytics based on Samanage in Clear Analytics.