CData Software - Knowledge Base
Recent Articles
-
Integrate Trae with Live Avalara AvaTax Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Avalara AvaTax data from within the AI-powered IDE.
-
Work with Live Jumpseller Data in Power Query
Use CData Connect AI to connect to Jumpseller data and work with live Jumpseller data in Microsoft Power Query.
-
Getting Started with the CData SSIS Components for Salesforce CRM Analytics
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Salesforce CRM Analytics.
-
How to Work with Humanity Data in AWS Glue Jobs Using JDBC
Connect to Humanity from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Bugsnag Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Bugsnag replication to AlloyDB.
-
Analyze SAP Business One Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Business One data and visualize live SAP Business One data in Infragistics Reveal.
-
Analyze Live Asana Data in SAS Viya
Use CData Connect AI to connect to Asana data from SAS Viya and deploy self-service analytics using live Asana data.
-
Replicate Multiple SAP HANA Accounts
Replicate multiple SAP HANA accounts to one or many databases.
-
Connect to Browserless Data from a Connection Pool in JBoss
Integrate Browserless data into Java servlets: Use the Management Console in JBoss to install the Browserless JDBC Driver.
-
Access Live Microsoft Entra ID Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Entra ID data from your Excel spreadsheets.
-
Getting Started with the CData Excel Add-In for Active Directory
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Active Directory.
-
Create Reports from PingOne Data in Looker Studio
Use CData Connect AI to gain access to live PingOne data and create custom reports in Looker Studio.
-
Build Pipelines with Live MarkLogic Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to MarkLogic from Google Cloud Data Fusion, enabling the integration of live MarkLogic data into the building and management of effective data pipelines.
-
Analyze PayPal Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of PayPal data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Perigon Data from a Connection Pool in Jetty
The Perigon JDBC Driver supports connection pooling: This article shows how to connect faster to Perigon data from Web apps in Jetty.
-
Integrating Boomi Agentstudio with EnterpriseDB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to EnterpriseDB data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Campaigner Data in CloverDX (formerly CloverETL)
Transfer Campaigner data using the visual workflow in the CloverDX data integration tool.
-
Connect Jira Assets to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Jira Assets with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Coda Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Coda replication to PostgreSQL.
-
Automated Continuous Shortcut Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Shortcut replication to Apache Cassandra.
-
Easily Integrate Highrise Data in Lazarus Pascal IDE
Learn how to easily integrate live Highrise data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Charts with TaxJar Data in Clear Analytics
Create dynamic charts and perform analytics based on TaxJar data in Clear Analytics.
-
Import Real-Time Stripe Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Stripe data in ColdFusion.
-
Consume Microsoft Planner OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Planner feeds that reflect any changes in SAP Lumira.
-
Automated Continuous XML Replication to Snowflake
Use CData Sync for automated, continuous, customizable XML replication to Snowflake.
-
Validate Greenhouse Data with QuerySurge
Access and validate Greenhouse data in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData ODBC Driver for Grafana
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Grafana.
-
Connect to PhantomBuster Data in DBArtisan
Use wizards in DBArtisan to configure PhantomBuster data as a data source.
-
Replicate Vault CRM Data in Heroku for Use in Salesforce Connect
Replicate Vault CRM data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating LangChain with iContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on iContact data within automated workflows.
-
Create Apps from SAP Ariba Source Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP Ariba Source Data and build apps from live SAP Ariba Source data in Qlik Sense Cloud.
-
Automated Continuous PagerDuty Replication to SingleStore
Use CData Sync for automated, continuous, customizable PagerDuty replication to SingleStore.
-
Prepare, Blend, and Analyze Shippo Data in Alteryx Designer (Connect AI)
Build workflows to access live Shippo data for self-service data analytics.
-
Connect to Contentful Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Contentful and work with Contentful data in your FileMaker applications.
-
Create Datasets from Oracle HCM Cloud in Domo Workbench and Build Visualizations of Oracle HCM Cloud Data in Domo
Use the CData Software ODBC Driver for Oracle HCM Cloud to create datasets from Oracle HCM Cloud data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to TaxJar Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for TaxJar Data and connect to TaxJar data in Akorbi Digital RunMyProcess.
-
Query Apify Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Apify data from Node.js.
-
Access Supabase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Supabase data from HeidiSQL.
-
Connect to Confluence Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Confluence and the SQL Gateway to access Confluence data from Google Apps Script.
-
Operational Reporting on JotForm Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote JotForm data.
-
How to Connect Flowise AI Agents to Live PolarTeamPro 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 PolarTeamPro data without replication.
-
Connect to Teamgate Data in DBeaver
Use the CData ODBC Driver to connect to Teamgate data in DBeaver.
-
Integrating Claude Code CLI with Wave Financial 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 Azure AI Foundry to Talk to Your HDFS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your HDFS data for you.
-
Publish Crystal Reports on SendGrid Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SendGrid data.
-
Connect Presto to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Presto with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Cline with Live Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Airtable data from within your IDE.
-
ETL Microsoft Ads in Oracle Data Integrator
This article shows how to transfer Microsoft Ads data into a data warehouse using Oracle Data Integrator.
-
How to integrate Metabase with Google Forms Data
Use CData Connect AI to connect to live Google Forms data and create an interactive dashboard in Metabase from Google Forms data.
-
Build ADP-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ADP data.
-
Visualize TigerGraph Data in Tableau
The CData ODBC driver for TigerGraph enables you integrate TigerGraph data into Tableau dashboards.
-
Bridge Wrike Connectivity with Apache NiFi
Access and process Wrike data in Apache NiFi using the CData JDBC Driver.
-
Load Hacker News Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Hacker News data to a database.
-
Integrate Live SAP Business Warehouse Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Business Warehouse data and integrate live SAP Business Warehouse data into apps built in Microsoft Power Apps.
-
Connect to Oracle Sales Data in CloverDX (formerly CloverETL)
Transfer Oracle Sales data using the visual workflow in the CloverDX data integration tool.
-
How to Query Live Teradata Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Teradata data data in natural language using Python.
-
Replicate Multiple Lakebase Accounts
Replicate multiple Lakebase accounts to one or many databases.
-
Integrate Live BigQuery Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live BigQuery data from within the IDE.
-
Connect to Redis Data in Jaspersoft Studio
Execute SQL to remote Redis data in Jaspersoft Studio.
-
Use the CData Software JDBC Driver for Google Search in MicroStrategy Web
Connect to Google Search results in MicroStrategy Web using the CData Software JDBC Driver for Google Search.
-
Connect to Productboard Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Productboard to connect to Productboard data and execute queries in PowerBuilder.
-
Configure the CData JDBC Driver for MongoDB in a Connection Pool in Tomcat
Connect to MongoDB data from a connection pool in Tomcat.
-
Access Retently Data from MySQL in Amazon QuickSight
Connect to Retently and build visualizations of Retently data using a MySQL Connection in Amazon QuickSight.
-
Connect to Active Directory Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Active Directory data.
-
Create Data Visualizations in Cognos BI with Gong Data
Access Gong data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish ActiveCampaign-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ActiveCampaign data.
-
Access Live Couchbase Data in AWS Lambda
Connect to live Couchbase data in AWS Lambda using the CData JDBC Driver.
-
Analyze Telegram Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Telegram from Power Pivot. You will use the Table Import Wizard to load Telegram data. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData ADO.NET Provider for Adobe Target
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Adobe Target.
-
Replicate Zendesk Data to Multiple Databases
Replicate Zendesk data to disparate databases with a point-and-click configuration.
-
Build Semantic Layer Views for Redshift Data in APOS Live Data Gateway
Use the CData Connector for Redshift in APOS Live Data Gateway to build Semantic Layer Views for Redshift data.
-
Replicate Google Analytics Data to Multiple Databases via the CData Sync CLI
Replicate Google Analytics data to disparate databases with a single configuration.
-
Connect to Dynamics 365 Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Dynamics 365 data.
-
How to Connect DBeaver to Zoho Inventory via a JDBC Driver
Manage Zoho Inventory data with visual tools in DBeaver like the query browser.
-
DataBind Controls to Yelp Data in Delphi
DataBind to Yelp data in Delphi with standard data access components and controls.
-
Automate Printful Data Replication to Azure Data Lake
Use CData Sync to customize and automate Printful data replication to Azure Data Lake.
-
Use Databricks Agent Bricks to Talk to Your Oracle Service Cloud Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Oracle Service Cloud data for you.
-
How to Connect to Live Epicor Kinetic 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 Epicor Kinetic data for you.
-
Stream Samanage Data into Apache Kafka Topics
Access and stream Samanage data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Publish Crystal Reports on AlloyDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date AlloyDB data.
-
Access Power BI XMLA Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Power BI XMLA data from HeidiSQL.
-
Connect to Databricks Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Databricks data.
-
How to Access Live Cohere Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Cohere enables you to integrate Cohere data into workflows built using Microsoft Power Automate Desktop.
-
How to import Ontraport Data into Apache Solr
Use the CData Software JDBC Driver for Ontraport in Data Import Handler and create an automated import of Ontraport data to Apache Solr Enterprise Search platform.
-
Integrate LibreChat with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live eBay data from within the chat interface.
-
How to Access Live Act CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Act CRM enables you to integrate Act CRM data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Reckon Accounts Hosted Data in RapidMiner
Integrate Reckon Accounts Hosted data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build a Simple VCL Application for Mocean Data
How to build a simple VCL Application to view Mocean data in RAD Studio using the CData ODBC Driver for Mocean.
-
Use the CData Software JDBC Driver for Workable in MicroStrategy Desktop
Connect to Workable data in MicroStrategy Desktop using the CData Software JDBC Driver for Workable.
-
How to Use a Microsoft Access Database to Update Bitbucket Data in Real Time
Update Bitbucket data by creating a linked table in Microsoft Access with the CData Bitbucket ODBC Driver.
-
How to work with Pingdom Data in Apache Spark using SQL
Access and process Pingdom Data in Apache Spark using the CData Software JDBC Driver.
-
Create Power BI Reports on Real-Time Azure Table Data
Use the CData ODBC Driver for Azure Table to visualize Azure Table data in Power BI Desktop.
-
Use the CData SSIS Components to Insert New or Update Existing Workday Records from SQL Server
Easily push SQL Server data to Workday using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Workday or update existing records with data from a SQL Server database.
-
Automated Continuous Azure Data Lake Storage Replication to Oracle
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Oracle.
-
Integrating GitHub Copilot with Spark 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.
-
Link Humanity with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Humanity data in Filemaker Pro for Mac or Windows.
-
Connect to and Query Spotify Data in QlikView over ODBC
Create data visualizations with Spotify data in QlikView.
-
Connect HelloSign Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your HelloSign data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build MVC Applications with Connectivity to FreeAgent Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access FreeAgent from an ASP.NET MVC application.
-
Create Presto-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Presto Data from Klipfolio and build custom visualizations using live Presto data.