CData Software - Knowledge Base
Recent Articles
-
Query MailChimp Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MailChimp entities in PHP by modeling them as objects.
-
Use CData Connect AI to Access BigQuery Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google BigQuery in the Power Pivot business intelligence tool.
-
How to Connect to Facebook Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Facebook. Leverage the pyodbc module for ODBC in Python.
-
Analyze SendGrid Data in Cognos Analytics
Use CData Connect AI to connect to SendGrid Data from Cognos Analytics and analyze live SendGrid.
-
How to connect to Mailgun Data in DBVisualizer
Integrate Mailgun with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Data Flows from Oracle HCM Cloud to SQL Server using SSIS
Easily back up Oracle HCM Cloud 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 from Node.js.
-
Build Dashboards with ScrapingBee Data in Dundas BI
Create dynamic dashboards and perform analytics based on ScrapingBee in Dundas BI.
-
Integrating Codex CLI with TaxJar 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.
-
How to connect to ZarMoney Data from IntelliJ
Integrate connectivity to ZarMoney with wizards in IntelliJ.
-
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 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
-
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 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.
-
Stream Amazon Athena Data into Apache Kafka Topics
Access and stream Amazon Athena 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 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 in Birst.
-
View Reports on Real-Time ZendeskSell Data in Power BI Report Server
Use the CData ODBC Driver for ZendeskSell to visualize ZendeskSell 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.
-
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 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.
-
Build SAP Ariba Source-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP Ariba Source 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 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 from Web applications running on WebLogic.
-
Integrate with SAP Hybris C4C Data in JReport Designer
Create charts and reports based on SAP Hybris C4C in JReport Designer.
-
Connect Procore Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Procore 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 in ColdFusion.
-
How to integrate Metabase with Gong Data
Use CData Connect AI to connect to live Gong and create an interactive dashboard in Metabase from Gong.
-
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 for you.
-
How to Visualize Placid Data in Python with pandas
Use pandas and other modules to analyze and visualize live Placid in Python.
-
Configure the CData JDBC Driver for Moosend in a Connection Pool in Tomcat
Connect to Moosend 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 to SQL Server.
-
How to Design eBay Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to eBay from mobile and tablet Power Apps.
-
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 in MySQL .
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SingleStore using the Model Context Protocol.
-
Analyze Slack Data in Cognos Analytics
Use CData Connect AI to connect to Slack Data from Cognos Analytics and analyze live Slack.
-
Design BIRT Reports on Azure DevOps Data
Provide current Azure DevOps 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.
-
Query Asana Data as a SQL Server Database in Node.js
Execute SQL Server queries against Asana 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 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 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 to disparate databases with a single configuration.
-
Replicate Pingdom Data to Multiple Databases
Replicate Pingdom 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 into a data warehouse using Oracle Data Integrator.
-
Design BIRT Reports on Front Data
Provide current Front to your embedded analytics.
-
Connect to ClickUp Data in DBeaver
Use the CData ODBC Driver to connect to ClickUp in DBeaver.
-
Build Amazon S3-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Amazon S3 and build web apps with connectivity to live Amazon S3.
-
Viewing SendPulse Data in RAD Studio Data Explorer
How to view SendPulse in RAD Studio Data Explorer using the CData ODBC Driver for SendPulse.
-
Create SSAS Tabular Models from GetResponse Data
How to build a SQL Server Analysis Service Tabular Model from GetResponse using CData drivers.
-
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 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 into Tableau dashboards.
-
Integrating Kiro CLI 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.
-
Working with Google Translate Data in LINQPad
Execute LINQ queries to Google Translate in LINQPad.
-
Analyze Cvent Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Cvent and visualize live Cvent in Infragistics Reveal.
-
Bridge Zendesk Connectivity with Apache NiFi
Access and process Zendesk 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 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 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 via CData CLI
Connect Teamwork 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 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 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 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.
-
Replicate Exa Data from PowerShell
Write a quick PowerShell script to query Exa. Use connectivity to the live data to replicate Exa to SQL Server.
-
Connect to and Query Workable Data in QlikView over ODBC
Create data visualizations with Workable in QlikView.
-
Automated PagerDuty Data Replication to Teradata
Use CData Sync to Customize and automate PagerDuty replication to Teradata.
-
Connect to and Query Amazon Athena Data in QlikView over ODBC
Create data visualizations with Amazon Athena 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 in Apache NiFi using the CData JDBC Driver.
-
Build Dashboards with Zendesk Data in DBxtra
Create dynamic dashboards and perform analytics based on Zendesk in DBxtra.
-
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 from Google Apps Script.
-
Build Amazon Athena-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Amazon Athena to explore live Amazon Athena Data in Gemini Code Assist to assist with building Amazon Athena-powered applications.
-
Analyze Pipedrive Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Pipedrive and visualize live Pipedrive in Infragistics Reveal.
-
Use Databricks Agent Bricks to Talk to Your Sybase Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Sybase for you.
-
Connect to and Query Jumpseller Data in QlikView over ODBC
Create data visualizations with Jumpseller in QlikView.
-
Build Excel Online-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Excel Online Data and create custom apps in Bubble.