CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code CLI with Oracle Sales 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.
-
DataBind Controls to Oracle Service Cloud Data in C++Builder
DataBind to Oracle Service Cloud data in C++Builder with standard components and controls.
-
Automated Continuous Gumroad Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Gumroad replication to delimited files (CSV/TSV).
-
Analyze Marketo Data in Cognos Analytics
Use CData Connect AI to connect to Marketo Data from Cognos Analytics and analyze live Marketo data.
-
Analyze Facebook Ads Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Facebook Ads data and visualize Facebook Ads data in SAP Analytics Cloud.
-
Use the CData SSIS Components to Insert New or Update Existing EnterpriseDB Records from SQL Server
Easily push SQL Server data to EnterpriseDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into EnterpriseDB or update existing records with data from a SQL Server database.
-
Add Freshservice Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Freshservice with the Informatica Enterprise Data Catalog to classify and organize data.
-
Visualize Short.io Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Short.io data.
-
Build NetSuite SuiteAnalytics-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for NetSuite SuiteAnalytics Data and create custom apps in Bubble.
-
Replicate Codat Data to Multiple Databases
Replicate Codat data to disparate databases with a point-and-click configuration.
-
Visualize Live Klaviyo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Klaviyo data.
-
Automated Continuous Airtable Replication to Snowflake
Use CData Sync for automated, continuous, customizable Airtable replication to Snowflake.
-
Create Data Visualizations Based On Reckon Data in Mode
Use CData Connect AI to connect to Reckon Data from Mode and build visualizations using live Reckon data.
-
Add Acumatica Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Acumatica with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Oracle Eloqua Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Eloqua data from your Google Sheets.
-
Use the CData Software ODBC Driver for Zoho CRM in MicroStrategy Web
Connect to Zoho CRM data in MicroStrategy Web using the CData Software ODBC Driver for Zoho CRM.
-
Automated Continuous Telegram Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Telegram replication to IBM DB2.
-
How to update Marketo from Excel
This article explains how to transfer data from Excel to Marketo using the Excel Add-In for Marketo.
-
Access Live Amazon Athena Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Amazon Athena data through MCP integration.
-
Bidirectional Access to SendGrid Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SendGrid data in Filemaker Pro for Mac or Windows.
-
Configure the CData JDBC Driver for SQL Server in a Connection Pool in Tomcat
Connect to SQL Server data from a connection pool in Tomcat.
-
Establish a Live Connection with Nethunt Data using Tableau Bridge
The CData ODBC Driver for Nethunt enables you to integrate live Nethunt data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build AI Agents with Impala 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 Impala data through CData Connect AI.
-
Choosing the Best Method to Connect Campaigner to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Campaigner data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Pipeline CRM 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 Pipeline CRM data into TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for QuickBooks Time.
-
Use the CData Software ODBC Driver for Neo4J in SAS for Real-Time Reporting and Analytics
Connect to real-time Neo4J data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Neo4J.
-
Connecting Pipedream with Grafana 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 Grafana data in real time.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Exchange
Provide connectivity to Microsoft Exchange data through an SAP BusinessObjects universe.
-
Integrating GitHub Copilot with ZohoPeople 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.
-
Search External Sage 200 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Sage 200 data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sage 200 Data objects that you can access from apps and the dashboard.
-
Query ZendeskSell Data in ColdFusion
Write standard ColdFusion data access code to connect to ZendeskSell data.
-
Publish Redis-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Redis data.
-
Use the CData Software JDBC Driver for Harvest in MicroStrategy Web
Connect to Harvest data in MicroStrategy Web using the CData Software JDBC Driver for Harvest.
-
Automate API Data Replication to Azure Synapse
Use CData Sync to customize and automate API data replication to Azure Synapse.
-
Back Up WordPress data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for WordPress. In this article, we will employ an SSIS workflow to populate a database with WordPress data data.
-
Work with Live MYOB AccountRight Data in Power Query
Use CData Connect AI to connect to MYOB AccountRight data and work with live MYOB AccountRight data in Microsoft Power Query.
-
ETL Clio in Oracle Data Integrator
This article shows how to transfer Clio data into a data warehouse using Oracle Data Integrator.
-
Connect to Raisers Edge NXT Data in DBArtisan
Use wizards in DBArtisan to configure Raisers Edge NXT data as a data source.
-
Build a Singer.io Tap for Basecamp With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Basecamp data using the CData Python Connector.
-
Connect to ADP Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ADP and the SQL Gateway to access ADP data from Google Apps Script.
-
ETL HelloSign in Oracle Data Integrator
This article shows how to transfer HelloSign data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Perplexity Replication to Oracle
Use CData Sync for automated, continuous, customizable Perplexity replication to Oracle.
-
Getting Started with the CData Tableau Connector for Airtable
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Airtable.
-
Integrating Gumloop with Toggl Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Toggl data within automated workflows.
-
Access Live Copper Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Copper data into the statistical analysis tools available in SAS JMP. This article shows how to use Copper data in the Graph Builder and Query Builder.
-
Query Mailjet Data as a SQL Server Database in Node.js
Execute SQL Server queries against Mailjet data from Node.js.
-
ETL NASA in Oracle Data Integrator
This article shows how to transfer NASA data into a data warehouse using Oracle Data Integrator.
-
Connect to Teradata Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Teradata data.
-
Feed SAP Netweaver Gateway Data into FineReport
How to set SAP Netweaver Gateway data as a JDBC data source in FineReport.
-
How to load Reckon Accounts Hosted data into Elasticsearch via Logstash
Introducing a simple method to load Reckon Accounts Hosted data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automate Pipeline CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Pipeline CRM data replication to Azure Data Lake.
-
Create Informatica Mappings From/To a JDBC Data Source for Shortcut
Create Shortcut data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate with ConvertAPI Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ConvertAPI data to a JSON file on disk.
-
Getting Started with the CData Power BI Connector for Epicor Kinetic
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Epicor Kinetic.
-
Create Act CRM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Act CRM Data from Klipfolio and build custom visualizations using live Act CRM data.
-
Connecting Pipedream with SendGrid 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 SendGrid data in real time.
-
Easily Integrate Samanage Data in Lazarus Pascal IDE
Learn how to easily integrate live Samanage data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Interact with Live Raisers Edge NXT Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Raisers Edge NXT data.
-
Migrating data from Tickspot to Databricks using CData SSIS Components.
Easily push Tickspot data to Databricks using the CData SSIS Tasks for Tickspot and Databricks.
-
How to Connect to Mode Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mode data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Testmonitor Data in JRuby
Create a simple JRuby app with access to live Testmonitor data.
-
Use Claude to Talk to Your Sales Data
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your finance & accounting data for you
-
Automated Continuous IBM Informix Replication to IBM DB2
Use CData Sync for automated, continuous, customizable IBM Informix replication to IBM DB2.
-
Connect to SAP BusinessObjects BI Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP BusinessObjects BI in FileMaker Pro to connect to SAP BusinessObjects BI and work with SAP BusinessObjects BI data in your FileMaker applications.
-
Migrating data from Deel to Databricks using CData SSIS Components.
Easily push Deel data to Databricks using the CData SSIS Tasks for Deel and Databricks.
-
Integrate Trae with Live MongoDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live MongoDB data from within the AI-powered IDE.
-
Easily Integrate SpaceX Data in Lazarus Pascal IDE
Learn how to easily integrate live SpaceX data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Sage Cloud Accounting-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Sage Cloud Accounting Data from Klipfolio and build custom visualizations using live Sage Cloud Accounting data.
-
How to publish and share Avalara AvaTax Data dashboards with Tableau Server
The CData ODBC driver for Avalara AvaTax enables you integrate Avalara AvaTax data into Tableau dashboards.
-
Connect to Zoho Creator Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoho Creator data.
-
Integrating TigerGraph Data in Talend Cloud Data Management Platform
Connect TigerGraph Data with Talend Cloud Data Management Platform using the CData JDBC Driver for TigerGraph.
-
Connect to Live Facebook Ads Data in MicroStrategy through CData Connect AI
Create a live connection to Facebook Ads Data in CData Connect AI and connect to your Facebook Ads data from MicroStrategy.
-
Automated Continuous MarkLogic Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MarkLogic replication to IBM DB2.
-
Access Klipfolio Data from MySQL in PHP
Connect to Klipfolio through the standard MySQL libraries in PHP.
-
Build Pipelines with Live Jira Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Jira from Google Cloud Data Fusion, enabling the integration of live Jira data into the building and management of effective data pipelines.
-
Connect to Rebilly Data in DBArtisan
Use wizards in DBArtisan to configure Rebilly data as a data source.
-
Integrating LlamaIndex with Grafana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Grafana data in real time.
-
How to connect to JDBC-ODBC Bridge Data from IntelliJ
Integrate connectivity to JDBC-ODBC Bridge data with wizards in IntelliJ.
-
Natively Connect to Quickbase Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Quickbase data. Leverage the native support for ODBC in PHP.
-
How to load Gmail data into Elasticsearch via Logstash
Introducing a simple method to load Gmail data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Stream Kintone Data into Apache Kafka Topics
Access and stream Kintone data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Access Live Dropbox Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Dropbox enables you to integrate Dropbox data into workflows built using Microsoft Power Automate Desktop.
-
Analyze Authorize.Net Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Authorize.Net data and visualize Authorize.Net data in SAP Analytics Cloud.
-
Manage NetSuite Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for NetSuite.
-
How to publish and share CouchDB Data dashboards with Tableau Server
The CData ODBC driver for CouchDB enables you integrate CouchDB data into Tableau dashboards.
-
Getting Started with the CData Power BI Connector for Workable
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Working with DocuSign Data in LINQPad
Execute LINQ queries to DocuSign data in LINQPad.
-
Publish Factorial-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Factorial data.
-
Create Data Visualizations in Cognos BI with Suadeo Data
Access Suadeo data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to PagerDuty Data in CloverDX (formerly CloverETL)
Transfer PagerDuty data using the visual workflow in the CloverDX data integration tool.
-
Connecting Agentforce with Instagram Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Instagram data for you.
-
Getting Started with the CData ODBC Driver for Microsoft Planner
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Microsoft Planner.
-
Connect to PostgreSQL Data from a Connection Pool in JBoss
Integrate PostgreSQL data into Java servlets: Use the Management Console in JBoss to install the PostgreSQL JDBC Driver.
-
Integrate Theia IDE with Live ADP 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 ADP data from within the development environment.
-
Using the CData Software ODBC Driver for Databricks in PyCharm
Connect to Databricks as an ODBC data source in PyCharm using the CData Software ODBC Driver for Databricks.
-
Automated Continuous Vercel Replication to SQL Server
Use CData Sync for automated, continuous, customizable Vercel replication to SQL Server.
-
Access Sage 300 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sage 300 data from HeidiSQL.
-
Connect to Live SAS xpt Data in MicroStrategy through CData Connect AI
Create a live connection to SAS xpt Data in CData Connect AI and connect to your SAS xpt data from MicroStrategy.
-
DataBind Controls to SAP Ariba Procurement Data in Delphi
DataBind to SAP Ariba Procurement data in Delphi with standard data access components and controls.