Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

How to Build an ETL App for Cvent in Python with CData

Create ETL applications and real-time data pipelines for Cvent in Python with petl.
Connect to Google Ad Manager in JRuby

Create a simple JRuby app with access to live Google Ad Manager.
Connect to Bing Ads in Ruby

Connect to Bing Ads in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
Using the CData Software ODBC Driver for Sage 300 in PyCharm

Connect to Sage 300 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage 300.
CData Sync’s Enhanced CDC vs Traditional CDC: A Performance Comparison

Testing how much faster Sync is able to replicate changes using Enhanced CDC vs Traditional CDC.
Integrate with Access in JReport Designer

Create charts and reports based on Microsoft Access in JReport Designer.
How to Work with QuickBooks Time in AWS Glue Jobs Using JDBC

Connect to QuickBooks Time from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
Build SAP Concur-Connected Apps in Bubble

Use CData Connect AI to create an OData feed for SAP Concur and create custom apps in Bubble.
Use the CData Software JDBC Driver for Typeform in MicroStrategy Web

Connect to Typeform in MicroStrategy Web using the CData Software JDBC Driver for Typeform.
Integrating Boomi Agentstudio with Active Directory via CData Connect AI

Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Active Directory, enabling AI agents to act on live enterprise data within your integration and automation workflows.
Automated Continuous Spark Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable Apache Spark SQL replication to OneLake in Microsoft Fabric.
Access Live Jira Assets in Coginiti Pro

Connect to and query live Jira Assets from the GUI in the Coginiti Pro: SQL Analytics Tool.
Publish Crystal Reports on Drip

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Drip.
Query Zoom from Node.js

Use the OData endpoint of the CData API Server to connect to your Zoom and perform CRUD operations on Zoom from Node.js.
How to work with Xero in Apache Spark using SQL

Access and process Xero in Apache Spark using the CData Software JDBC Driver.
Connect to Adobe Target in Jaspersoft Studio

Execute SQL to remote Adobe Target in Jaspersoft Studio.
How to create an RPA flow for eBay Analytics in UiPath Studio

Use the eBay Analytics ODBC Driver to create workflows that access real-time eBay Analytics without any coding.
Excel Spreadsheet Automation on QuickBooks with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.
Visualize ServiceNow in Tableau

The CData ODBC driver for ServiceNow enables you integrate ServiceNow into Tableau dashboards.
Analyze SAP Business One in R via JDBC

Use standard R functions and the development environment of your choice to analyze SAP Business One with the CData JDBC Driver for SAP Business One.
Use Microsoft Copilot Studio to talk to your Zoho Projects 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 Zoho Projects for you.
Prepare, Blend, and Analyze Lakebase in Alteryx Designer (ODBC)

Build workflows to access live Lakebase for self-service data analytics.
How to connect and process Apache Avro from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Apache Avro.
Excel Spreadsheet Automation on Zoho Projects with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.
Use Azure AI Foundry to Talk to Your Oracle Eloqua 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 Oracle Eloqua for you.
Design BIRT Reports on Aha

Provide current Aha! to your embedded analytics.
Create a Data Access Object for Zoho Books using JDBI

A brief overview of creating a SQL Object API for Zoho Books in JDBI.
Deploy the ADO.NET Provider for Google Cloud Storage on an SSRS Report Server

Connect to Google Cloud Storage 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.
How to connect SharePoint with Amazon Athena through external lists

Provide Amazon Athena to SharePoint users as an external list.
Build Oracle Financials Cloud-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle Financials Cloud.
Analyze Adobe Analytics in R via JDBC

Use standard R functions and the development environment of your choice to analyze Adobe Analytics with the CData JDBC Driver for Adobe Analytics.
Integrate with Oracle Sales in JReport Designer

Create charts and reports based on Oracle Sales in JReport Designer.
Feed Confluence into FineReport

How to set Atlassian Confluence as a JDBC data source in FineReport.
Automated Continuous Sage Cloud Accounting Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to delimited files (CSV/TSV).
How to create Lakebase federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Lakebase in MySQL .
Connect and Visualize Live Airtable Data in Databricks Lakehouse Federation with CData Connect AI

Use CData Connect AI to integrate live Airtable into the Databricks platform and create visualization dashboards with real-time Airtable.
Replicate DocuSign to Multiple Databases via the CData Sync CLI

Replicate DocuSign to disparate databases with a single configuration.
Use Biml to Build SSIS Tasks to Replicate Zoho CRM to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho CRM to SQL Server.
Create Oracle Service Cloud-Connected Dashboards in Grafana

Connect to Oracle Service Cloud via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle Service Cloud.
Connect to Square in SpagoBI

Create reports featuring live Square in SpagoBI Studio. Host Square reports on SpagoBI Server.
Integrate Real-Time Access to Basecamp in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Basecamp in real time.
How to Connect Flowise AI Agents to Live Google Directory via CData Connect AI

Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
Create HCL Domino-Connected Enterprise Applications in OutSystems

Use CData Connect AI to connect to HCL Domino from OutSystems and build custom enterprise apps using live HCL Domino.
Getting Started with the CData PowerShell Cmdlets for SuiteCRM

CData is the data layer that makes AI work in production—live connectivity and replication across 350+ sources, semantic context, and built-in governance. Powering AI for Databricks, Microsoft, Google, Palantir, and 10,000+ customers worldwide.