CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Sage 300 Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sage 300 replication to Snowflake.
-
Getting Started with the CData JDBC Driver for Databricks
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Databricks.
-
Use the CData Software ODBC Driver for Impala in MicroStrategy Web
Connect to Impala data in MicroStrategy Web using the CData Software ODBC Driver for Impala.
-
Query Splunk Data as a MySQL Database in Node.js
Execute MySQL queries against Splunk data from Node.js.
-
Integrating Gumloop with Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Adobe Analytics data within automated workflows.
-
Connecting Pipedream with Bullhorn CRM 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 Bullhorn CRM data in real time.
-
Build Phoenix-Connected Apps in Choreo
Use CData Connect AI to connect to Phoenix Data from Choreo and build custom apps using live Phoenix data.
-
Connect to Oracle Service Cloud Data in HULFT Integrate
Connect to Oracle Service Cloud as a JDBC data source in HULFT Integrate
-
Create TaxJar Dataflows on PowerBI.com
Connect to the CData Power BI Connector for TaxJar from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software ODBC Driver for Oracle Service Cloud in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle Service Cloud data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle Service Cloud.
-
Feed Google Ads Data into FineReport
How to set Google Ads data as a JDBC data source in FineReport.
-
Connect to PagerDuty Data in DBArtisan
Use wizards in DBArtisan to configure PagerDuty data as a data source.
-
Build Pipelines with Live Printify Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Printify from Google Cloud Data Fusion, enabling the integration of live Printify data into the building and management of effective data pipelines.
-
Moving Data from REST to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live REST data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Amazon S3-Connected Nintex Workflows
Use CData Connect AI to connect to Amazon S3 Data from Nintex Workflow Cloud and build custom workflows using live Amazon S3 data.
-
Automated Continuous Twilio Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Twilio data replication to OneLake in Microsoft Fabric.
-
Connect to Real-Time Insightly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Insightly data in Power Apps.
-
Integrate Theia IDE with Live Bitbucket 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 Bitbucket data from within the development environment.
-
Connect to Omnisend Data in DBArtisan
Use wizards in DBArtisan to configure Omnisend data as a data source.
-
Analyze ServiceNow Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ServiceNow data in Microsoft R Open.
-
Access Live QuickBooks Time Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to QuickBooks Time data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Semantic Layer Views for Elasticsearch Data in APOS Live Data Gateway
Use the CData Connector for Elasticsearch in APOS Live Data Gateway to build Semantic Layer Views for Elasticsearch data.
-
Automated Continuous Greenplum Replication to SQLite
Use CData Sync for automated, continuous, customizable Greenplum replication to SQLite.
-
Query Live TaxJar 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 TaxJar data directly from the development environment.
-
Integrate Live Smartsheet Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Smartsheet from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Smartsheet data.
-
Integrate Theia IDE with Live Amazon S3 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 Amazon S3 data from within the development environment.
-
Import Real-Time Factorial Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Factorial data in ColdFusion.
-
Connect to Missive Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Missive and the SQL Gateway to access Missive data from Google Apps Script.
-
Connect to Parallel Data in RapidMiner
Integrate Parallel data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to create an RPA flow for Testmonitor Data in UiPath Studio
Use the Testmonitor ODBC Driver to create workflows that access real-time Testmonitor data without any coding.
-
Access Live Wistia Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Wistia data from your Google Sheets.
-
How to load MarkLogic data into Elasticsearch via Logstash
Introducing a simple method to load MarkLogic data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build AI/ML Models with Live Mouseflow Data using Dataiku
Connect Mouseflow Data with Dataiku using the CData API Driver for JDBC.
-
Integrating Antigravity CLI with ConstantContact data via CData CLI
Connect ConstantContact data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate with live Active Directory Data in Jitterbit
Use CData Connect AI to connect to and integrate live Active Directory data in Jitterbit.
-
Automated Continuous Paddle Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Paddle replication to IBM DB2.
-
Connect to Live Tavily Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Tavily in CData Connect AI and connect to your Tavily data from PostgreSQL.
-
Edit and Search External Elasticsearch Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Elasticsearch data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Elasticsearch Data objects that you can access from apps and the dashboard.
-
Query Microsoft Ads Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Microsoft Ads entities in PHP by modeling them as objects.
-
Replicate Phoenix Data to Multiple Databases via the CData Sync CLI
Replicate Phoenix data to disparate databases with a single configuration.
-
View Reports on Real-Time Neo4J Data in Power BI Report Server
Use the CData ODBC Driver for Neo4J to visualize Neo4J data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Airtable Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Airtable replication to IBM DB2.
-
Analyze iContact Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of iContact data and visualize iContact data in SAP Analytics Cloud.
-
Create Reports from Dynamics 365 Business Central Data in Looker Studio
Use CData Connect AI to gain access to live Dynamics 365 Business Central data and create custom reports in Looker Studio.
-
Build Moosend Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Moosend data and build visualizations in Tableau.
-
Build AI/ML Models with Live Jira Assets Data using Dataiku
Connect Jira Assets Data with Dataiku using the CData JDBC Driver for Jira Assets.
-
Integrate Cline with Live Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Highrise data from within your IDE.
-
Integrate Trae with Live Freshservice Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Freshservice data from within the AI-powered IDE.
-
Connect to JDBC-ODBC Bridge Data in Aqua Data Studio
Access JDBC-ODBC Bridge data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Manage ZohoInvoice Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ZohoInvoice.
-
Connect to Figshare Data in Ruby
Connect to Figshare data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData SSIS Components for Insightly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Insightly.
-
Easily Integrate Nethunt Data in Lazarus Pascal IDE
Learn how to easily integrate live Nethunt data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live Oracle Eloqua Data in AWS Lambda
Connect to live Oracle Eloqua data in AWS Lambda using the CData JDBC Driver.
-
Analyze Reckon Accounts Hosted Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Reckon Accounts Hosted data in Microsoft R Open.
-
Build Act-On-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Act-On Data and create custom apps in Bubble.
-
Use Databricks Agent Bricks to Talk to Your SuiteCRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SuiteCRM data for you.
-
Use Azure AI Foundry to Talk to Your Cloudflare Data 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 Cloudflare data for you.
-
How to Connect Flowise AI Agents to Live Blackbaud FE NXT 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 Blackbaud FE NXT data without replication.
-
Use the CData Software JDBC Driver for Pingdom in MicroStrategy
Connect to Pingdom data in MicroStrategy Developer using the CData Software JDBC Driver for Pingdom.
-
How to create Salesforce Marketing federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce Marketing data in MySQL .
-
Integrating Codex with Bright Data 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.
-
Query, Visualize, and Share live OneNote Data in Redash
Use CData Connect AI to connect to live OneNote data in Redash for querying, visualizing, and sharing.
-
Visualize Discourse Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Discourse data into TIBCO Spotfire.
-
Integrate Google's Vertex AI Agent with Live Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Workday data within intelligent workflows.
-
Connect to Attio Data from a Connection Pool in JBoss
Integrate Attio data into Java servlets: Use the Management Console in JBoss to install the Attio JDBC Driver.
-
How to Connect DBeaver to Oracle Eloqua Reporting via a JDBC Driver
Manage Oracle Eloqua Reporting data with visual tools in DBeaver like the query browser.
-
Design BIRT Reports on Microsoft Entra ID Data
Provide current Microsoft Entra ID data to your embedded analytics.
-
Use Databricks Agent Bricks to Talk to Your CockroachDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your CockroachDB data for you.
-
Load Azure Analysis Services Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Analysis Services data to a database.
-
Build Data Flows from SQL Server to Cassandra through SSIS
Easily push SQL Server data to Cassandra using the CData SSIS Tasks for Cassandra.
-
Query Live Sybase IQ Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Sybase IQ data through a conversational interface.
-
Integrate Live Eventbrite Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Eventbrite data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect and Query Live Hive Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Hive data into Databricks and enable direct, live querying and analysis without replication.
-
Automated Continuous Templated Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Templated replication to delimited files (CSV/TSV).
-
Build an OLAP Cube in SSAS from Amazon Marketplace Data
Establish a connection to Amazon Marketplace data data from SQL Server Analysis Services, and use the Amazon Marketplace Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Wave Financial-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Wave Financial data.
-
Migrating data from Flowlu to Databricks using CData SSIS Components.
Easily push Flowlu data to Databricks using the CData SSIS Tasks for Flowlu and Databricks.
-
Automated Continuous Hacker News Replication to MongoDB
Use CData Sync for automated, continuous, customizable Hacker News replication to MongoDB.
-
Build Voice Agents in ElevenLabs with access to Live Optimizely Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Optimizely data.
-
Query Mode Data in ColdFusion
Write standard ColdFusion data access code to connect to Mode data.
-
Use the CData Software ODBC Driver for HBase in SAS for Real-Time Reporting and Analytics
Connect to real-time HBase data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for HBase.
-
How to connect PolyBase to SendGrid
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SendGrid data.
-
Access Live AgileCRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to AgileCRM data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect to Live Google Analytics 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 Google Analytics data for you.
-
How to Visualize Supabase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Supabase data in Python.
-
Integrating Codex with SAP Fieldglass 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.
-
How to Connect to Live Grafana Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Grafana data without replication.
-
Create Datasets from SAP BusinessObjects BI in Domo Workbench and Build Visualizations of SAP BusinessObjects BI Data in Domo
Use the CData Software ODBC Driver for SAP BusinessObjects BI to create datasets from SAP BusinessObjects BI data in Domo Workbench and then build visualizations in the Domo service.
-
Import Freshteam Data Using Azure Data Factory
Use CData Connect AI to connect to Freshteam Data from Azure Data Factory and import live Freshteam data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Gmail
Provide connectivity to Gmail data through an SAP BusinessObjects universe.
-
How to Connect DBeaver to Zoho Projects via a JDBC Driver
Manage Zoho Projects data with visual tools in DBeaver like the query browser.
-
Viewing Square Data in RAD Studio Data Explorer
How to view Square data in RAD Studio Data Explorer using the CData ODBC Driver for Square.
-
Use CData Connect AI to Access Oracle HCM Cloud Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle HCM Cloud data in the Power Pivot business intelligence tool.
-
Access Live Bitbucket Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Bitbucket data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Amazon Athena Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amazon Athena data from HeidiSQL.
-
Link SAS xpt with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAS xpt data in Filemaker Pro for Mac or Windows.
-
Build Apps with Live Simplesat Data Using the Low-Code Development Platform of Mendix
Connect Simplesat data with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize Live Blackbaud FE NXT Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Blackbaud FE NXT data into custom reports in Power BI.
-
Integrate Shortcut Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Shortcut data and integrate live Shortcut data into your Power Automate tasks.