CData Software - Knowledge Base
Recent Articles
-
Build Testmonitor-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Testmonitor Data from Zoho Analytics and import live Testmonitor data.
-
Connecting GenSpark with Perplexity Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Perplexity data without any replication or custom integration required.
-
Create Data Visualizations in Cognos BI with Spotify Data
Access Spotify data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use Claude to Talk to Your Freshdesk 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 Freshdesk data for you.
-
Integrate with live Odoo Data in Jitterbit
Use CData Connect AI to connect to and integrate live Odoo data in Jitterbit.
-
How to Query Live Bitly Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Bitly data data in natural language using Python.
-
Edit and Search External Epicor Kinetic Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Epicor Kinetic data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Epicor Kinetic Data objects that you can access from apps and the dashboard.
-
Connect to ConstantContact Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ConstantContact data using standard SQL.
-
Configure the CData JDBC Driver for Greenplum in a Connection Pool in Tomcat
Connect to Greenplum data from a connection pool in Tomcat.
-
Access Coinbase 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 Coinbase data.
-
Moving Data from Parallel to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Parallel data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Raisers Edge NXT Data in HULFT Integrate
Connect to Raisers Edge NXT as a JDBC data source in HULFT Integrate
-
Connect Splunk Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Splunk data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData JDBC Driver for Figshare
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Figshare.
-
Integrate Open WebUI with Live Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Highrise data from within the chat interface.
-
Excel Spreadsheet Automation on Amazon S3 Data with the QUERY Formula
Pull data from Amazon S3, automate spreadsheets, and more with the QUERY formula.
-
Connect to HCL Domino from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from HCL Domino data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Replicate Multiple Freshservice Accounts
Replicate multiple Freshservice accounts to one or many databases.
-
Connect to and Query Teradata Data in QlikView over ODBC
Create data visualizations with Teradata data in QlikView.
-
Connecting Mastra with SAP SuccessFactors LMS Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAP SuccessFactors LMS data, no replication required.
-
Visualize LinkedIn Ads Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to LinkedIn Ads data.
-
How to load Nethunt data into Elasticsearch via Logstash
Introducing a simple method to load Nethunt data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for IBM Cloud Object Storage in SAS for Real-Time Reporting and Analytics
Connect to real-time IBM Cloud Object Storage data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for IBM Cloud Object Storage.
-
Analyze Salesloft Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesloft from Power Pivot. You will use the Table Import Wizard to load Salesloft data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Zoho Inventory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Google BigQuery.
-
Migrating data from eBay Analytics to Databricks using CData SSIS Components.
Easily push eBay Analytics data to Databricks using the CData SSIS Tasks for eBay Analytics and Databricks.
-
Connect ShipStation Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ShipStation data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Configure the CData JDBC Driver for Clockify in a Connection Pool in Tomcat
Connect to Clockify data from a connection pool in Tomcat.
-
Query SAP Business Warehouse Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Business Warehouse data from Node.js.
-
How to Connect Basecamp 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 Basecamp data in real time using natural language.
-
Publish Zoho Recruit-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoho Recruit data.
-
Connect Oracle to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Bullhorn CRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Bullhorn CRM data.
-
Link ZohoPeople with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZohoPeople data in Filemaker Pro for Mac or Windows.
-
How to create an RPA flow for FreshBooks Data in UiPath Studio
Use the FreshBooks ODBC Driver to create workflows that access real-time FreshBooks data without any coding.
-
Integrate Live Apify Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Apify from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Apify data.
-
Integrating Claude Code CLI with Paylocity 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.
-
DataBind CouchDB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for CouchDB with the DevExpress Windows Forms and Web controls to provide CouchDB data to a chart.
-
How to connect and process Microsoft Ads data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Ads data.
-
Analyze PolarTeamPro Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PolarTeamPro from Power Pivot. You will use the Table Import Wizard to load PolarTeamPro data. You can visually build the import query or use any SQL supported by the driver.
-
Analyze SAP Business Warehouse Data in Looker
Use CData Connect AI to connect to SAP Business Warehouse Data from Looker and build custom apps using live SAP Business Warehouse data.
-
Use Azure AI Foundry to Talk to Your Dynamics CRM 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 Dynamics CRM data for you.
-
DataBind Controls to Bright Data Data in C++Builder
DataBind to Bright Data data in C++Builder with standard components and controls.
-
Create SAP Ariba Source-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP Ariba Source Data from Klipfolio and build custom visualizations using live SAP Ariba Source data.
-
Load Clari Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Clari data to a database.
-
Create Reports from ConstantContact Data in Looker Studio
Use CData Connect AI to gain access to live ConstantContact data and create custom reports in Looker Studio.
-
Connect to Salesforce Pardot Data in CloverDX (formerly CloverETL)
Transfer Salesforce Pardot data using the visual workflow in the CloverDX data integration tool.
-
Connect to Zuora Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zuora data from Crystal Reports.
-
Access Facebook Ads Data from MySQL in PHP
Connect to Facebook Ads through the standard MySQL libraries in PHP.
-
Create Datasets from Apify in Domo Workbench and Build Visualizations of Apify Data in Domo
Use the CData Software ODBC Driver for Apify to create datasets from Apify data in Domo Workbench and then build visualizations in the Domo service.
-
How to integrate Acumatica with Apache Airflow
Access and process Acumatica data in Apache Airflow using the CData JDBC Driver.
-
Visualize Timely Data in Tableau
The CData ODBC driver for Timely enables you integrate Timely data into Tableau dashboards.
-
Use ChatGPT to Talk to Your Campaigner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Campaigner data for you.
-
Migrating data from Freshservice to Google BigQuery using CData SSIS Components.
Easily push Freshservice data to Google BigQuery using the CData SSIS Tasks for Freshservice and Google BigQuery.
-
How to Use a Microsoft Access Database to Update Salesforce CRM Analytics Data in Real Time
Update Salesforce CRM Analytics data by creating a linked table in Microsoft Access with the CData Salesforce CRM Analytics ODBC Driver.
-
Back Up FHIR data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for FHIR. In this article, we will employ an SSIS workflow to populate a database with FHIR data data.
-
Use Manus AI to Talk to Your IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on IBM Cloud Object Storage data.
-
Use Claude to Talk to Your Oracle Financials Cloud 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 Oracle Financials Cloud data for you.
-
Automated Continuous IBM Informix Replication to Oracle
Use CData Sync for automated, continuous, customizable IBM Informix replication to Oracle.
-
Connect to SageHR Data from PowerBuilder via ADO.NET
This article demonstrates how to access SageHR data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Informatica Mappings From/To an ODBC Data Source for ElevenLabs
Create an ODBC connection to ElevenLabs in Informatica and browse and transfer ElevenLabs data.
-
Build Apps with Live SAP Netweaver Gateway data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Netweaver Gateway data into the Adalo platform and build custom mobile and web applications with real-time SAP Netweaver Gateway data.
-
Manage MarkLogic Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MarkLogic.
-
How to connect to GetResponse Data from Spring Boot
Connect to GetResponse in a Spring Boot Application using the CData API Driver for JDBC
-
LINQ to Act-On Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Act-On Data Provider.
-
Connect to Strava Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Strava and the SQL Gateway to access Strava data from Google Apps Script.
-
Automated Continuous Perplexity Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Perplexity data replication to OneLake in Microsoft Fabric.
-
Analyze Redis Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Redis from Power Pivot. You will use the Table Import Wizard to load Redis data. You can visually build the import query or use any SQL supported by the driver.
-
How to integrate REST with Apache Airflow
Access and process REST data in Apache Airflow using the CData JDBC Driver.
-
Create Dashboards and Visualize Live ConstantContact Data in Geckoboard
Use CData Connect AI to connect to live ConstantContact data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Visualize GitHub Data in Sisense
Create an ElastiCube in Sisense app with access to GitHub data.
-
DataBind Controls to Pushbullet Data in Delphi
DataBind to Pushbullet data in Delphi with standard data access components and controls.
-
How to Connect to Live VWO Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your VWO data for you.
-
Access Live Active Directory Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Active Directory data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Wrike Data from PowerBuilder via JDBC
This article demonstrates how to access Wrike data from PowerBuilder using the Wrike JDBC Driver.
-
How to Work with Placid Data in ETL Validator JDBC
Connect to Placid from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind Controls to Apify Data in C++Builder
DataBind to Apify data in C++Builder with standard components and controls.
-
Build Dashboards with Jira Assets Data in DBxtra
Create dynamic dashboards and perform analytics based on Jira Assets data in DBxtra.
-
Use the CData Software ODBC Driver for Adobe Experience Manager in MicroStrategy Web
Connect to Adobe Experience Manager data in MicroStrategy Web using the CData Software ODBC Driver for Adobe Experience Manager.
-
Build Pipelines with Live Oracle Service Cloud Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle Service Cloud from Google Cloud Data Fusion, enabling the integration of live Oracle Service Cloud data into the building and management of effective data pipelines.
-
Import Real-Time YouTube Analytics Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use YouTube Analytics data in ColdFusion.
-
Visualize Live Google Spanner Data in the Power BI Service
Use CData Connect AI to connect to live Google Spanner data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
A PostgreSQL Interface for Amplitude Data using the CData ODBC Driver
Use the SQL Gateway and Amplitude ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Reports with Facebook Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Facebook data.
-
Build Apps with Live ZohoPeople data in Adalo using CData Connect AI
Use CData Connect AI to integrate live ZohoPeople data into the Adalo platform and build custom mobile and web applications with real-time ZohoPeople data.
-
Rapidly Develop ConvertKit-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by ConvertKit.
-
Access Bright Data Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Bright Data data from your Oracle system.
-
Smartsheet Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Smartsheet facts in real time.
-
ETL Greenplum in Oracle Data Integrator
This article shows how to transfer Greenplum data into a data warehouse using Oracle Data Integrator.
-
Access Oracle 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 Oracle data.
-
How to publish and share RSS Feeds dashboards with Tableau Server
The CData ODBC driver for RSS enables you integrate RSS feeds into Tableau dashboards.
-
Automated Continuous SAP Netweaver Gateway Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Databricks.
-
Getting Started with the CData SSIS Components for Spotify
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Spotify.
-
Integrating Boomi Agentstudio with Adobe Experience Manager Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Adobe Experience Manager data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Analyze IBM Informix Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze IBM Informix data with the CData JDBC Driver for IBM Informix.
-
Connect to Ontraport Data in CloverDX (formerly CloverETL)
Transfer Ontraport data using the visual workflow in the CloverDX data integration tool.
-
Automated Miro Data Replication to Teradata
Use CData Sync to Customize and automate Miro data replication to Teradata.
-
Integrating Gumloop with Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Phoenix data within automated workflows.
-
Integrating Gumloop with Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Ads data within automated workflows.
-
Excel Spreadsheet Automation on Google Ad Manager Data with the QUERY Formula
Pull data from Google Ad Manager, automate spreadsheets, and more with the QUERY formula.