CData Software - Knowledge Base
Recent Articles
-
Create Zoho Inventory-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Zoho Inventory Data from Klipfolio and build custom visualizations using live Zoho Inventory data.
-
How to create Access federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Access data in MySQL .
-
Import Tally Data Using Azure Data Factory
Use CData Connect AI to connect to Tally Data from Azure Data Factory and import live Tally data.
-
Connect to Reckon Data in Google Apps Script via Connect AI
Use CData Connect AI to access Reckon data in Google Apps Script.
-
Automated Continuous Clockify Replication to MongoDB
Use CData Sync for automated, continuous, customizable Clockify replication to MongoDB.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Authorize.Net
Provide connectivity to Authorize.Net data through an SAP BusinessObjects universe.
-
Automated Continuous Xero Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Xero replication to PostgreSQL.
-
Use the CData Software ODBC Driver for Sentry in MicroStrategy Web
Connect to Sentry data in MicroStrategy Web using the CData Software ODBC Driver for Sentry.
-
Automated Continuous LeadDesk Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable LeadDesk replication to delimited files (CSV/TSV).
-
Visualize Live Auth0 Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Auth0 data.
-
Access Attio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Attio data from HeidiSQL.
-
How to Seamlessly Import Box Data into IBM SPSS Modeler
Integrate Box data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Easily Integrate Azure Synapse Data in Lazarus Pascal IDE
Learn how to easily integrate live Azure Synapse data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access OpenWeatherMap Data from MySQL in PHP
Connect to OpenWeatherMap through the standard MySQL libraries in PHP.
-
Use Claude to Talk to Your Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Sugar CRM data for you.
-
Integrating GitHub Copilot with Excel Online 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 Insightly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Insightly as an External Source in Dremio.
-
Automated Continuous Outreach.io Replication to SQL Server
Use CData Sync for automated, continuous, customizable Outreach.io replication to SQL Server.
-
Query Snowflake Data as a SQL Server Database in Node.js
Execute SQL Server queries against Snowflake data from Node.js.
-
Integrate eBay Analytics with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate eBay Analytics with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to eBay Analytics data.
-
Connect to Raisers Edge NXT Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Raisers Edge NXT Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Automated FHIR-Connected Workflows in Zapier
Use CData Connect AI to connect to live FHIR data and build automated workflows in Zapier.
-
Configure the CData JDBC Driver for Neo4J in a Connection Pool in Tomcat
Connect to Neo4J data from a connection pool in Tomcat.
-
Natively Connect to iContact Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to iContact data. Leverage the native support for ODBC in PHP.
-
Use JayDeBeApi to access Shortcut Data in Python
Use standard Python scripting and the development environment of your choice to access live Shortcut data.
-
Create Informatica Mappings From/To a JDBC Data Source for Nuclia
Create Nuclia data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build AI/ML Models with Live Dropbox Data using Dataiku
Connect Dropbox Data with Dataiku using the CData JDBC Driver for Dropbox.
-
Build AI Agents with Moosend 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 Moosend data through CData Connect AI.
-
Build MVC Applications with Connectivity to Adobe Target Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Adobe Target from an ASP.NET MVC application.
-
Write a Simple Go Application to work with Pipedrive Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pipedrive data.
-
Automated Continuous MailerLite Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MailerLite replication to Azure SQL Database.
-
Getting Started with the CData Power BI Connector for MailChimp
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for MailChimp.
-
Connect to Salesforce Data in Aqua Data Studio
Access Salesforce data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Data Flows from SQL Server to Klaviyo through SSIS
Easily push SQL Server data to Klaviyo using the CData SSIS Tasks for Klaviyo.
-
Connect to and Visualize Live Perigon Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Perigon data.
-
Integrating Boomi Agentstudio with Microsoft Entra ID Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Entra ID data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous PhantomBuster Replication to SingleStore
Use CData Sync for automated, continuous, customizable PhantomBuster replication to SingleStore.
-
ETL Azure DevOps in Oracle Data Integrator
This article shows how to transfer Azure DevOps data into a data warehouse using Oracle Data Integrator.
-
Connect and Visualize Live Oracle Service Cloud Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle Service Cloud data into the Databricks platform and create visualization dashboards with real-time Oracle Service Cloud data.
-
Link SageHR with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SageHR data in Filemaker Pro for Mac or Windows.
-
Integrate Open WebUI with Live XML Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live XML data from within the chat interface.
-
Write a Simple Go Application to work with Stack Exchange Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Stack Exchange data.
-
How to Use a Microsoft Access Database to Update OneNote Data in Real Time
Update OneNote data by creating a linked table in Microsoft Access with the CData OneNote ODBC Driver.
-
Write a Simple Go Application to work with Campaigner Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Campaigner data.
-
Connect HBase to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live HBase data using the CData Python MCP Server.
-
Automated Continuous Attio Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Attio replication to Apache Kafka.
-
Build Voice Agents in ElevenLabs with access to Live iContact Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live iContact data.
-
Build Supabase-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Supabase data.
-
Build Snapchat Ads-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Snapchat Ads Data and create custom apps in Mendix.
-
Visualize Supabase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Supabase data.
-
Perform Batch Operations with MailChimp Data in Apache NiFi
Connect to MailChimp data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate ZendeskSell with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZendeskSell with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZendeskSell data.
-
Integrate with Live Bright Data Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Bright Data from the MuleSoft Anypoint Platform to integrate live Bright Data data into custom reports and dashboards.
-
How to Visualize AfterShip Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live AfterShip data in Python.
-
Create SSAS Tabular Models from Eventbrite Data
How to build a SQL Server Analysis Service Tabular Model from Eventbrite data using CData drivers.
-
Feed EmailOctopus Data into FineReport
How to set EmailOctopus data as a JDBC data source in FineReport.
-
Query Google Cloud Storage Data as a MySQL Database in Node.js
Execute MySQL queries against Google Cloud Storage data from Node.js.
-
Connect to Highrise Data in JRuby
Create a simple JRuby app with access to live Highrise data.
-
Connect to Active Directory Data in ACL Analytics
Connect to Active Directory data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Active Directory data.
-
Feed Amazon Athena Data into FineReport
How to set Amazon Athena data as a JDBC data source in FineReport.
-
Connect to Gong Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Gong as an External Source in Dremio.
-
How to Work with Oracle HCM Cloud Data in ETL Validator JDBC
Connect to Oracle HCM Cloud from ETL Validator jobs using the CData Software JDBC Driver.
-
Working with SAS Data Sets Data in LINQPad
Execute LINQ queries to SAS Data Sets data in LINQPad.
-
Automate Google Ad Manager Data Replication to SAP HANA
Use CData Sync to customize and automate Google Ad Manager data replication to SAP HANA.
-
Deploy the ADO.NET Provider for Excel Online on an SSRS Report Server
Connect to Excel Online data 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 connect and process SAP Ariba Source data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Ariba Source data.
-
Connecting Mastra with Testmonitor 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 Testmonitor data, no replication required.
-
HCL Domino Reporting in OBIEE with the HCL Domino JDBC Driver
Deploy the HCL Domino JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Google Forms Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Forms data.
-
Use Azure AI Foundry to Talk to Your Exact Online 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 Exact Online data for you.
-
Create Reports with Retently Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Retently data.
-
Use Claude to Talk to Your Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Smartsheet data for you.
-
How to Query Live Eventbrite Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Eventbrite data data in natural language using Python.
-
Query OneNote Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume OneNote entities in PHP by modeling them as objects.
-
Use Azure AI Foundry to Talk to Your SAP Fieldglass 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 SAP Fieldglass data for you.
-
Work with Landbot Data in FoxPro
Load Landbot data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Object-Relational Mapping (ORM) with Typeform 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 Typeform data into a Java-based ORM framework, Hibernate.
-
Connect to Egnyte Data in NetBeans
Connect to Egnyte data in NetBeans with the data source configuration wizard.
-
Connect to Quaderno Data in JRuby
Create a simple JRuby app with access to live Quaderno data.
-
Publish Reports with Adobe Commerce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Commerce data.
-
How to connect to MongoDB Data from Spring Boot
Connect to MongoDB in a Spring Boot Application using the CData JDBC Driver for MongoDB
-
Using the CData Software ODBC Driver for Sybase in PyCharm
Connect to Sybase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sybase.
-
Stream SharePoint Data into Apache Kafka Topics
Access and stream SharePoint data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Mailgun Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Mailgun data.
-
Use Claude to Talk to Your Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Email data for you.
-
Access Live Box Data in AWS Lambda
Connect to live Box data in AWS Lambda using the CData JDBC Driver.
-
Work with Wistia Data in FoxPro
Load Wistia data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create SQL Analysis Services-Connected Business Apps in AppSheet
Connect to SQL Analysis Services Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SQL Analysis Services data.
-
How to Connect to Live Dynamics NAV Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Dynamics NAV data for you.
-
Access ConvertKit Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ConvertKit data from HeidiSQL.
-
Connect to PolarTeamPro Data from a Connection Pool in JBoss
Integrate PolarTeamPro data into Java servlets: Use the Management Console in JBoss to install the PolarTeamPro JDBC Driver.
-
How to Access Live Zoom Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoom enables you to integrate Zoom data into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live GetResponse Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live GetResponse data into custom reports in Power BI.
-
Connect to Real-Time PingOne Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for PingOne and Dataflow to import and use PingOne data in Power Apps.
-
Edit and Search External SAP Business One Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Business One data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Business One Data objects that you can access from apps and the dashboard.
-
Build Apps with Live Email Data Using the Low-Code Development Platform of Mendix
Connect Email data with Mendix to build apps using the CData JDBC Driver for Email.
-
Build a Simple VCL Application for Retently Data
How to build a simple VCL Application to view Retently data in RAD Studio using the CData ODBC Driver for Retently.
-
Connect to SAP Business Warehouse Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Business Warehouse data.
-
LINQ to Dynamics NAV 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 Dynamics NAV Data Provider.
-
Interact with Live Zoho Creator Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Zoho Creator data.