CData Software - Knowledge Base
Recent Articles
-
Build Google Translate-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Google Translate Data in Claude Code to assist with building Google Translate-powered applications.
-
Getting Started with the CData ODBC Driver for SurveyMonkey
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SurveyMonkey.
-
Replicate Shortcut Data to Multiple Databases via the CData Sync CLI
Replicate Shortcut to disparate databases with a single configuration.
-
Use the CData ODBC Driver for Demio in Microsoft Power Query
You can use the CData Demio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Demio into Microsoft Power Query.
-
Replicate Multiple ADP Accounts
Replicate multiple ADP accounts to one or many databases.
-
Analyze QuickBooks Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for QuickBooks from Power Pivot. You will use the Table Import Wizard to load QuickBooks Desktop. You can visually build the import query or use any SQL supported by the driver.
-
Connect to NASA Data in HULFT Integrate
Connect to NASA as a JDBC data source in HULFT Integrate
-
Connect to Oracle Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle and the Script function in FileMaker Pro to connect to Oracle and work with Oracle Database in your FileMaker application.
-
Build MVC Applications with Connectivity to VWO Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access VWO from an ASP.NET MVC application.
-
Query Instantly Data as a MySQL Database in Node.js
Execute MySQL queries against Instantly from Node.js.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Asana
Provide connectivity to Asana through an SAP BusinessObjects universe.
-
Working with REST Data in LINQPad
Execute LINQ queries to REST in LINQPad.
-
Use the CData Software JDBC Driver for Apify in MicroStrategy
Connect to Apify in MicroStrategy Developer using the CData Software JDBC Driver for Apify.
-
Provide OData Services of Notion Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Notion by developing a WCF Service Application.
-
Getting Started with the CData JDBC Driver for Customer.io
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Customer.io.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Microsoft Dataverse
Provide connectivity to Microsoft Dataverse (CDS) through an SAP BusinessObjects universe.
-
Access Live Mistral AI Data in AWS Lambda
Connect to live Mistral AI in AWS Lambda using the CData JDBC Driver.
-
Connect to HelloSign Data from PowerBuilder via ADO.NET
This article demonstrates how to access HelloSign from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Salesforce Marketing Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce Marketing data access from reports, embedded analytics, and more.
-
How to Connect to Live Freshservice Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Freshservice securely in real time.
-
Create Paddle Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Paddle data access from reports, embedded analytics, and more.
-
Use Azure AI Foundry to Talk to Your Zendesk 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 Zendesk for you.
-
Automated Continuous OnePageCrm Replication to IBM DB2
Use CData Sync for automated, continuous, customizable OnePageCrm replication to IBM DB2.
-
Automated Continuous Adobe Commerce Replication to MySQL
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to MySQL.
-
Connect to Avalara AvaTax Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Avalara AvaTax and the SQL Gateway to access Avalara AvaTax from Google Apps Script.
-
Work with NetSuite Data in FoxPro
Load NetSuite CRM & ERP into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating GitHub Copilot CLI with Teamgate 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.
-
Integrating OpenCode Terminal with Paymo 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.
-
Use the CData ODBC Driver for Google Directory from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Directory to connect to Google Directory from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Directory in Excel.
-
Start with CData Sync Part 1: Licensing, Creating Connections, and Creating a Replication Job
Use CData Sync to create a replication job.
-
Perform Batch Operations with Cosmos DB Data in Apache NiFi
Connect to Azure Cosmos DB and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Publish Reckon-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Reckon.
-
Publish Notion-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Notion.
-
Publish Stripe-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Stripe.
-
Analyze Live Xero Data in SAS Viya
Use CData Connect AI to connect to Xero Accounting from SAS Viya and deploy self-service analytics using live Xero Accounting.
-
Stream Sybase IQ Data into Apache Kafka Topics
Access and stream Sybase IQ in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Oracle Data into Power Automate Desktop using CData Connect
CData Connect for Oracle Data enables you to integrate Oracle Database into workflows built using Microsoft Power Automate Desktop.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAS Data Sets using the Model Context Protocol.
-
Getting Started with the CData Power BI Connector for Avaza
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to MarkLogic Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live MarkLogic.
-
Build an OLAP Cube in SSAS from Tanda Data
Establish a connection to Tanda data from SQL Server Analysis Services, and use the Tanda Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Easily Query QuickBooks Time Data in OpenOffice Base
Connect to QuickBooks Time data in OpenOffice Base using the CData ODBC Driver for QuickBooks Time and generate reports with live data insights.
-
Easily Integrate Google Analytics Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Analytics in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Live MariaDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Access Live Sage Cloud Accounting Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sage Business Cloud Accounting into the statistical analysis tools available in SAS JMP. This article shows how to use Sage Business Cloud Accounting in the Graph Builder and Query Builder.
-
Create Informatica Mappings From/To a JDBC Data Source for PDFMonkey
Create PDFMonkey data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Rapidly Develop Shortcut-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 Shortcut.
-
Create TigerGraph Dataflows on PowerBI.com
Connect to the CData Power BI Connector for TigerGraph from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to Browserless Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Browserless. Leverage the pyodbc module for ODBC in Python.
-
Build XML-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for XML to explore live XML Data in Claude Code to assist with building XML-powered applications.
-
Edit and Search Google Analytics External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Analytics to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Analytics objects that you can access from apps and the dashboard.
-
Configure the CData JDBC Driver for FHIR in a Connection Pool in Tomcat
Connect to FHIR from a connection pool in Tomcat.
-
Connect to Instantly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Instantly.
-
Connect to Everhour Data in NetBeans
Connect to Everhour in NetBeans with the data source configuration wizard.
-
Use the CData Software JDBC Driver for Parallel in MicroStrategy Desktop
Connect to Parallel in MicroStrategy Desktop using the CData Software JDBC Driver for Parallel.
-
View Reports on Real-Time SAS xpt Data in Power BI Report Server
Use the CData ODBC Driver for SAS xpt to visualize SAS XPORT in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate LionDesk Data Replication to Couchbase
Use CData Sync to Customize and automate LionDesk replication to Couchbase.
-
Connecting Pipedream with Google Calendar Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Calendar data in real time.
-
Integrating Codex CLI with BigCommerce 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.
-
Prepare, Blend, and Analyze Cosmos DB Data in Alteryx Designer (Connect AI)
Build workflows to access live Azure Cosmos DB for self-service data analytics.
-
Automated Continuous Adobe Commerce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Amazon Redshift.
-
Access Live Nuclia Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Nuclia data source in TIBCO Data Virtualization Studio and gain access to live Nuclia from your TDV Server.
-
Connecting GenSpark with Spark Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Apache Spark SQL without any replication or custom integration required.
-
Automated Continuous SharePoint Excel Services Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Apache Cassandra.
-
Use the CData Software ODBC Driver for LightSpeedRetail in MicroStrategy
Connect to LightSpeedRetail in MicroStrategy Developer using the CData Software ODBC Driver for LightSpeedRetail.
-
Connect to Billsby Data in Aqua Data Studio
Access Billsby from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Provide OData Services of CloudConvert Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for CloudConvert by developing a WCF Service Application.
-
Visualize Live Amplitude Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amplitude.
-
How to Query MailerSend Data in MySQL Workbench
Execute MySQL queries against live MailerSend from MySQL Workbench.
-
Access Live SAS Data Sets Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAS Data Sets from your Google Sheets.
-
Import Hive Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache Hive. In this article, you will use the OData format to import Apache Hive into Microsoft Power Query.
-
Connect to and Query Mailgun Data in QlikView over ODBC
Create data visualizations with Mailgun in QlikView.
-
Integrate eBay Analytics Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live eBay Analytics from Informatica Cloud.
-
Viewing QuickBooks Online Data in RAD Studio Data Explorer
How to view QuickBooks Online in RAD Studio Data Explorer using the CData ODBC Driver for QuickBooks Online.
-
Access Live Freshdesk Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Freshdesk from your Excel spreadsheets.
-
Getting Started with the CData Python Connector for Printful
Learn to install and license the CData Python Connector
-
Build Charts with Elorus Data in Clear Analytics
Create dynamic charts and perform analytics based on Elorus in Clear Analytics.
-
How to Connect to & Open Oracle Sales Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle Sales to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to AfterShip Data in NetBeans
Connect to AfterShip in NetBeans with the data source configuration wizard.
-
Integrating OpenCode Terminal with SurveyMonkey 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.
-
Automated Continuous XML Replication to IBM DB2
Use CData Sync for automated, continuous, customizable XML replication to IBM DB2.
-
How to Query Live Mouseflow Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mouseflow data in natural language using Python.
-
Access Live Rootly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Rootly into the statistical analysis tools available in SAS JMP. This article shows how to use Rootly in the Graph Builder and Query Builder.
-
Prepare, Blend, and Analyze WooCommerce Data in Alteryx Designer (Connect AI)
Build workflows to access live WooCommerce for self-service data analytics.
-
How to import Samanage Data into Apache Solr
Use the CData Software JDBC Driver for Samanage in Data Import Handler and create an automated import of Samanage to Apache Solr Enterprise Search platform.
-
Use the CData Software ODBC Driver for Amazon Marketplace in SAS for Real-Time Reporting and Analytics
Connect to real-time Amazon Marketplace in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Amazon Marketplace.
-
Use the CData ODBC Driver for EnterpriseDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for EnterpriseDB to connect to EnterpriseDB from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring EnterpriseDB in Excel.
-
Access Postmark Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Postmark.
-
Visualize AfterShip 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 AfterShip into TIBCO Spotfire.
-
Connect to ZohoInvoice Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZohoInvoice as an External Source in Dremio.
-
Import and Visualize GitHub Data in Power View
Create data visualizations based on GitHub in Excel.
-
Access Live HDFS Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache HDFS into the statistical analysis tools available in SAS JMP. This article shows how to use Apache HDFS in the Graph Builder and Query Builder.
-
Build Visualizations of Salesloft Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Salesloft in Birst.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MailChimp
Provide connectivity to MailChimp through an SAP BusinessObjects universe.
-
Getting Started with the CData Power BI Connector for Suadeo
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Suadeo.
-
Seamlessly Bring Oracle HCM Cloud Data into Retool Using CData Connect AI
Integrate Oracle HCM Cloud data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Freshsales Replication to SQLite
Use CData Sync for automated, continuous, customizable Freshsales replication to SQLite.
-
Automated Continuous QuickBooks Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable QuickBooks replication to Amazon Redshift.
-
Visualize ActiveCampaign Data in Tableau
The CData ODBC driver for ActiveCampaign enables you integrate ActiveCampaign into Tableau dashboards.
-
Automated Continuous Bullhorn CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to delimited files (CSV/TSV).