CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Excel Online Replication to SingleStore
Use CData Sync for automated, continuous, customizable Excel Online replication to SingleStore.
-
How to Connect to & Open CouchDB Data in Microsoft Excel
This article uses the CData ODBC driver for CouchDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to IBM Informix Data in ACL Analytics
Connect to IBM Informix data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to IBM Informix data.
-
Automated Continuous Highrise Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Highrise replication to Google BigQuery.
-
Create Sybase Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sybase from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to LinkedIn from a Connection Pool in WebLogic
Use the CData JDBC Driver for LinkedIn to connect to LinkedIn data from Web applications running on WebLogic.
-
Perform Batch Operations with Paylocity Data in Apache NiFi
Connect to Paylocity data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Instagram with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Instagram with External Services.
-
Automated Continuous BambooHR Replication to MongoDB
Use CData Sync for automated, continuous, customizable BambooHR replication to MongoDB.
-
How to import Aircall Data into Apache Solr
Use the CData Software JDBC Driver for Aircall in Data Import Handler and create an automated import of Aircall data to Apache Solr Enterprise Search platform.
-
Integrate Devin with Live Airtable 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 Airtable data.
-
Build Visualizations of Mocean Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Mocean data in Birst.
-
Integrate Rootly Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Rootly data from Informatica Cloud.
-
Access Instantly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Instantly data from your Oracle system.
-
Replicate Factorial Data to Multiple Databases via the CData Sync CLI
Replicate Factorial data to disparate databases with a single configuration.
-
Visualize Typeform 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 Typeform data into TIBCO Spotfire.
-
Use the CData Software JDBC Driver for BigQuery in MicroStrategy Web
Connect to BigQuery data in MicroStrategy Web using the CData Software JDBC Driver for BigQuery.
-
Deploy the ADO.NET Provider for PDFMonkey on an SSRS Report Server
Connect to PDFMonkey 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 create an RPA flow for FHIR Data in UiPath Studio
Use the FHIR ODBC Driver to create workflows that access real-time FHIR data without any coding.
-
Build Voice Agents in ElevenLabs with access to Live BambooHR Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live BambooHR data.
-
Connect to Microsoft Dataverse Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Dataverse data from HeidiSQL.
-
Use Agno to Talk to Your DocuSign 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 DocuSign data for you.
-
Manage Discourse Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Discourse.
-
Connect to eBay Analytics Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for eBay Analytics and the Script function in FileMaker Pro to connect to eBay Analytics and work with eBay Analytics data in your FileMaker application.
-
Automated Continuous Google Analytics Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Analytics replication to SQLite.
-
How to Connect to Live AfterShip Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live AfterShip data without replication.
-
Integrate with Kafka Data in JReport Designer
Create charts and reports based on Kafka data in JReport Designer.
-
Integrating Claude Code CLI with Short.io 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 Google's Vertex AI Agent with Live Azure DevOps 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 Azure DevOps data within intelligent workflows.
-
Integrating OpenCode with Google Ad Manager 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 Bright Data Data in ETL Validator JDBC
Connect to Bright Data from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live Teradata Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Teradata data for you.
-
Integrate Microsoft Dataverse Data into Power Automate Desktop using CData Connect
CData Connect for Microsoft Dataverse Data enables you to integrate Microsoft Dataverse data into workflows built using Microsoft Power Automate Desktop.
-
Using the CData Software ODBC Driver for Campaigner in PyCharm
Connect to Campaigner as an ODBC data source in PyCharm using the CData Software ODBC Driver for Campaigner.
-
Moving Data from Freshdesk to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Freshdesk data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to and Visualize Live Hugging Face Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Hugging Face data.
-
Add Zoho Recruit Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho Recruit with the Informatica Enterprise Data Catalog to classify and organize data.
-
ETL Splunk in Oracle Data Integrator
This article shows how to transfer Splunk data into a data warehouse using Oracle Data Integrator.
-
Build Data Flows from Wrike to SQL Server using SSIS
Easily back up Wrike data to SQL Server using the SSIS components for Wrike.
-
Integrating Gumloop with Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Elasticsearch data within automated workflows.
-
Seamlessly Bring Odoo Data into Retool Using CData Connect AI
Integrate Odoo data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Sybase Data in Claris FileMaker Pro
Use the CData ODBC Driver for Sybase in FileMaker Pro to connect to Sybase and work with Sybase data in your FileMaker applications.
-
How to publish and share Parquet Data dashboards with Tableau Server
The CData ODBC driver for Parquet enables you integrate Parquet data into Tableau dashboards.
-
Connect to Bannerbear from a Connection Pool in WebLogic
Use the CData JDBC Driver for Bannerbear to connect to Bannerbear data from Web applications running on WebLogic.
-
Back Up PabblySubscriptions 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 PabblySubscriptions data data.
-
Integrate Cline with Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Ads data from within your IDE.
-
Moving Data from Opsgenie to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Opsgenie data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Automated Workflows with Live Sybase Data in Workato
Use CData Connect AI to connect to live Sybase data and build automated workflows in Workato.
-
Connect to SAP HANA XS Advanced Data in CloverDX (formerly CloverETL)
Transfer SAP HANA XS Advanced data using the visual workflow in the CloverDX data integration tool.
-
Access Reckon Data from MySQL in Amazon QuickSight
Connect to Reckon and build visualizations of Reckon data using a MySQL Connection in Amazon QuickSight.
-
Connect JobNimbus Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your JobNimbus data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Google's Vertex AI Agent with Live Lakebase 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 Lakebase data within intelligent workflows.
-
Connect to Jira Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Jira Data and connect to Jira data in Akorbi Digital RunMyProcess.
-
Use the CData ODBC Driver for Telegram from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Telegram to connect to Telegram data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Telegram data in Excel.
-
Viewing Billsby Data in RAD Studio Data Explorer
How to view Billsby data in RAD Studio Data Explorer using the CData ODBC Driver for Billsby.
-
Create Zoom-Connected Dashboards in Grafana
Connect to Zoom Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoom data.
-
Build Gorgias-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Gorgias data.
-
Extract, Transform, and Load Foursquare Data in Informatica PowerCenter
Create a simple Workflow for Foursquare data in Informatica PowerCenter.
-
Analyze Kafka Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Kafka data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Design BIRT Reports on Tavily Data
Provide current Tavily data to your embedded analytics.
-
Visualize Bitbucket Data in TIBCO Spotfire through ADO.NET
Integrate Bitbucket data into dashboards in TIBCO Spotfire.
-
Replicate Oracle Sales Data in Heroku for Use in Salesforce Connect
Replicate Oracle Sales data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating LangGraph with Vertica Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Vertica data within automated workflows.
-
How to Connect Adobe Analytics Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Adobe Analytics data in real time using natural language.
-
Build Visualizations of Salesforce Marketing Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Salesforce Marketing data in Birst.
-
Integrate Live SuiteCRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SuiteCRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SuiteCRM data.
-
Publish LinkedIn Ads-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live LinkedIn Ads data.
-
Connect to PayPal Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PayPal and the SQL Gateway to access PayPal data from Google Apps Script.
-
Natively Connect to Vault CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Vault CRM data. Leverage the native support for ODBC in PHP.
-
Access Live Jira Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Jira data from your Excel spreadsheets.
-
Create Apps from ZohoDesk Data in Qlik Sense Cloud
Use CData Connect AI to connect to ZohoDesk Data and build apps from live ZohoDesk data in Qlik Sense Cloud.
-
How to publish and share Certinia Data dashboards with Tableau Server
The CData ODBC driver for Certinia enables you integrate Certinia data into Tableau dashboards.
-
Visualize Highrise Data in TIBCO Spotfire through ADO.NET
Integrate Highrise data into dashboards in TIBCO Spotfire.
-
Validate MariaDB Data with QuerySurge
Access and validate MariaDB data in QuerySurge using the CData JDBC Driver.
-
Connect Oracle SCM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Oracle SCM data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query ShipStation Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ShipStation entities in PHP by modeling them as objects.
-
A PostgreSQL Interface for Workable Data using the CData ODBC Driver
Use the SQL Gateway and Workable ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Azure Synapse Replication to SingleStore
Use CData Sync for automated, continuous, customizable Azure Synapse replication to SingleStore.
-
Query Freshdesk Data as a MySQL Database in Node.js
Execute MySQL queries against Freshdesk data from Node.js.
-
How to Connect to Live Jira 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 Jira data for you.
-
Automated Continuous Google Cloud Storage Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Vertica.
-
Access PingOne Data from MySQL in PHP
Connect to PingOne through the standard MySQL libraries in PHP.
-
Connect to and Query Microsoft OneDrive Data in QlikView over ODBC
Create data visualizations with Microsoft OneDrive data in QlikView.
-
Build Semantic Layer Views for Todoist Data in APOS Live Data Gateway
Use the CData Connector for Todoist in APOS Live Data Gateway to build Semantic Layer Views for Todoist data.
-
Connect to Reckon Accounts Hosted Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Reckon Accounts Hosted as an External Source in Dremio.
-
Integrate Google's Antigravity Agent with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Basecamp data using the Model Context Protocol.
-
Migrating data from NASA to Snowflake using CData SSIS Components.
Easily push NASA data to Snowflake using the CData SSIS Tasks for NASA and Snowflake.
-
Connecting Mastra with FreshBooks Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time FreshBooks data, no replication required.
-
Integrate OpenCode with Live MongoDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live MongoDB data from within your AI coding agent.
-
DataBind Controls to CSV Data in Delphi
DataBind to CSV data in Delphi with standard data access components and controls.
-
How to publish and share Sugar CRM Data dashboards with Tableau Server
The CData ODBC driver for Sugar CRM enables you integrate Sugar CRM data into Tableau dashboards.
-
How to Visualize SAP Ariba Source Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SAP Ariba Source data in Python.
-
Build ShipEngine Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ShipEngine data and build visualizations in Tableau.
-
Access AgileCRM Data from MySQL in PHP
Connect to AgileCRM through the standard MySQL libraries in PHP.
-
Build HDFS-Connected Apps in Choreo
Use CData Connect AI to connect to HDFS Data from Choreo and build custom apps using live HDFS data.
-
How to Connect to Live SQL Analysis Services Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SQL Analysis Services data for you.
-
Automated Continuous Adobe Analytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Google BigQuery.
-
Getting Started with the CData Excel Add-In for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for QuickBooks Time.
-
Integrating GitHub Copilot with CircleCI 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.
-
Stream Twilio Data into Apache Kafka Topics
Access and stream Twilio data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.