CData Software - Knowledge Base
Recent Articles
-
Bidirectional Access to ZohoInvoice Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZohoInvoice in Filemaker Pro for Mac or Windows.
-
Operational Reporting on Email Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Email.
-
Connect to Elasticsearch Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Elasticsearch in Airbyte.
-
Build a Singer.io Tap for Recurly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Recurly data using
-
DataBind Controls to MailChimp Data in Delphi
DataBind to MailChimp in Delphi with standard data access components and controls.
-
How to Build an ETL App for Tanda Data in Python with CData
Create ETL applications and real-time data pipelines for Tanda in Python with petl.
-
How to Query Sugar CRM Data in MySQL Workbench
Execute MySQL queries against live Sugar CRM from MySQL Workbench.
-
Use the CData API Server to Access Jira Data in Microsoft PowerPivot
Use the CData API Server to connect to live Atlassian Jira in the Power Pivot business intelligence tool.
-
Build Okta-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Okta Data and create custom apps in Mendix.
-
Build Semantic Layer Views for Vertica Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Vertica.
-
Integrate Cursor with Live Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoho Projects from within the editor.
-
Connect to SAS Data Sets Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAS Data Sets from Filemaker Pro on Mac.
-
Build SAP BusinessObjects BI-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP BusinessObjects BI Data and create custom apps in Mendix.
-
Establish a Live Connection with Gong Data using Tableau Bridge
The CData ODBC Driver for Gong enables you to integrate live Gong into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Data Flows from Azure Analysis Services to SQL Server using SSIS
Easily back up Azure Analysis Services to SQL Server using the SSIS components for Azure Analysis Services.
-
Build Lakebase-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Lakebase Data from Zoho Analytics and import live Lakebase.
-
How to publish and share Google Campaign Manager 360 Data dashboards with Tableau Server
The CData ODBC driver for Google Campaign Manager 360 enables you integrate Google Campaign Manager 360 into Tableau dashboards.
-
Build Automated Workflows with Live Azure Synapse Data in Workato
Use CData Connect AI to connect to live Azure Synapse and build automated workflows in Workato.
-
How to Connect to Live Exact Online 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 Exact Online for you.
-
Connect to MongoDB Data in DBeaver
Use the CData ODBC Driver to connect to MongoDB in DBeaver.
-
Build Apps with Live Aircall Data Using the Low-Code Development Platform of Mendix
Connect Aircall with Mendix to build apps using the CData API Driver for JDBC.
-
Getting Started: Build a Customer Health AI Agent with Microsoft Copilot Studio and CData Connect AI
Learn how to build a customer health AI agent in Microsoft Copilot Studio using CData Connect AI to analyze sample customer data from Google Sheets.
-
Connect to Zoho Creator Data from HeidiSQL
Use CData Connect AI to connect to and query live Zoho Creator from HeidiSQL.
-
Use the CData Software JDBC Driver for Qualaroo in MicroStrategy Web
Connect to Qualaroo in MicroStrategy Web using the CData Software JDBC Driver for Qualaroo.
-
How to Connect Google Directory 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 Google Directory data in real time using natural language.
-
Work with ZarMoney Data in FoxPro
Load ZarMoney into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Kafka Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Kafka replication to Google BigQuery.
-
Automated Continuous Bullhorn CRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Google BigQuery.
-
Access Discord Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Discord from HeidiSQL.
-
Connect to Reckon Accounts Hosted Data from PowerBuilder via ADO.NET
This article demonstrates how to access Reckon Accounts Hosted from Appeon PowerBuilder using the CData ADO.NET Provider for Reckon Accounts Hosted.
-
Replicate ZohoSubscriptions Data to Multiple Databases via the CData Sync CLI
Replicate ZohoSubscriptions to disparate databases with a single configuration.
-
Connect to Splunk Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Splunk and the SQL Gateway to access Splunk from Google Apps Script.
-
Analyze Aweber Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Aweber in Microsoft R Open.
-
Integrate Real-Time Access to PayPal in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to PayPal in real time.
-
Connect to Pinterest Data in Jaspersoft Studio
Execute SQL to remote Pinterest in Jaspersoft Studio.
-
Automate Freshteam Data Replication to SAP HANA
Use CData Sync to customize and automate Freshteam replication to SAP HANA.
-
Automated Continuous ActiveCampaign Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Google BigQuery.
-
Build Charts with Humanity Data in Clear Analytics
Create dynamic charts and perform analytics based on Humanity in Clear Analytics.
-
Create Reports from SAP Ariba Procurement Data in Looker Studio
Use CData Connect AI to gain access to live SAP Ariba Procurement and create custom reports in Looker Studio.
-
Create Dynamic Hive Grids Using the Infragistics XamDataGrid
Learn how you can connect Hive to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software JDBC Driver for Vimeo in MicroStrategy
Connect to Vimeo in MicroStrategy Developer using the CData Software JDBC Driver for Vimeo.
-
How to Use a Microsoft Access Database to Update Google Calendar Data in Real Time
Update Google Calendar data by creating a linked table in Microsoft Access with the CData Google Calendar ODBC Driver.
-
Connect to Jodoo Data in Aqua Data Studio
Access Jodoo from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Migrating data from Timely to Google BigQuery using CData SSIS Components.
Easily push Timely to Google BigQuery using the CData SSIS Tasks for Timely and Google BigQuery.
-
Integrating Cursor CLI with Scrapfly 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.
-
Build Amazon DynamoDB-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Amazon DynamoDB to explore live Amazon DynamoDB Data in Gemini Code Assist to assist with building Amazon DynamoDB-powered applications.
-
Build Data Flows from Attio to SQL Server using SSIS
Easily back up Attio to SQL Server using the SSIS components for Attio.
-
Configure the CData JDBC Driver for Instantly in a Connection Pool in Tomcat
Connect to Instantly from a connection pool in Tomcat.
-
Use the CData Software ODBC Driver for PolarTeamPro in MicroStrategy Web
Connect to PolarTeamPro in MicroStrategy Web using the CData Software ODBC Driver for PolarTeamPro.
-
Access Sendwithus 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 Sendwithus.
-
Create Microsoft Entra ID Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft Entra ID from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to CouchDB 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 Apache CouchDB.
-
A PostgreSQL Interface for Retently Data using the CData ODBC Driver
Use the SQL Gateway and Retently ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Snowflake Data in TIBCO Data Virtualization
Use the Snowflake Tibco DV Adapter to create a Snowflake data source in TIBCO Data Virtualization Studio and gain access to live Snowflake from your TDV Server.
-
Build Automated QuickBooks Time-Connected Workflows in Zapier
Use CData Connect AI to connect to live QuickBooks Time and build automated workflows in Zapier.
-
Connect to Beeminder Data in DBArtisan
Use wizards in DBArtisan to configure Beeminder as a data source.
-
Build Data Flows from SQL Server to Bullhorn CRM through SSIS
Easily push SQL Server data to Bullhorn CRM using the CData SSIS Tasks for Bullhorn CRM.
-
Create Informatica Mappings From/To a JDBC Data Source for Oracle Eloqua Reporting
Create Oracle Eloqua Reporting data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Real-Time Access to Act CRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Act CRM in real time.
-
Integrate Live Sage Intacct Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SingleStore
Provide connectivity to SingleStore through an SAP BusinessObjects universe.
-
Use Agno to Talk to Your Asana 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 Asana for you.
-
Build Semantic Layer Views for Figshare Data in APOS Live Data Gateway
Use the CData Connector for Figshare in APOS Live Data Gateway to build Semantic Layer Views for Figshare.
-
Automate SageHR Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SageHR from PowerShell? This article demonstrates how to utilize the SageHR Cmdlets for tasks like connecting to SageHR, automating operations, downloading data, and more.
-
Integrate Goose with Live SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP Ariba Procurement from within the local AI agent.
-
Integrating Claude Code CLI with Basecamp 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.
-
Excel Spreadsheet Automation on Figshare Data with the QUERY Formula
Pull data from Figshare, automate spreadsheets, and more with the QUERY formula.
-
Access Live Discourse Data in AWS Lambda
Connect to live Discourse in AWS Lambda using the CData JDBC Driver.
-
Connecting Mastra with Microsoft Dataverse 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 Microsoft Dataverse (CDS), no replication required.
-
Replicate PabblySubscriptions Data in Heroku for Use in Salesforce Connect
Replicate PabblySubscriptions to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connecting GenSpark with Blackbaud FE NXT Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Blackbaud FE NXT without any replication or custom integration required.
-
Integrate Goose with Live Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Apache Cassandra from within the local AI agent.
-
Create SSAS Tabular Models from Google Search Results
How to build a SQL Server Analysis Service Tabular Model from Google Search using CData drivers.
-
Integrating GitHub Copilot CLI with Google Drive 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.
-
Migrating data from Sage Cloud Accounting to Snowflake using CData SSIS Components.
Easily push Sage Business Cloud Accounting to Snowflake using the CData SSIS Tasks for Sage Cloud Accounting and Snowflake.
-
Use the CData Software ODBC Driver for Gorgias in SAS for Real-Time Reporting and Analytics
Connect to real-time Gorgias in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Gorgias.
-
Natively Connect to Browserless Data in PHP
The CData ODBC driver for Browserless enables you to create PHP applications with connectivity to Browserless. Leverage the native support for ODBC in PHP.
-
Automated CSV Data Replication to Teradata
Use CData Sync to Customize and automate CSV/TSV Files replication to Teradata.
-
Create SSAS Tabular Models from Quickbase Data
How to build a SQL Server Analysis Service Tabular Model from Quickbase using CData drivers.
-
Excel Spreadsheet Automation on Samanage Data with the QUERY Formula
Pull data from Samanage, automate spreadsheets, and more with the QUERY formula.
-
Integrating Kiro CLI with Jodoo 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.
-
Publish ConvertAPI-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ConvertAPI.
-
How to Query Live Google Directory Data in Claude Desktop
Connect to and query live Google Directory Data in Claude Desktop using CData MCP Server.
-
Validate MailerSend Data with QuerySurge
Access and validate MailerSend in QuerySurge using the CData JDBC Driver.
-
Integrating GitHub Copilot CLI with GetResponse 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 Live SAP BusinessObjects BI Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP BusinessObjects BI from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP BusinessObjects BI.
-
How to create Visio diagrams from Google Sheets Data
Automatically update Google Sheets with the changes you make to Visio master shapes.
-
Integrating LlamaIndex with PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on PayPal in real time.
-
Query Missive Data as a MySQL Database in Node.js
Execute MySQL queries against Missive from Node.js.
-
How to work with Freshteam Data in Apache Spark using SQL
Access and process Freshteam Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Amazon DynamoDB Data in DBeaver
Use the CData ODBC Driver to connect to Amazon DynamoDB in DBeaver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MarkLogic
Provide connectivity to MarkLogic through an SAP BusinessObjects universe.
-
Write a Simple Go Application to work with ZohoSubscriptions Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZohoSubscriptions.
-
How to Connect to Live QuickBooks Online Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live QuickBooks Online without replication.
-
Enable the Placid JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Placid.
-
Visualize Oracle Eloqua Reporting Data in Sisense
Create an ElastiCube in Sisense app with access to Oracle Eloqua Reporting.
-
Access Asana Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Asana from HeidiSQL.
-
Bridge ServiceDesk Plus Connectivity with Apache NiFi
Access and process ServiceDesk Plus in Apache NiFi using the CData JDBC Driver.
-
Build SAP Hybris C4C-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP Hybris C4C to explore live SAP Hybris C4C Data in GitHub Copilot to assist with building SAP Hybris C4C-powered applications.
-
Connect to Square Data from Crystal Reports
Use CData Connect AI to connect to and report on live Square from Crystal Reports.