CData Software - Knowledge Base
Recent Articles
-
Visualize PagerDuty 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 PagerDuty data into TIBCO Spotfire.
-
ODBC Driver Getting Started Guide
A basic guide to connecting applications to data from anywhere using the CData ODBC Driver
-
Publish Xero-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Xero data.
-
Integrating Claude Code CLI with Salesforce Marketing 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 use SQLAlchemy ORM to access Oracle Eloqua Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Eloqua data.
-
Integrating Hacker News Data in Talend Cloud Data Management Platform
Connect Hacker News Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Freshsales Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Freshsales replication to Google Cloud SQL.
-
Automate Cloudant Data Replication to Couchbase
Use CData Sync to Customize and automate Cloudant data replication to Couchbase.
-
Integrating Codex with REST 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.
-
Create Dynamics 365 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dynamics 365 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Dashboards and Visualize Live Microsoft Teams Data in Geckoboard
Use CData Connect AI to connect to live Microsoft Teams data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Access Live Adobe Target Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Adobe Target enables you to integrate Adobe Target data into workflows built using Microsoft Power Automate Desktop.
-
Connect SharePoint Excel Services to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SharePoint Excel Services with IBM WebSphere for seamless data integration and connectivity.
-
Create Dashboards and Visualize Live SAP Hybris C4C Data in Geckoboard
Use CData Connect AI to connect to live SAP Hybris C4C data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Airtable Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Airtable replication to AlloyDB.
-
How to Easily Query Sybase IQ Data in OpenOffice Base
Connect to Sybase IQ data in OpenOffice Base using the CData ODBC Driver for Sybase IQ and generate reports with live data insights.
-
Connect to Tanda Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Tanda.
-
Integrate with PayPal Data in SnapLogic
Use CData Connect AI to connect to and integrate with live PayPal data in SnapLogic.
-
Integrate Recurly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Recurly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Recurly data.
-
Query SparkPost Data in DataGrip
Create a Data Source for SparkPost in DataGrip and use SQL to query live SparkPost data.
-
Connecting Mastra with Cosmos DB 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 Cosmos DB data, no replication required.
-
Connect MYOB AccountRight to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MYOB AccountRight data using the CData Python MCP Server.
-
Build AI/ML Models with Live CouchDB Data using Dataiku
Connect CouchDB Data with Dataiku using the CData JDBC Driver for CouchDB.
-
Connect to Scrapfly Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Scrapfly.
-
Integrate Outlook Data in the Pentaho Report Designer
Publish reports based on Outlook data in the Pentaho BI tool.
-
Connect to SAP HANA Data in RapidMiner
Integrate SAP HANA data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to AfterShip Data from PowerBuilder via ADO.NET
This article demonstrates how to access AfterShip data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Extract, Transform, and Load ChargeOver Data in Informatica PowerCenter
Create a simple Workflow for ChargeOver data in Informatica PowerCenter.
-
Use the CData SSIS Components to Insert New or Update Existing Hive Records from SQL Server
Easily push SQL Server data to Hive using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Hive or update existing records with data from a SQL Server database.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Ad Manager
Provide connectivity to Google Ad Manager data through an SAP BusinessObjects universe.
-
How to load DB2 data into Elasticsearch via Logstash
Introducing a simple method to load DB2 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating GitHub Copilot with Microsoft Planner 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.
-
Connect to Amazon Marketplace Data in Ruby
Connect to Amazon Marketplace data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software ODBC Driver for FHIR in MicroStrategy Desktop
Connect to FHIR data in MicroStrategy Desktop using the CData Software ODBC Driver for FHIR.
-
Build Dashboards with PingOne Data in DBxtra
Create dynamic dashboards and perform analytics based on PingOne data in DBxtra.
-
Connect and Visualize Live FHIR Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live FHIR data into the Databricks platform and create visualization dashboards with real-time FHIR data.
-
Integrate Dify with Live Dynamics 365 Business Central Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Dynamics 365 Business Central data.
-
Perform Batch Operations with Smartsheet Data in Apache NiFi
Connect to Smartsheet data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Reckon Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Reckon data from your Oracle system.
-
How to Create Power BI Visual Reports with Real-Time Close Data
Use CData Power BI Connectors to visualize Close data in Power BI.
-
Automated Continuous Neo4J Replication to SingleStore
Use CData Sync for automated, continuous, customizable Neo4J replication to SingleStore.
-
Use Databricks Agent Bricks to Talk to Your ServiceDesk Plus Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your ServiceDesk Plus data for you.
-
Object-Relational Mapping (ORM) with Blackbaud FE NXT 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 Blackbaud FE NXT data into a Java-based ORM framework, Hibernate.
-
Access Live FreshBooks Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live FreshBooks data from your Excel spreadsheets.
-
How to Build an ETL App for Dynamics 365 Business Central Data in Python with CData
Create ETL applications and real-time data pipelines for Dynamics 365 Business Central data in Python with petl.
-
Automate Strava Data Replication to Couchbase
Use CData Sync to Customize and automate Strava data replication to Couchbase.
-
Integrating Claude Code with SendGrid Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SendGrid data within assisted coding and automated development workflows.
-
Build a PostgreSQL Interface for ClickTime Data using the CData JDBC Driver
Use the Remoting features of the ClickTime JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating LlamaIndex with Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Sybase data in real time.
-
Integrating Boomi Agentstudio with Wave Financial Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Wave Financial data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build a Singer.io Tap for OpenWeatherMap With the CData Python Connector
Learn how to easily build a Singer.io Tap for live OpenWeatherMap data using the CData Python Connector.
-
Integrate Bitbucket Data in the Pentaho Report Designer
Publish reports based on Bitbucket data in the Pentaho BI tool.
-
Replicate Multiple Workday Accounts
Replicate multiple Workday accounts to one or many databases.
-
Connect to VWO Data in HULFT Integrate
Connect to VWO as a JDBC data source in HULFT Integrate
-
How to Connect to Live ZohoDesk 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 ZohoDesk data for you.
-
Integrating LangGraph with Gmail Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Gmail data within automated workflows.
-
How to Connect to & Open Outlook Data in Microsoft Excel
This article uses the CData ODBC driver for Outlook to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Power BI Reports on Real-Time TigerGraph Data
Use the CData ODBC Driver for TigerGraph to visualize TigerGraph data in Power BI Desktop.
-
Import Real-Time Aha! Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Aha! data in ColdFusion.
-
Build Salesforce Marketing Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Salesforce Marketing data and build visualizations in Tableau Cloud.
-
Connect to Todoist 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 Todoist and work with Todoist data in your FileMaker application.
-
Analyze Odoo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Odoo data in Microsoft R Open.
-
Connecting GenSpark with Email Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Email data without any replication or custom integration required.
-
Bridge Ontraport Connectivity with Apache NiFi
Access and process Ontraport data in Apache NiFi using the CData JDBC Driver.
-
Integrating Boomi Agentstudio with Gong Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Gong data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect to Live SAP SuccessFactors 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 SAP SuccessFactors data through natural language.
-
Build a Singer.io Tap for Microsoft Entra ID With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Microsoft Entra ID data using the CData Python Connector.
-
Integrate HubSpot Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to HubSpot data and integrate live HubSpot data into your Power Automate tasks.
-
Connecting Pipedream with Asana 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 Asana data in real time.
-
Automate WordPress Data Replication to Azure Data Lake
Use CData Sync to customize and automate WordPress data replication to Azure Data Lake.
-
Build a Simple VCL Application for Dotmailer Data
How to build a simple VCL Application to view Dotmailer data in RAD Studio using the CData ODBC Driver for Dotmailer.
-
Getting Started with the CData Python Connector for Microsoft Ads
Learn to install and license the CData Python Connector and configure a connection to live Microsoft Ads data.
-
Build Agents in Relevance AI with Access to Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Dataverse data within intelligent agent workflows.
-
Build Automated Workflows with Live Gong Data in Workato
Use CData Connect AI to connect to live Gong data and build automated workflows in Workato.
-
Connecting Mastra with Impala 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 Impala data, no replication required.
-
Connect and Visualize Live QuickBooks Online Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live QuickBooks Online data into the Databricks platform and create visualization dashboards with real-time QuickBooks Online data.
-
How to load Google Cloud Storage data into Elasticsearch via Logstash
Introducing a simple method to load Google Cloud Storage data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Visualize Live SendPulse Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SendPulse data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
View Reports on Real-Time GitHub Data in Power BI Report Server
Use the CData ODBC Driver for GitHub to visualize GitHub data in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Odoo Data as a SQL Server Database in Node.js
Execute SQL Server queries against Odoo data from Node.js.
-
Use Grok to Talk to Your Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Blackbaud FE NXT data for you.
-
Connect to Shippo in SpagoBI
Create reports featuring live Shippo data in SpagoBI Studio. Host Shippo reports on SpagoBI Server.
-
How to import Dynamics CRM Data into Apache Solr
Use the CData Software JDBC Driver for Dynamics CRM in Data Import Handler and create an automated import of Dynamics CRM data to Apache Solr Enterprise Search platform.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Harvest
Provide connectivity to Harvest data through an SAP BusinessObjects universe.
-
Integrate with live Sendwithus Data in Jitterbit
Use CData Connect AI to connect to and integrate live Sendwithus data in Jitterbit.
-
Access Live Oracle SCM Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Oracle SCM data through MCP integration.
-
Create Power BI Reports on Real-Time Adobe Analytics Data
Use the CData ODBC Driver for Adobe Analytics to visualize Adobe Analytics data in Power BI Desktop.
-
DataBind Controls to Redis Data in C++Builder
DataBind to Redis data in C++Builder with standard components and controls.
-
Connect to Rootly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Rootly to connect to Rootly data and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for GetResponse in MicroStrategy
Connect to GetResponse data in MicroStrategy Developer using the CData Software JDBC Driver for GetResponse.
-
Automated Continuous AgileCRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable AgileCRM replication to IBM DB2.
-
Automated Continuous Planio Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Planio replication to Google BigQuery.
-
Access Live Short.io Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Short.io data into the statistical analysis tools available in SAS JMP. This article shows how to use Short.io data in the Graph Builder and Query Builder.
-
Explore Geographical Relationships in Cvent Data with Power Map
Create data visualizations with Cvent data in Power Map.
-
Connect and Visualize Live Snowflake Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Snowflake data into the Databricks platform and create visualization dashboards with real-time Snowflake data.
-
Build Postmark-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Postmark data and build web apps with connectivity to live Postmark data.
-
Replicate Multiple Xero Accounts
Replicate multiple Xero accounts to one or many databases.
-
Automated Continuous Teamwork Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Teamwork replication to Apache Kafka.
-
Import Real-Time Act CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Act CRM data in ColdFusion.
-
Publish Dynamics CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Dynamics CRM data.