CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Stripe in MicroStrategy
Connect to Stripe in MicroStrategy Developer using the CData Software JDBC Driver for Stripe.
-
Integrating OpenCode Terminal with Vault CRM 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 PivotalTracker Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PivotalTracker data access from reports, embedded analytics, and more.
-
Getting Started with the CData Tableau Connector for Eventbrite
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Query Live Zuora Data in Claude Desktop
Connect to and query live Zuora Data in Claude Desktop using CData MCP Server.
-
How to Build an ETL App for Zuora Data in Python with CData
Create ETL applications and real-time data pipelines for Zuora in Python with petl.
-
Connect to OneNote Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for OneNote to connect to Microsoft OneNote and execute queries in PowerBuilder.
-
How to Access Freshdesk Data Using Entity Framework
This article shows how to access Freshdesk using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Charts with Stripe Data in Clear Analytics
Create dynamic charts and perform analytics based on Stripe in Clear Analytics.
-
Getting Started with the CData JDBC Driver for Facebook
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Facebook.
-
Natively Connect to Aweber Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Aweber. Leverage the native support for ODBC in PHP.
-
How to load ZohoSubscriptions data into Elasticsearch via Logstash
Introducing a simple method to load ZohoSubscriptions data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query DB2 Data from Node.js
Use the OData endpoint of the CData API Server to connect to your IBM DB2 and perform CRUD operations on DB2 from Node.js.
-
Connect to Dropbox Data from HeidiSQL
Use CData Connect AI to connect to and query live Dropbox from HeidiSQL.
-
How to use SQLAlchemy ORM to access Copper Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Copper.
-
Build a Simple VCL Application for AgileCRM Data
How to build a simple VCL Application to view AgileCRM in RAD Studio using the CData ODBC Driver for AgileCRM.
-
Connect Dynamics NAV to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Dynamics NAV using the CData Python MCP Server.
-
DataBind Controls to Google Tasks Data in C++Builder
DataBind to Google Tasks in C++Builder with standard components and controls.
-
How to publish and share SingleStore Data dashboards with Tableau Server
The CData ODBC driver for SingleStore enables you integrate SingleStore into Tableau dashboards.
-
Connect ElevenLabs to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ElevenLabs using the CData Python MCP Server.
-
Access Live OData Services in AWS Lambda (with IntelliJ IDEA)
Connect to live OData in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect Humanity to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Humanity with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Vault CRM Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Veeva Vault & Vault CRM for you.
-
Integrating GitHub Copilot CLI with Apache Impala 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.
-
Bright Data Reporting in OBIEE with the Bright Data JDBC Driver
Deploy the Bright Data JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Live Perplexity Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Perplexity using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Elasticsearch in SpagoBI
Create reports featuring live Elasticsearch in SpagoBI Studio. Host Elasticsearch reports on SpagoBI Server.
-
Access EnterpriseDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access EnterpriseDB from your Oracle system.
-
Getting Started with the CData JDBC Driver for Salesforce Pardot
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Salesforce Pardot.
-
Replicate Bitbucket Data to Multiple Databases via the CData Sync CLI
Replicate Bitbucket to disparate databases with a single configuration.
-
Connect Recurly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Recurly using the CData Python MCP Server.
-
Connect to Vercel Data in RapidMiner
Integrate Vercel with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind Controls to SingleStore Data in Delphi
DataBind to SingleStore in Delphi with standard data access components and controls.
-
Analyze API Data in Looker
Use CData Connect AI to connect to API Data from Looker and build custom apps using live API.
-
Create Apps from Dynamics CRM Data in Qlik Sense Cloud
Use CData Connect AI to connect to Dynamics CRM Data and build apps from live Microsoft Dynamics CRM in Qlik Sense Cloud.
-
Connect to Google Sheets Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Sheets.
-
Integrating GitHub Copilot CLI with Teamwork 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 Data Flows from Paymo to SQL Server using SSIS
Easily back up Paymo to SQL Server using the SSIS components for Paymo.
-
How to Work with Accelo Data in AWS Glue Jobs Using JDBC
Connect to Accelo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Replicate Multiple NetSuite Accounts via the CData Sync CLI
Replicate multiple NetSuite accounts to one or many databases.
-
Getting Started with the CData ADO.NET Provider for Browserless
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Excel Online Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Excel Online from HeidiSQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Calendar
Provide connectivity to Google Calendar through an SAP BusinessObjects universe.
-
Enable the Tally JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Tally ERP.
-
Connect to Mailjet Data from PowerBuilder via JDBC
This article demonstrates how to access Mailjet from PowerBuilder using the Mailjet JDBC Driver.
-
Configure the CData JDBC Driver for MariaDB in a Connection Pool in Tomcat
Connect to MariaDB from a connection pool in Tomcat.
-
How to create an RPA flow for JotForm Data in UiPath Studio
Use the JotForm ODBC Driver to create workflows that access real-time JotForm without any coding.
-
How to Work with Insightly Data in AWS Glue Jobs Using JDBC
Connect to Insightly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Bridge Samanage Connectivity with Apache NiFi
Access and process Samanage in Apache NiFi using the CData JDBC Driver.
-
Phoenix Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Phoenix facts in real time.
-
Build MySQL-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for MySQL Data and create custom apps in Mendix.
-
Access Tickspot Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Tickspot from HeidiSQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Hubstaff
Provide connectivity to Hubstaff through an SAP BusinessObjects universe.
-
Integrate Theia IDE with Live SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connecting GenSpark with Zoho Books Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Zoho Books without any replication or custom integration required.
-
How to Design Dynamics 365 Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Dynamics 365 from mobile and tablet Power Apps.
-
How to Import Data from Certinia into Google Sheets
Import Certinia into a Google spreadsheet that is automatically refreshed.
-
How to Use a Microsoft Access Database to Update Marketo Data in Real Time
Update Marketo data by creating a linked table in Microsoft Access with the CData Marketo ODBC Driver.
-
Import Real-Time Basecamp Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Basecamp in ColdFusion.
-
Automated Continuous Airtable Replication to Databricks
Use CData Sync for automated, continuous, customizable Airtable replication to Databricks.
-
Integrate Real-Time Access to Microsoft Ads in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Ads in real time.
-
Migrating data from Google Calendar to Google BigQuery using CData SSIS Components.
Easily push Google Calendar to Google BigQuery using the CData SSIS Tasks for Google Calendar and Google BigQuery.
-
Replicate Copper Data from PowerShell
Write a quick PowerShell script to query Copper. Use connectivity to the live data to replicate Copper to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MarkLogic
Provide connectivity to MarkLogic through an SAP BusinessObjects universe.
-
Migrating data from SAP SuccessFactors to Snowflake using CData SSIS Components.
Easily push SAP SuccessFactors to Snowflake using the CData SSIS Tasks for SAP SuccessFactors and Snowflake.
-
Getting Started with the CData Excel Add-In for Miro
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Miro.
-
Build MVC Applications with Connectivity to PDFMonkey Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access PDFMonkey from an ASP.NET MVC application.
-
Connect to CSV in SpagoBI
Create reports featuring live CSV/TSV Files in SpagoBI Studio. Host CSV reports on SpagoBI Server.
-
Access MarkLogic Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MarkLogic from your Oracle system.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for eBay
Provide connectivity to eBay through an SAP BusinessObjects universe.
-
Build a Singer.io Tap for Sage 300 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sage 300 data using
-
Use Manus AI to Talk to Your SAP Ariba Source 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 SAP Ariba Source.
-
Visualize Live Google Calendar Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Calendar.
-
Build AI/ML Models with Live ActiveCampaign Data using Dataiku
Connect ActiveCampaign Data with Dataiku using the CData JDBC Driver for ActiveCampaign.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics NAV
Provide connectivity to Microsoft Dynamics NAV through an SAP BusinessObjects universe.
-
Build Agents in Relevance AI with Access to Live JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on JSON within intelligent agent workflows.
-
Publish Reports with Dynamics NAV Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Dynamics NAV.
-
Visualize Amazon Athena 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 Amazon Athena into TIBCO Spotfire.
-
Query SAP Hybris C4C Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Hybris C4C.
-
Visualize Live Salesforce CRM Analytics Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Salesforce CRM Analytics.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live MarkLogic within intelligent workflows.
-
Connect to Real-Time ShipEngine Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ShipEngine in Power Apps.
-
Access Notion Data from MySQL in PHP
Connect to Notion through the standard MySQL libraries in PHP.
-
Migrating data from Paylocity to Google BigQuery using CData SSIS Components.
Easily push Paylocity to Google BigQuery using the CData SSIS Tasks for Paylocity and Google BigQuery.
-
Work with Oracle Data in FoxPro
Load Oracle Database into a FoxPro database. This article includes full code and a walk-through of the process.
-
Stream Salesforce Data 360 Data into Apache Kafka Topics
Access and stream Salesforce Data 360 in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Gong Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Gong data access from reports, embedded analytics, and more.
-
How to Connect to Live Blackbaud FE NXT Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Blackbaud FE NXT for you.
-
Process & Analyze Onfleet Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Onfleet Data.
-
A PostgreSQL Interface for Bannerbear Data using the CData ODBC Driver
Use the SQL Gateway and Bannerbear ODBC Driver to create a PostgreSQL entry-point for data access.
-
ETL Google Drive in Oracle Data Integrator
This article shows how to transfer Google Drive into a data warehouse using Oracle Data Integrator.
-
Building Dynamic Web Pages with PingOne Data Using AngularJS
Create single-page applications with live connectivity to PingOne using the CData API Server.
-
Operational Reporting on Oracle Sales Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Sales.
-
How to Visualize MessageBird Data in Python with pandas
Use pandas and other modules to analyze and visualize live MessageBird in Python.
-
How to Access Live Mouseflow Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Mouseflow enables you to integrate Mouseflow into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Google Calendar Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Calendar replication to SQLite.
-
Integrate eBay Data into Power Automate Desktop using CData Connect
CData Connect for eBay Data enables you to integrate eBay into workflows built using Microsoft Power Automate Desktop.
-
Import MYOB AccountRight Data Using Azure Data Factory
Use CData Connect AI to connect to MYOB AccountRight Data from Azure Data Factory and import live MYOB AccountRight.
-
Using the CData Software ODBC Driver for Strava in PyCharm
Connect to Strava as an ODBC data source in PyCharm using the CData Software ODBC Driver for Strava.
-
Connect to Reckon Accounts Hosted Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Reckon Accounts Hosted in Airbyte.