CData Software - Knowledge Base
Recent Articles
-
Migrating data from ConvertAPI to Databricks using CData SSIS Components.
Easily push ConvertAPI 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 into TIBCO Spotfire.
-
Build a Simple VCL Application for ScrapingBee Data
How to build a simple VCL Application to view ScrapingBee in RAD Studio using the CData ODBC Driver for ScrapingBee.
-
Connect to PagerDuty in SpagoBI
Create reports featuring live PagerDuty in SpagoBI Studio. Host PagerDuty reports on SpagoBI Server.
-
How to integrate Lakebase with Apache Airflow
Access and process Lakebase in Apache Airflow using the CData JDBC Driver.
-
Query Discord Data as a MySQL Database in Node.js
Execute MySQL queries against Discord from Node.js.
-
How to integrate ActiveCampaign with Apache Airflow
Access and process ActiveCampaign 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.
-
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 in Power BI Desktop.
-
Integrating Antigravity CLI with PhantomBuster via CData CLI
Connect PhantomBuster 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 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.
-
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 in LINQPad.
-
Create a Data Access Object for Productboard Data using JDBI
A brief overview of creating a SQL Object API for Productboard in JDBI.
-
Access Live Outreach.io Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Outreach.io into the statistical analysis tools available in SAS JMP. This article shows how to use Outreach.io in the Graph Builder and Query Builder.
-
Connect to Amazon S3 Data in NetBeans
Connect to Amazon S3 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 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 and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Kintone Data in RapidMiner
Integrate Kintone 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 Accounting.
-
Build AI/ML Models with Live ChargeOver Data using Dataiku
Connect ChargeOver Data with Dataiku using the CData API Driver for JDBC.
-
How to Query Live Square Data in Claude Desktop
Connect to and query live Square Data in Claude Desktop using CData MCP Server.
-
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 for you.
-
Integrating Codex CLI with SAP Concur 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 Business ByDesign 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 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 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 into the statistical analysis tools available in SAS JMP. This article shows how to use SAP HANA XS Advanced 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 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 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. 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 from HeidiSQL.
-
Build Dashboards with Moosend Data in DBxtra
Create dynamic dashboards and perform analytics based on Moosend in DBxtra.
-
How to Connect DBeaver to Bugsnag via a JDBC Driver
Manage Bugsnag with visual tools in DBeaver like the query browser.
-
How to Create Power BI Visual Reports with Real-Time Pinecone Data
Use CData Power BI Connectors to visualize Pinecone 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 Microsoft Access 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.
-
Query FreeAgent Data as a MySQL Database in Node.js
Execute MySQL queries against FreeAgent 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 in Birst.
-
Migrating data from Mouseflow to Databricks using CData SSIS Components.
Easily push Mouseflow 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 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 (CDS) 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
-
DataBind Charts to Mailgun Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mailgun 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.
-
Build OneNote-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for OneNote to explore live OneNote Data in Claude Code to assist with building OneNote-powered applications.
-
Replicate SpaceX Data to Multiple Databases via the CData Sync CLI
Replicate SpaceX 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 IBM DB2.
-
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 for you.
-
Access Microsoft Dataverse Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dataverse (CDS) from HeidiSQL.
-
Validate LightSpeedRetail Data with QuerySurge
Access and validate LightSpeedRetail in QuerySurge using the CData JDBC Driver.
-
Build Automated Zoho Projects-Connected Workflows in Zapier
Use CData Connect AI to connect to live Zoho Projects 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, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
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 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 in MicroStrategy Desktop using the CData Software JDBC Driver for Discourse.
-
How to Access Live Bullhorn CRM Data in Visual Studio Code via Cline
Run CData MCP Server for Bullhorn CRM on Windows Subsytem for Linux (WSL) and connect to live Bullhorn CRM from the Cline extension in Visual Studio Code.
-
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 using a MySQL Connection in Amazon QuickSight.
-
Integrate with Salesforce Pardot Data in JReport Designer
Create charts and reports based on Salesforce Pardot in JReport Designer.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesforce Marketing
Provide connectivity to Salesforce Marketing Cloud through an SAP BusinessObjects universe.
-
Integrate Avalara AvaTax Data in the Pentaho Report Designer
Publish reports based on Avalara AvaTax in the Pentaho BI tool.
-
How to connect to ShipEngine Data with Squirrel SQL client
Connect to ShipEngine 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 Amazon Redshift 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.
-
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 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 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 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 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. Leverage the native support for ODBC in PHP.
-
Perform Batch Operations with Sage Cloud Accounting Data in Apache NiFi
Connect to Sage Business Cloud Accounting and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live Microsoft Dataverse Data in Coginiti Pro
Connect to and query live Microsoft Dataverse (CDS) 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 with Mendix to build apps using the CData JDBC Driver for Adobe Commerce.
-
Integrating OpenCode Terminal 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. Use connectivity to the live data to replicate CampaignMonitor to SQL Server.
-
Use the CData Software ODBC Driver for Kintone in SAS for Real-Time Reporting and Analytics
Connect to real-time Kintone 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 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 Apache Cassandra 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.
-
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.
-
Visualize Bugsnag Data in Sisense
Create an ElastiCube in Sisense app with access to Bugsnag.
-
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 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.
-
Automate Tasks in Power Automate Using the CData API Server
Automate HubSpot actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Build Dashboards with Invoiced Data in Dundas BI
Create dynamic dashboards and perform analytics based on Invoiced in Dundas BI.
-
How to connect to Redis Data with Squirrel SQL client
Connect to Redis and execute queries in the Squirrel SQL Client.
-
Viewing Moosend Data in RAD Studio Data Explorer
How to view Moosend in RAD Studio Data Explorer using the CData ODBC Driver for Moosend.
-
Build SQL Analysis Services Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SQL Analysis Services and build visualizations in Tableau Cloud.
-
Getting Started with the CData Excel Add-In for Calendly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Calendly.
-
Bridge CloudConvert Connectivity with Apache NiFi
Access and process CloudConvert in Apache NiFi using the CData JDBC Driver.