CData Software - Knowledge Base
Recent Articles
-
Connect to Retently Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Retently to connect to Retently data and execute queries in PowerBuilder.
-
How to Work with Zoom Data in ETL Validator JDBC
Connect to Zoom from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to NetSuite Data in DBVisualizer
Integrate NetSuite data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Google Sheets Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Sheets replication to Oracle.
-
Deploy the ADO.NET Provider for Neo4J on an SSRS Report Server
Connect to Neo4J data 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.
-
How to connect to Teradata Data from Spring Boot
Connect to Teradata in a Spring Boot Application using the CData JDBC Driver for Teradata
-
Getting Started with the CData Tableau Connector for Redshift
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Redshift.
-
Integrating Claude Code CLI with AlloyDB 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 Open WebUI with Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Facebook Ads data from within the chat interface.
-
Connect to eBay Analytics Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for eBay Analytics data.
-
Connect to CSV Data in DBArtisan
Use wizards in DBArtisan to configure CSV data as a data source.
-
Model, Search, and Visualize Live Azure Analysis Services Data in ThoughtSpot
Use CData Connect AI to connect to live Azure Analysis Services data for modeling, searching, and visualizing.
-
Query CockroachDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume CockroachDB entities in PHP by modeling them as objects.
-
Getting Started with the CData Tableau Connector for XML
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for XML.
-
Access Live Snowflake Data in Excel 365 Online (Excel for the web)
Connect to Snowflake data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Access Live Basecamp Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Basecamp enables you to integrate Basecamp data into workflows built using Microsoft Power Automate Desktop.
-
How to connect and process Google Drive data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Drive data.
-
Establish a Live Connection with Pipeline CRM Data using Tableau Bridge
The CData ODBC Driver for Pipeline CRM enables you to integrate live Pipeline CRM data into Tableau Cloud dashboards using the Tableau Bridge.
-
Work with Zuora Data in FoxPro
Load Zuora data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect and Visualize Live Impala Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Impala data into the Databricks platform and create visualization dashboards with real-time Impala data.
-
Access Live Neo4J Data in AWS Lambda
Connect to live Neo4J data in AWS Lambda using the CData JDBC Driver.
-
Connect Chargebee to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Chargebee data using the CData Python MCP Server.
-
Automated Continuous Amazon S3 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Amazon S3.
-
Analyze Kafka Data in Cognos Analytics
Use CData Connect AI to connect to Kafka Data from Cognos Analytics and analyze live Kafka data.
-
Analyze Neo4J Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Neo4J data with the CData JDBC Driver for Neo4J.
-
Prepare, Blend, and Analyze Yelp Data in Alteryx Designer (ODBC)
Build workflows to access live Yelp data for self-service data analytics.
-
Build SAP ByDesign-Connected Apps in Choreo
Use CData Connect AI to connect to SAP ByDesign Data from Choreo and build custom apps using live SAP ByDesign data.
-
Publish Reports with MessageBird Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MessageBird data.
-
How to Query Live Google Ad Manager Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Ad Manager data data in natural language using Python.
-
How to Connect to & Open Mistral AI Data in Microsoft Excel
This article uses the CData ODBC driver for Mistral AI to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Open WebUI with Live AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live AlloyDB data from within the chat interface.
-
Object-Relational Mapping (ORM) with Reply.io 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 Reply.io data into a Java-based ORM framework, Hibernate.
-
Integrate Google's Vertex AI Agent with Live Reckon Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Reckon data within intelligent workflows.
-
Query Live Bannerbear Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Bannerbear data directly from the development environment.
-
Visualize YouTube Analytics Data in Sisense
Create an ElastiCube in Sisense app with access to YouTube Analytics data.
-
Publish Crystal Reports on Freshteam Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Freshteam data.
-
Connect to Sugar CRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sugar CRM data from Crystal Reports.
-
Automated Continuous Zendesk Replication to MySQL
Use CData Sync for automated, continuous, customizable Zendesk replication to MySQL.
-
How to import Outlook Data into Apache Solr
Use the CData Software JDBC Driver for Outlook in Data Import Handler and create an automated import of Outlook data to Apache Solr Enterprise Search platform.
-
Automated Continuous ZohoMarketingHub Replication to SQL Server
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to SQL Server.
-
Access LaunchDarkly Data from MySQL in Amazon QuickSight
Connect to LaunchDarkly and build visualizations of LaunchDarkly data using a MySQL Connection in Amazon QuickSight.
-
Build AI/ML Models with Live Nuclia Data using Dataiku
Connect Nuclia Data with Dataiku using the CData API Driver for JDBC.
-
Create Asana-Connected Applications in Appsmith
Connect to Asana Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Asana data.
-
Connect to Stripe Data in Aqua Data Studio
Access Stripe data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Manus AI to Talk to Your Dynamics 365 Business Central 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 Dynamics 365 Business Central data.
-
Query SAS xpt Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAS xpt data from Node.js.
-
Automate Avalara AvaTax Data Replication to Azure Synapse
Use CData Sync to customize and automate Avalara AvaTax data replication to Azure Synapse.
-
Connect to Live Zoho Books Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Zoho Books in CData Connect AI and connect to your Zoho Books data from PostgreSQL.
-
Use the CData Software JDBC Driver for TigerGraph in MicroStrategy Web
Connect to TigerGraph data in MicroStrategy Web using the CData Software JDBC Driver for TigerGraph.
-
Create Datasets from Azure DevOps in Domo Workbench and Build Visualizations of Azure DevOps Data in Domo
Use the CData Software ODBC Driver for Azure DevOps to create datasets from Azure DevOps data in Domo Workbench and then build visualizations in the Domo service.
-
Import Real-Time Google Contacts Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Contacts data in ColdFusion.
-
Connect to Dynamics 365 Business Central Data in CloverDX (formerly CloverETL)
Transfer Dynamics 365 Business Central data using the visual workflow in the CloverDX data integration tool.
-
Integrating LlamaIndex with Paymo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Paymo data in real time.
-
Operational Reporting on MailChimp Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MailChimp data.
-
Automated Continuous Slack Replication to Oracle
Use CData Sync for automated, continuous, customizable Slack replication to Oracle.
-
Using the CData Software ODBC Driver for HCL Domino in PyCharm
Connect to HCL Domino as an ODBC data source in PyCharm using the CData Software ODBC Driver for HCL Domino.
-
Integrate Real-Time Access to Oracle Eloqua Reporting in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle Eloqua Reporting data in real time.
-
Connect to and Visualize Live WordPress Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live WordPress data.
-
Use the CData ODBC Driver for ShipEngine from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ShipEngine to connect to ShipEngine data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ShipEngine data in Excel.
-
How to use SQLAlchemy ORM to access Zoho Projects Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho Projects data.
-
Build Semantic Layer Views for MySQL Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MySQL data.
-
Prepare, Blend, and Analyze Kafka Data in Alteryx Designer (Connect AI)
Build workflows to access live Kafka data for self-service data analytics.
-
Prepare, Blend, and Analyze Apollo Data in Alteryx Designer (ODBC)
Build workflows to access live Apollo data for self-service data analytics.
-
Use the CData Software ODBC Driver for iContact in MicroStrategy
Connect to iContact data in MicroStrategy Developer using the CData Software ODBC Driver for iContact.
-
Connect Spark Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Spark data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Manage TaxJar Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for TaxJar.
-
Access Live Vimeo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Vimeo data into the statistical analysis tools available in SAS JMP. This article shows how to use Vimeo data in the Graph Builder and Query Builder.
-
Automated Continuous Customer.io Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Customer.io replication to Azure SQL Database.
-
Connect to Marketo Data in RazorSQL
Connect to Marketo from wizards and query Marketo data from the GUI in the RazorSQL database management tool.
-
Build Data Flows from TaxJar to SQL Server using SSIS
Easily back up TaxJar data to SQL Server using the SSIS components for TaxJar.
-
Use the CData Software JDBC Driver for Printify in MicroStrategy Web
Connect to Printify data in MicroStrategy Web using the CData Software JDBC Driver for Printify.
-
Connect to and Visualize Live Amazon S3 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amazon S3 data.
-
Rapidly Develop EmailOctopus-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 EmailOctopus.
-
A PostgreSQL Interface for HDFS Data using the CData ODBC Driver
Use the SQL Gateway and HDFS ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live ShipEngine Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your ShipEngine data for you.
-
Moving Data from ActiveCampaign to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ActiveCampaign data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Visualizations of SendGrid Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SendGrid data in Birst.
-
Connect to Certinia Data from a Connection Pool in Jetty
The Certinia JDBC Driver supports connection pooling: This article shows how to connect faster to Certinia data from Web apps in Jetty.
-
Create AfterShip-Connected Business Apps in AppSheet
Connect to AfterShip Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to AfterShip data.
-
Connect to BambooHR Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for BambooHR data.
-
Connect to Lakebase 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 Lakebase data.
-
Trigger FTP IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for FTP with standard wizards in Logic Apps.
-
Connect to NASA Data in RapidMiner
Integrate NASA data with standard components and data source configuration wizards in RapidMiner Studio.
-
Query Azure Data Lake Storage Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Azure Data Lake Storage data from Node.js.
-
Analyze Jumpseller Data in Cognos Analytics
Use CData Connect AI to connect to Jumpseller Data from Cognos Analytics and analyze live Jumpseller data.
-
Automated Continuous MongoDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable MongoDB replication to Snowflake.
-
Connect to CapsuleCRM Data in ACL Analytics
Connect to CapsuleCRM data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to CapsuleCRM data.
-
Viewing Microsoft Entra ID Data in RAD Studio Data Explorer
How to view Microsoft Entra ID data in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Entra ID.
-
Design BIRT Reports on Clari Data
Provide current Clari data to your embedded analytics.
-
Connect and Query Live Avalara AvaTax Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Avalara AvaTax data into Databricks and enable direct, live querying and analysis without replication.
-
Manage ClickTime Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ClickTime.
-
Query Ontraport Data in DataGrip
Create a Data Source for Ontraport in DataGrip and use SQL to query live Ontraport data.
-
Migrating data from Microsoft Planner to Databricks using CData SSIS Components.
Easily push Microsoft Planner data to Databricks using the CData SSIS Tasks for Microsoft Planner and Databricks.
-
View Reports on Real-Time Templated Data in Power BI Report Server
Use the CData ODBC Driver for Templated to visualize Templated data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Exact Online Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Exact Online replication to delimited files (CSV/TSV).
-
Publish Amazon Athena-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Amazon Athena data.
-
Bidirectional Access to Bitbucket Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bitbucket data in Filemaker Pro for Mac or Windows.
-
DataBind Controls to SFTP Data in Delphi
DataBind to SFTP data in Delphi with standard data access components and controls.
-
Analyze Live Certinia Data in SAS Viya
Use CData Connect AI to connect to Certinia data from SAS Viya and deploy self-service analytics using live Certinia data.
-
Analyze iContact Data in Cognos Analytics
Use CData Connect AI to connect to iContact Data from Cognos Analytics and analyze live iContact data.