CData Software - Knowledge Base
Recent Articles
-
Connect to Paymo Data from a Connection Pool in JBoss
Integrate Paymo data into Java servlets: Use the Management Console in JBoss to install the Paymo JDBC Driver.
-
Humanity Reporting in OBIEE with the Humanity JDBC Driver
Deploy the Humanity JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Codex with Scrapfly 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 Flowise AI Agents to Live XML 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 XML data without replication.
-
Access Bullhorn CRM Data from MySQL in Amazon QuickSight
Connect to Bullhorn CRM and build visualizations of Bullhorn CRM data using a MySQL Connection in Amazon QuickSight.
-
Build Automated Workflows with Live Gmail Data in Workato
Use CData Connect AI to connect to live Gmail data and build automated workflows in Workato.
-
Integrating Boomi Agentstudio with Discord Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Discord data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access AlloyDB Data from MySQL in Amazon QuickSight
Connect to AlloyDB and build visualizations of AlloyDB data using a MySQL Connection in Amazon QuickSight.
-
Build Dashboards with Parquet Data in DBxtra
Create dynamic dashboards and perform analytics based on Parquet data in DBxtra.
-
Connect to HDFS Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for HDFS data 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 data to a database.
-
Integrate ADP Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to ADP data and integrate live ADP data 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 data through MCP integration.
-
Connect to LinkedIn from a Connection Pool in WebLogic
Use the CData JDBC Driver for LinkedIn to connect to LinkedIn data 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 data 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 and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Publish Crystal Reports on Postmark Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Postmark data.
-
Integrate Live Shippo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Shippo data 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 data 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 data 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 data 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.
-
Replicate Factorial Data to Multiple Databases via the CData Sync CLI
Replicate Factorial data to disparate databases with a single configuration.
-
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 data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for BigQuery in MicroStrategy Web
Connect to BigQuery data 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 Greenplum data within automated workflows.
-
Connect to Microsoft Dataverse Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Dataverse data from HeidiSQL.
-
Visualize Bugsnag Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Bugsnag data.
-
Use Azure AI Foundry to Talk to Your Aweber 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 Aweber data for you.
-
Connect to Live ZohoMarketingHub Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ZohoMarketingHub in CData Connect AI and connect to your ZohoMarketingHub data from PostgreSQL.
-
Analyze DocuSign Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of DocuSign data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating OpenCode 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 data in NetBeans with the data source configuration wizard.
-
Work with Instantly Data in FoxPro
Load Instantly data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create AgileCRM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to AgileCRM Data from Klipfolio and build custom visualizations using live AgileCRM data.
-
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 data.
-
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.
-
Create PolarTeamPro-Connected Applications in Appsmith
Connect to PolarTeamPro Data via CData Connect AI in Appsmith and create custom business applications with real-time access to PolarTeamPro data.
-
Getting Started with the CData Tableau Connector for Toggl
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Query Anaplan Data as a SQL Server Database in Node.js
Execute SQL Server queries against Anaplan data from Node.js.
-
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 data. 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 data 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 data 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 data 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 data.
-
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 and configure a connection to live ElevenLabs data.
-
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 data into Tableau dashboards.
-
Connect JobNimbus Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your JobNimbus data 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 data.
-
Integrate Google's Vertex AI Agent with Live Lakebase 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 Lakebase data 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 Jira data 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 data.
-
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 data.
-
Connect to Tanda Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Tanda data using standard SQL.
-
Access TaxJar Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live TaxJar data from HeidiSQL.
-
Use the CData Software JDBC Driver for OpenWeatherMap in MicroStrategy
Connect to OpenWeatherMap data 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 BigQuery data in Filemaker Pro for Mac or Windows.
-
Analyze OData Services in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of OData services and visualize OData services 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 data 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 data 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 data.
-
Visualize Intercom Data in Tableau
The CData ODBC driver for Intercom enables you integrate Intercom data 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 Phoenix data 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 data 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 data through natural language.
-
Validate MariaDB Data with QuerySurge
Access and validate MariaDB data in QuerySurge using the CData JDBC Driver.
-
Integrating GitHub Copilot with Greenplum 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.
-
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 data 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 data.
-
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 data for you.
-
Edit and Search External Salesforce Marketing Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Salesforce Marketing data 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 data 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 data.
-
Build Workday-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Workday data.
-
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's Antigravity Agent with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Basecamp data using the Model Context Protocol.
-
Migrating data from NASA to Snowflake using CData SSIS Components.
Easily push NASA data 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 data.
-
Visualize Live Apollo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apollo data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
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 data. 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 data 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 data in ColdFusion.
-
Connect to Opsgenie in SpagoBI
Create reports featuring live Opsgenie data in SpagoBI Studio. Host Opsgenie reports on SpagoBI Server.