CData Software - Knowledge Base
Recent Articles
-
Connect to Zoho Books Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoho Books.
-
Integrate with Instagram Data in JReport Designer
Create charts and reports based on Instagram in JReport Designer.
-
Integrate Cursor with Live Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Cloud Storage from within the editor.
-
How to Connect the Power BI Service to Codat: Complete Guide
Connect to the CData Software Power BI Connector for Codat from PowerBI.com to provide real-time Codat across the organization.
-
Integrating Kiro CLI with Excel Online 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 the CData Software JDBC Driver for Shortcut in MicroStrategy Web
Connect to Shortcut in MicroStrategy Web using the CData Software JDBC Driver for Shortcut.
-
Use Manus AI to Talk to Your Splunk 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 Splunk.
-
Getting Started with the CData Power BI Connector for Active Directory
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Active Directory.
-
Perform Batch Operations with Google Contacts Data in Apache NiFi
Connect to Google Contacts and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Getting Started with the CData Python Connector for Certinia
Learn to install and license the CData Python Connector
-
Use the CData Software ODBC Driver for Simplesat in MicroStrategy Web
Connect to Simplesat in MicroStrategy Web using the CData Software ODBC Driver for Simplesat.
-
Replicate Moosend Data from PowerShell
Write a quick PowerShell script to query Moosend. Use connectivity to the live data to replicate Moosend to SQL Server.
-
Replicate Aircall Data to Multiple Databases
Replicate Aircall to disparate databases with a point-and-click configuration.
-
Connect to JSON Services from AWS Glue
Use CData Connect AI to gain access to live JSON from your AWS Glue jobs.
-
Publish Gumroad-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Gumroad.
-
Create Data Visualizations in Cognos BI with Keap Data
Access Keap as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Validate ShipStation Data with QuerySurge
Access and validate ShipStation in QuerySurge using the CData JDBC Driver.
-
Create ChargeOver Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ChargeOver data access from reports, embedded analytics, and more.
-
Connect to Live Avro Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Avro in CData Connect AI and connect to your Apache Avro from PostgreSQL.
-
Create Dynamic SAP Business One Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Business One to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Vertica
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Vertica.
-
Connect to Google Cloud Storage Data in Jaspersoft Studio
Execute SQL to remote Google Cloud Storage in Jaspersoft Studio.
-
Design BIRT Reports on Jira Assets Data
Provide current Jira Assets to your embedded analytics.
-
How to connect to YouTube Analytics Data with Squirrel SQL client
Connect to YouTube Analytics and execute queries in the Squirrel SQL Client.
-
Configure the CData JDBC Driver for LightSpeedRetail in a Connection Pool in Tomcat
Connect to LightSpeedRetail from a connection pool in Tomcat.
-
Use Dash to Build Web Apps on Zendesk Data via CData Connect AI
Build interactive Dash web apps on live Zendesk using pandas and the CData Connect AI Python SDK.
-
Connect to Timely Data from a Connection Pool in Jetty
The Timely JDBC Driver supports connection pooling: This article shows how to connect faster to Timely from Web apps in Jetty.
-
Create Dynamic MYOB AccountRight Grids Using the Infragistics XamDataGrid
Learn how you can connect MYOB AccountRight to Infragistics XamDataGrid to build dynamic grids.
-
How to connect and process Salesloft from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Salesloft.
-
A PostgreSQL Interface for Zoho Creator Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho Creator JDBC Driver to create a PostgreSQL entry-point for data access.
-
Feed Suadeo Data into FineReport
How to set Suadeo as a JDBC data source in FineReport.
-
Integrate Open WebUI with Live SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Hybris C4C from within the chat interface.
-
Integrate Live SAP HANA Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP HANA to Blue Prism using the CData ODBC Driver for SAP HANA to create automated workflows for repetitive business tasks.
-
ETL Webex in Oracle Data Integrator
This article shows how to transfer Webex into a data warehouse using Oracle Data Integrator.
-
How to import Shopify Data into Apache Solr
Use the CData Software JDBC Driver for Shopify in Data Import Handler and create an automated import of Shopify to Apache Solr Enterprise Search platform.
-
Create Azure DevOps-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Azure DevOps Data from Klipfolio and build custom visualizations using live Azure DevOps.
-
Connect to ActiveCampaign Data in Aqua Data Studio
Access ActiveCampaign from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Contentful Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Contentful from PowerBI.com to create Power BI Dataflows with real-time data.
-
Easily Integrate Telegram Data in Lazarus Pascal IDE
Learn how to easily integrate live Telegram in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use Manus AI to Talk to Your FHIR 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 FHIR.
-
Query Gmail Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Gmail and perform CRUD operations on Gmail from Node.js.
-
Using the CData Software ODBC Driver for Typeform in PyCharm
Connect to Typeform as an ODBC data source in PyCharm using the CData Software ODBC Driver for Typeform.
-
Access Monday.com Data from MySQL in PHP
Connect to Monday.com through the standard MySQL libraries in PHP.
-
Changelog: Driver Release 2025 Q4
Review the driver-specific changes from the 2025 Q4 CData Driver release.
-
Import Real-Time Mailjet Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mailjet in ColdFusion.
-
Connect to Azure Data Catalog Data in HULFT Integrate
Connect to Azure Data Catalog as a JDBC data source in HULFT Integrate
-
Visualize Drift Data in Sisense
Create an ElastiCube in Sisense app with access to Drift.
-
Create Power BI Reports on Real-Time Slack Data
Use the CData ODBC Driver for Slack to visualize Slack in Power BI Desktop.
-
How to Connect DBeaver to Discord via a JDBC Driver
Manage Discord with visual tools in DBeaver like the query browser.
-
A PostgreSQL Interface for TigerGraph Data using the CData ODBC Driver
Use the SQL Gateway and TigerGraph ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect Flowise AI Agents to Live Cloudant Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live IBM Cloudant without replication.
-
Migrating data from FTP to Databricks using CData SSIS Components.
Easily push FTP Servers to Databricks using the CData SSIS Tasks for FTP and Databricks.
-
Migrating data from ZohoPeople to Snowflake using CData SSIS Components.
Easily push ZohoPeople to Snowflake using the CData SSIS Tasks for ZohoPeople and Snowflake.
-
Automated Continuous Discord Replication to SQL Server
Use CData Sync for automated, continuous, customizable Discord replication to SQL Server.
-
How to publish and share Microsoft OneDrive Data dashboards with Tableau Server
The CData ODBC driver for Microsoft OneDrive enables you integrate Microsoft OneDrive into Tableau dashboards.
-
Moving Data from eBay Analytics to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live eBay Analytics data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Getting Started with the CData Python Connector for Campaigner
Learn to install and license the CData Python Connector
-
Natively Connect to Cloudflare Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Cloudflare. Leverage the native support for ODBC in PHP.
-
Add OneNote Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for OneNote with the Informatica Enterprise Data Catalog to classify and organize data.
-
Analyze Google Calendar Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Calendar and visualize Google Calendar in SAP Analytics Cloud.
-
How to connect and process Vercel from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Vercel.
-
Bridge Rootly Connectivity with Apache NiFi
Access and process Rootly in Apache NiFi using the CData JDBC Driver.
-
Moving Data from Amazon S3 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Amazon S3 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to import Quickbase Data into Apache Solr
Use the CData Software JDBC Driver for Quickbase in Data Import Handler and create an automated import of Quickbase to Apache Solr Enterprise Search platform.
-
Use the CData Software ODBC Driver for Factorial in MicroStrategy Web
Connect to Factorial in MicroStrategy Web using the CData Software ODBC Driver for Factorial.
-
Connect to Cvent Data in Jaspersoft Studio
Execute SQL to remote Cvent in Jaspersoft Studio.
-
Use the CData SSIS Components to Insert New or Update Existing Dynamics CRM Records from SQL Server
Easily push SQL Server data to Dynamics CRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Dynamics CRM or update existing records with data from a SQL Server database.
-
How to integrate Metabase with Lakebase Data
Use CData Connect AI to connect to live Lakebase and create an interactive dashboard in Metabase from Lakebase.
-
Connect to Sybase Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Sybase.
-
Extract, Transform, and Load TaxJar Data in Informatica PowerCenter
Create a simple Workflow for TaxJar in Informatica PowerCenter.
-
Access Miro Data from MySQL in Amazon QuickSight
Connect to Miro and build visualizations of Miro using a MySQL Connection in Amazon QuickSight.
-
Connect to SAP Netweaver Gateway Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Netweaver Gateway from Crystal Reports.
-
Visualize ZohoMarketingHub 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 ZohoMarketingHub into TIBCO Spotfire.
-
Integrating Cursor CLI with Sentry 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 Work with YouTube Analytics Data in AWS Glue Jobs Using JDBC
Connect to YouTube Analytics from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to SAP SuccessFactors Data in Jaspersoft Studio
Execute SQL to remote SAP SuccessFactors in Jaspersoft Studio.
-
Create SSAS Tabular Models from Mocean Data
How to build a SQL Server Analysis Service Tabular Model from Mocean using CData drivers.
-
Use ChatGPT to Talk to Your SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SendGrid for you.
-
How to Connect to & Open Procore Data in Microsoft Excel
This article uses the CData ODBC driver for Procore to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with Facebook Ads Data in Dundas BI
Create dynamic dashboards and perform analytics based on Facebook Ads in Dundas BI.
-
Explore Geographical Relationships in Webflow Data with Power Map
Create data visualizations with Webflow in Power Map.
-
Work with Live Odoo Data in Power Query
Use CData Connect AI to connect to Odoo ERP and work with live Odoo ERP in Microsoft Power Query.
-
Integrating Claude Code CLI with Mixpanel 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.
-
Connect to ConvertAPI Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ConvertAPI and the SQL Gateway to access ConvertAPI from Google Apps Script.
-
Build Google Cloud Storage-Connected Apps in Choreo
Use CData Connect AI to connect to Google Cloud Storage Data from Choreo and build custom apps using live Google Cloud Storage.
-
Use Agno to Talk to Your Gong 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 Gong for you.
-
Access Live BambooHR Data in AWS Lambda (with IntelliJ IDEA)
Connect to live BambooHR in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Telegram Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Telegram.
-
Analyze HubDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of HubDB and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to import iContact Data into Apache Solr
Use the CData Software JDBC Driver for iContact in Data Import Handler and create an automated import of iContact to Apache Solr Enterprise Search platform.
-
Extract, Transform, and Load ADP Data in Informatica PowerCenter
Create a simple Workflow for ADP in Informatica PowerCenter.
-
Excel Spreadsheet Automation on Apollo Data with the QUERY Formula
Pull data from Apollo, automate spreadsheets, and more with the QUERY formula.
-
Query Toggl Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Toggl from Node.js.
-
Integrating Snapchat Ads Data in Talend Cloud Data Management Platform
Connect Snapchat Ads Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Snapchat Ads.
-
Enable the Mistral AI JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Mistral AI.
-
Create Dynamic RabbitMQ Grids Using the Infragistics XamDataGrid
Learn how you can connect RabbitMQ to Infragistics XamDataGrid to build dynamic grids.
-
Import Real-Time Google Search Results via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Search in ColdFusion.
-
Migrating data from MailerLite to Snowflake using CData SSIS Components.
Easily push MailerLite to Snowflake using the CData SSIS Tasks for MailerLite and Snowflake.
-
Analyze Oracle HCM Cloud Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle HCM Cloud and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Teamgate Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Teamgate replication to Apache Cassandra.