CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Twitter Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Google BigQuery.
-
Build Presto Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Presto and build visualizations in Tableau Cloud.
-
Migrating data from Salesforce Pardot to Google BigQuery using CData SSIS Components.
Easily push Salesforce Pardot to Google BigQuery using the CData SSIS Tasks for Salesforce Pardot and Google BigQuery.
-
Connect to PagerDuty Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PagerDuty.
-
Build MVC Applications with Connectivity to SAP Business Warehouse Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Business Warehouse from an ASP.NET MVC application.
-
Build SAP Concur-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAP Concur to explore live SAP Concur Data in Claude Code to assist with building SAP Concur-powered applications.
-
Create Datasets from Google Ad Manager in Domo Workbench and Build Visualizations of Google Ad Manager Data in Domo
Use the CData Software ODBC Driver for Google Ad Manager to create datasets from Google Ad Manager in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to MessageBird Data with Squirrel SQL client
Connect to MessageBird and execute queries in the Squirrel SQL Client.
-
Automate Datadog Data Replication to Azure Synapse
Use CData Sync to customize and automate Datadog replication to Azure Synapse.
-
Design BIRT Reports on CapsuleCRM Data
Provide current CapsuleCRM to your embedded analytics.
-
How to Connect to Live NetSuite 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 NetSuite CRM & ERP through natural language.
-
Connect Azure Analysis Services to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Azure Analysis Services using the CData Python MCP Server.
-
Work with Quaderno Data in FoxPro
Load Quaderno into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Gmail-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Gmail Data from Zoho Analytics and import live Gmail.
-
Build Dashboards with Teamgate Data in Dundas BI
Create dynamic dashboards and perform analytics based on Teamgate in Dundas BI.
-
How to connect to Zoho Books Data with Squirrel SQL client
Connect to Zoho Books and execute queries in the Squirrel SQL Client.
-
Connect to Teamwork from a Connection Pool in WebLogic
Use the CData JDBC Driver for Teamwork to connect to Teamwork from Web applications running on WebLogic.
-
Use the CData Software JDBC Driver for Foursquare in MicroStrategy Web
Connect to Foursquare in MicroStrategy Web using the CData Software JDBC Driver for Foursquare.
-
Write a Simple Go Application to work with Teamwork Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Teamwork.
-
DataBind Controls to ZohoPeople Data in Delphi
DataBind to ZohoPeople in Delphi with standard data access components and controls.
-
Connect to LDAP Objects in Jaspersoft Studio
Execute SQL to remote LDAP in Jaspersoft Studio.
-
SAP Drivers Overview
In this entry, you will find an overview of the SAP products supported by CData as well as the interfaces used to surface their data.
-
Stream ADP Data into Apache Kafka Topics
Access and stream ADP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Query Azure Data Lake Storage Data in MySQL Workbench
Execute MySQL queries against live Azure Data Lake Storage from MySQL Workbench.
-
Integrate Cursor with Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live HubSpot from within the editor.
-
How to Access ConstantContact Data Using Entity Framework
This article shows how to access ConstantContact using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query Vertica Data as a SQL Server Database in Node.js
Execute SQL Server queries against Vertica from Node.js.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Entra ID within intelligent workflows.
-
LINQ to SAP Business One 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 SAP Business One Data Provider.
-
Connect Adobe Commerce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Adobe Commerce with IBM WebSphere for seamless data integration and connectivity.
-
Automate NetSuite SuiteAnalytics Data Replication to Couchbase
Use CData Sync to Customize and automate NetSuite SuiteAnalytics replication to Couchbase.
-
How to publish and share Smartsheet Data dashboards with Tableau Server
The CData ODBC driver for Smartsheet enables you integrate Smartsheet into Tableau dashboards.
-
Integrate Cline with Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Azure Cosmos DB from within your IDE.
-
Connect to Billsby in SpagoBI
Create reports featuring live Billsby in SpagoBI Studio. Host Billsby reports on SpagoBI Server.
-
Connect to LightSpeedRetail Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for LightSpeedRetail and the SQL Gateway to access LightSpeedRetail from Google Apps Script.
-
Use the CData Software ODBC Driver for Accelo in MicroStrategy
Connect to Accelo in MicroStrategy Developer using the CData Software ODBC Driver for Accelo.
-
Build Visualizations of ScrapingBee Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ScrapingBee in Birst.
-
Use Dash to Build to Web Apps on Foursquare Data
Create Python applications that use pandas and Dash to build Foursquare-connected web apps.
-
Viewing Parquet Data in RAD Studio Data Explorer
How to view Apache Parquet in RAD Studio Data Explorer using the CData ODBC Driver for Parquet.
-
Build Voice Agents in ElevenLabs with access to Live Marketo Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Marketo.
-
Visualize Live eBay Data in the Power BI Service
Use CData Connect AI to connect to live eBay and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live PingOne Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PingOne into the statistical analysis tools available in SAS JMP. This article shows how to use PingOne in the Graph Builder and Query Builder.
-
Edit and Search Act CRM External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Act CRM to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Act CRM objects that you can access from apps and the dashboard.
-
Integrating Gumloop with Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Greenhouse within automated workflows.
-
Create Power BI Reports on Real-Time Dynamics 365 Business Central Data
Use the CData ODBC Driver for Dynamics 365 Business Central to visualize Dynamics 365 Business Central in Power BI Desktop.
-
Connect and Visualize Live Microsoft Exchange Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Exchange into the Databricks platform and create visualization dashboards with real-time Microsoft Exchange.
-
Automated Continuous Splunk Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Splunk replication to Google Cloud SQL.
-
Integrating Codex CLI with Bitbucket 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 FreshBooks Data in DBeaver
Use the CData ODBC Driver to connect to FreshBooks in DBeaver.
-
Bidirectional Access to Vercel Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Vercel in Filemaker Pro for Mac or Windows.
-
Explore Geographical Relationships in ConstantContact Data with Power Map
Create data visualizations with ConstantContact in Power Map.
-
Automated Continuous Odoo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Odoo replication to Google Cloud SQL.
-
Automated Continuous QuickBooks Online Replication to MongoDB
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to MongoDB.
-
Automated Continuous Planio Replication to SingleStore
Use CData Sync for automated, continuous, customizable Planio replication to SingleStore.
-
Integrating Codex CLI with WooCommerce 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 an OLAP Cube in SSAS from Epicor Kinetic Data
Establish a connection to Epicor Kinetic data from SQL Server Analysis Services, and use the Epicor Kinetic Data Provider to build OLAP cubes for use in analytics and reporting.
-
DataBind Controls to Autopilot Data in C++Builder
DataBind to Autopilot in C++Builder with standard components and controls.
-
Automated Continuous Microsoft Ads Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Amazon Redshift.
-
Feed Elorus Data into FineReport
How to set Elorus as a JDBC data source in FineReport.
-
Automate SAP Ariba Source Data Replication to Couchbase
Use CData Sync to Customize and automate SAP Ariba Source replication to Couchbase.
-
Query CouchDB Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Apache CouchDB and perform CRUD operations on CouchDB from Node.js.
-
Process & Analyze Mode Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Mode Data.
-
Connect to Samanage Data from a Connection Pool in Jetty
The Samanage JDBC Driver supports connection pooling: This article shows how to connect faster to Samanage from Web apps in Jetty.
-
Build a Singer.io Tap for PayPal With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PayPal data using
-
Add Oracle HCM Cloud Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle HCM Cloud with the Informatica Enterprise Data Catalog to classify and organize data.
-
Load Zoom Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoom to a database.
-
How to Connect to Live Snapchat Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Snapchat Ads securely in real time.
-
Getting Started with the CData Tableau Connector for Pipeline CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize Google Translate 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 Google Translate into TIBCO Spotfire.
-
Getting Started with the CData SSIS Components for VWO
Complete guide to installing, licensing, and connecting with the CData SSIS Components for VWO.
-
Connect to and Visualize Live CouchDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache CouchDB.
-
Access Wrike Data from MySQL in PHP
Connect to Wrike through the standard MySQL libraries in PHP.
-
Build Agents in Relevance AI with Access to Live Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zendesk within intelligent agent workflows.
-
Replicate Sage 200 Data from PowerShell
Write a quick PowerShell script to query Sage 200. Use connectivity to the live data to replicate Sage 200 to SQL Server.
-
Import and Visualize Spark Data in Power View
Create data visualizations based on Apache Spark SQL in Excel.
-
Integrating Antigravity CLI with Bright Data via CData CLI
Connect Bright Data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Missive Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Missive.
-
Integrating Twilio Data in Talend Cloud Data Management Platform
Connect Twilio Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Twilio.
-
How to connect to MongoDB Data in DBVisualizer
Integrate MongoDB with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Semantic Layer Views for Anaplan Data in APOS Live Data Gateway
Use the CData Connector for Anaplan in APOS Live Data Gateway to build Semantic Layer Views for Anaplan.
-
Build GraphQL-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for GraphQL to explore live GraphQL Data in Cursor to assist with building GraphQL-powered applications.
-
Automated Continuous MongoDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable MongoDB replication to SingleStore.
-
DataBind Controls to IBM Cloud Object Storage Data in Delphi
DataBind to IBM Cloud Object Storage in Delphi with standard data access components and controls.
-
Integrate TigerGraph Data in Pentaho Data Integration
Build ETL pipelines based on TigerGraph in the Pentaho Data Integration tool.
-
Operational Reporting on SAP SuccessFactors Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP SuccessFactors.
-
Automated Continuous Xero Replication to MySQL
Use CData Sync for automated, continuous, customizable Xero replication to MySQL.
-
Extract, Transform, and Load Bugsnag Data in Informatica PowerCenter
Create a simple Workflow for Bugsnag in Informatica PowerCenter.
-
Build Pipelines with Live Oracle Financials Cloud Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle Financials Cloud from Google Cloud Data Fusion, enabling the integration of live Oracle Financials Cloud into the building and management of effective data pipelines.
-
How to Access Live QuickBooks Time Data in Power Automate Desktop via ODBC
The CData ODBC Driver for QuickBooks Time enables you to integrate QuickBooks Time into workflows built using Microsoft Power Automate Desktop.
-
Connect to Microsoft Planner Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft Planner and the SQL Gateway to access Microsoft Planner from Google Apps Script.
-
Use the CData Software JDBC Driver for PivotalTracker in MicroStrategy Web
Connect to PivotalTracker in MicroStrategy Web using the CData Software JDBC Driver for PivotalTracker.
-
How to Connect to Live HBase 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 Apache HBase for you.
-
Getting Started with the CData SSIS Components for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for LaunchDarkly.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live PayPal within intelligent workflows.
-
How to work with Clockify Data in Apache Spark using SQL
Access and process Clockify Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate with SAS xpt Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAS XPORT to a JSON file on disk.
-
Connect to and Visualize Live Twitter Ads Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Twitter Ads.
-
Integrate Instantly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Instantly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Instantly.
-
DataBind Controls to Attio Data in Delphi
DataBind to Attio in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Unbounce in MicroStrategy Web
Connect to Unbounce in MicroStrategy Web using the CData Software ODBC Driver for Unbounce.