CData Software - Knowledge Base
Recent Articles
-
Migrating data from ConvertAPI to Databricks using CData SSIS Components.
Easily push ConvertAPI data to Databricks using the CData SSIS Tasks for ConvertAPI and Databricks.
-
Visualize Freshsales 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 Freshsales data into TIBCO Spotfire.
-
Build a Simple VCL Application for ScrapingBee Data
How to build a simple VCL Application to view ScrapingBee data in RAD Studio using the CData ODBC Driver for ScrapingBee.
-
Connect to PagerDuty in SpagoBI
Create reports featuring live PagerDuty data in SpagoBI Studio. Host PagerDuty reports on SpagoBI Server.
-
How to integrate Lakebase with Apache Airflow
Access and process Lakebase data in Apache Airflow using the CData JDBC Driver.
-
Query Discord Data as a MySQL Database in Node.js
Execute MySQL queries against Discord data from Node.js.
-
How to integrate ActiveCampaign with Apache Airflow
Access and process ActiveCampaign data in Apache Airflow using the CData JDBC Driver.
-
How to Connect Sybase IQ 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 Sybase IQ data in real time using natural language.
-
Integrate Dify with Live Aweber Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Aweber data.
-
Create Informatica Mappings From/To a JDBC Data Source for Cvent
Create Cvent data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
LINQ to Sage 200 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 Sage 200 Data Provider.
-
Create Power BI Reports on Real-Time Telegram Data
Use the CData ODBC Driver for Telegram to visualize Telegram data in Power BI Desktop.
-
Connect to Grafana Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Grafana Data and connect to Grafana data in Akorbi Digital RunMyProcess.
-
Integrating Antigravity CLI with PhantomBuster data via CData CLI
Connect PhantomBuster data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Service Cloud
Provide connectivity to Oracle Service Cloud data through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To an ODBC Data Source for Mixpanel
Create an ODBC connection to Mixpanel in Informatica and browse and transfer Mixpanel data.
-
How to load Airtable data into Elasticsearch via Logstash
Introducing a simple method to load Airtable data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Working with Trello Data in LINQPad
Execute LINQ queries to Trello data in LINQPad.
-
Create a Data Access Object for Productboard Data using JDBI
A brief overview of creating a SQL Object API for Productboard data in JDBI.
-
Access Live Outreach.io Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Outreach.io data into the statistical analysis tools available in SAS JMP. This article shows how to use Outreach.io data in the Graph Builder and Query Builder.
-
Connect to Amazon S3 Data in NetBeans
Connect to Amazon S3 data in NetBeans with the data source configuration wizard.
-
Connecting Agentforce with Google Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Google Ads data for you.
-
Use the CData SSIS Components to Insert New or Update Existing SharePoint Excel Services Records from SQL Server
Easily push SQL Server data to SharePoint Excel Services using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SharePoint Excel Services or update existing records with data from a SQL Server database.
-
Visualize Live Zuora Data in the Power BI Service
Use CData Connect AI to connect to live Zuora data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Kintone Data in RapidMiner
Integrate Kintone data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Manus AI to Talk to Your Xero 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 Xero data.
-
Build AI/ML Models with Live ChargeOver Data using Dataiku
Connect ChargeOver Data with Dataiku using the CData API Driver for JDBC.
-
How to integrate Metabase with ZohoExpense Data
Use CData Connect AI to connect to live ZohoExpense data and create an interactive dashboard in Metabase from ZohoExpense data.
-
Connecting GenSpark with Reckon Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Reckon data without any replication or custom integration required.
-
Use Grok to Talk to Your Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Elasticsearch data for you.
-
Integrating Codex with SAP Concur 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 SAP ByDesign Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP ByDesign data from Node.js.
-
Getting Started with the CData SSIS Components for Chargebee
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Chargebee.
-
Replicate CockroachDB Data to Multiple Databases via the CData Sync CLI
Replicate CockroachDB data to disparate databases with a single configuration.
-
How to connect to BambooHR Data from Spring Boot
Connect to BambooHR in a Spring Boot Application using the CData API Driver for JDBC
-
How to Visualize Google Search Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Search results in Python.
-
Access Live SAP HANA XS Advanced Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP HANA XS Advanced data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP HANA XS Advanced data in the Graph Builder and Query Builder.
-
Connect Tickspot Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Tickspot data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
DataBind Controls to Zoho CRM Data in C++Builder
DataBind to Zoho CRM data in C++Builder with standard components and controls.
-
Getting Started with the CData ODBC Driver for Oracle
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Oracle.
-
Natively Connect to Billsby Data in PHP
The CData ODBC driver for Billsby enables you to create PHP applications with connectivity to Billsby data. Leverage the native support for ODBC in PHP.
-
Access Reckon Accounts Hosted Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Reckon Accounts Hosted data from HeidiSQL.
-
Build Dashboards with Moosend Data in DBxtra
Create dynamic dashboards and perform analytics based on Moosend data in DBxtra.
-
How to Connect DBeaver to Bugsnag via a JDBC Driver
Manage Bugsnag data with visual tools in DBeaver like the query browser.
-
How to Connect to Live QuickBooks Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your QuickBooks data for you.
-
How to Create Power BI Visual Reports with Real-Time Pinecone Data
Use CData Power BI Connectors to visualize Pinecone data in Power BI.
-
Use Biml to Build SSIS Tasks to Replicate Access Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Access data to SQL Server.
-
Publish Reports with Contentful Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Contentful data.
-
Query FreeAgent Data as a MySQL Database in Node.js
Execute MySQL queries against FreeAgent data from Node.js.
-
Build Visualizations of Jumpseller Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Jumpseller data in Birst.
-
Migrating data from Mouseflow to Databricks using CData SSIS Components.
Easily push Mouseflow data to Databricks using the CData SSIS Tasks for Mouseflow and Databricks.
-
Use the CData Software ODBC Driver for Toggl in MicroStrategy Web
Connect to Toggl data in MicroStrategy Web using the CData Software ODBC Driver for Toggl.
-
Building Dynamic Web Pages with Exact Online Data Using AngularJS
Create single-page applications with live connectivity to Exact Online using the CData API Server.
-
Feed Microsoft Dataverse Data into FineReport
How to set Microsoft Dataverse data as a JDBC data source in FineReport.
-
Bind Live Twitter Ads Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Twitter Ads data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
DataBind Charts to Mailgun Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mailgun 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 SpaceX Data to Multiple Databases via the CData Sync CLI
Replicate SpaceX data to disparate databases with a single configuration.
-
Automated Continuous CampaignMonitor Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Apache Cassandra.
-
Publish Reports with DB2 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date DB2 data.
-
How to Connect to Live Salesforce Pardot Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Salesforce Pardot data for you.
-
Access Microsoft Dataverse Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dataverse data from HeidiSQL.
-
Validate LightSpeedRetail Data with QuerySurge
Access and validate LightSpeedRetail data in QuerySurge using the CData JDBC Driver.
-
Analyze PolarTeamPro Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of PolarTeamPro data and visualize live PolarTeamPro data in Infragistics Reveal.
-
Build Automated Zoho Projects-Connected Workflows in Zapier
Use CData Connect AI to connect to live Zoho Projects data and build automated workflows in Zapier.
-
Connect to SAP HANA from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP HANA data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connecting GenSpark with xBase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to xBase data without any replication or custom integration required.
-
Getting Started with the CData SSIS Components for Tavily
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Tavily.
-
Build Apps with Live PhantomBuster Data Using the Low-Code Development Platform of Mendix
Connect PhantomBuster data with Mendix to build apps using the CData API Driver for JDBC.
-
Use the CData Software JDBC Driver for Discourse in MicroStrategy Desktop
Connect to Discourse data in MicroStrategy Desktop using the CData Software JDBC Driver for Discourse.
-
Use Dash to Build to Web Apps on Presto Data
Create Python applications that use pandas and Dash to build Presto-connected web apps.
-
Access ZeroBounce Data from MySQL in Amazon QuickSight
Connect to ZeroBounce and build visualizations of ZeroBounce data using a MySQL Connection in Amazon QuickSight.
-
Integrate with Salesforce Pardot Data in JReport Designer
Create charts and reports based on Salesforce Pardot data in JReport Designer.
-
Build ZohoPeople Visualizations in Tableau Cloud
Use CData Connect AI to connect to live ZohoPeople data and build visualizations in Tableau Cloud.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesforce Marketing
Provide connectivity to Salesforce Marketing data through an SAP BusinessObjects universe.
-
Integrate Avalara AvaTax Data in the Pentaho Report Designer
Publish reports based on Avalara AvaTax data in the Pentaho BI tool.
-
How to connect to ShipEngine Data with Squirrel SQL client
Connect to ShipEngine data and execute queries in the Squirrel SQL Client.
-
Provide OData Services of Redshift Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Redshift data by developing a WCF Service Application.
-
Publish Paylocity-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Paylocity data.
-
Optimizely Reporting in OBIEE with the Optimizely JDBC Driver
Deploy the Optimizely JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Claude Code with Slack Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Slack data within assisted coding and automated development workflows.
-
How to Access Live EnterpriseDB Data in Power Automate Desktop via ODBC
The CData ODBC Driver for EnterpriseDB enables you to integrate EnterpriseDB data into workflows built using Microsoft Power Automate Desktop.
-
SAP SuccessFactors Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP SuccessFactors data through CData Connect AI using different applications and tools.
-
Build Pipelines with Live Zendesk Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Zendesk from Google Cloud Data Fusion, enabling the integration of live Zendesk data into the building and management of effective data pipelines.
-
Natively Connect to NASA Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to NASA data. Leverage the native support for ODBC in PHP.
-
Perform Batch Operations with Sage Cloud Accounting Data in Apache NiFi
Connect to Sage Cloud Accounting data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build Pipelines with Live ShipEngine Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ShipEngine from Google Cloud Data Fusion, enabling the integration of live ShipEngine data into the building and management of effective data pipelines.
-
Access Live Microsoft Dataverse Data in Coginiti Pro
Connect to and query live Microsoft Dataverse data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Apps with Live Adobe Commerce Data Using the Low-Code Development Platform of Mendix
Connect Adobe Commerce data with Mendix to build apps using the CData JDBC Driver for Adobe Commerce.
-
Integrating OpenCode with Microsoft Planner 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 CampaignMonitor Data from PowerShell
Write a quick PowerShell script to query CampaignMonitor data. Use connectivity to the live data to replicate CampaignMonitor data to SQL Server.
-
Use the CData Software ODBC Driver for Kintone in SAS for Real-Time Reporting and Analytics
Connect to real-time Kintone data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Kintone.
-
Connect to Humanity Data from a Connection Pool in Jetty
The Humanity JDBC Driver supports connection pooling: This article shows how to connect faster to Humanity data from Web apps in Jetty.
-
Import Real-Time Cassandra Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Cassandra data in ColdFusion.
-
Build MVC Applications with Connectivity to Printful Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Printful from an ASP.NET MVC application.
-
Connect to Toggl Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Toggl data.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP Netweaver Gateway
Create an ODBC connection to SAP Netweaver Gateway in Informatica and browse and transfer SAP Netweaver Gateway data.
-
Visualize Bugsnag Data in Sisense
Create an ElastiCube in Sisense app with access to Bugsnag data.
-
Connecting Agentforce with Lakebase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Lakebase data for you.
-
How to work with HCL Domino Data in Apache Spark using SQL
Access and process HCL Domino Data in Apache Spark using the CData Software JDBC Driver.
-
Build Dashboards with Invoiced Data in Dundas BI
Create dynamic dashboards and perform analytics based on Invoiced data in Dundas BI.