CData Software - Knowledge Base
Recent Articles
-
Connect to Rootly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Rootly from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Visualize ConvertAPI Data in Sisense
Create an ElastiCube in Sisense app with access to ConvertAPI.
-
Automated Continuous SAS xpt Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAS xpt replication to Azure SQL Database.
-
Build Charts with Pinecone Data in Clear Analytics
Create dynamic charts and perform analytics based on Pinecone in Clear Analytics.
-
Connect to Elorus Data in Ruby
Connect to Elorus in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Enable the MarkLogic JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MarkLogic.
-
Work with Shortcut Data in FoxPro
Load Shortcut into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Odoo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Odoo ERP from Node.js.
-
Create SSAS Tabular Models from Mode Data
How to build a SQL Server Analysis Service Tabular Model from Mode using CData drivers.
-
Access Lakebase 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 Lakebase.
-
Build CouchDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache CouchDB.
-
Connecting Agentforce with Jira Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Atlassian Jira for you.
-
Connect to DB2 Data in CloverDX (formerly CloverETL)
Transfer IBM DB2 using the visual workflow in the CloverDX data integration tool.
-
Natively Connect to Azure Table Data in PHP
The CData ODBC driver for Azure Table enables you to create PHP applications with connectivity to Azure Table Storage. Leverage the native support for ODBC in PHP.
-
Query Google Drive Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Drive.
-
DataBind Controls to Spark Data in C++Builder
DataBind to Apache Spark SQL in C++Builder with standard components and controls.
-
How to Build an ETL App for HCL Domino Data in Python with CData Connect AI
Build ETL pipelines that read and write live HCL Domino in Python with petl and the CData Connect AI Python SDK.
-
Getting Started with the CData Python Connector for Simplesat
Learn to install and license the CData Python Connector
-
Connect to AlloyDB Data in NetBeans
Connect to Google AlloyDB in NetBeans with the data source configuration wizard.
-
How to Access Paylocity Data Using Entity Framework
This article shows how to access Paylocity using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to EnterpriseDB from a Connection Pool in WebLogic
Use the CData JDBC Driver for EnterpriseDB to connect to EnterpriseDB from Web applications running on WebLogic.
-
Use ChatGPT to Talk to Your Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Gmail for you.
-
Connect to and Query Snapchat Ads Data in QlikView over ODBC
Create data visualizations with Snapchat Ads in QlikView.
-
How to Work with Avaza Data in ETL Validator JDBC
Connect to Avaza from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Visualize ZeroBounce Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZeroBounce in Python.
-
How to Connect to Live Dynamics CRM Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Microsoft Dynamics CRM for you.
-
Integrate MariaDB Data into Power Automate Desktop using CData Connect
CData Connect for MariaDB Data enables you to integrate MariaDB into workflows built using Microsoft Power Automate Desktop.
-
Connect to Zoom Data in Ruby
Connect to Zoom in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Model, Search, and Visualize Live FreshBooks Data in ThoughtSpot
Use CData Connect AI to connect to live FreshBooks for modeling, searching, and visualizing.
-
Dynamics CRM Reporting in OBIEE with the Dynamics CRM JDBC Driver
Deploy the Dynamics CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Azure Data Lake Storage Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Azure Data Lake Storage from Power Pivot. You will use the Table Import Wizard to load Azure Data Lake Storage. You can visually build the import query or use any SQL supported by the driver.
-
Publish Snapchat Ads-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Snapchat Ads.
-
Build Voice Agents in ElevenLabs with access to Live MongoDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live MongoDB.
-
Connecting GenSpark with Zoho Inventory Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Zoho Inventory without any replication or custom integration required.
-
Object-Relational Mapping (ORM) with Guru Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Guru into a Java-based ORM framework, Hibernate.
-
Automated Continuous Quaderno Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Quaderno replication to Apache Cassandra.
-
Automated Continuous Dynamics 365 Business Central Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Apache Kafka.
-
Access Live Campaigner Data in AWS Lambda
Connect to live Campaigner in AWS Lambda using the CData JDBC Driver.
-
How to Build an ETL App for Google Ads Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google Ads in Python with petl and the CData Connect AI Python SDK.
-
Connect to DocuSign Data from PowerBuilder via ADO.NET
This article demonstrates how to access DocuSign from Appeon PowerBuilder using the CData ADO.NET Provider for DocuSign.
-
Automated Continuous SAP HANA Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP HANA replication to Databricks.
-
Connect to Lakebase Data in RapidMiner
Integrate Lakebase with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Zendesk Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zendesk in Airbyte.
-
A PostgreSQL Interface for Dotmailer Data (MySQL Remoting via JDBC)
Use the Remoting features of the Dotmailer JDBC Driver to create a PostgreSQL entry-point for data access.
-
Model, Search, and Visualize Live Smartsheet Data in ThoughtSpot
Use CData Connect AI to connect to live Smartsheet for modeling, searching, and visualizing.
-
Configure the CData JDBC Driver for Placid in a Connection Pool in Tomcat
Connect to Placid from a connection pool in Tomcat.
-
Bridge Gumroad Connectivity with Apache NiFi
Access and process Gumroad in Apache NiFi using the CData JDBC Driver.
-
Visualize ZohoMarketingHub Data in Sisense
Create an ElastiCube in Sisense app with access to ZohoMarketingHub.
-
How to load Oracle data into Elasticsearch via Logstash
Introducing a simple method to load Oracle data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to AgileCRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for AgileCRM and the SQL Gateway to access AgileCRM from Google Apps Script.
-
Connect to Zoho Creator Data from PowerBuilder via ADO.NET
This article demonstrates how to access Zoho Creator from Appeon PowerBuilder using the CData ADO.NET Provider for Zoho Creator.
-
Build a Simple VCL Application for Azure Data Catalog Data
How to build a simple VCL Application to view Azure Data Catalog in RAD Studio using the CData ODBC Driver for Azure Data Catalog.
-
Create Power BI Reports on Real-Time Zoho Creator Data
Use the CData ODBC Driver for Zoho Creator to visualize Zoho Creator in Power BI Desktop.
-
Integrating GitHub Copilot CLI with Coinbase 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.
-
Getting Started with the CData Excel Add-In for Kintone
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Kintone.
-
How to Visualize Paylocity Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Paylocity in Python.
-
How to Build an ETL App for Impala Data in Python with CData
Create ETL applications and real-time data pipelines for Apache Impala in Python with petl.
-
Replicate Multiple JotForm Accounts
Replicate multiple JotForm accounts to one or many databases.
-
Connect to Nethunt Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Nethunt and work with Nethunt in your FileMaker applications.
-
ETL Facebook Ads in Oracle Data Integrator
This article shows how to transfer Facebook Ads into a data warehouse using Oracle Data Integrator.
-
Use the CData ODBC Driver for Bitly in Microsoft Power Query
You can use the CData Bitly ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Bitly into Microsoft Power Query.
-
How to Connect to Live Bullhorn CRM Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Bullhorn CRM without replication.
-
Feed Bannerbear Data into FineReport
How to set Bannerbear as a JDBC data source in FineReport.
-
Working with Slack Data in LINQPad
Execute LINQ queries to Slack in LINQPad.
-
Connect to Kintone Data from HeidiSQL
Use CData Connect AI to connect to and query live Kintone from HeidiSQL.
-
Connect to Google Ads Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Ads from Appeon PowerBuilder using the CData ADO.NET Provider for Google Ads.
-
Build a Simple VCL Application for PhantomBuster Data
How to build a simple VCL Application to view PhantomBuster in RAD Studio using the CData ODBC Driver for PhantomBuster.
-
Natively Connect to Discourse Data in PHP
The CData ODBC driver for Discourse enables you to create PHP applications with connectivity to Discourse. Leverage the native support for ODBC in PHP.
-
How to Connect LinkedIn Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live LinkedIn data in real time using natural language.
-
How to import Adobe Target Data into Apache Solr
Use the CData Software JDBC Driver for Adobe Target in Data Import Handler and create an automated import of Adobe Target to Apache Solr Enterprise Search platform.
-
Publish SageHR-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SageHR.
-
Natively Connect to VWO Data in PHP
The CData ODBC driver for VWO enables you to create PHP applications with connectivity to VWO. Leverage the native support for ODBC in PHP.
-
Create Datasets from Rootly in Domo Workbench and Build Visualizations of Rootly Data in Domo
Use the CData Software ODBC Driver for Rootly to create datasets from Rootly in Domo Workbench and then build visualizations in the Domo service.
-
Import Real-Time Discord Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Discord in ColdFusion.
-
Operational Reporting on Cvent Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Cvent.
-
Access Harvest 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 Harvest.
-
Integrating LangChain with Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Gong within automated workflows.
-
How to connect PolyBase to Odoo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Odoo ERP.
-
Prepare, Blend, and Analyze CouchDB Data in Alteryx Designer (Connect AI)
Build workflows to access live Apache CouchDB for self-service data analytics.
-
Integrating OpenCode Terminal with Codat 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.
-
Connect to Freshsales Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software ODBC Driver for CouchDB in MicroStrategy Desktop
Connect to Apache CouchDB in MicroStrategy Desktop using the CData Software ODBC Driver for CouchDB.
-
Automated Continuous Printful Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Printful replication to Amazon S3.
-
How to Build an ETL App for NetSuite Data in Python with CData
Create ETL applications and real-time data pipelines for NetSuite CRM & ERP in Python with petl.
-
Build Apps with Live MYOB AccountRight Data Using the Low-Code Development Platform of Mendix
Connect MYOB AccountRight with Mendix to build apps using the CData JDBC Driver for MYOB AccountRight.
-
How to Connect to Live FTP 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 FTP Servers for you.
-
Use the CData ODBC Driver for FreshBooks from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for FreshBooks to connect to FreshBooks from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring FreshBooks in Excel.
-
Build Xero Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Xero Accounting and build visualizations in Tableau.
-
Integrate Customer.io Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Customer.io from Informatica Cloud.
-
Working with JSON Services in LINQPad
Execute LINQ queries to JSON in LINQPad.
-
Create Reports with Bugsnag Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bugsnag.
-
Integrate ZohoSubscriptions with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ZohoSubscriptions with External Services.
-
Build WooCommerce-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to WooCommerce and build web apps with connectivity to live WooCommerce.
-
Connect to Adobe Analytics Data from a Connection Pool in JBoss
Integrate Adobe Analytics into Java servlets: Use the Management Console in JBoss to install the Adobe Analytics JDBC Driver.
-
How to create an RPA flow for SAP Data in UiPath Studio
Use the SAP ODBC Driver to create workflows that access real-time SAP ERP/NetWeaver without any coding.
-
Access Postmark Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Postmark from HeidiSQL.
-
Rapidly Develop Odoo-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 Odoo.
-
Add Bitly Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Bitly with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connecting Pipedream with Azure Table 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 Azure Table data in real time.
-
Visualize Live Jira Assets Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Jira Assets using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.