CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Elasticsearch Replication to SQLite
Use CData Sync for automated, continuous, customizable Elasticsearch replication to SQLite.
-
Create Power BI Reports on Real-Time Insightly Data
Use the CData ODBC Driver for Insightly to visualize Insightly data in Power BI Desktop.
-
Using the CData Software ODBC Driver for Guru in PyCharm
Connect to Guru as an ODBC data source in PyCharm using the CData Software ODBC Driver for Guru.
-
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 data 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 data 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.
-
Access Paylocity Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Paylocity data from your Oracle system.
-
Natively Connect to Apollo Data in PHP
The CData ODBC driver for Apollo enables you to create PHP applications with connectivity to Apollo data. Leverage the native support for ODBC in PHP.
-
Integrating GitHub Copilot with Monday.com 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.
-
Enable the PolarTeamPro JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PolarTeamPro data.
-
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.
-
Connecting Pipedream with ZohoSubscriptions 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 ZohoSubscriptions data in real time.
-
Getting Started with the CData Excel Add-In for Gmail
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Gmail.
-
Connect to Adobe Experience Manager Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Adobe Experience Manager and the SQL Gateway to access Adobe Experience Manager data from Google Apps Script.
-
Connect to DocuSign Data from PowerBuilder via ADO.NET
This article demonstrates how to access DocuSign data from Appeon PowerBuilder using the CData ADO.NET Provider for DocuSign.
-
Integrate Shopify Data in the Pentaho Report Designer
Publish reports based on Shopify data in the Pentaho BI tool.
-
How to import CouchDB Data into Apache Solr
Use the CData Software JDBC Driver for CouchDB in Data Import Handler and create an automated import of CouchDB data to Apache Solr Enterprise Search platform.
-
Analyze Teradata Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Teradata from Power Pivot. You will use the Table Import Wizard to load Teradata data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Live TigerGraph Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live TigerGraph data.
-
Integrate Cline with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sybase IQ data from within your IDE.
-
Connect to Lakebase Data in RapidMiner
Integrate Lakebase data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Paylocity Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Paylocity replication to IBM DB2.
-
Feed Campaigner Data into FineReport
How to set Campaigner data as a JDBC data source in FineReport.
-
Build a Singer.io Tap for VWO With the CData Python Connector
Learn how to easily build a Singer.io Tap for live VWO data using the CData Python Connector.
-
Prepare, Blend, and Analyze Google Forms Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Forms data for self-service data analytics.
-
Visualize ZohoMarketingHub Data in Sisense
Create an ElastiCube in Sisense app with access to ZohoMarketingHub data.
-
Stream Moosend Data into Apache Kafka Topics
Access and stream Moosend data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
ETL Spark in Oracle Data Integrator
This article shows how to transfer Spark data into a data warehouse using Oracle Data Integrator.
-
Connect to Airtable Data from a Connection Pool in Jetty
The Airtable JDBC Driver supports connection pooling: This article shows how to connect faster to Airtable data from Web apps in Jetty.
-
Automated Continuous Clari Replication to Snowflake
Use CData Sync for automated, continuous, customizable Clari replication to Snowflake.
-
Bind Live Azure Table Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Table data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build Phoenix-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Phoenix data.
-
Query Salesforce CRM Analytics Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Salesforce CRM Analytics data from Node.js.
-
Integrating Codex with Acumatica 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.
-
Integrating GitHub Copilot with Coinbase 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.
-
Integrating Claude Code CLI with ZendeskSell 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.
-
Build Perplexity-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Perplexity Data and create custom apps in Bubble.
-
Use the CData Software ODBC Driver for Pingdom in SAS for Real-Time Reporting and Analytics
Connect to real-time Pingdom data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pingdom.
-
Connect to SageHR Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SageHR data.
-
Build Automated Workflows with Live Smartsheet Data in Workato
Use CData Connect AI to connect to live Smartsheet data and build automated workflows in Workato.
-
Query Pingdom Data as a MySQL Database in Node.js
Execute MySQL queries against Pingdom data from Node.js.
-
Integrate Dify with Live Mailgun Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Mailgun data.
-
How to connect PolyBase to Gumroad
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Gumroad data.
-
Query Live Yelp 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 Yelp data directly from the development environment.
-
Connect to Oracle Service Cloud Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle Service Cloud to connect to Oracle Service Cloud data and execute queries in PowerBuilder.
-
Connect to ZohoInvoice Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZohoInvoice and work with ZohoInvoice data in your FileMaker applications.
-
Build Agents in Relevance AI with Access to Live Yelp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Yelp data within intelligent agent workflows.
-
Replicate Multiple Twitter Ads Accounts
Replicate multiple Twitter Ads accounts to one or many databases.
-
Create Mailjet-Connected Business Apps in AppSheet
Connect to Mailjet Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Mailjet data.
-
How to Connect DBeaver to SAP SuccessFactors LMS via a JDBC Driver
Manage SAP SuccessFactors LMS data with visual tools in DBeaver like the query browser.
-
Integrate Bannerbear with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Bannerbear with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Bannerbear data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for DocuSign
Provide connectivity to DocuSign data through an SAP BusinessObjects universe.
-
How to Connect the Power BI Service to Oracle Sales: Complete Guide
Connect to the CData Software Power BI Connector for Oracle Sales from PowerBI.com to provide real-time Oracle Sales data across the organization.
-
Connect and Visualize Live eBay Analytics Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live eBay Analytics data into the Databricks platform and create visualization dashboards with real-time eBay Analytics data.
-
Connect to PostgreSQL Data in Aqua Data Studio
Access PostgreSQL data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
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.
-
ETL Ontraport in Oracle Data Integrator
This article shows how to transfer Ontraport data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous SendPulse Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SendPulse data replication to OneLake in Microsoft Fabric.
-
Natively Connect to VWO Data in PHP
The CData ODBC driver for VWO enables you to create PHP applications with connectivity to VWO data. Leverage the native support for ODBC in PHP.
-
Create Apps from Egnyte Data in Qlik Sense Cloud
Use CData Connect AI to connect to Egnyte Data and build apps from live Egnyte data in Qlik Sense Cloud.
-
Integrate Devin with Live Shortcut Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Shortcut data.
-
Integrate with Live Timely Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Timely from the MuleSoft Anypoint Platform to integrate live Timely data into custom reports and dashboards.
-
Connect to Salesforce Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Salesforce Data and connect to Salesforce data in Akorbi Digital RunMyProcess.
-
Integrating Kiro with Dynamics 365 Business Central 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.
-
Integrating Kiro with Google Spanner 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.
-
Use the CData Software JDBC Driver for Oracle Financials Cloud in MicroStrategy Web
Connect to Oracle Financials Cloud data in MicroStrategy Web using the CData Software JDBC Driver for Oracle Financials Cloud.
-
Access Live Klipfolio Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Klipfolio data from your Google Sheets.
-
Create Data Visualizations in Cognos BI with REST Data
Access REST data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Aweber Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Aweber and work with Aweber data in your FileMaker application.
-
Integrating LangChain with Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Oracle SCM data within automated workflows.
-
How to Easily Query Xero Data in OpenOffice Base
Connect to Xero data in OpenOffice Base using the CData ODBC Driver for Xero and generate reports with live data insights.
-
Getting Started with the CData JDBC Driver for Amazon S3
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Amazon S3.
-
Access SAP Ariba Procurement Data from MySQL in PHP
Connect to SAP Ariba Procurement through the standard MySQL libraries in PHP.
-
Access Mistral AI Data from MySQL in Amazon QuickSight
Connect to Mistral AI and build visualizations of Mistral AI data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous GitHub Replication to AlloyDB
Use CData Sync for automated, continuous, customizable GitHub replication to AlloyDB.
-
Integrating OpenCode 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.
-
Use the CData Software JDBC Driver for CockroachDB in MicroStrategy
Connect to CockroachDB data in MicroStrategy Developer using the CData Software JDBC Driver for CockroachDB.
-
Use the CData Software ODBC Driver for Apify in MicroStrategy
Connect to Apify data in MicroStrategy Developer using the CData Software ODBC Driver for Apify.
-
How to Build an ETL App for NetSuite Data in Python with CData
Create ETL applications and real-time data pipelines for NetSuite data in Python with petl.
-
Use Databricks Agent Bricks to Talk to Your Guru Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Guru data for you.
-
Connect to ServiceDesk Plus Data in CloverDX (formerly CloverETL)
Transfer ServiceDesk Plus data using the visual workflow in the CloverDX data integration tool.
-
Publish Avro-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Avro data.
-
Use the CData Software JDBC Driver for PhantomBuster in MicroStrategy Web
Connect to PhantomBuster data in MicroStrategy Web using the CData Software JDBC Driver for PhantomBuster.
-
How to Connect to Live Stripe 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 Stripe data for you.
-
Integrate Live Sybase IQ Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sybase IQ data and integrate live Sybase IQ data into apps built in Microsoft Power Apps.
-
Bidirectional Access to SAS Data Sets Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAS Data Sets data in Filemaker Pro for Mac or Windows.
-
DataBind Controls to Superchat Data in C++Builder
DataBind to Superchat data in C++Builder with standard components and controls.
-
Access Postmark Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Postmark data from HeidiSQL.
-
Back Up OneNote data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for OneNote. In this article, we will employ an SSIS workflow to populate a database with OneNote data data.
-
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.
-
Natively Connect to Salesforce Data in PHP
The CData ODBC driver for Salesforce enables you to create PHP applications with connectivity to Salesforce data. Leverage the native support for ODBC in PHP.
-
Analyze Cloudflare Data in Cognos Analytics
Use CData Connect AI to connect to Cloudflare Data from Cognos Analytics and analyze live Cloudflare data.
-
Getting Started with the CData JDBC Driver for Aha!
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Aha!.
-
Query Snapchat Ads Data as a SQL Server Database in Node.js
Execute SQL Server queries against Snapchat Ads data from Node.js.
-
How to connect to Snowflake Data with Squirrel SQL client
Connect to Snowflake data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Flowlu Replication to SQLite
Use CData Sync for automated, continuous, customizable Flowlu replication to SQLite.
-
How to Connect Flowise AI Agents to Live xBase Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live xBase data without replication.
-
Connect to Azure DevOps Data in HULFT Integrate
Connect to Azure DevOps as a JDBC data source in HULFT Integrate
-
Integrate Theia IDE with Live Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Hive data from within the development environment.
-
Integrating Gumloop with SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Concur data within automated workflows.