CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with Parquet Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache Parquet in DBxtra.
-
Connect to HDFS Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apache HDFS in the Denodo Virtual DataPort Administrator.
-
Automated Continuous FormSite Replication to SQLite
Use CData Sync for automated, continuous, customizable FormSite replication to SQLite.
-
Load Typeform Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Typeform to a database.
-
Integrate ADP Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to ADP and integrate live ADP into your Power Automate tasks.
-
Access Live Zoho Creator 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 Zoho Creator through MCP integration.
-
Connect to LinkedIn from a Connection Pool in WebLogic
Use the CData JDBC Driver for LinkedIn to connect to LinkedIn from Web applications running on WebLogic.
-
Connect to Elorus Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Elorus using standard SQL.
-
Bind Live Wave Financial Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Wave Financial data
-
Publish Crystal Reports on Postmark Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Postmark.
-
Integrate Live Shippo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Shippo to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to SendGrid Data from a Connection Pool in JBoss
Integrate SendGrid into Java servlets: Use the Management Console in JBoss to install the SendGrid JDBC Driver.
-
Import and Visualize Cloudflare Data in Power View
Create data visualizations based on Cloudflare in Excel.
-
Build AI/ML Models with Live AlloyDB Data using Dataiku
Connect AlloyDB Data with Dataiku using the CData JDBC Driver for AlloyDB.
-
DataBind Charts to Amazon DynamoDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amazon DynamoDB from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Create HubSpot Dataflows on PowerBI.com
Connect to the CData Power BI Connector for HubSpot from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Access Live Microsoft OneDrive Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Microsoft OneDrive enables you to integrate Microsoft OneDrive into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for BigQuery in MicroStrategy Web
Connect to Google BigQuery in MicroStrategy Web using the CData Software JDBC Driver for BigQuery.
-
Build AI/ML Models with Live Missive Data using Dataiku
Connect Missive Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Billsby Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Billsby replication to Apache Kafka.
-
Integrating LangChain with Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Pivotal GreenPlum within automated workflows.
-
Connect to Microsoft Dataverse Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Dataverse (CDS) from HeidiSQL.
-
Visualize Bugsnag Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Bugsnag.
-
Analyze DocuSign Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of DocuSign and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating OpenCode Terminal with Google Ad Manager 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 XML Data in NetBeans
Connect to XML Files in NetBeans with the data source configuration wizard.
-
Work with Instantly Data in FoxPro
Load Instantly into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous SAP HANA Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP HANA replication to SQL Server.
-
Connect to and Visualize Live Oracle Eloqua Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle Eloqua.
-
Build Zuora-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Zuora to explore live Zuora Data in Claude Code to assist with building Zuora-powered applications.
-
Using the CData Software ODBC Driver for Campaigner in PyCharm
Connect to Campaigner as an ODBC data source in PyCharm using the CData Software ODBC Driver for Campaigner.
-
Getting Started with the CData Tableau Connector for Toggl
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Analyze LaunchDarkly Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for LaunchDarkly from Power Pivot. You will use the Table Import Wizard to load LaunchDarkly. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Gumloop with Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Elasticsearch within automated workflows.
-
Seamlessly Bring Odoo Data into Retool Using CData Connect AI
Integrate Odoo data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Intercom Data in Pentaho Data Integration
Build ETL pipelines based on Intercom in the Pentaho Data Integration tool.
-
Add Active Directory Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Active Directory with the Informatica Enterprise Data Catalog to classify and organize data.
-
Back Up PabblySubscriptions to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with PabblySubscriptions data.
-
Build PayPal-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for PayPal to explore live PayPal Data in GitHub Copilot to assist with building PayPal-powered applications.
-
How to Connect Oracle HCM Cloud 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 Oracle HCM Cloud data in real time using natural language.
-
Getting Started with the CData Python Connector for ElevenLabs
Learn to install and license the CData Python Connector
-
How to work with Google Campaign Manager 360 Data in Apache Spark using SQL
Access and process Google Campaign Manager 360 Data in Apache Spark using the CData Software JDBC Driver.
-
How to publish and share Short.io Data dashboards with Tableau Server
The CData ODBC driver for Short.io enables you integrate Short.io into Tableau dashboards.
-
Connect JobNimbus Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your JobNimbus using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Operational Reporting on Freshdesk Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Freshdesk.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Lakebase within intelligent workflows.
-
Connect to Jira Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Jira Data and connect to Atlassian Jira in Akorbi Digital RunMyProcess.
-
Access Shippo 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 Shippo.
-
A PostgreSQL Interface for CapsuleCRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the CapsuleCRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Dynamics 365 Business Central Data in Cognos Analytics
Use CData Connect AI to connect to Dynamics 365 Business Central Data from Cognos Analytics and analyze live Dynamics 365 Business Central.
-
Connect to Tanda Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Tanda using standard SQL.
-
Access TaxJar Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live TaxJar from HeidiSQL.
-
Use the CData Software JDBC Driver for OpenWeatherMap in MicroStrategy
Connect to OpenWeatherMap in MicroStrategy Developer using the CData Software JDBC Driver for OpenWeatherMap.
-
Bidirectional Access to BigQuery Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google BigQuery in Filemaker Pro for Mac or Windows.
-
Use the CData API Server to Access Excel Online Data in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft Excel Online in the Power Pivot business intelligence tool.
-
Analyze OData Services in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of OData and visualize OData in SAP Analytics Cloud.
-
Create Datasets from SQL Analysis Services in Domo Workbench and Build Visualizations of SQL Analysis Services Data in Domo
Use the CData Software ODBC Driver for SQL Analysis Services to create datasets from SQL Analysis Services in Domo Workbench and then build visualizations in the Domo service.
-
Manage Helpscout Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Helpscout.
-
Create SSAS Tabular Models from LinkedIn Ads Data
How to build a SQL Server Analysis Service Tabular Model from LinkedIn Ads using CData drivers.
-
Create Reports with Oracle Service Cloud Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Service Cloud.
-
Visualize Intercom Data in Tableau
The CData ODBC driver for Intercom enables you integrate Intercom into Tableau dashboards.
-
Analyze Phoenix Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Apache Phoenix and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to publish and share Certinia Data dashboards with Tableau Server
The CData ODBC driver for Certinia enables you integrate Certinia into Tableau dashboards.
-
How to Connect to Live Zoho Inventory Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Zoho Inventory through natural language.
-
Validate MariaDB Data with QuerySurge
Access and validate MariaDB in QuerySurge using the CData JDBC Driver.
-
Integrating GitHub Copilot CLI with Pivotal GreenPlum 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.
-
Replicate Multiple Impala Accounts via the CData Sync CLI
Replicate multiple Impala accounts to one or many databases.
-
Getting Started with the CData Connect AI Python SDK for Email
Install the CData Connect AI Python SDK to read and write live Email with standard DB-API 2.0 Python code.
-
Connecting Pipedream with Authorize.Net 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 Authorize.Net data in real time.
-
Create Email-Connected Business Apps in AppSheet
Connect to Email Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Email.
-
A PostgreSQL Interface for Workable Data using the CData ODBC Driver
Use the SQL Gateway and Workable ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live MySQL Data 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 MySQL for you.
-
Edit and Search External Salesforce Marketing Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Salesforce Marketing Cloud to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Salesforce Marketing Data objects that you can access from apps and the dashboard.
-
Replicate Multiple CSV Accounts
Replicate multiple CSV accounts to one or many databases.
-
Process & Analyze ADP Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ADP Data.
-
Connect to Live Zuora Data in MicroStrategy through CData Connect AI
Create a live connection to Zuora Data in CData Connect AI and connect to your Zuora from MicroStrategy.
-
Build Voice Agents in ElevenLabs with access to Live Acumatica Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Acumatica ERP.
-
Build Workday-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Workday.
-
How to Easily Query Apollo Data in OpenOffice Base
Connect to Apollo data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Basecamp using the Model Context Protocol.
-
Migrating data from NASA to Snowflake using CData SSIS Components.
Easily push NASA to Snowflake using the CData SSIS Tasks for NASA and Snowflake.
-
How to connect PolyBase to JobNimbus
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live JobNimbus.
-
Visualize Live Apollo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apollo using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Workday Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Workday and visualize live Workday in Infragistics Reveal.
-
Automated Continuous PayPal Replication to SQLite
Use CData Sync for automated, continuous, customizable PayPal replication to SQLite.
-
Analyze GetResponse Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for GetResponse from Power Pivot. You will use the Table Import Wizard to load GetResponse. You can visually build the import query or use any SQL supported by the driver.
-
Connect to and Query PayPal Data in QlikView over ODBC
Create data visualizations with PayPal in QlikView.
-
Automated Continuous ZendeskSell Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Apache Kafka.
-
Import Real-Time Klaviyo Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Klaviyo in ColdFusion.
-
Connect to Opsgenie in SpagoBI
Create reports featuring live Opsgenie in SpagoBI Studio. Host Opsgenie reports on SpagoBI Server.
-
How to Connect to Live Act-On Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Act-On through natural language.
-
Integrating Codex CLI with Paddle 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 Bannerbear JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Bannerbear.
-
DataBind Charts to Customer.io Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Customer.io from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Excel Spreadsheet Automation on Splunk Data with the QUERY Formula
Pull data from Splunk, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Pipeline CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to OneLake in Microsoft Fabric.
-
Use CData Connect AI to Access Sybase IQ Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Sybase IQ in the Power Pivot business intelligence tool.
-
Connect to Phoenix Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apache Phoenix in the Denodo Virtual DataPort Administrator.
-
Build Tally-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Tally ERP and build Tally-connected web apps with Axios.
-
How to Query SendGrid Data in MySQL Workbench
Execute MySQL queries against live SendGrid from MySQL Workbench.