CData Software - Knowledge Base
Recent Articles
-
Automated Continuous HubSpot Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable HubSpot data replication to OneLake in Microsoft Fabric.
-
How to Connect to Bullhorn CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bullhorn CRM data. Leverage the pyodbc module for ODBC in Python.
-
Visualize Live Bannerbear Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Bannerbear data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for Jumpseller in SAS for Real-Time Reporting and Analytics
Connect to real-time Jumpseller data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Jumpseller.
-
Import Real-Time JSON Services via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use JSON services in ColdFusion.
-
Query Live Google Calendar 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 Google Calendar data directly from the development environment.
-
Create Adobe Analytics-Connected Applications in Appsmith
Connect to Adobe Analytics Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Adobe Analytics data.
-
How to Connect to Live Salesforce CRM Analytics 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 Salesforce CRM Analytics data for you.
-
Connect to and Query Freshteam Data in QlikView over ODBC
Create data visualizations with Freshteam data in QlikView.
-
How to load Google Forms data into Elasticsearch via Logstash
Introducing a simple method to load Google Forms data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for SAS xpt in SAS for Real-Time Reporting and Analytics
Connect to real-time SAS xpt data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAS xpt.
-
Connecting GenSpark with Mailjet Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Mailjet data without any replication or custom integration required.
-
Access Cassandra Data from MySQL in PHP
Connect to Cassandra through the standard MySQL libraries in PHP.
-
Create Power BI Reports on Real-Time Impala Data
Use the CData ODBC Driver for Impala to visualize Impala data in Power BI Desktop.
-
Connect to ServiceNow Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for ServiceNow and the Script function in FileMaker Pro to connect to ServiceNow and work with ServiceNow data in your FileMaker application.
-
Connect to Avalara AvaTax Data in ACL Analytics
Connect to Avalara AvaTax data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Avalara AvaTax data.
-
Integrating Kiro with GetResponse 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.
-
Build a Simple VCL Application for YouTube Analytics Data
How to build a simple VCL Application to view YouTube Analytics data in RAD Studio using the CData ODBC Driver for YouTube Analytics.
-
How to Connect to Live Bitly Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Bitly data for you.
-
Connecting Pipedream with FHIR Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on FHIR data in real time.
-
Connect to Oracle Service Cloud Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle Service Cloud data from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Service Cloud.
-
Connect to ZohoMarketingHub Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ZohoMarketingHub Data and connect to ZohoMarketingHub data in Akorbi Digital RunMyProcess.
-
Build a Singer.io Tap for Clari With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Clari data using the CData Python Connector.
-
How to Connect to Live GitLab Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live GitLab data securely in real time.
-
How to Connect Flowise AI Agents to Live Sage Cloud Accounting 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 Sage Cloud Accounting data without replication.
-
Integrating Cursor with SAP Ariba Procurement 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 OpenCode with Live Exa Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Exa data from within your AI coding agent.
-
Analyze Apollo Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Apollo data and visualize live Apollo data in Infragistics Reveal.
-
How to load Facebook Ads data into Elasticsearch via Logstash
Introducing a simple method to load Facebook Ads data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Work with Airtable Data in ETL Validator JDBC
Connect to Airtable from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous SAP SuccessFactors Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP SuccessFactors data replication to OneLake in Microsoft Fabric.
-
Integrate Cosmos DB Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Cosmos DB data and integrate live Cosmos DB data into your Power Automate tasks.
-
Connect to QuickBooks Online Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for QuickBooks Online and the SQL Gateway to access QuickBooks Online data from Google Apps Script.
-
Use Biml to Build SSIS Tasks to Replicate Unbounce Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Unbounce data to SQL Server.
-
Integrate Azure Data Catalog Data in the Pentaho Report Designer
Publish reports based on Azure Data Catalog data in the Pentaho BI tool.
-
Automated Continuous AfterShip Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable AfterShip replication to delimited files (CSV/TSV).
-
Visualize Live Elorus Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Elorus data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize GetResponse Data in TIBCO Spotfire through ADO.NET
Integrate GetResponse data into dashboards in TIBCO Spotfire.
-
Automate Short.io Data Replication to Azure Synapse
Use CData Sync to customize and automate Short.io data replication to Azure Synapse.
-
Query Live Google Contacts 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 Google Contacts data directly from the development environment.
-
Build Dashboards with Samanage Data in DBxtra
Create dynamic dashboards and perform analytics based on Samanage data in DBxtra.
-
Create SSAS Tabular Models from iContact Data
How to build a SQL Server Analysis Service Tabular Model from iContact data using CData drivers.
-
How to Seamlessly Import Google Translate Data into IBM SPSS Modeler
Integrate Google Translate data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to GetResponse Data in NetBeans
Connect to GetResponse data in NetBeans with the data source configuration wizard.
-
Egnyte Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Egnyte facts in real time.
-
Connect to Quickbase Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Quickbase data from Filemaker Pro on Mac.
-
Use Databricks Agent Bricks to Talk to Your ServiceNow Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your ServiceNow data for you.
-
Integrate LibreChat with Live Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Sage 200 data from within the chat interface.
-
Getting Started with the CData Tableau Connector for PagerDuty
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to and Visualize Live Webex Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Webex data.
-
Use the CData Software JDBC Driver for Figshare in MicroStrategy
Connect to Figshare data in MicroStrategy Developer using the CData Software JDBC Driver for Figshare.
-
Publish Reports with HubSpot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HubSpot data.
-
Build a PostgreSQL Interface for Mocean Data using the CData JDBC Driver
Use the Remoting features of the Mocean JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate SAP Ariba Source Data Replication to SAP HANA
Use CData Sync to customize and automate SAP Ariba Source data replication to SAP HANA.
-
Automated Continuous ConvertKit Replication to Vertica
Use CData Sync for automated, continuous, customizable ConvertKit replication to Vertica.
-
Automate HubSpot Data Replication to SAP HANA
Use CData Sync to customize and automate HubSpot data replication to SAP HANA.
-
How to Connect to Live iContact Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your iContact data through natural language.
-
Connect to Sugar CRM Data in HULFT Integrate
Connect to Sugar CRM as a JDBC data source in HULFT Integrate
-
Import Real-Time Mixpanel Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Mixpanel data in ColdFusion.
-
How to connect to JotForm Data from IntelliJ
Integrate connectivity to JotForm data with wizards in IntelliJ.
-
Publish Supabase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Supabase data.
-
Replicate CloudConvert Data to Multiple Databases via the CData Sync CLI
Replicate CloudConvert data to disparate databases with a single configuration.
-
Write a Simple Go Application to work with SpaceX Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SpaceX data.
-
How to integrate ADP with Apache Airflow
Access and process ADP data in Apache Airflow using the CData JDBC Driver.
-
DataBind Charts to SharePoint Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SharePoint data 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 Dotmailer Data using the CData JDBC Driver
Use the Remoting features of the Dotmailer JDBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time REST Data in Power BI Report Server
Use the CData ODBC Driver for REST to visualize REST data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Kiro with Mailgun 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.
-
Automated Continuous Stripe Replication to SQLite
Use CData Sync for automated, continuous, customizable Stripe replication to SQLite.
-
Use the CData Software JDBC Driver for Wistia in MicroStrategy Web
Connect to Wistia data in MicroStrategy Web using the CData Software JDBC Driver for Wistia.
-
Connect to RSS Feeds in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for RSS feeds in Airbyte.
-
Use the CData Software ODBC Driver for MySQL in SAS for Real-Time Reporting and Analytics
Connect to real-time MySQL data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MySQL.
-
Connect to Google Contacts Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Contacts data from Appeon PowerBuilder using the CData ADO.NET Provider for Google Contacts.
-
Access Live Vertica Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Vertica data from your Excel spreadsheets.
-
Automated Continuous HDFS Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HDFS replication to Amazon Redshift.
-
Load Salesforce Pardot Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesforce Pardot data to a database.
-
Connect to Azure Synapse Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Azure Synapse Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
ETL Sage Intacct in Oracle Data Integrator
This article shows how to transfer Sage Intacct data into a data warehouse using Oracle Data Integrator.
-
Natively Connect to SAS Data Sets Data in PHP
The CData ODBC driver for SAS Data Sets enables you to create PHP applications with connectivity to SAS Data Sets data. Leverage the native support for ODBC in PHP.
-
Write a Simple Go Application to work with Zoho Creator Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho Creator data.
-
Visualize Copper Data in Tableau
The CData ODBC driver for Copper enables you integrate Copper data into Tableau dashboards.
-
Import and Visualize Wistia Data in Power View
Create data visualizations based on Wistia data in Excel.
-
Connect to YouTube Analytics Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for YouTube Analytics data.
-
How to Query Cohere Data in MySQL Workbench
Execute MySQL queries against live Cohere data from MySQL Workbench.
-
Use Biml to Build SSIS Tasks to Replicate Recurly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Recurly data to SQL Server.
-
Connect to Vault CRM Data in Ruby
Connect to Vault CRM data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Process & Analyze Pinecone Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Pinecone Data.
-
Connect to Anaplan Data in ACL Analytics
Connect to Anaplan data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Anaplan data.
-
Integrate Devin with Live QuickBooks Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live QuickBooks data.
-
How to Visualize Bullhorn CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Bullhorn CRM data in Python.
-
Analyze SAP Fieldglass Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Fieldglass data and visualize live SAP Fieldglass data in Infragistics Reveal.
-
How to connect SharePoint with Adobe Analytics Data through external lists
Provide Adobe Analytics data to SharePoint users as an external list.
-
Connect ZendeskSell to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZendeskSell with IBM WebSphere for seamless data integration and connectivity.
-
Back Up Highrise data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Highrise. In this article, we will employ an SSIS workflow to populate a database with Highrise data data.
-
Viewing Brex Data in RAD Studio Data Explorer
How to view Brex data in RAD Studio Data Explorer using the CData ODBC Driver for Brex.
-
Analyze Simplesat Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Simplesat data with the CData JDBC Driver for Simplesat.
-
Natively Connect to eBay Data in PHP
The CData ODBC driver for eBay enables you to create PHP applications with connectivity to eBay data. Leverage the native support for ODBC in PHP.
-
Build Data Flows from Zoho Creator to SQL Server using SSIS
Easily back up Zoho Creator data to SQL Server using the SSIS components for Zoho Creator.
-
Design BIRT Reports on CloudConvert Data
Provide current CloudConvert data to your embedded analytics.
-
Connect to Google Calendar Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Calendar data from Filemaker Pro on Mac.