CData Software - Knowledge Base
Recent Articles
-
Build Data Flows from Oracle HCM Cloud to SQL Server using SSIS
Easily back up Oracle HCM Cloud data to SQL Server using the SSIS components for Oracle HCM Cloud.
-
Connecting Pipedream with OneNote 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 OneNote data in real time.
-
Getting Started with the CData Power BI Connector for Jira Assets
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Jira Assets.
-
Query Act CRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Act CRM data from Node.js.
-
Build Dashboards with ScrapingBee Data in Dundas BI
Create dynamic dashboards and perform analytics based on ScrapingBee data in Dundas BI.
-
Integrating Codex with TaxJar 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 ClickTime-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ClickTime data.
-
How to connect to ZarMoney Data from IntelliJ
Integrate connectivity to ZarMoney data with wizards in IntelliJ.
-
Analyze Bitbucket Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Bitbucket data and visualize Bitbucket data in SAP Analytics Cloud.
-
Create Datasets from EnterpriseDB in Domo Workbench and Build Visualizations of EnterpriseDB Data in Domo
Use the CData Software ODBC Driver for EnterpriseDB to create datasets from EnterpriseDB data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Office 365 Data in HULFT Integrate
Connect to Office 365 as a JDBC data source in HULFT Integrate
-
Process & Analyze Sentry Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sentry Data.
-
Integrate Live Salesforce Marketing 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 Salesforce Marketing data from within the IDE.
-
Access Live Perplexity Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Perplexity data from your Google Sheets.
-
Create Datasets from Campaigner in Domo Workbench and Build Visualizations of Campaigner Data in Domo
Use the CData Software ODBC Driver for Campaigner to create datasets from Campaigner data in Domo Workbench and then build visualizations in the Domo service.
-
How to load Freshteam data into Elasticsearch via Logstash
Introducing a simple method to load Freshteam data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query GitLab Data in ColdFusion
Write standard ColdFusion data access code to connect to GitLab data.
-
Stream Amazon Athena Data into Apache Kafka Topics
Access and stream Amazon Athena data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Dash to Build to Web Apps on Hive Data
Create Python applications that use pandas and Dash to build Hive-connected web apps.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Adobe Analytics
Provide connectivity to Adobe Analytics data through an SAP BusinessObjects universe.
-
Build Visualizations of Klipfolio Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Klipfolio data in Birst.
-
View Reports on Real-Time ZendeskSell Data in Power BI Report Server
Use the CData ODBC Driver for ZendeskSell to visualize ZendeskSell data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect PolyBase to MYOB AccountRight
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MYOB AccountRight data.
-
Use the CData Software ODBC Driver for Power BI XMLA in SAS for Real-Time Reporting and Analytics
Connect to real-time Power BI XMLA data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Power BI XMLA.
-
Query Spark Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Spark entities in PHP by modeling them as objects.
-
Use Claude to Talk to Your Omnisend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Omnisend data for you.
-
Build SAP Ariba Source-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP Ariba Source data and build SAP Ariba Source-connected web apps with Axios.
-
Build Apps with Live Elorus Data Using the Low-Code Development Platform of Mendix
Connect Elorus data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Front from a Connection Pool in WebLogic
Use the CData JDBC Driver for Front to connect to Front data from Web applications running on WebLogic.
-
Integrate with SAP Hybris C4C Data in JReport Designer
Create charts and reports based on SAP Hybris C4C data in JReport Designer.
-
Connect to Live AgileCRM Data in MicroStrategy through CData Connect AI
Create a live connection to AgileCRM Data in CData Connect AI and connect to your AgileCRM data from MicroStrategy.
-
Connect Procore Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Procore data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Import Real-Time BenchmarkEmail Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use BenchmarkEmail data in ColdFusion.
-
Connecting Agentforce with Dynamics NAV 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 Dynamics NAV data for you.
-
How to integrate Metabase with Gong Data
Use CData Connect AI to connect to live Gong data and create an interactive dashboard in Metabase from Gong data.
-
Integrating Claude Code CLI with ZohoSubscriptions 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 Work with Qualaroo Data in ETL Validator JDBC
Connect to Qualaroo from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live Microsoft Exchange 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 Exchange data for you.
-
Query Live NetSuite 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 NetSuite data through a conversational interface.
-
How to Visualize Placid Data in Python with pandas
Use pandas and other modules to analyze and visualize live Placid data in Python.
-
Configure the CData JDBC Driver for Moosend in a Connection Pool in Tomcat
Connect to Moosend data from a connection pool in Tomcat.
-
Use Biml to Build SSIS Tasks to Replicate Wrike Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Wrike data to SQL Server.
-
How to create Salesforce CRM Analytics federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce CRM Analytics data in MySQL .
-
Integrate Google's Antigravity Agent with Live SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SingleStore data using the Model Context Protocol.
-
Integrate Google's Vertex AI Agent with Live Notion 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 Notion data within intelligent workflows.
-
Analyze Slack Data in Cognos Analytics
Use CData Connect AI to connect to Slack Data from Cognos Analytics and analyze live Slack data.
-
Design BIRT Reports on Azure DevOps Data
Provide current Azure DevOps data to your embedded analytics.
-
Connect to SAP ByDesign Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP ByDesign as an External Source in Dremio.
-
Create Access Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Access from PowerBI.com to create Power BI Dataflows with real-time data.
-
Enable the Clockify JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Clockify data.
-
Query Asana Data as a SQL Server Database in Node.js
Execute SQL Server queries against Asana data from Node.js.
-
Integrating Claude Code CLI with Sendwithus 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.
-
Access Discourse Data from MySQL in PHP
Connect to Discourse through the standard MySQL libraries in PHP.
-
How to Work with Microsoft Exchange Data in AWS Glue Jobs Using JDBC
Connect to Microsoft Exchange from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous CampaignMonitor Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to PostgreSQL.
-
Deploy the ADO.NET Provider for HelloSign on an SSRS Report Server
Connect to HelloSign data 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.
-
Use Azure AI Foundry to Talk to Your Authorize.Net 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 Authorize.Net data for you.
-
How to Connect SQL Analysis Services 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 SQL Analysis Services data in real time using natural language.
-
Replicate ServiceNow Data to Multiple Databases via the CData Sync CLI
Replicate ServiceNow data to disparate databases with a single configuration.
-
Replicate Pingdom Data to Multiple Databases
Replicate Pingdom data to disparate databases with a point-and-click configuration.
-
Getting Started with the CData Tableau Connector for HBase
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for HBase.
-
Excel Spreadsheet Automation on ZendeskSell Data with the QUERY Formula
Pull data from ZendeskSell, automate spreadsheets, and more with the QUERY formula.
-
ETL Oracle Financials Cloud in Oracle Data Integrator
This article shows how to transfer Oracle Financials Cloud data into a data warehouse using Oracle Data Integrator.
-
Design BIRT Reports on Front Data
Provide current Front data to your embedded analytics.
-
Connect to ClickUp Data in DBeaver
Use the CData ODBC Driver to connect to ClickUp data in DBeaver.
-
Build Amazon S3-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Amazon S3 data and build web apps with connectivity to live Amazon S3 data.
-
Viewing SendPulse Data in RAD Studio Data Explorer
How to view SendPulse data in RAD Studio Data Explorer using the CData ODBC Driver for SendPulse.
-
Access Live Shippo Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Shippo data through MCP integration.
-
Create SSAS Tabular Models from GetResponse Data
How to build a SQL Server Analysis Service Tabular Model from GetResponse data using CData drivers.
-
Interact with Live LDAP Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live LDAP objects.
-
Getting Started with the CData ADO.NET Provider for Gorgias
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use the CData ODBC Driver for Coda in Microsoft Power Query
You can use the CData Coda ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Coda data into Microsoft Power Query.
-
How to work with OData Services in Apache Spark using SQL
Access and process OData Services in Apache Spark using the CData Software JDBC Driver.
-
Visualize ClickTime Data in Tableau
The CData ODBC driver for ClickTime enables you integrate ClickTime data into Tableau dashboards.
-
Integrating Kiro with Reply.io 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 PDFMonkey Data in DataGrip
Create a Data Source for PDFMonkey in DataGrip and use SQL to query live PDFMonkey data.
-
Working with Google Translate Data in LINQPad
Execute LINQ queries to Google Translate data in LINQPad.
-
Analyze Cvent Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Cvent data and visualize live Cvent data in Infragistics Reveal.
-
Bridge Zendesk Connectivity with Apache NiFi
Access and process Zendesk data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous iContact Replication to MySQL
Use CData Sync for automated, continuous, customizable iContact replication to MySQL.
-
Consume Dropbox OData Feeds in PowerBuilder
This article demonstrates how to consume Dropbox data as OData feeds from PowerBuilder using the API Server.
-
How to Connect to Live OData Services from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your OData services for you.
-
Getting Started with the CData Power BI Connector for Excel Online
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Excel Online.
-
Integrating Antigravity CLI with Teamwork data via CData CLI
Connect Teamwork data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect DBeaver to WordPress via a JDBC Driver
Manage WordPress data with visual tools in DBeaver like the query browser.
-
Use Microsoft Copilot Studio to talk to your SendGrid Data 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 SendGrid data for you.
-
Connect to Eventbrite Data from a Connection Pool in Jetty
The Eventbrite JDBC Driver supports connection pooling: This article shows how to connect faster to Eventbrite data from Web apps in Jetty.
-
Connect to Amazon Athena from Asprova with CData Software ODBC Driver for Amazon Athena
This article shows how to connect faster to Amazon Athena data from Asprova.
-
Connecting Pipedream with Gong 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 Gong data in real time.
-
Publish Reports with Power BI XMLA Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Power BI XMLA data.
-
Replicate Exa Data from PowerShell
Write a quick PowerShell script to query Exa data. Use connectivity to the live data to replicate Exa data to SQL Server.
-
Connect to and Query Workable Data in QlikView over ODBC
Create data visualizations with Workable data in QlikView.
-
Automated PagerDuty Data Replication to Teradata
Use CData Sync to Customize and automate PagerDuty data replication to Teradata.
-
Connect to and Query Amazon Athena Data in QlikView over ODBC
Create data visualizations with Amazon Athena data in QlikView.
-
Automated Continuous PayPal Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable PayPal replication to Amazon Redshift.
-
Bridge Hubstaff Connectivity with Apache NiFi
Access and process Hubstaff data in Apache NiFi using the CData JDBC Driver.
-
Build Dashboards with Zendesk Data in DBxtra
Create dynamic dashboards and perform analytics based on Zendesk data in DBxtra.
-
Connect to Pinterest Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Pinterest data in Airbyte.
-
Connect to Azure Data Lake Storage Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Azure Data Lake Storage and the SQL Gateway to access Azure Data Lake Storage data from Google Apps Script.
-
Use Microsoft Copilot Studio to talk to your QuickBooks Data 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 QuickBooks data for you.