CData Software - Knowledge Base
Recent Articles
-
Connect to Tickspot in SpagoBI
Create reports featuring live Tickspot in SpagoBI Studio. Host Tickspot reports on SpagoBI Server.
-
Analyze Salesforce Marketing Data in Looker
Use CData Connect AI to connect to Salesforce Marketing Data from Looker and build custom apps using live Salesforce Marketing Cloud.
-
Build Automated Excel Online-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Excel Online and build automated workflows in Zapier.
-
Connect to Webflow Data from a Connection Pool in Jetty
The Webflow JDBC Driver supports connection pooling: This article shows how to connect faster to Webflow from Web apps in Jetty.
-
Create SSAS Tabular Models from MySQL Data
How to build a SQL Server Analysis Service Tabular Model from MySQL using CData drivers.
-
Use the CData Software ODBC Driver for Odoo in SAS for Real-Time Reporting and Analytics
Connect to real-time Odoo ERP in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Odoo.
-
Visualize eBay Analytics Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to eBay Analytics.
-
Rapidly Develop ServiceNow-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by ServiceNow.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Vertica using the Model Context Protocol.
-
Query SAP ByDesign Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Business ByDesign from Node.js.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Shortcut
Provide connectivity to Shortcut through an SAP BusinessObjects universe.
-
Connect to Brex Data in RazorSQL
Connect to Brex from wizards and query Brex from the GUI in the RazorSQL database management tool.
-
Automate Google Analytics Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Analytics and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Marketo Data in Google Apps Script via Connect AI
Use CData Connect AI to access Marketo in Google Apps Script.
-
Connect to ActiveCampaign Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ActiveCampaign to connect to ActiveCampaign and execute queries in PowerBuilder.
-
Rapidly Develop MariaDB-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by MariaDB.
-
Create Datasets from AfterShip in Domo Workbench and Build Visualizations of AfterShip Data in Domo
Use the CData Software ODBC Driver for AfterShip to create datasets from AfterShip in Domo Workbench and then build visualizations in the Domo service.
-
Work with Freshdesk Data in FoxPro
Load Freshdesk into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Productboard from a Connection Pool in WebLogic
Use the CData JDBC Driver for Productboard to connect to Productboard from Web applications running on WebLogic.
-
How to Easily Query PabblySubscriptions Data in OpenOffice Base
Connect to PabblySubscriptions data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Create Power BI Visual Reports with Real-Time Gorgias Data
Use CData Power BI Connectors to visualize Gorgias in Power BI.
-
Integrating Dataiku with Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Act CRM.
-
Using the CData Software ODBC Driver for Salesforce Pardot in PyCharm
Connect to Salesforce Pardot as an ODBC data source in PyCharm using the CData Software ODBC Driver for Salesforce Pardot.
-
Analyze Microsoft OneDrive Data in Looker
Use CData Connect AI to connect to Microsoft OneDrive Data from Looker and build custom apps using live Microsoft OneDrive.
-
Connect to Zoho Books Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zoho Books to connect to Zoho Books and execute queries in PowerBuilder.
-
How to Build an ETL App for Facebook Ads Data in Python with CData
Create ETL applications and real-time data pipelines for Facebook Ads in Python with petl.
-
Use the CData ODBC Driver for Supabase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Supabase to connect to Supabase from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Supabase in Excel.
-
Connect to Gong Data from PowerBuilder via ADO.NET
This article demonstrates how to access Gong from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData Software JDBC Driver for Neo4J in MicroStrategy Desktop
Connect to Neo4J in MicroStrategy Desktop using the CData Software JDBC Driver for Neo4J.
-
Build LDAP-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for LDAP to explore live LDAP Objects in Claude Code to assist with building LDAP-powered applications.
-
Access Oracle Sales Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Sales from HeidiSQL.
-
Replicate Multiple Apify Accounts
Replicate multiple Apify accounts to one or many databases.
-
Deploy the ADO.NET Provider for Moosend on an SSRS Report Server
Connect to Moosend 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.
-
Getting Started with the CData Connect AI Python SDK for Acumatica
Install the CData Connect AI Python SDK to read and write live Acumatica ERP with standard DB-API 2.0 Python code.
-
Connect to Amazon DynamoDB Data in Jaspersoft Studio
Execute SQL to remote Amazon DynamoDB in Jaspersoft Studio.
-
Create Data Visualizations in Cognos BI with Nuclia Data
Access Nuclia as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automate Google Cloud Storage Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Cloud Storage and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Sybase IQ Data in DBArtisan
Use wizards in DBArtisan to configure Sybase IQ as a data source.
-
Integrating LangChain with IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on IBM Informix within automated workflows.
-
Visualize Live DocuSign Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live DocuSign.
-
Automate Cosmos DB Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Azure Cosmos DB and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Access Live QuickBooks Data in TIBCO Data Virtualization
Use the QuickBooks Tibco DV Adapter to create a QuickBooks Desktop data source in TIBCO Data Virtualization Studio and gain access to live QuickBooks Desktop from your TDV Server.
-
How to connect to ADP Data from Spring Boot
Connect to ADP in a Spring Boot Application using the CData JDBC Driver for ADP
-
How to Connect to Live Jira Assets 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 Jira Assets through natural language.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZohoMarketingHub
Provide connectivity to ZohoMarketingHub through an SAP BusinessObjects universe.
-
Create a Data Access Object for SQL Analysis Services Data using JDBI
A brief overview of creating a SQL Object API for SQL Analysis Services in JDBI.
-
Access Live Dropbox Data in Coginiti Pro
Connect to and query live Dropbox from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate ClickUp Data from PowerShell
Write a quick PowerShell script to query ClickUp. Use connectivity to the live data to replicate ClickUp to SQL Server.
-
DataBind Controls to SAP HANA XS Advanced Data in C++Builder
DataBind to SAP HANA XS Advanced in C++Builder with standard components and controls.
-
Create SparkPost Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SparkPost data access from reports, embedded analytics, and more.
-
Connect to Sage Cloud Accounting Data in Aqua Data Studio
Access Sage Business Cloud Accounting from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use CData Connect AI to Access Pipedrive Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Pipedrive in the Power Pivot business intelligence tool.
-
Connect to AfterShip Data from a Connection Pool in JBoss
Integrate AfterShip into Java servlets: Use the Management Console in JBoss to install the AfterShip JDBC Driver.
-
Automated Continuous NetSuite Replication to Oracle
Use CData Sync for automated, continuous, customizable NetSuite replication to Oracle.
-
How to Connect to Live Microsoft Ads 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 Microsoft Ads through natural language.
-
How to Access Live Google Sheets Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Sheets enables you to integrate Google Sheets into workflows built using Microsoft Power Automate Desktop.
-
Build Visualizations of Placid Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Placid in Birst.
-
Create LinkedIn-Connected Nintex Workflows
Use CData Connect AI to connect to LinkedIn Data from Nintex Workflow Cloud and build custom workflows using live LinkedIn.
-
Automated Continuous Flowlu Replication to Snowflake
Use CData Sync for automated, continuous, customizable Flowlu replication to Snowflake.
-
Basecamp Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Basecamp through CData Connect AI using different applications and tools.
-
Integrating Kiro CLI with Lakebase 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 an SAP BusinessObjects Universe on the CData ODBC Driver for Sendwithus
Provide connectivity to Sendwithus through an SAP BusinessObjects universe.
-
Integrating Dataiku with SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP BusinessObjects BI.
-
Connecting Mastra with Avro 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 Apache Avro, no replication required.
-
Add Presto Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Presto with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to EnterpriseDB Data from Crystal Reports
Use CData Connect AI to connect to and report on live EnterpriseDB from Crystal Reports.
-
Integrating Codex CLI with Shippo 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 a PostgreSQL Interface for Customer.io Data using the CData JDBC Driver
Use the Remoting features of the Customer.io JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to publish and share Vercel Data dashboards with Tableau Server
The CData ODBC driver for Vercel enables you integrate Vercel into Tableau dashboards.
-
How to Connect to Live ADP 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 ADP for you.
-
Build FHIR-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for FHIR to explore live FHIR Data in Claude Code to assist with building FHIR-powered applications.
-
Getting Started with the CData Tableau Connector for Exa
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData ODBC Driver for Oracle Eloqua from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle Eloqua to connect to Oracle Eloqua from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle Eloqua in Excel.
-
Visualize Demio Data in TIBCO Spotfire through ADO.NET
Integrate Demio into dashboards in TIBCO Spotfire.
-
Connect to SAP SuccessFactors LMS Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP SuccessFactors LMS and the SQL Gateway to access SAP SuccessFactors LMS from Google Apps Script.
-
Connect to Vertica Data from HeidiSQL
Use CData Connect AI to connect to and query live Vertica from HeidiSQL.
-
Build SAP Fieldglass-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP Fieldglass and build SAP Fieldglass-connected web apps with Axios.
-
Dedicated App or In-Session Agent? Choosing How to Use the CData CLI
Compare two ways to use the CData CLI with an AI coding agent (building a dedicated app vs. driving it interactively) and learn which approach fits your workflow.
-
Create Google Search-Connected Applications in Appsmith
Connect to Google Search Results via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Search.
-
Publish FreshBooks-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live FreshBooks.
-
Bind Live Adobe Target Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Adobe Target data
-
Analyze Amazon Marketplace Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Amazon Marketplace and visualize live Amazon Marketplace in Infragistics Reveal.
-
Analyze Invoiced Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Invoiced in Microsoft R Open.
-
How to Connect to Live Paylocity 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 Paylocity for you.
-
Use Dash to Build to Web Apps on Oracle HCM Cloud Data
Create Python applications that use pandas and Dash to build Oracle HCM Cloud-connected web apps.
-
How to import Lakebase Data into Apache Solr
Use the CData Software JDBC Driver for Lakebase in Data Import Handler and create an automated import of Lakebase to Apache Solr Enterprise Search platform.
-
How to Work with Wave Financial Data in ETL Validator JDBC
Connect to Wave Financial from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect Productboard to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Productboard with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData Python Connector for Rootly
Learn to install and license the CData Python Connector
-
Integrate LibreChat with Live Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Apache Spark SQL from within the chat interface.
-
Automated Continuous Codat Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Codat replication to AlloyDB.
-
Replicate Multiple EmailOctopus Accounts via the CData Sync CLI
Replicate multiple EmailOctopus accounts to one or many databases.
-
Extract, Transform, and Load Zoom Data in Informatica PowerCenter
Create a simple Workflow for Zoom in Informatica PowerCenter.
-
Replicate HelloSign Data to Multiple Databases via the CData Sync CLI
Replicate HelloSign to disparate databases with a single configuration.
-
Connect to Bugsnag Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bugsnag to connect to Bugsnag and execute queries in PowerBuilder.
-
Automated Continuous FreeAgent Replication to Vertica
Use CData Sync for automated, continuous, customizable FreeAgent replication to Vertica.
-
Connect to Google Drive Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Drive from Crystal Reports.
-
How to Query Zuora Data in MySQL Workbench
Execute MySQL queries against live Zuora from MySQL Workbench.
-
Visualize MongoDB Data in Sisense
Create an ElastiCube in Sisense app with access to MongoDB.
-
Perform Batch Operations with Instagram Data in Apache NiFi
Connect to Instagram and perform batch operations in Apache NiFi using the CData Software JDBC Driver.