CData Software - Knowledge Base
Recent Articles
-
How to work with Zuora Data in Apache Spark using SQL
Access and process Zuora Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating Cursor with AgileCRM 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.
-
Creating Pinterest-Connected Applications in Unqork
You can use CData Connect AI to feed Pinterest data to Unqork and build custom business apps.
-
DataBind Controls to Freshsales Data in C++Builder
DataBind to Freshsales data in C++Builder with standard components and controls.
-
Automate Perigon Data Replication to SAP HANA
Use CData Sync to customize and automate Perigon data replication to SAP HANA.
-
Add SendInBlue Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SendInBlue with the Informatica Enterprise Data Catalog to classify and organize data.
-
ETL Exact Online in Oracle Data Integrator
This article shows how to transfer Exact Online data into a data warehouse using Oracle Data Integrator.
-
Create RSS Dataflows on PowerBI.com
Connect to the CData Power BI Connector for RSS from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Automated Workflows with Live Box Data in Workato
Use CData Connect AI to connect to live Box data and build automated workflows in Workato.
-
View Reports on Real-Time Optimizely Data in Power BI Report Server
Use the CData ODBC Driver for Optimizely to visualize Optimizely data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Live Omnisend Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Omnisend from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Omnisend data.
-
ETL Reckon Accounts Hosted in Oracle Data Integrator
This article shows how to transfer Reckon Accounts Hosted data into a data warehouse using Oracle Data Integrator.
-
Replicate Rootly Data from PowerShell
Write a quick PowerShell script to query Rootly data. Use connectivity to the live data to replicate Rootly data to SQL Server.
-
How to create Zoho Projects federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho Projects data in MySQL .
-
Egnyte Reporting in OBIEE with the Egnyte JDBC Driver
Deploy the Egnyte JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create a Data Access Object for Anaplan Data using JDBI
A brief overview of creating a SQL Object API for Anaplan data in JDBI.
-
Automated Continuous Float Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Float replication to delimited files (CSV/TSV).
-
Build Azure Analysis Services-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Azure Analysis Services Data from Zoho Analytics and import live Azure Analysis Services data.
-
Connect to WordPress Data in ACL Analytics
Connect to WordPress data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to WordPress data.
-
Create Informatica Mappings From/To an ODBC Data Source for Avalara AvaTax
Create an ODBC connection to Avalara AvaTax in Informatica and browse and transfer Avalara AvaTax data.
-
How to Connect to Exact Online Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Exact Online data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Postmark Data in RazorSQL
Connect to Postmark from wizards and query Postmark data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Telegram Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Telegram replication to Google BigQuery.
-
Visualize Live JotForm Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live JotForm data.
-
Import Real-Time Xero Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Xero data in ColdFusion.
-
Automated Continuous Mixpanel Replication to Oracle
Use CData Sync for automated, continuous, customizable Mixpanel replication to Oracle.
-
How to import MySQL Data into Apache Solr
Use the CData Software JDBC Driver for MySQL in Data Import Handler and create an automated import of MySQL data to Apache Solr Enterprise Search platform.
-
Visualize Live MySQL Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MySQL data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Bridge Bitbucket Connectivity with Apache NiFi
Access and process Bitbucket data in Apache NiFi using the CData JDBC Driver.
-
Visualize Live Gong Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Gong data.
-
Create MarkLogic Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MarkLogic data access from reports, embedded analytics, and more.
-
Integrate with live ADP Data in Jitterbit
Use CData Connect AI to connect to and integrate live ADP data in Jitterbit.
-
Use Agno to Talk to Your WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your WooCommerce data for you.
-
Use the CData Software ODBC Driver for Elasticsearch in SAS for Real-Time Reporting and Analytics
Connect to real-time Elasticsearch data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Elasticsearch.
-
Consume Google Cloud Storage OData Feeds in PowerBuilder
This article demonstrates how to consume Google Cloud Storage data as OData feeds from PowerBuilder using the API Server.
-
Build Semantic Layer Views for Salesforce Marketing Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Salesforce Marketing data.
-
Automated Continuous Sybase Replication to Databricks
Use CData Sync for automated, continuous, customizable Sybase replication to Databricks.
-
Integrate Cline with Live Exa Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Exa data from within your IDE.
-
How to work with Aha! Data in Apache Spark using SQL
Access and process Aha! Data in Apache Spark using the CData Software JDBC Driver.
-
Bridge EnterpriseDB Connectivity with Apache NiFi
Access and process EnterpriseDB data in Apache NiFi using the CData JDBC Driver.
-
How to connect PolyBase to ChartMogul
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ChartMogul data.
-
Query HCL Domino Data as a MySQL Database in Node.js
Execute MySQL queries against HCL Domino data from Node.js.
-
How to Connect to Live Spark 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 Spark data for you.
-
Build a Simple VCL Application for PayPal Data
How to build a simple VCL Application to view PayPal data in RAD Studio using the CData ODBC Driver for PayPal.
-
Automated Continuous Apify Replication to Snowflake
Use CData Sync for automated, continuous, customizable Apify replication to Snowflake.
-
How to Connect to SingleStore Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SingleStore data. Leverage the pyodbc module for ODBC in Python.
-
Import Real-Time PostgreSQL Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PostgreSQL data in ColdFusion.
-
Create Datasets from SAP HANA XS Advanced in Domo Workbench and Build Visualizations of SAP HANA XS Advanced Data in Domo
Use the CData Software ODBC Driver for SAP HANA XS Advanced to create datasets from SAP HANA XS Advanced data in Domo Workbench and then build visualizations in the Domo service.
-
Back Up Facebook data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Facebook. In this article, we will employ an SSIS workflow to populate a database with Facebook data data.
-
Search External Amazon S3 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Amazon S3 data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Amazon S3 Data objects that you can access from apps and the dashboard.
-
Build Dashboards with Dynamics 365 Data in Dundas BI
Create dynamic dashboards and perform analytics based on Dynamics 365 data in Dundas BI.
-
Connect to WooCommerce in SpagoBI
Create reports featuring live WooCommerce data in SpagoBI Studio. Host WooCommerce reports on SpagoBI Server.
-
Access Live Sage 300 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Sage 300 data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData Python Connector for Helpscout
Learn to install and license the CData Python Connector and configure a connection to live Helpscout data.
-
Connect to Freshservice Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Freshservice to connect to Freshservice data and execute queries in PowerBuilder.
-
Analyze PingOne Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PingOne from Power Pivot. You will use the Table Import Wizard to load PingOne data. You can visually build the import query or use any SQL supported by the driver.
-
Build Avro-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Avro Data and create custom apps in Mendix.
-
Moosend Reporting in OBIEE with the Moosend JDBC Driver
Deploy the Moosend JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Teamwork 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 Teamwork data.
-
Query Auth0 Data in ColdFusion
Write standard ColdFusion data access code to connect to Auth0 data.
-
Build Slack Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Slack data and build visualizations in Tableau.
-
Query ADP Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ADP data from Node.js.
-
Create CouchDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time CouchDB data access from reports, embedded analytics, and more.
-
Use the CData ODBC Driver for Samanage in Microsoft Power Query
You can use the CData Samanage ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Samanage data into Microsoft Power Query.
-
Connect to Sybase Data from a Connection Pool in JBoss
Integrate Sybase data into Java servlets: Use the Management Console in JBoss to install the Sybase JDBC Driver.
-
Replicate Zuora Data to Multiple Databases via the CData Sync CLI
Replicate Zuora data to disparate databases with a single configuration.
-
Use Dash to Build to Web Apps on Oracle Eloqua Reporting Data
Create Python applications that use pandas and Dash to build Oracle Eloqua Reporting-connected web apps.
-
Connect to CloudConvert Data in Ruby
Connect to CloudConvert data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Google Forms Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Forms data from Node.js.
-
How to connect and process Paddle data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Paddle data.
-
Automated Continuous Rootly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Rootly replication to Amazon S3.
-
Connect to CouchDB Data from PowerBuilder via JDBC
This article demonstrates how to access CouchDB data from PowerBuilder using the CouchDB JDBC Driver.
-
Automated Continuous AfterShip Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable AfterShip replication to Apache Kafka.
-
Query Live Redis Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Redis data directly from the development environment.
-
Integrate Cline with Live Coda Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Coda data from within your IDE.
-
How to connect and process OneNote data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live OneNote data.
-
Publish Zuora-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zuora data.
-
Getting Started with the CData Python Connector for DocuSign
Learn to install and license the CData Python Connector and configure a connection to live DocuSign data.
-
Connect to Real-Time Cvent Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Cvent and Dataflow to import and use Cvent data in Power Apps.
-
Integrate Live Tavily Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Tavily data from within the IDE.
-
How to update MarkLogic from Excel
This article explains how to transfer data from Excel to MarkLogic using the Excel Add-In for MarkLogic.
-
Build Automated Workflows with Live Microsoft Dataverse Data in Workato
Use CData Connect AI to connect to live Microsoft Dataverse data and build automated workflows in Workato.
-
Integrating Dataiku with WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live WooCommerce data.
-
Use Agno to Talk to Your SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SAP Netweaver Gateway data for you.
-
Ingest Data into Salesforce Data 360 Using CData JDBC Driver
Ingest external data into Salesforce Data 360 using the CData Salesforce Data 360 JDBC Driver.
-
How to publish and share Zoom Data dashboards with Tableau Server
The CData ODBC driver for Zoom enables you integrate Zoom data into Tableau dashboards.
-
Access Live xBase Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to xBase data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating LlamaIndex with Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Vertica data in real time.
-
Query FormSite Data as a MySQL Database in Node.js
Execute MySQL queries against FormSite data from Node.js.
-
How to Query Eventbrite Data in MySQL Workbench
Execute MySQL queries against live Eventbrite data from MySQL Workbench.
-
Integrating OpenCode with SAP ByDesign 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.
-
Connecting Mastra with Salesforce Pardot 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 Salesforce Pardot data, no replication required.
-
Integrate Dynamics CRM Data into Power Automate Desktop using CData Connect
CData Connect for Dynamics CRM Data enables you to integrate Dynamics CRM data into workflows built using Microsoft Power Automate Desktop.
-
DataBind Charts to Avaza Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Avaza data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrating Boomi Agentstudio with Microsoft Ads Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Ads data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live Google Sheets Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Sheets data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData JDBC Driver for Outlook
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Outlook.
-
Connect to CapsuleCRM Data in DBArtisan
Use wizards in DBArtisan to configure CapsuleCRM data as a data source.
-
Integrate ZohoMarketingHub Data in Pentaho Data Integration
Build ETL pipelines based on ZohoMarketingHub data in the Pentaho Data Integration tool.
-
Visualize Live Klaviyo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Klaviyo data into custom reports in Power BI.