CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Highrise Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Highrise data in ColdFusion.
-
Query Raisers Edge NXT Data in DataGrip
Create a Data Source for Raisers Edge NXT in DataGrip and use SQL to query live Raisers Edge NXT data.
-
Connect to Grafana Data from a Connection Pool in Jetty
The Grafana JDBC Driver supports connection pooling: This article shows how to connect faster to Grafana data from Web apps in Jetty.
-
Automated Continuous Mailjet Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Mailjet replication to Apache Kafka.
-
Getting Started with the CData JDBC Driver for ShipStation
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ShipStation.
-
How to Connect to Klaviyo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Klaviyo data. Leverage the pyodbc module for ODBC in Python.
-
Create Data Visualizations Based On Confluence Data in Mode
Use CData Connect AI to connect to Confluence Data from Mode and build visualizations using live Confluence data.
-
Build a Singer.io Tap for Onfleet With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Onfleet data using the CData Python Connector.
-
Connect to Salesforce Pardot Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Salesforce Pardot to connect to Salesforce Pardot data and execute queries in PowerBuilder.
-
Easily Integrate Reckon Data in Lazarus Pascal IDE
Learn how to easily integrate live Reckon data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Live JobNimbus Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live JobNimbus data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live DB2 Data in AWS Lambda
Connect to live DB2 data in AWS Lambda using the CData JDBC Driver.
-
Access Live iContact Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live iContact data from your Excel spreadsheets.
-
Integrating LlamaIndex with Supabase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Supabase data in real time.
-
How to connect PolyBase to SAP Concur
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Concur data.
-
How to Connect to SAP SuccessFactors LMS Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP SuccessFactors LMS data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Live Google Cloud Storage Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Cloud Storage in CData Connect AI and connect to your Google Cloud Storage data from PostgreSQL.
-
Getting Started with the CData Excel Add-In for Insightly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Insightly.
-
Connect to Google Calendar from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Calendar data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Query Act-On Data as a MySQL Database in Node.js
Execute MySQL queries against Act-On data from Node.js.
-
Automated Continuous Reckon Accounts Hosted Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Amazon Redshift.
-
Build a Singer.io Tap for OData With the CData Python Connector
Learn how to easily build a Singer.io Tap for live OData data using the CData Python Connector.
-
DataBind Controls to Instagram Data in Delphi
DataBind to Instagram data in Delphi with standard data access components and controls.
-
Connecting Mastra with eBay Analytics 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 eBay Analytics data, no replication required.
-
Integrate Open WebUI with Live DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live DocuSign data from within the chat interface.
-
Connect to SageHR Data in DBeaver
Use the CData ODBC Driver to connect to SageHR data in DBeaver.
-
Operational Reporting on FHIR Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote FHIR data.
-
Feed Aha! Data into FineReport
How to set Aha! data as a JDBC data source in FineReport.
-
Integrating VWO Data in Talend Cloud Data Management Platform
Connect VWO Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Google Forms Data in JRuby
Create a simple JRuby app with access to live Google Forms data.
-
Integrate LibreChat with Live Adobe Target Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Adobe Target data from within the chat interface.
-
Automated Continuous Landbot Replication to Snowflake
Use CData Sync for automated, continuous, customizable Landbot replication to Snowflake.
-
How to connect to SAP Data from IntelliJ
Integrate connectivity to SAP data with wizards in IntelliJ.
-
How to integrate Xero with Apache Airflow
Access and process Xero data in Apache Airflow using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for PhantomBuster in MicroStrategy Desktop
Connect to PhantomBuster data in MicroStrategy Desktop using the CData Software ODBC Driver for PhantomBuster.
-
Replicate Multiple Keap Accounts via the CData Sync CLI
Replicate multiple Keap accounts to one or many databases.
-
Working with PingOne Data in LINQPad
Execute LINQ queries to PingOne data in LINQPad.
-
Create Avro Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Avro data access from reports, embedded analytics, and more.
-
Perform Batch Operations with XML Data in Apache NiFi
Connect to XML data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Back Up Avaza data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Avaza data data.
-
Connecting GenSpark with Quickbase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Quickbase data without any replication or custom integration required.
-
Create Wave Financial Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Wave Financial data access from reports, embedded analytics, and more.
-
Connect to SAP Ariba Source Data in CloverDX (formerly CloverETL)
Transfer SAP Ariba Source data using the visual workflow in the CloverDX data integration tool.
-
How to integrate Metabase with Dynamics 365 Data
Use CData Connect AI to connect to live Dynamics 365 data and create an interactive dashboard in Metabase from Dynamics 365 data.
-
Use the CData Software JDBC Driver for Vault CRM in MicroStrategy Web
Connect to Vault CRM data in MicroStrategy Web using the CData Software JDBC Driver for Vault CRM.
-
Import Real-Time WordPress Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use WordPress data in ColdFusion.
-
Publish Oracle SCM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle SCM data.
-
Build Charts with Elasticsearch Data in Clear Analytics
Create dynamic charts and perform analytics based on Elasticsearch data in Clear Analytics.
-
Integrate with Copper Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Copper data to a JSON file on disk.
-
Manage Amazon Athena Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Amazon Athena.
-
DataBind SQL Analysis Services Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SQL Analysis Services with the DevExpress Windows Forms and Web controls to provide SQL Analysis Services data to a chart.
-
Model AgileCRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and AgileCRM, enabling the direct import of real-time AgileCRM data.
-
Access Live Act CRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Act CRM data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use JayDeBeApi to access Reckon Accounts Hosted Data in Python
Use standard Python scripting and the development environment of your choice to access live Reckon Accounts Hosted data.
-
Working with DB2 Data in LINQPad
Execute LINQ queries to DB2 data in LINQPad.
-
Automate Pushbullet Data Replication to Azure Synapse
Use CData Sync to customize and automate Pushbullet data replication to Azure Synapse.
-
Automated Continuous Vault CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Vault CRM replication to SingleStore.
-
Connect to JobNimbus Data in NetBeans
Connect to JobNimbus data in NetBeans with the data source configuration wizard.
-
Connect and Query Live Guru Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Guru data into Databricks and enable direct, live querying and analysis without replication.
-
Automated Continuous Asana Replication to SQL Server
Use CData Sync for automated, continuous, customizable Asana replication to SQL Server.
-
Replicate Google Ad Manager Data to Multiple Databases
Replicate Google Ad Manager data to disparate databases with a point-and-click configuration.
-
Choosing the Best Method to Connect JSON to SQL Server: 5 Options Explained
Discover multiple ways to connect and use JSON services from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze Azure Data Lake Storage Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Azure Data Lake Storage data with the CData JDBC Driver for Azure Data Lake Storage.
-
Connect to Drip from Asprova with CData Software ODBC Driver for Drip
This article shows how to connect faster to Drip data from Asprova.
-
Connect to SparkPost in SpagoBI
Create reports featuring live SparkPost data in SpagoBI Studio. Host SparkPost reports on SpagoBI Server.
-
Create Oracle Eloqua-Connected Business Apps in AppSheet
Connect to Oracle Eloqua Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle Eloqua data.
-
Build Google Campaign Manager 360-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Campaign Manager 360 Data and create custom apps in Bubble.
-
Natively Connect to JobNimbus Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to JobNimbus data. Leverage the native support for ODBC in PHP.
-
Connect to Deel Data in RapidMiner
Integrate Deel data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to AdRoll Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for AdRoll and the SQL Gateway to access AdRoll data from Google Apps Script.
-
Getting Started with the CData Tableau Connector for Perigon
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Publish ServiceDesk Plus-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ServiceDesk Plus data.
-
Integrating OpenCode with Factorial 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.
-
Create AlloyDB-Connected Dashboards in Grafana
Connect to AlloyDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to AlloyDB data.
-
A PostgreSQL Interface for ActiveCampaign Data using the CData ODBC Driver
Use the SQL Gateway and ActiveCampaign ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query Chargebee Data in ColdFusion
Write standard ColdFusion data access code to connect to Chargebee data.
-
LINQ to JotForm 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 JotForm Data Provider.
-
Building Dynamic Web Pages with SharePoint Data Using AngularJS
Create single-page applications with live connectivity to SharePoint using the CData API Server.
-
Publish Snapchat Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Snapchat Ads data.
-
Changelog: Driver Update 2025.2
Review the driver-specific changes from the 2025.2 CData Driver release.
-
Visualize Live SharePoint Excel Services Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SharePoint Excel Services data.
-
Use Manus AI to Talk to Your Google Ads 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 Google Ads data.
-
Analyze Live Stripe Data in SAS Viya
Use CData Connect AI to connect to Stripe data from SAS Viya and deploy self-service analytics using live Stripe data.
-
Integrate SAS xpt Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAS xpt data and integrate live SAS xpt data into your Power Automate tasks.
-
How to Seamlessly Import Access Data into IBM SPSS Modeler
Integrate Access data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to import Contentful Data into Apache Solr
Use the CData Software JDBC Driver for Contentful in Data Import Handler and create an automated import of Contentful data to Apache Solr Enterprise Search platform.
-
Use the CData ODBC Driver for OnePageCrm from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for OnePageCrm to connect to OnePageCrm data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring OnePageCrm data in Excel.
-
How to Connect to Live Azure Table 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 Azure Table data for you.
-
Connect to Real-Time Oracle SCM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle SCM and Dataflow to import and use Oracle SCM data in Power Apps.
-
Create a Data Access Object for Sage 300 Data using JDBI
A brief overview of creating a SQL Object API for Sage 300 data in JDBI.
-
Query Demio Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Demio data from Node.js.
-
Connect to SendPulse from a Connection Pool in WebLogic
Use the CData JDBC Driver for SendPulse to connect to SendPulse data from Web applications running on WebLogic.
-
Replicate Postmark Data to Multiple Databases
Replicate Postmark data to disparate databases with a point-and-click configuration.
-
Create Cvent-Connected Dashboards in Grafana
Connect to Cvent Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Cvent data.
-
Integrate Dify with Live Supabase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Supabase data.
-
Create AgileCRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for AgileCRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Visualize ServiceNow Data in Python with pandas
Use pandas and other modules to analyze and visualize live ServiceNow data in Python.
-
How to integrate WordPress with Apache Airflow
Access and process WordPress data in Apache Airflow using the CData JDBC Driver.
-
Integrate SendInBlue Data in the Pentaho Report Designer
Publish reports based on SendInBlue data in the Pentaho BI tool.
-
Procore Reporting in OBIEE with the Procore JDBC Driver
Deploy the Procore JDBC driver on OBIEE to provide real-time reporting across the enterprise.