CData Software - Knowledge Base
Recent Articles
-
Integrate Live Exact Online 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 Exact Online data from within the IDE.
-
Migrating data from Webex to Databricks using CData SSIS Components.
Easily push Webex data to Databricks using the CData SSIS Tasks for Webex and Databricks.
-
Access Parquet Data from MySQL in PHP
Connect to Parquet through the standard MySQL libraries in PHP.
-
Visualize Clockify Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Clockify data.
-
Integrating LangGraph with Cvent Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Cvent data within automated workflows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Superchat
Provide connectivity to Superchat data through an SAP BusinessObjects universe.
-
Connect to Sentry Data in Aqua Data Studio
Access Sentry data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Google's Vertex AI Agent with Live Xero 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 Xero data within intelligent workflows.
-
Design BIRT Reports on Authorize.Net Data
Provide current Authorize.Net data to your embedded analytics.
-
Integrating Claude Code CLI with Oracle Eloqua Reporting 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.
-
Bind Live Salesforce Marketing Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce Marketing data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Getting Started with the CData SSIS Components for Amazon S3
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Amazon S3.
-
Automated Continuous Mocean Replication to MySQL
Use CData Sync for automated, continuous, customizable Mocean replication to MySQL.
-
Use Agno to Talk to Your Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Discord data for you.
-
Connect to SparkPost Data in JRuby
Create a simple JRuby app with access to live SparkPost data.
-
Create Reports from Airtable Data in Looker Studio
Use CData Connect AI to gain access to live Airtable data and create custom reports in Looker Studio.
-
Visualize ZohoDesk Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoDesk data.
-
Working with Zoho Projects Data in LINQPad
Execute LINQ queries to Zoho Projects data in LINQPad.
-
Getting Started with the CData Tableau Connector for Copper
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Epicor Kinetic Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Apache Kafka.
-
Integrate Open WebUI with Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP SuccessFactors data from within the chat interface.
-
Natively Connect to SQL Server Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SQL Server data. Leverage the native support for ODBC in PHP.
-
Build Data Flows from SQL Server to IBM Informix through SSIS
Easily push SQL Server data to IBM Informix using the CData SSIS Tasks for IBM Informix.
-
Import Real-Time Mixpanel Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mixpanel data in ColdFusion.
-
Connect to Mailjet Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Mailjet data in the Denodo Virtual DataPort Administrator.
-
Extract, Transform, and Load ZohoDesk Data in Informatica PowerCenter
Create a simple Workflow for ZohoDesk data in Informatica PowerCenter.
-
Connect to Harvest Data in DBArtisan
Use wizards in DBArtisan to configure Harvest data as a data source.
-
Connect to Google Analytics Data from a Connection Pool in Jetty
The Google Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to Google Analytics data from Web apps in Jetty.
-
Integrating GitHub Copilot with Customer.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.
-
Connect to SAP Business Warehouse Data in CloverDX (formerly CloverETL)
Transfer SAP Business Warehouse data using the visual workflow in the CloverDX data integration tool.
-
Configure the CData JDBC Driver for Oracle Eloqua Reporting in a Connection Pool in Tomcat
Connect to Oracle Eloqua Reporting data from a connection pool in Tomcat.
-
LINQ to BigCommerce 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 BigCommerce Data Provider.
-
Publish Confluence-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Confluence data.
-
Connect to PostgreSQL Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PostgreSQL data.
-
Visualize Sybase IQ Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sybase IQ data.
-
How to create an RPA flow for Jodoo Data in UiPath Studio
Use the Jodoo ODBC Driver to create workflows that access real-time Jodoo data without any coding.
-
Integrate IBM Informix Data into Power Automate Desktop using CData Connect
CData Connect for IBM Informix Data enables you to integrate IBM Informix data into workflows built using Microsoft Power Automate Desktop.
-
How to use SQLAlchemy ORM to access SparkPost Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SparkPost data.
-
Establish a Live Connection with Elorus Data using Tableau Bridge
The CData ODBC Driver for Elorus enables you to integrate live Elorus data into Tableau Cloud dashboards using the Tableau Bridge.
-
Publish CloudConvert-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live CloudConvert data.
-
Visualize Live Webex Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Webex data.
-
Import Real-Time Salesforce Pardot Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Salesforce Pardot data in ColdFusion.
-
Query FormSite Data in DataGrip
Create a Data Source for FormSite in DataGrip and use SQL to query live FormSite data.
-
Prepare, Blend, and Analyze PingOne Data in Alteryx Designer (Connect AI)
Build workflows to access live PingOne data for self-service data analytics.
-
Excel Spreadsheet Automation on Zendesk Data with the QUERY Formula
Pull data from Zendesk, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData JDBC Driver for Mistral AI
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mistral AI.
-
Integrating Gumloop with PolarTeamPro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on PolarTeamPro data within automated workflows.
-
Deploy the ADO.NET Provider for ConvertKit on an SSRS Report Server
Connect to ConvertKit 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.
-
Create Reports with Sugar CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sugar CRM data.
-
How to load PostgreSQL data into Elasticsearch via Logstash
Introducing a simple method to load PostgreSQL data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Epicor Kinetic Replication to SQLite
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to SQLite.
-
Back Up JotForm 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 JotForm data data.
-
Publish Reports with FormSite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FormSite data.
-
Automated Continuous SurveyMonkey Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Google Cloud SQL.
-
Connecting Pipedream with MongoDB 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 MongoDB data in real time.
-
Integrate Live Cloudflare 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 Cloudflare data from within the IDE.
-
Create Informatica Mappings From/To a JDBC Data Source for PhantomBuster
Create PhantomBuster data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect and process Airtable data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Airtable data.
-
Import Real-Time Pinecone Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Pinecone data in ColdFusion.
-
Create Data Visualizations Based On Omnisend Data in Mode
Use CData Connect AI to connect to Omnisend Data from Mode and build visualizations using live Omnisend data.
-
Getting Started with the CData Python Connector for AlloyDB
Learn to install and license the CData Python Connector and configure a connection to live AlloyDB data.
-
Connect to Microsoft OneDrive Data in RazorSQL
Connect to Microsoft OneDrive from wizards and query Microsoft OneDrive data from the GUI in the RazorSQL database management tool.
-
Integrate Landbot Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Landbot data from Informatica Cloud.
-
Create a Data Access Object for SAS Data Sets Data using JDBI
A brief overview of creating a SQL Object API for SAS Data Sets data in JDBI.
-
How to use SQLAlchemy ORM to access Unbounce Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Unbounce data.
-
Access NASA Data from MySQL in Amazon QuickSight
Connect to NASA and build visualizations of NASA data using a MySQL Connection in Amazon QuickSight.
-
ETL SharePoint in Oracle Data Integrator
This article shows how to transfer SharePoint data into a data warehouse using Oracle Data Integrator.
-
Write a Simple Go Application to work with LinkedIn Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LinkedIn data.
-
Visualize Hubstaff Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Hubstaff data.
-
Integrate Cline with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Campaign Manager 360 data from within your IDE.
-
SAP Hybris C4C Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Hybris C4C facts in real time.
-
How to Connect to & Open Insightly Data in Microsoft Excel
This article uses the CData ODBC driver for Insightly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous SAP Ariba Procurement Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Apache Kafka.
-
Integrating Dataiku with ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ZohoExpense data.
-
Connecting Moonlit Workflow with Klaviyo Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Klaviyo data in real time.
-
Integrating Dataiku with SFTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SFTP data.
-
Create Amazon DynamoDB-Connected Dashboards in Grafana
Connect to Amazon DynamoDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Amazon DynamoDB data.
-
Connect to Azure Data Catalog Data from Crystal Reports
Use CData Connect AI to connect to and report on live Azure Data Catalog data from Crystal Reports.
-
Design BIRT Reports on JobNimbus Data
Provide current JobNimbus data to your embedded analytics.
-
Integrate Trae with Live Box Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Box data from within the AI-powered IDE.
-
View Reports on Real-Time ChargeOver Data in Power BI Report Server
Use the CData ODBC Driver for ChargeOver to visualize ChargeOver data in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Live Guru Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Guru data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Salesloft Data from HeidiSQL
Use CData Connect AI to connect to and query live Salesloft data from HeidiSQL.
-
Connect to SAP HANA Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP HANA data in Google Apps Script.
-
Perform Batch Operations with Salesloft Data in Apache NiFi
Connect to Salesloft data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Process & Analyze NASA Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live NASA Data.
-
Visualize Certinia Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Certinia data into TIBCO Spotfire.
-
Build Charts with Figshare Data in Clear Analytics
Create dynamic charts and perform analytics based on Figshare data in Clear Analytics.
-
Connecting Mastra with GetResponse 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 GetResponse data, no replication required.
-
Import Real-Time Retently Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Retently data in ColdFusion.
-
How to Connect to Live eBay Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your eBay data for you.
-
Moving Data from Oracle Service Cloud to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Oracle Service Cloud data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData Software JDBC Driver for Adobe Target in MicroStrategy
Connect to Adobe Target data in MicroStrategy Developer using the CData Software JDBC Driver for Adobe Target.
-
DataBind Controls to LightSpeedRetail Data in Delphi
DataBind to LightSpeedRetail data in Delphi with standard data access components and controls.
-
Integrate Live Facebook Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Facebook data to Blue Prism using the CData ODBC Driver for Facebook to create automated workflows for repetitive business tasks.
-
Model Guru Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Guru, enabling the direct import of real-time Guru data.
-
Connect to and Visualize Live Google Directory Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Directory data.
-
Feed Greenhouse Data into FineReport
How to set Greenhouse data as a JDBC data source in FineReport.
-
Enable the ConvertKit JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ConvertKit data.
-
Visualize WordPress Data in Tableau
The CData ODBC driver for WordPress enables you integrate WordPress data into Tableau dashboards.