CData Software - Knowledge Base
Recent Articles
-
Connect to Access from a Connection Pool in WebLogic
Use the CData JDBC Driver for Access to connect to Access data from Web applications running on WebLogic.
-
Connect to ServiceDesk Plus Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ServiceDesk Plus to connect to ServiceDesk Plus data and execute queries in PowerBuilder.
-
Connect to Greenhouse Data in CloverDX (formerly CloverETL)
Transfer Greenhouse data using the visual workflow in the CloverDX data integration tool.
-
How to work with REST Data in Apache Spark using SQL
Access and process REST Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live Sybase IQ 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 Sybase IQ data for you.
-
Automated Continuous Auth0 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Auth0 replication to PostgreSQL.
-
Create Databricks-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Databricks Data from Klipfolio and build custom visualizations using live Databricks data.
-
Prepare, Blend, and Analyze Presto Data in Alteryx Designer (ODBC)
Build workflows to access live Presto data for self-service data analytics.
-
Connect to Smartsheet Data from Crystal Reports
Use CData Connect AI to connect to and report on live Smartsheet data from Crystal Reports.
-
LINQ to Greenplum Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Greenplum Data Provider.
-
Build Visualizations of Grafana Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Grafana data in Birst.
-
Getting Started with the CData ODBC Driver for Todoist
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Todoist.
-
Visualize Airtable 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 Airtable data into TIBCO Spotfire.
-
Object-Relational Mapping (ORM) with Couchbase 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 Couchbase data into a Java-based ORM framework, Hibernate.
-
Query Live Zendesk Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Zendesk data through a conversational interface.
-
Integrate with Mailgun Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mailgun data to a JSON file on disk.
-
Integrating OpenCode with ZendeskSell 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.
-
Query Excel Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Excel entities in PHP by modeling them as objects.
-
Establish a Live Connection with DB2 Data using Tableau Bridge
The CData ODBC Driver for DB2 enables you to integrate live DB2 data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Bullhorn CRM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Bullhorn CRM data.
-
Use JayDeBeApi to access SAP Ariba Procurement Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Ariba Procurement data.
-
Create Pinterest Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Pinterest from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Visualizations of Exact Online Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Exact Online data in Birst.
-
Build Printify-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Printify data and build Printify-connected web apps with Axios.
-
Connect to Amazon Athena Data from a Connection Pool in Jetty
The Amazon Athena JDBC Driver supports connection pooling: This article shows how to connect faster to Amazon Athena data from Web apps in Jetty.
-
Query RSS Feeds as a MySQL Database in Node.js
Execute MySQL queries against RSS feeds from Node.js.
-
Integrate Cursor with Live Anaplan Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Anaplan data from within the editor.
-
Build a PostgreSQL Interface for SAP HANA Data using the CData JDBC Driver
Use the Remoting features of the SAP HANA JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Apps with Live RSS Feeds Using the Low-Code Development Platform of Mendix
Connect RSS feeds with Mendix to build apps using the CData JDBC Driver for RSS.
-
Connect to PostgreSQL Data in HULFT Integrate
Connect to PostgreSQL as a JDBC data source in HULFT Integrate
-
Connect to and Visualize Live Sage 300 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage 300 data.
-
Integrate Live Adobe Experience Manager Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Adobe Experience Manager data and integrate live Adobe Experience Manager data into apps built in Microsoft Power Apps.
-
Integrate Cursor with Live SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SharePoint data from within the editor.
-
How to Access Live Amazon Marketplace Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Amazon Marketplace enables you to integrate Amazon Marketplace data into workflows built using Microsoft Power Automate Desktop.
-
Create Reports with JotForm Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date JotForm data.
-
Import Real-Time Jumpseller Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Jumpseller data in ColdFusion.
-
Query Humanity Data in DataGrip
Create a Data Source for Humanity in DataGrip and use SQL to query live Humanity data.
-
Connect Dynamics 365 Business Central to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Dynamics 365 Business Central data using the CData Python MCP Server.
-
Query Odoo Data as a MySQL Database in Node.js
Execute MySQL queries against Odoo data from Node.js.
-
Use Manus AI to Talk to Your Figshare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Figshare data.
-
How to connect Amazon QuickSight to SuiteCRM Data
Create a connection to SuiteCRM data in CData Connect AI and insert SuiteCRM data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Miro Data in DBArtisan
Use wizards in DBArtisan to configure Miro data as a data source.
-
ETL Optimizely in Oracle Data Integrator
This article shows how to transfer Optimizely data into a data warehouse using Oracle Data Integrator.
-
Build Pipelines with Live Exa Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Exa from Google Cloud Data Fusion, enabling the integration of live Exa data into the building and management of effective data pipelines.
-
Bridge Greenplum Connectivity with Apache NiFi
Access and process Greenplum data in Apache NiFi using the CData JDBC Driver.
-
Seamlessly Bring Google Ads Data into Retool Using CData Connect AI
Integrate Google Ads data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Freshdesk Data in Talend Cloud Data Management Platform
Connect Freshdesk Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Freshdesk.
-
Work with Excel Data in FoxPro
Load Excel data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Act CRM Data as a MySQL Database in Node.js
Execute MySQL queries against Act CRM data from Node.js.
-
A PostgreSQL Interface for Twilio Data using the CData ODBC Driver
Use the SQL Gateway and Twilio ODBC Driver to create a PostgreSQL entry-point for data access.
-
Write a Simple Go Application to work with Instantly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Instantly data.
-
How to load SFTP data into Elasticsearch via Logstash
Introducing a simple method to load SFTP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for Office 365 in SAS for Real-Time Reporting and Analytics
Connect to real-time Office 365 data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Office 365.
-
Use Grok to Talk to Your Trello 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 Trello data for you.
-
Connect to CSV from Asprova with CData Software ODBC Driver for CSV
This article shows how to connect faster to CSV data from Asprova.
-
Automated Continuous Billsby Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Billsby data replication to OneLake in Microsoft Fabric.
-
Viewing Placid Data in RAD Studio Data Explorer
How to view Placid data in RAD Studio Data Explorer using the CData ODBC Driver for Placid.
-
Build Semantic Layer Views for QuickBooks Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for QuickBooks data.
-
Build Semantic Layer Views for Power BI XMLA Data in APOS Live Data Gateway
Use the CData Connector for Power BI XMLA in APOS Live Data Gateway to build Semantic Layer Views for Power BI XMLA data.
-
Seamlessly Bring MailerLite Data into Retool Using CData Connect AI
Integrate MailerLite data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate ClickUp Data in Pentaho Data Integration
Build ETL pipelines based on ClickUp data in the Pentaho Data Integration tool.
-
How to connect and process Mailgun data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mailgun data.
-
Connect to and Visualize Live Salesforce Marketing Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce Marketing data.
-
Configure the CData JDBC Driver for Azure Data Lake Storage in a Connection Pool in Tomcat
Connect to Azure Data Lake Storage data from a connection pool in Tomcat.
-
Use Agno to Talk to Your SuiteCRM 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 SuiteCRM data for you.
-
Working with Productboard Data in LINQPad
Execute LINQ queries to Productboard data in LINQPad.
-
Integrating Antigravity CLI with Splunk data via CData CLI
Connect Splunk data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Missive Data from MySQL in PHP
Connect to Missive through the standard MySQL libraries in PHP.
-
Integrate SAP SuccessFactors Data in the Pentaho Report Designer
Publish reports based on SAP SuccessFactors data in the Pentaho BI tool.
-
Build AI/ML Models with Live Zuora Data using Dataiku
Connect Zuora Data with Dataiku using the CData JDBC Driver for Zuora.
-
Automated Continuous Unbounce Replication to MySQL
Use CData Sync for automated, continuous, customizable Unbounce replication to MySQL.
-
Integrating Claude Code CLI with Aircall 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.
-
Analyze Presto Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Presto from Power Pivot. You will use the Table Import Wizard to load Presto data. You can visually build the import query or use any SQL supported by the driver.
-
ETL Gumroad in Oracle Data Integrator
This article shows how to transfer Gumroad data into a data warehouse using Oracle Data Integrator.
-
Build AI Agents with Microsoft Entra ID 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 Microsoft Entra ID data through CData Connect AI.
-
Automate Mistral AI Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Mistral AI data from PowerShell? This article demonstrates how to utilize the Mistral AI Cmdlets for tasks like connecting to Mistral AI data, automating operations, downloading data, and more.
-
Connect to Microsoft Planner Data in Aqua Data Studio
Access Microsoft Planner data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
DataBind SAP BusinessObjects BI Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP BusinessObjects BI with the DevExpress Windows Forms and Web controls to provide SAP BusinessObjects BI data to a chart.
-
Access Sage 200 Data from MySQL in PHP
Connect to Sage 200 through the standard MySQL libraries in PHP.
-
Integrating LlamaIndex with Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Power BI XMLA data in real time.
-
Query Zoom Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zoom data from Node.js.
-
Build Semantic Layer Views for Google Translate Data in APOS Live Data Gateway
Use the CData Connector for Google Translate in APOS Live Data Gateway to build Semantic Layer Views for Google Translate data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Jumpseller
Provide connectivity to Jumpseller data through an SAP BusinessObjects universe.
-
Access Bitly Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Bitly data.
-
Connect Lakebase to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Lakebase data using the CData Python MCP Server.
-
Visualize MailerSend Data in Tableau
The CData ODBC driver for MailerSend enables you integrate MailerSend data into Tableau dashboards.
-
Build Visualizations of Deel Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Deel data in Birst.
-
Access Live Gmail 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 Gmail data through MCP integration.
-
Connect Testmonitor to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Testmonitor with IBM WebSphere for seamless data integration and connectivity.
-
Connecting Pipedream with Google Sheets 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 Google Sheets data in real time.
-
Visualize Apollo 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 Apollo data into TIBCO Spotfire.
-
Query Google Directory Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Directory entities in PHP by modeling them as objects.
-
How to Connect to Campaigner Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Campaigner data. Leverage the pyodbc module for ODBC in Python.
-
DataBind Controls to Simplesat Data in Delphi
DataBind to Simplesat data in Delphi with standard data access components and controls.
-
Integrate LibreChat with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Pipedrive data from within the chat interface.
-
Automate Google Ad Manager Data Replication to Couchbase
Use CData Sync to Customize and automate Google Ad Manager data replication to Couchbase.
-
Connect to Mailjet Data in Google Apps Script via Connect AI
Use CData Connect AI to access Mailjet data in Google Apps Script.
-
Visualize Access Data in Tableau
The CData ODBC driver for Access enables you integrate Access data into Tableau dashboards.
-
Automate Mailgun Data Replication to Azure Synapse
Use CData Sync to customize and automate Mailgun data replication to Azure Synapse.
-
Query Trello Data as a MySQL Database in Node.js
Execute MySQL queries against Trello data from Node.js.