CData Software - Knowledge Base
Recent Articles
-
Use Azure AI Foundry to Talk to Your Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Active Directory for you.
-
Build a Singer.io Tap for ZohoPeople With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ZohoPeople data using
-
Extend Google Sheets with Anaplan Data
Make calls to Anaplan from Google Apps Script via the API Server.
-
Build YouTube Analytics-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for YouTube Analytics to explore live YouTube Analytics Data in Cursor to assist with building YouTube Analytics-powered applications.
-
Integrate Sage 300 Data in Pentaho Data Integration
Build ETL pipelines based on Sage 300 in the Pentaho Data Integration tool.
-
Integrating LangChain with Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Acumatica ERP within automated workflows.
-
Automated Continuous RSS Replication to Databricks
Use CData Sync for automated, continuous, customizable RSS replication to Databricks.
-
Build Sybase-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Sybase Data from Zoho Analytics and import live Sybase.
-
Automated Continuous ChargeOver Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ChargeOver replication to delimited files (CSV/TSV).
-
Connect to and Visualize Live CSV Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live CSV/TSV Files.
-
Integrating Codex CLI with Ontraport 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 and Visualize Live Klaviyo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Klaviyo.
-
Connect to Sugar CRM from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Sugar CRM, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Google Contacts Data Replication to Teradata
Use CData Sync to Customize and automate Google Contacts replication to Teradata.
-
Connect to Shortcut Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Shortcut.
-
Create Azure Data Lake Storage-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Azure Data Lake Storage Data from OutSystems and build custom enterprise apps using live Azure Data Lake Storage.
-
How to Connect to Live Google Sheets 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 Google Sheets without replication.
-
Use the CData Software JDBC Driver for Azure Analysis Services in MicroStrategy
Connect to Azure Analysis Services in MicroStrategy Developer using the CData Software JDBC Driver for Azure Analysis Services.
-
Connect to Real-Time Amazon S3 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Amazon S3 and Dataflow to import and use Amazon S3 in Power Apps.
-
How to Seamlessly Import Paylocity Data into IBM SPSS Modeler
Integrate Paylocity data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to PayPal from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from PayPal, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData ODBC Driver for Vimeo in Microsoft Power Query
You can use the CData Vimeo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Vimeo into Microsoft Power Query.
-
Query Adobe Commerce Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Adobe Commerce entities in PHP by modeling them as objects.
-
Getting Started with the CData Excel Add-In for Mouseflow
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Mouseflow.
-
Automate Reckon Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Reckon and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use the CData Software ODBC Driver for Gong in SAS for Real-Time Reporting and Analytics
Connect to real-time Gong in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Gong.
-
Edit and Search Exact Online External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Exact Online to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Exact Online objects that you can access from apps and the dashboard.
-
How to Connect to & Open Clockify Data in Microsoft Excel
This article uses the CData ODBC driver for Clockify to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to ServiceDesk Plus Data in DBArtisan
Use wizards in DBArtisan to configure ServiceDesk Plus as a data source.
-
Integrating Cursor CLI with Certinia 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.
-
Working with Marketo Data in LINQPad
Execute LINQ queries to Marketo in LINQPad.
-
Create a Data Access Object for Samanage Data using JDBI
A brief overview of creating a SQL Object API for Samanage in JDBI.
-
Connect to ZohoMarketingHub Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ZohoMarketingHub and the SQL Gateway to access ZohoMarketingHub from Google Apps Script.
-
Feed Microsoft Planner Data into FineReport
How to set Microsoft Planner as a JDBC data source in FineReport.
-
A PostgreSQL Interface for Google Ad Manager Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Ad Manager JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to use SQLAlchemy ORM to access Miro Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Miro.
-
Import Real-Time Klaviyo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Klaviyo in ColdFusion.
-
Getting Started with the CData ADO.NET Provider for ActiveCampaign
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for ActiveCampaign.
-
How to connect to Productboard Data from Spring Boot
Connect to Productboard in a Spring Boot Application using the CData API Driver for JDBC
-
Access Live Microsoft Teams Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Teams into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Teams in the Graph Builder and Query Builder.
-
Getting Started with the CData Python Connector for Microsoft OneDrive
Learn to install and license the CData Python Connector
-
Connecting Moonlit Workflow with GitLab Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your GitLab in real time.
-
Integrate Live Adobe Analytics Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Adobe Analytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Adobe Analytics.
-
How to Query Gmail Data in MySQL Workbench
Execute MySQL queries against live Gmail from MySQL Workbench.
-
Creating BigQuery-Connected Applications in Unqork
You can use CData Connect AI to feed Google BigQuery to Unqork and build custom business apps.
-
How to Work with Missive Data in ETL Validator JDBC
Connect to Missive from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate Multiple OnePageCrm Accounts via the CData Sync CLI
Replicate multiple OnePageCrm accounts to one or many databases.
-
Create Informatica Mappings From/To an ODBC Data Source for Splunk
Create an ODBC connection to Splunk in Informatica and browse and transfer Splunk.
-
Connect to Oracle Eloqua Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle Eloqua from Filemaker Pro on Mac.
-
Build SendGrid-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SendGrid to explore live SendGrid Data in Claude Code to assist with building SendGrid-powered applications.
-
Bind Live Airtable Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Airtable data
-
Visualize Gmail 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 Gmail into TIBCO Spotfire.
-
Excel Spreadsheet Automation on SAP Business One Data with the QUERY Formula
Pull data from SAP Business One, automate spreadsheets, and more with the QUERY formula.
-
Integrating OAuth Authorization Code Grant with CData Connectors
A comprehensive guide to implementing OAuth Authorization Code Grant flows with CData embedded connectors for desktop and web applications.
-
Query Salesforce CRM Analytics Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Salesforce CRM Analytics entities in PHP by modeling them as objects.
-
Integrating Tally Data in Talend Cloud Data Management Platform
Connect Tally Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Tally.
-
Connect to NetSuite Data from a Connection Pool in JBoss
Integrate NetSuite CRM & ERP into Java servlets: Use the Management Console in JBoss to install the NetSuite JDBC Driver.
-
Extract, Transform, and Load Aircall Data in Informatica PowerCenter
Create a simple Workflow for Aircall in Informatica PowerCenter.
-
Replicate Multiple Clio Accounts via the CData Sync CLI
Replicate multiple Clio accounts to one or many databases.
-
Integrating Cursor CLI with Mixpanel 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 Instantly in SpagoBI
Create reports featuring live Instantly in SpagoBI Studio. Host Instantly reports on SpagoBI Server.
-
How to Connect to Live Power BI XMLA 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 Power BI XMLA through natural language.
-
Getting Started with the CData Tableau Connector for Sage 300
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Sage 300.
-
Object-Relational Mapping (ORM) with Amazon Athena 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 Amazon Athena into a Java-based ORM framework, Hibernate.
-
Analyze Google Drive Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Drive and visualize Google Drive in SAP Analytics Cloud.
-
Use the CData Software JDBC Driver for Sybase in MicroStrategy
Connect to Sybase in MicroStrategy Developer using the CData Software JDBC Driver for Sybase.
-
Automated Continuous Avro Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Avro replication to PostgreSQL.
-
Build Dashboards with Pipedrive Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pipedrive in Dundas BI.
-
Build a Simple VCL Application for Notion Data
How to build a simple VCL Application to view Notion in RAD Studio using the CData ODBC Driver for Notion.
-
Getting Started with the CData Python Connector for LightSpeedRetail
Learn to install and license the CData Python Connector
-
DataBind Charts to Pinecone Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Pinecone from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrating LlamaIndex with Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Square in real time.
-
Use the CData Software ODBC Driver for Cloudflare in SAS for Real-Time Reporting and Analytics
Connect to real-time Cloudflare in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cloudflare.
-
How to Connect to Live Dropbox Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Dropbox for you.
-
Moosend Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Moosend facts in real time.
-
Integrating Kiro CLI with Telegram 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 Xero Data in Delphi
DataBind to Xero Accounting in Delphi with standard data access components and controls.
-
Create Google Campaign Manager 360-Connected Dashboards in Grafana
Connect to Google Campaign Manager 360 Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Campaign Manager 360.
-
Connect to Google Analytics Data in HULFT Integrate
Connect to Google Analytics as a JDBC data source in HULFT Integrate
-
Create Bannerbear Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Bannerbear from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software JDBC Driver for Aircall in MicroStrategy
Connect to Aircall in MicroStrategy Developer using the CData Software JDBC Driver for Aircall.
-
Connect to Phoenix Data in NetBeans
Connect to Apache Phoenix in NetBeans with the data source configuration wizard.
-
How to Create Power BI Visual Reports with Real-Time HCL Domino Data
Use CData Power BI Connectors to visualize HCL Domino in Power BI.
-
How to load SAP ByDesign data into Elasticsearch via Logstash
Introducing a simple method to load SAP ByDesign data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating OpenCode Terminal with XML 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 Bright Data-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Bright Data.
-
Import Real-Time ADP Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ADP in ColdFusion.
-
Access Live Aweber Data in Coginiti Pro
Connect to and query live Aweber from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Notion Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Notion replication to IBM DB2.
-
Access Live Gong Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Gong from your Excel spreadsheets.
-
Integrate Theia IDE with Live WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connecting GenSpark with Greenhouse Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Greenhouse without any replication or custom integration required.
-
Automate Active Directory Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Active Directory and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous Zendesk Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zendesk replication to Google Cloud SQL.
-
Create HelloSign Dataflows on PowerBI.com
Connect to the CData Power BI Connector for HelloSign from PowerBI.com to create Power BI Dataflows with real-time data.
-
Model Exact Online Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Exact Online, enabling the direct import of real-time Exact Online.
-
Connecting Pipedream with Google Spanner 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 Spanner data in real time.
-
Automated Continuous DB2 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable DB2 replication to Apache Cassandra.
-
How to load Copper data into Elasticsearch via Logstash
Introducing a simple method to load Copper data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Klipfolio Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Klipfolio.