CData Software - Knowledge Base
Recent Articles
-
Access Microsoft Ads 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 Microsoft Ads.
-
Getting Started with the CData ODBC Driver for Box
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Box.
-
Analyze Stripe Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Stripe with the CData JDBC Driver for Stripe.
-
Access Intercom Data from MySQL in PHP
Connect to Intercom through the standard MySQL libraries in PHP.
-
Build Visualizations of Mixpanel Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Mixpanel in Birst.
-
Connect to Databricks Data in Ruby
Connect to Databricks in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Elasticsearch Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Elasticsearch facts in real time.
-
Use Biml to Build SSIS Tasks to Replicate Adobe Experience Manager Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Adobe Experience Manager to SQL Server.
-
Use JayDeBeApi to access Sentry Data in Python
Use standard Python scripting and the development environment of your choice to access live Sentry.
-
Automated Continuous Paymo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Paymo replication to Amazon S3.
-
Access ConvertKit Data from MySQL in Amazon QuickSight
Connect to ConvertKit and build visualizations of ConvertKit using a MySQL Connection in Amazon QuickSight.
-
Access Live Reckon Accounts Hosted Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Reckon Accounts Hosted from your Excel spreadsheets.
-
Replicate Office 365 Data to Multiple Databases
Replicate Microsoft Office 365 to disparate databases with a point-and-click configuration.
-
Build Salesforce Marketing-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Salesforce Marketing to explore live Salesforce Marketing Data in GitHub Copilot to assist with building Salesforce Marketing-powered applications.
-
Connect to ZohoSubscriptions Data in Jaspersoft Studio
Execute SQL to remote ZohoSubscriptions in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for Mixpanel in MicroStrategy
Connect to Mixpanel in MicroStrategy Developer using the CData Software ODBC Driver for Mixpanel.
-
Build Google Calendar-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Calendar.
-
Build Charts with HubDB Data in Clear Analytics
Create dynamic charts and perform analytics based on HubDB in Clear Analytics.
-
How to Query Mocean Data in MySQL Workbench
Execute MySQL queries against live Mocean from MySQL Workbench.
-
DataBind Controls to Azure Data Lake Storage Data in C++Builder
DataBind to Azure Data Lake Storage in C++Builder with standard components and controls.
-
Stream Mode Data into Apache Kafka Topics
Access and stream Mode in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData SSIS Components for Freshdesk
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Freshdesk.
-
Query Gong Data as a SQL Server Database in Node.js
Execute SQL Server queries against Gong from Node.js.
-
Visualize Testmonitor Data in Tableau
The CData ODBC driver for Testmonitor enables you integrate Testmonitor into Tableau dashboards.
-
Design BIRT Reports on IBM Cloud Object Storage Data
Provide current IBM Cloud Object Storage to your embedded analytics.
-
Connect to Autopilot Data in RapidMiner
Integrate Autopilot with standard components and data source configuration wizards in RapidMiner Studio.
-
Stream SAS Data Sets Data into Apache Kafka Topics
Access and stream SAS Data Sets in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a Singer.io Tap for Reckon Accounts Hosted With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Reckon Accounts Hosted data using
-
Process & Analyze Google Drive Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Drive Data.
-
Build LinkedIn-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to LinkedIn Data from Zoho Analytics and import live LinkedIn.
-
Connect to Nuclia from a Connection Pool in WebLogic
Use the CData JDBC Driver for Nuclia to connect to Nuclia from Web applications running on WebLogic.
-
Use the CData Software JDBC Driver for Stripe in MicroStrategy Web
Connect to Stripe in MicroStrategy Web using the CData Software JDBC Driver for Stripe.
-
A PostgreSQL Interface for Parquet Data using the CData ODBC Driver
Use the SQL Gateway and Parquet ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Grafana Data Replication to Teradata
Use CData Sync to Customize and automate Grafana replication to Teradata.
-
Connect to MariaDB Data from Crystal Reports
Use CData Connect AI to connect to and report on live MariaDB from Crystal Reports.
-
DataBind BigQuery Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for BigQuery with the DevExpress Windows Forms and Web controls to provide Google BigQuery to a chart.
-
Use the CData Software JDBC Driver for Greenhouse in MicroStrategy
Connect to Greenhouse in MicroStrategy Developer using the CData Software JDBC Driver for Greenhouse.
-
Automated Continuous Oracle HCM Cloud Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Amazon S3.
-
Automated Continuous Reckon Accounts Hosted Replication to Databricks
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Databricks.
-
Build Greenhouse-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Greenhouse to explore live Greenhouse Data in Claude Code to assist with building Greenhouse-powered applications.
-
Add Hubstaff Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Hubstaff with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connecting Pipedream with Google Ad Manager 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 Ad Manager data in real time.
-
Connect and Query Live FreshBooks Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live FreshBooks into Databricks
-
Integrating Antigravity CLI with Marketo via CData CLI
Connect Marketo to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Helpscout Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Helpscout replication to Amazon Redshift.
-
Use JayDeBeApi to access ElevenLabs Data in Python
Use standard Python scripting and the development environment of your choice to access live ElevenLabs.
-
Create Reports with MarkLogic Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MarkLogic.
-
Integrating Antigravity CLI with REST via CData CLI
Connect REST to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Kiro CLI with Everhour 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 Tally-Connected Nintex Workflows
Use CData Connect AI to connect to Tally Data from Nintex Workflow Cloud and build custom workflows using live Tally ERP.
-
Integrate Airtable Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Airtable from Informatica Cloud.
-
How to create Zoho Creator federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho Creator in MySQL .
-
How to Connect the Power BI Service to Zuora: Complete Guide
Connect to the CData Software Power BI Connector for Zuora from PowerBI.com to provide real-time Zuora across the organization.
-
Connect to Google Analytics Data in NetBeans
Connect to Google Analytics in NetBeans with the data source configuration wizard.
-
Create SSAS Tabular Models from Tickspot Data
How to build a SQL Server Analysis Service Tabular Model from Tickspot using CData drivers.
-
Query AlloyDB Data in ColdFusion
Write standard ColdFusion data access code to connect to Google AlloyDB.
-
Connect to Suadeo Data from a Connection Pool in Jetty
The Suadeo JDBC Driver supports connection pooling: This article shows how to connect faster to Suadeo from Web apps in Jetty.
-
Use the CData API Server to Access Azure Synapse Data in Microsoft PowerPivot
Use the CData API Server to connect to live Azure Synapse in the Power Pivot business intelligence tool.
-
Migrating data from Twilio to Google BigQuery using CData SSIS Components.
Easily push Twilio to Google BigQuery using the CData SSIS Tasks for Twilio and Google BigQuery.
-
Integrate Aha! with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Aha! with External Services.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Snapchat Ads actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to Facebook Data in Aqua Data Studio
Access Facebook from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Migrating data from Shippo to Google BigQuery using CData SSIS Components.
Easily push Shippo to Google BigQuery using the CData SSIS Tasks for Shippo and Google BigQuery.
-
Connect to Live Jira Assets Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Jira Assets in CData Connect AI and connect to your Jira Assets from PostgreSQL.
-
Automated Continuous Chargebee Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Chargebee replication to Google Cloud SQL.
-
How to Visualize SageHR Data in Python with pandas
Use pandas and other modules to analyze and visualize live SageHR in Python.
-
Integrate LinkedIn Data in the Pentaho Report Designer
Publish reports based on LinkedIn in the Pentaho BI tool.
-
Getting Started with the CData Tableau Connector for MariaDB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for MariaDB.
-
Use Microsoft Copilot Studio to talk to your Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Azure Synapse for you.
-
How to Query Live Odoo Data in Perplexity MacOS Desktop
Connect to and query live Odoo Data in Perplexity Desktop using CData MCP Server.
-
Extend Google Sheets with BigQuery Data
Make calls to BigQuery from Google Apps Script via the API Server.
-
Stream Cloudflare Data into Apache Kafka Topics
Access and stream Cloudflare in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Edit and Search External Cosmos DB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Azure Cosmos DB to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Cosmos DB Data objects that you can access from apps and the dashboard.
-
Connect to Humanity Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Humanity to connect to Humanity and execute queries in PowerBuilder.
-
Automated Continuous Yelp Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Yelp replication to delimited files (CSV/TSV).
-
LINQ to Billsby 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 Billsby Data Provider.
-
Automated Continuous Google Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Ads replication to SQL Server.
-
Automated Continuous Drift Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Drift replication to Google BigQuery.
-
Connect to Google Drive Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Drive and the Script function in FileMaker Pro to connect to Google Drive and work with Google Drive in your FileMaker application.
-
Getting Started with the CData Excel Add-In for Templated
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Templated.
-
How to Query Live Odoo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Odoo ERP data in natural language using Python.
-
Access Live Marketo Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Marketo through MCP integration.
-
Create Reports with Billsby Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Billsby.
-
Create Data Visualizations Based On Google Sheets Data in Mode
Use CData Connect AI to connect to Google Sheets Data from Mode and build visualizations using live
-
Automated Continuous Campaigner Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Campaigner replication to Amazon S3.
-
Extract, Transform, and Load Todoist Data in Informatica PowerCenter
Create a simple Workflow for Todoist in Informatica PowerCenter.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Figshare
Provide connectivity to Figshare through an SAP BusinessObjects universe.
-
Integrate with Apollo Data in JReport Designer
Create charts and reports based on Apollo in JReport Designer.
-
Build Azure Synapse Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Azure Synapse and build visualizations in Tableau.
-
Model Microsoft OneDrive Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft OneDrive, enabling the direct import of real-time Microsoft OneDrive.
-
Integrating Boomi Agentstudio with MySQL Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MySQL, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Validate Epicor Kinetic Data with QuerySurge
Access and validate Epicor Kinetic in QuerySurge using the CData JDBC Driver.
-
How to Query Timely Data in MySQL Workbench
Execute MySQL queries against live Timely from MySQL Workbench.
-
Integrating Cursor CLI with Epicor Kinetic 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.
-
Migrating data from Gumroad to Google BigQuery using CData SSIS Components.
Easily push Gumroad to Google BigQuery using the CData SSIS Tasks for Gumroad and Google BigQuery.
-
Getting Started with the CData SSIS Components for SharePoint Excel Services
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SharePoint Excel Services.
-
Use the CData Software ODBC Driver for Email in SAS for Real-Time Reporting and Analytics
Connect to real-time Email in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Email.
-
Extract, Transform, and Load Accelo Data in Informatica PowerCenter
Create a simple Workflow for Accelo in Informatica PowerCenter.
-
Integrate Cursor with Live Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Acumatica ERP from within the editor.
-
Connect to Lakebase Data in ACL Analytics
Connect to Lakebase via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Lakebase.