CData Software - Knowledge Base
Recent Articles
-
Build Visualizations of Bullhorn CRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Bullhorn CRM in Birst.
-
Connect to Guru Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Guru and the SQL Gateway to access Guru from Google Apps Script.
-
Use the CData Software ODBC Driver for Google Tasks in MicroStrategy
Connect to Google Tasks in MicroStrategy Developer using the CData Software ODBC Driver for Google Tasks.
-
Integrating Kiro CLI with Access 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.
-
Automate JSON Services Replication to SAP HANA
Use CData Sync to customize and automate JSON replication to SAP HANA.
-
Create Facebook-Connected Dashboards in Grafana
Connect to Facebook Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Facebook.
-
Use JayDeBeApi to access Printful Data in Python
Use standard Python scripting and the development environment of your choice to access live Printful.
-
Connect to Moosend Data in RazorSQL
Connect to Moosend from wizards and query Moosend from the GUI in the RazorSQL database management tool.
-
How to update Certinia from Excel
This article explains how to transfer data from Excel to Certinia using the Excel Add-In for Certinia.
-
Integrate with Gorgias Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Gorgias to a JSON file on disk.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Outreach.io
Provide connectivity to Outreach.io through an SAP BusinessObjects universe.
-
Connect Templated Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Templated using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build a Simple VCL Application for Aha! Data
How to build a simple VCL Application to view Aha! in RAD Studio using the CData ODBC Driver for Aha!.
-
Integrating Codex CLI with TigerGraph 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.
-
Model, Search, and Visualize Live Certinia Data in ThoughtSpot
Use CData Connect AI to connect to live Certinia for modeling, searching, and visualizing.
-
Import SAP Concur Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Concur Data from Azure Data Factory and import live SAP Concur.
-
Migrating data from Sage 200 to Snowflake using CData SSIS Components.
Easily push Sage 200 to Snowflake using the CData SSIS Tasks for Sage 200 and Snowflake.
-
Integrating Kiro CLI with SendInBlue 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.
-
Write a Simple Go Application to work with Short.io Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Short.io.
-
Migrating data from Notion to Google BigQuery using CData SSIS Components.
Easily push Notion to Google BigQuery using the CData SSIS Tasks for Notion and Google BigQuery.
-
Build Exact Online-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Exact Online.
-
A Comparison of Database Drivers for MySQL
A performance comparison of the CData JDBC & ODBC Drivers for MySQL and the native MySQL Connector/J & Connector/ODBC (updated May 2020)
-
Work with AgileCRM Data in FoxPro
Load AgileCRM into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connecting Pipedream with Blackbaud FE NXT 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 Blackbaud FE NXT data in real time.
-
Automated Continuous Twilio Replication to SQL Server
Use CData Sync for automated, continuous, customizable Twilio replication to SQL Server.
-
Automated Continuous Dynamics NAV Replication to SQL Server
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to SQL Server.
-
Configure the CData JDBC Driver for ShipEngine in a Connection Pool in Tomcat
Connect to ShipEngine from a connection pool in Tomcat.
-
Build Twilio-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Twilio to explore live Twilio Data in GitHub Copilot to assist with building Twilio-powered applications.
-
Deploy the ADO.NET Provider for Tavily on an SSRS Report Server
Connect to Tavily 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.
-
Create Reports with SQL Analysis Services Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SQL Analysis Services.
-
How to Connect to Live SAP SuccessFactors 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 SAP SuccessFactors for you.
-
Query Tavily Data as a MySQL Database in Node.js
Execute MySQL queries against Tavily from Node.js.
-
Integrate Live Sugar CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Sugar CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sugar CRM.
-
Create Power BI XMLA-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Power BI XMLA Data from OutSystems and build custom enterprise apps using live Power BI XMLA.
-
How to Connect to Live Kintone 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 Kintone for you.
-
Connect to Gong 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 Gong.
-
How to Query Live FHIR Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live FHIR data in natural language using Python.
-
Use the CData Software ODBC Driver for MongoDB in MicroStrategy Desktop
Connect to MongoDB in MicroStrategy Desktop using the CData Software ODBC Driver for MongoDB.
-
Automated Continuous Dynamics CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to MongoDB.
-
Automate Aha! Data Replication to Azure Synapse
Use CData Sync to customize and automate Aha! replication to Azure Synapse.
-
Build Zuora-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zuora.
-
Automated Continuous eBay Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable eBay Analytics replication to SingleStore.
-
Integrating Codex CLI with Zendesk 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.
-
Object-Relational Mapping (ORM) with Codat 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 Codat into a Java-based ORM framework, Hibernate.
-
Integrating Codex CLI with Calendly 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 Connect to Live Power BI XMLA Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Power BI XMLA securely in real time.
-
Use the CData ODBC Driver for Short.io in Microsoft Power Query
You can use the CData Short.io ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Short.io into Microsoft Power Query.
-
Integrate Aircall with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Aircall with External Services.
-
Integrate ChargeOver with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ChargeOver with External Services.
-
How to Visualize Paymo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Paymo in Python.
-
How to Connect to Live Oracle Service Cloud Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Oracle Service Cloud securely in real time.
-
Integrate Yelp with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Yelp with External Services.
-
Build Jira Assets-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Jira Assets to explore live Jira Assets Data in Gemini Code Assist to assist with building Jira Assets-powered applications.
-
Automated Continuous Printify Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Printify replication to Amazon S3.
-
Automate Adobe Target Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Adobe Target and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
DataBind Controls to JSON Services in Delphi
DataBind to JSON in Delphi with standard data access components and controls.
-
Connect to Blackbaud FE NXT Data in Claris FileMaker Pro
Use the CData ODBC Driver for Blackbaud FE NXT in FileMaker Pro to connect to Blackbaud FE NXT and work with Blackbaud FE NXT in your FileMaker applications.
-
Connect to Greenplum Data in Claris FileMaker Pro
Use the CData ODBC Driver for Greenplum in FileMaker Pro to connect to Greenplum and work with Pivotal GreenPlum in your FileMaker applications.
-
Establish a Live Connection with Dynamics 365 Data using Tableau Bridge
The CData ODBC Driver for Dynamics 365 enables you to integrate live Microsoft Dynamics 365 into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect Flowise AI Agents to Live Epicor Kinetic 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 Epicor Kinetic without replication.
-
Use ChatGPT to Talk to Your Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Snowflake for you.
-
Consume SAP Hybris C4C OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Hybris C4C feeds that reflect any changes in SAP Lumira.
-
Create Data Visualizations in Cognos BI with BigCommerce Data
Access BigCommerce as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import Real-Time Mailgun Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mailgun in ColdFusion.
-
Integrate Typeform Data in the Pentaho Report Designer
Publish reports based on Typeform in the Pentaho BI tool.
-
Integrate Adobe Analytics Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Adobe Analytics from Informatica Cloud.
-
DataBind Controls to Calendly Data in Delphi
DataBind to Calendly in Delphi with standard data access components and controls.
-
Automated Continuous Office 365 Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Office 365 replication to AlloyDB.
-
Integrating Gumloop with Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Drive within automated workflows.
-
Connect to Microsoft Planner Data in JRuby
Create a simple JRuby app with access to live Microsoft Planner.
-
Connecting Pipedream with Sage Cloud Accounting 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 Sage Cloud Accounting data in real time.
-
Visualize Microsoft Planner Data in Tableau
The CData ODBC driver for Microsoft Planner enables you integrate Microsoft Planner into Tableau dashboards.
-
Publish Crystal Reports on Act-On Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Act-On.
-
Connect to Demio Data in NetBeans
Connect to Demio in NetBeans with the data source configuration wizard.
-
Natively Connect to Adobe Target Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Adobe Target. Leverage the native support for ODBC in PHP.
-
Visualize Live Vault CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Veeva Vault & Vault CRM.
-
How to connect to Presto Data from IntelliJ
Integrate connectivity to Presto with wizards in IntelliJ.
-
Connect to Gumroad Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Gumroad using standard SQL.
-
Connect to Zoho Creator Data in NetBeans
Connect to Zoho Creator in NetBeans with the data source configuration wizard.
-
How to publish and share SQL Analysis Services Data dashboards with Tableau Server
The CData ODBC driver for SQL Analysis Services enables you integrate SQL Analysis Services into Tableau dashboards.
-
Bind Live Klaviyo Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Klaviyo data
-
Connect to Marketo Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Marketo Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Facebook Ads Data in CloverDX (formerly CloverETL)
Transfer Facebook Ads using the visual workflow in the CloverDX data integration tool.
-
Build Cassandra-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Cassandra Data from Zoho Analytics and import live Apache Cassandra.
-
Integrate Reckon with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Reckon with External Services.
-
Create MySQL-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to MySQL Data from OutSystems and build custom enterprise apps using live MySQL.
-
Access Live Microsoft Ads Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft Ads from your Excel spreadsheets.
-
Stream Zoho Inventory Data into Apache Kafka Topics
Access and stream Zoho Inventory in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Natively Connect to ZohoDesk Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZohoDesk. Leverage the native support for ODBC in PHP.
-
Validate HelloSign Data with QuerySurge
Access and validate HelloSign in QuerySurge using the CData JDBC Driver.
-
Integrating Elasticsearch Data in Talend Cloud Data Management Platform
Connect Elasticsearch Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Elasticsearch.
-
Getting Started with the CData Excel Add-In for Tickspot
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Tickspot.
-
Integrate Act-On Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Act-On and integrate live Act-On into your Power Automate tasks.
-
How to connect to Blackbaud FE NXT Data from IntelliJ
Integrate connectivity to Blackbaud FE NXT with wizards in IntelliJ.
-
Integrate WordPress Data in Pentaho Data Integration
Build ETL pipelines based on WordPress in the Pentaho Data Integration tool.
-
Integrate Amazon DynamoDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Amazon DynamoDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Amazon DynamoDB.
-
Integrate Live PhantomBuster Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PhantomBuster to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to connect SharePoint with FHIR Data through external lists
Provide FHIR to SharePoint users as an external list.
-
Automated Continuous FreeAgent Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable FreeAgent replication to Google Cloud SQL.
-
Connect to Workable Data in NetBeans
Connect to Workable in NetBeans with the data source configuration wizard.