CData Software - Knowledge Base
Recent Articles
-
Connect to Tally Data from Crystal Reports
Use CData Connect AI to connect to and report on live Tally ERP from Crystal Reports.
-
How to Access Sybase Data Using Entity Framework
This article shows how to access Sybase using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Claude Code with SAP BusinessObjects BI Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP BusinessObjects BI within assisted coding and automated development workflows.
-
How to Access Live Helpscout Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Helpscout enables you to integrate Helpscout into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to SendGrid Data in Delphi
DataBind to SendGrid in Delphi with standard data access components and controls.
-
Create Slack-Connected Dashboards in Grafana
Connect to Slack Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Slack.
-
Access Live SAP HANA 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 SAP HANA through MCP integration.
-
Configure the CData JDBC Driver for SQL Server in a Connection Pool in Tomcat
Connect to Microsoft SQL Server from a connection pool in Tomcat.
-
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 Apache Impala through CData Connect AI.
-
How to work with SingleStore Data in Apache Spark using SQL
Access and process SingleStore Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to GraphQL Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live GraphQL.
-
Connect Factorial to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Factorial with IBM WebSphere for seamless data integration and connectivity.
-
How to Query Live SAP Concur Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Concur data in natural language using Python.
-
Edit and Search External Sage 200 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Sage 200 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.
-
Build Adobe Analytics-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Adobe Analytics Data and create custom apps in Bubble.
-
Connect to SAP HANA Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP HANA in Airbyte.
-
Automate API Data Replication to Azure Synapse
Use CData Sync to customize and automate API replication to Azure Synapse.
-
How to publish and share Azure Synapse Data dashboards with Tableau Server
The CData ODBC driver for Azure Synapse enables you integrate Azure Synapse into Tableau dashboards.
-
Migrating data from LDAP to Databricks using CData SSIS Components.
Easily push LDAP to Databricks using the CData SSIS Tasks for LDAP and Databricks.
-
Work with Live MYOB AccountRight Data in Power Query
Use CData Connect AI to connect to MYOB AccountRight and work with live MYOB AccountRight in Microsoft Power Query.
-
Use JayDeBeApi to access Reply.io Data in Python
Use standard Python scripting and the development environment of your choice to access live Reply.io.
-
Connect to Monday.com Data in HULFT Integrate
Connect to Monday.com as a JDBC data source in HULFT Integrate
-
Create Power BI Reports on Real-Time Tickspot Data
Use the CData ODBC Driver for Tickspot to visualize Tickspot in Power BI Desktop.
-
Migrating data from HubDB to Databricks using CData SSIS Components.
Easily push HubDB to Databricks using the CData SSIS Tasks for HubDB and Databricks.
-
Bidirectional Access to PingOne Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PingOne in Filemaker Pro for Mac or Windows.
-
Add Box Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Box with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect to CouchDB Data from IntelliJ
Integrate connectivity to Apache CouchDB with wizards in IntelliJ.
-
Connect to ShipEngine in SpagoBI
Create reports featuring live ShipEngine in SpagoBI Studio. Host ShipEngine reports on SpagoBI Server.
-
Integrate with Hugging Face Data in JReport Designer
Create charts and reports based on Hugging Face in JReport Designer.
-
Automated Continuous Jira Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Jira replication to Apache Cassandra.
-
Edit and Search Reckon External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Reckon to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Reckon objects that you can access from apps and the dashboard.
-
Feed SAP Netweaver Gateway Data into FineReport
How to set SAP Netweaver Gateway 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.
-
How to Query Live Google Calendar Data in Perplexity MacOS Desktop
Connect to and query live Google Calendar Data in Perplexity Desktop using CData MCP Server.
-
Use Microsoft Copilot Studio to talk to your Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Kintone for you.
-
How to Work with Access Data in AWS Glue Jobs Using JDBC
Connect to Access from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Deploy the ADO.NET Provider for Zoho Inventory on an SSRS Report Server
Connect to Zoho Inventory 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.
-
How to Query Live Amazon S3 Data in Claude Desktop
Connect to and query live Amazon S3 Data in Claude Desktop using CData MCP Server.
-
How to connect and process Azure Synapse from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Azure Synapse.
-
Use the CData Software ODBC Driver for Instagram in SAS for Real-Time Reporting and Analytics
Connect to real-time Instagram in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Instagram.
-
Replicate Multiple Codat Accounts via the CData Sync CLI
Replicate multiple Codat accounts to one or many databases.
-
Create JotForm Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time JotForm data access from reports, embedded analytics, and more.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Shopify using the Model Context Protocol.
-
Integrating GitHub Copilot CLI with EmailOctopus 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 Raisers Edge NXT Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Raisers Edge NXT Data and connect to Raisers Edge NXT in Akorbi Digital RunMyProcess.
-
DataBind Charts to Trello Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Trello 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.
-
Connect to Xero Data in RapidMiner
Integrate Xero Accounting with standard components and data source configuration wizards in RapidMiner Studio.
-
Feed HCL Domino Data into FineReport
How to set HCL Domino as a JDBC data source in FineReport.
-
Build Charts with Optimizely Data in Clear Analytics
Create dynamic charts and perform analytics based on Optimizely in Clear Analytics.
-
Connect ServiceNow to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ServiceNow using the CData Python MCP Server.
-
How to Connect to & Open MailerSend Data in Microsoft Excel
This article uses the CData ODBC driver for MailerSend to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Microsoft OneDrive 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 Microsoft OneDrive through MCP integration.
-
Connect to and Visualize Live AdRoll Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live AdRoll.
-
Build an OLAP Cube in SSAS from Toggl Data
Establish a connection to Toggl data from SQL Server Analysis Services, and use the Toggl Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect the Power BI Service to IBM Cloud Object Storage: Complete Guide
Connect to the CData Software Power BI Connector for IBM Cloud Object Storage from PowerBI.com to provide real-time IBM Cloud Object Storage across the organization.
-
How to work with Oracle SCM Data in Apache Spark using SQL
Access and process Oracle SCM Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect DBeaver to Airtable via a JDBC Driver
Manage Airtable with visual tools in DBeaver like the query browser.
-
How to publish and share Authorize.Net Data dashboards with Tableau Server
The CData ODBC driver for Authorize.Net enables you integrate Authorize.Net into Tableau dashboards.
-
Perform Batch Operations with SharePoint Data in Apache NiFi
Connect to Microsoft SharePoint and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Live NetSuite Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Consume Google Analytics OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Analytics feeds that reflect any changes in SAP Lumira.
-
Visualize Live Marketo Data in the Power BI Service
Use CData Connect AI to connect to live Marketo and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Authorize.Net Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Authorize.Net and visualize Authorize.Net in SAP Analytics Cloud.
-
Integrating Dynamics NAV Data in Talend Cloud Data Management Platform
Connect Dynamics NAV Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Dynamics NAV.
-
Working with DocuSign Data in LINQPad
Execute LINQ queries to DocuSign in LINQPad.
-
Load Copper Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Copper to a database.
-
How to Easily Query Tally Data in OpenOffice Base
Connect to Tally data in OpenOffice Base using the CData ODBC Driver for Tally and generate reports with live data insights.
-
Migrating data from Salesforce Marketing to Databricks using CData SSIS Components.
Easily push Salesforce Marketing Cloud to Databricks using the CData SSIS Tasks for Salesforce Marketing and Databricks.
-
Getting Started with the CData ADO.NET Provider for Aircall
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous ZohoExpense Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZohoExpense replication to delimited files (CSV/TSV).
-
Use Databricks Agent Bricks to Talk to Your Cosmos DB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure Cosmos DB for you.
-
Create Box-Connected Nintex Workflows
Use CData Connect AI to connect to Box Data from Nintex Workflow Cloud and build custom workflows using live Box.
-
DataBind Controls to SAP Ariba Procurement Data in Delphi
DataBind to SAP Ariba Procurement in Delphi with standard data access components and controls.
-
Connect to Instagram Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Instagram and the SQL Gateway to access Instagram from Google Apps Script.
-
Import Dynamics 365 Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Dynamics 365. In this article, you will use the OData format to import Microsoft Dynamics 365 into Microsoft Power Query.
-
Query MariaDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against MariaDB from Node.js.
-
Build Dashboards with SFTP Data in Dundas BI
Create dynamic dashboards and perform analytics based on SFTP in Dundas BI.
-
Bidirectional Access to Paymo Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Paymo in Filemaker Pro for Mac or Windows.
-
Create Datasets from PagerDuty in Domo Workbench and Build Visualizations of PagerDuty Data in Domo
Use the CData Software ODBC Driver for PagerDuty to create datasets from PagerDuty in Domo Workbench and then build visualizations in the Domo service.
-
Integrate LibreChat with Live Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Ad Manager from within the chat interface.
-
Replicate MailerSend Data from PowerShell
Write a quick PowerShell script to query MailerSend. Use connectivity to the live data to replicate MailerSend to SQL Server.
-
Use Biml to Build SSIS Tasks to Replicate Sybase Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sybase to SQL Server.
-
Changelog: Driver Update 2025.2
Review the driver-specific changes from the 2025.2 CData Driver release.
-
How to connect PolyBase to Suadeo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Suadeo.
-
Automated Continuous RSS Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable RSS replication to Apache Kafka.
-
Automated Continuous ZohoDesk Replication to SQL Server
Use CData Sync for automated, continuous, customizable ZohoDesk replication to SQL Server.
-
Connect to ElevenLabs Data in JRuby
Create a simple JRuby app with access to live ElevenLabs.
-
DataBind Controls to SAS Data Sets Data in C++Builder
DataBind to SAS Data Sets in C++Builder with standard components and controls.
-
How to create Moosend federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Moosend in MySQL .
-
How to Build an ETL App for Epicor Kinetic Data in Python with CData
Create ETL applications and real-time data pipelines for Epicor Kinetic in Python with petl.
-
How to Query Moosend Data in MySQL Workbench
Execute MySQL queries against live Moosend from MySQL Workbench.
-
Analyze SAP BusinessObjects BI Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP BusinessObjects BI and visualize SAP BusinessObjects BI in SAP Analytics Cloud.
-
Bridge Printful Connectivity with Apache NiFi
Access and process Printful in Apache NiFi using the CData JDBC Driver.
-
Connect to SAP Business One Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP Business One and the SQL Gateway to access SAP Business One from Google Apps Script.
-
How to publish and share PagerDuty Data dashboards with Tableau Server
The CData ODBC driver for PagerDuty enables you integrate PagerDuty into Tableau dashboards.
-
How to Create Power BI Visual Reports with Real-Time SAP Concur Data
Use CData Power BI Connectors to visualize SAP Concur in Power BI.
-
Establish a Live Connection with MariaDB Data using Tableau Bridge
The CData ODBC Driver for MariaDB enables you to integrate live MariaDB into Tableau Cloud dashboards using the Tableau Bridge.
-
Import Real-Time Shippo Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Shippo in ColdFusion.
-
Connect to Mouseflow Data in Jaspersoft Studio
Execute SQL to remote Mouseflow in Jaspersoft Studio.
-
View Reports on Real-Time Cloudant Data in Power BI Report Server
Use the CData ODBC Driver for Cloudant to visualize IBM Cloudant in Power BI Desktop and then publish them to Power BI Report Server.