CData Software - Knowledge Base
Recent Articles
-
Connect to Yelp from a Connection Pool in WebLogic
Use the CData JDBC Driver for Yelp to connect to Yelp data from Web applications running on WebLogic.
-
Analyze Google Directory Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Directory data and visualize live Google Directory data in Infragistics Reveal.
-
Build Sage Intacct-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Sage Intacct data without replication.
-
Query, Visualize, and Share live QuickBooks Time Data in Redash
Use CData Connect AI to connect to live QuickBooks Time data in Redash for querying, visualizing, and sharing.
-
Connect to SAP Business Warehouse Data in RazorSQL
Connect to SAP Business Warehouse from wizards and query SAP Business Warehouse data from the GUI in the RazorSQL database management tool.
-
Integrate OpenCode with Live HubSpot Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live HubSpot data from within your AI coding agent.
-
Connect to PhantomBuster Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PhantomBuster and the SQL Gateway to access PhantomBuster data from Google Apps Script.
-
Connect to HDFS Data in NetBeans
Connect to HDFS data in NetBeans with the data source configuration wizard.
-
Integrating Dataiku with Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure DevOps data.
-
Use Manus AI to Talk to Your FTP 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 FTP data.
-
Work with Live MailChimp Data in Power Query
Use CData Connect AI to connect to MailChimp data and work with live MailChimp data in Microsoft Power Query.
-
Automated Continuous SendPulse Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SendPulse replication to Google BigQuery.
-
Visualize Retently Data in Tableau
The CData ODBC driver for Retently enables you integrate Retently data into Tableau dashboards.
-
Feed Vimeo Data into FineReport
How to set Vimeo data as a JDBC data source in FineReport.
-
Automated Continuous Sage 300 Replication to Databricks
Use CData Sync for automated, continuous, customizable Sage 300 replication to Databricks.
-
Automated Continuous Nuclia Replication to MongoDB
Use CData Sync for automated, continuous, customizable Nuclia replication to MongoDB.
-
Import and Visualize SAP SuccessFactors LMS Data in Power View
Create data visualizations based on SAP SuccessFactors LMS data in Excel.
-
Connect to Redshift Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Redshift data in the Denodo Virtual DataPort Administrator.
-
Build AI/ML Models with Live Salesforce Pardot Data using Dataiku
Connect Salesforce Pardot Data with Dataiku using the CData JDBC Driver for Salesforce Pardot.
-
Bridge SAP Business Warehouse Connectivity with Apache NiFi
Access and process SAP Business Warehouse data in Apache NiFi using the CData JDBC Driver.
-
Replicate ElevenLabs Data to Multiple Databases via the CData Sync CLI
Replicate ElevenLabs data to disparate databases with a single configuration.
-
Access Live Bullhorn CRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Bullhorn CRM data from your Excel spreadsheets.
-
Object-Relational Mapping (ORM) with Dotmailer 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 Dotmailer data into a Java-based ORM framework, Hibernate.
-
Visualize Webex 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 Webex data into TIBCO Spotfire.
-
Build Data Flows from SQL Server to JSON through SSIS
Easily push SQL Server data to JSON using the CData SSIS Tasks for JSON.
-
Automated Continuous Flowlu Replication to SingleStore
Use CData Sync for automated, continuous, customizable Flowlu replication to SingleStore.
-
Connecting GenSpark with Adobe Commerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Adobe Commerce data without any replication or custom integration required.
-
Build a Simple VCL Application for Browserless Data
How to build a simple VCL Application to view Browserless data in RAD Studio using the CData ODBC Driver for Browserless.
-
How to Query Live Epicor Kinetic Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Epicor Kinetic data data in natural language using Python.
-
Analyze SAP Ariba Procurement Data in Cognos Analytics
Use CData Connect AI to connect to SAP Ariba Procurement Data from Cognos Analytics and analyze live SAP Ariba Procurement data.
-
Consume Trello OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Trello feeds that reflect any changes in SAP Lumira.
-
Link Oracle Financials Cloud with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Financials Cloud data in Filemaker Pro for Mac or Windows.
-
Build a PostgreSQL Interface for Google Analytics Data using the CData JDBC Driver
Use the Remoting features of the Google Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Reckon Data in Power BI Report Server
Use the CData ODBC Driver for Reckon to visualize Reckon data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Cloudflare-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Cloudflare data without replication.
-
Analyze XML Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze XML data in Microsoft R Open.
-
How to Build an ETL App for PayPal Data in Python with CData
Create ETL applications and real-time data pipelines for PayPal data in Python with petl.
-
Use Manus AI to Talk to Your SAS xpt 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 SAS xpt data.
-
Create Teradata-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Teradata Data from Klipfolio and build custom visualizations using live Teradata data.
-
Connecting GenSpark with SageHR Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SageHR data without any replication or custom integration required.
-
Replicate Multiple QuickBooks Time Accounts
Replicate multiple QuickBooks Time accounts to one or many databases.
-
How to Connect to & Open eBay Analytics Data in Microsoft Excel
This article uses the CData ODBC driver for eBay Analytics to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Adobe Analytics Data in Aqua Data Studio
Access Adobe Analytics data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Rapidly Develop Bannerbear-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 Bannerbear.
-
Work with SuiteCRM Data in FoxPro
Load SuiteCRM data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with Odoo Data in JReport Designer
Create charts and reports based on Odoo data in JReport Designer.
-
Getting Started with the CData Tableau Connector for Trello
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Trello.
-
How to use SQLAlchemy ORM to access YouTube Analytics Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of YouTube Analytics data.
-
Access Live MailChimp Data in Excel 365 Online (Excel for the web)
Connect to MailChimp data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build AI Agents with OData Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live OData services through CData Connect AI.
-
Access eBay Analytics Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access eBay Analytics data from your Oracle system.
-
Excel Spreadsheet Automation on Act CRM Data with the QUERY Formula
Pull data from Act CRM, automate spreadsheets, and more with the QUERY formula.
-
Use Databricks Agent Bricks to Talk to Your QuickBooks Time Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your QuickBooks Time data for you.
-
Import Real-Time Productboard Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Productboard data in ColdFusion.
-
Query Sage Intacct Data as a MySQL Database in Node.js
Execute MySQL queries against Sage Intacct data from Node.js.
-
Build Shopify-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Shopify data and build Shopify-connected web apps with Axios.
-
How to Build an ETL App for Active Directory Data in Python with CData Connect AI
Build ETL pipelines that read and write live Active Directory data in Python with petl and the CData Connect AI Python SDK.
-
Import and Visualize Yelp Data in Power View
Create data visualizations based on Yelp data in Excel.
-
Use ChatGPT to Talk to Your Avro 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 Avro data for you.
-
Connect to ZarMoney Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ZarMoney and work with ZarMoney data in your FileMaker application.
-
Query Live Azure Data Lake Storage 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 Azure Data Lake Storage data directly from the development environment.
-
Access Exact Online Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Exact Online data from your Oracle system.
-
Connect to Azure Analysis Services Data from HeidiSQL
Use CData Connect AI to connect to and query live Azure Analysis Services data from HeidiSQL.
-
Build Dashboards with Toggl Data in Dundas BI
Create dynamic dashboards and perform analytics based on Toggl data in Dundas BI.
-
Create NetSuite SuiteAnalytics-Connected Applications in Appsmith
Connect to NetSuite SuiteAnalytics Data via CData Connect AI in Appsmith and create custom business applications with real-time access to NetSuite SuiteAnalytics data.
-
Access Avro Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Avro data from your Oracle system.
-
Use the CData Software JDBC Driver for Anaplan in MicroStrategy
Connect to Anaplan data in MicroStrategy Developer using the CData Software JDBC Driver for Anaplan.
-
How to connect and process IBM Informix data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live IBM Informix data.
-
Automated Continuous Oracle Financials Cloud Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Apache Kafka.
-
Back Up Keap data 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 Keap data data.
-
Build a Simple VCL Application for Access Data
How to build a simple VCL Application to view Access data in RAD Studio using the CData ODBC Driver for Access.
-
Integrate Theia IDE with Live Redis 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 Redis data from within the development environment.
-
Automated Continuous Exact Online Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Exact Online replication to IBM DB2.
-
Object-Relational Mapping (ORM) with Zoho Inventory 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 Zoho Inventory data into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData ADO.NET Provider for Impala
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Impala.
-
Connect to Sage 300 Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sage 300 Data and connect to Sage 300 data in Akorbi Digital RunMyProcess.
-
Manage ChargeOver Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ChargeOver.
-
Natively Connect to ClickTime Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ClickTime data. Leverage the native support for ODBC in PHP.
-
Integrate OpenCode with Live ZohoSubscriptions Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live ZohoSubscriptions data from within your AI coding agent.
-
Create Data Visualizations Based On Azure Data Lake Storage Data in Mode
Use CData Connect AI to connect to Azure Data Lake Storage Data from Mode and build visualizations using live Azure Data Lake Storage data.
-
Connect to CampaignMonitor Data in HULFT Integrate
Connect to CampaignMonitor as a JDBC data source in HULFT Integrate
-
DataBind Controls to Oracle Service Cloud Data in Delphi
DataBind to Oracle Service Cloud data in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Onfleet in MicroStrategy Desktop
Connect to Onfleet data in MicroStrategy Desktop using the CData Software ODBC Driver for Onfleet.
-
How to use SQLAlchemy ORM to access ConvertKit Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ConvertKit data.
-
Create Informatica Mappings From/To a JDBC Data Source for OneNote
Create OneNote data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use Biml to Build SSIS Tasks to Replicate CouchDB Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate CouchDB data to SQL Server.
-
How to Access Google Cloud Storage Data Using Entity Framework
This article shows how to access Google Cloud Storage data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access ZendeskSell Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ZendeskSell data from your Oracle system.
-
Use Biml to Build SSIS Tasks to Replicate Acumatica Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Acumatica data to SQL Server.
-
Analyze SurveyMonkey Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SurveyMonkey data with the CData JDBC Driver for SurveyMonkey.
-
Automated Continuous Clio Replication to MongoDB
Use CData Sync for automated, continuous, customizable Clio replication to MongoDB.
-
Build a Singer.io Tap for SharePoint With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SharePoint data using the CData Python Connector.
-
Access Live PingOne Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live PingOne data from your Excel spreadsheets.
-
Bridge CouchDB Connectivity with Apache NiFi
Access and process CouchDB data in Apache NiFi using the CData JDBC Driver.
-
Integrate Everhour Data in the Pentaho Report Designer
Publish reports based on Everhour data in the Pentaho BI tool.
-
Build Elasticsearch-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Elasticsearch data and build Elasticsearch-connected web apps with Axios.
-
Integrating OpenCode with Cvent 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.
-
Replicate Simplesat Data to Multiple Databases
Replicate Simplesat data to disparate databases with a point-and-click configuration.
-
How to Connect to Live Odoo 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 Odoo data for you.
-
How to Build an ETL App for Stack Exchange Data in Python with CData
Create ETL applications and real-time data pipelines for Stack Exchange data in Python with petl.