CData Software - Knowledge Base
Recent Articles
-
Add NetSuite Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for NetSuite with the Informatica Enterprise Data Catalog to classify and organize data.
-
Model Dropbox Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dropbox, enabling the direct import of real-time Dropbox data.
-
Integrating Antigravity CLI with Microsoft Teams data via CData CLI
Connect Microsoft Teams data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Viewing Webex Data in RAD Studio Data Explorer
How to view Webex data in RAD Studio Data Explorer using the CData ODBC Driver for Webex.
-
Import Real-Time Acumatica Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Acumatica data in ColdFusion.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Demio
Provide connectivity to Demio data through an SAP BusinessObjects universe.
-
Connecting Agentforce with Jumpseller 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 Jumpseller data for you.
-
Integrate Oracle HCM Cloud with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle HCM Cloud with External Services.
-
Visualize Harvest Data in Tableau
The CData ODBC driver for Harvest enables you integrate Harvest data into Tableau dashboards.
-
Google Sheets Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Sheets facts in real time.
-
Build Semantic Layer Views for GetResponse Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for GetResponse data.
-
Use the CData Software ODBC Driver for Google Search in MicroStrategy
Connect to Google Search results in MicroStrategy Developer using the CData Software ODBC Driver for Google Search.
-
Connect to PagerDuty Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PagerDuty data using standard SQL.
-
Work with Live Twilio Data in Power Query
Use CData Connect AI to connect to Twilio data and work with live Twilio data in Microsoft Power Query.
-
Use Claude to Talk to Your IBM Informix 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 IBM Informix data for you.
-
Excel Spreadsheet Automation on HelloSign Data with the QUERY Formula
Pull data from HelloSign, automate spreadsheets, and more with the QUERY formula.
-
DataBind Controls to IBM Informix Data in C++Builder
DataBind to IBM Informix data in C++Builder with standard components and controls.
-
Connect to Cassandra from Asprova with CData Software ODBC Driver for Cassandra
This article shows how to connect faster to Cassandra data from Asprova.
-
Link Freshteam with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Freshteam data in Filemaker Pro for Mac or Windows.
-
Rapidly Develop Freshsales-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 Freshsales.
-
Connect to Google Tasks Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Tasks data in the Denodo Virtual DataPort Administrator.
-
Use the CData Software JDBC Driver for Productboard in MicroStrategy
Connect to Productboard data in MicroStrategy Developer using the CData Software JDBC Driver for Productboard.
-
Build Visualizations of Presto Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Presto data in Birst.
-
Rapidly Develop Databricks-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 Databricks.
-
Use the CData Software ODBC Driver for SparkPost in SAS for Real-Time Reporting and Analytics
Connect to real-time SparkPost data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SparkPost.
-
How to Connect to Live MailerLite 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 MailerLite data for you.
-
Create Informatica Mappings From/To a JDBC Data Source for ElevenLabs
Create ElevenLabs data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Visualize Oracle Sales Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle Sales data in Python.
-
How to Connect Flowise AI Agents to Live Active Directory 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 Active Directory data without replication.
-
Integrate Zoho Books Data in the Pentaho Report Designer
Publish reports based on Zoho Books data in the Pentaho BI tool.
-
Analyze PayPal Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of PayPal data and visualize live PayPal data in Infragistics Reveal.
-
Automated Continuous Pipeliner CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to PostgreSQL.
-
Create Data Visualizations in Cognos BI with Xero Data
Access Xero data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect and Query Live SAP ByDesign Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP ByDesign data into Databricks and enable direct, live querying and analysis without replication.
-
Integrating OpenCode with LinkedIn Ads 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.
-
Import Real-Time Amazon S3 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Amazon S3 data in ColdFusion.
-
How to load Databricks data into Elasticsearch via Logstash
Introducing a simple method to load Databricks data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query SAP Data as a MySQL Database in Node.js
Execute MySQL queries against SAP data from Node.js.
-
Automated Continuous Eventbrite Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Eventbrite replication to PostgreSQL.
-
How to Connect DBeaver to Spark via a JDBC Driver
Manage Spark data with visual tools in DBeaver like the query browser.
-
Integrate LibreChat with Live SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SurveyMonkey data from within the chat interface.
-
Connect to Onfleet Data in RazorSQL
Connect to Onfleet from wizards and query Onfleet data from the GUI in the RazorSQL database management tool.
-
Access Live Apify 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 Apify data through MCP integration.
-
Create Reports with Databricks Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Databricks data.
-
Prepare, Blend, and Analyze Discord Data in Alteryx Designer (Connect AI)
Build workflows to access live Discord data for self-service data analytics.
-
Create Datasets from SAP in Domo Workbench and Build Visualizations of SAP Data in Domo
Use the CData Software ODBC Driver for SAP to create datasets from SAP data in Domo Workbench and then build visualizations in the Domo service.
-
Migrating data from CampaignMonitor to Databricks using CData SSIS Components.
Easily push CampaignMonitor data to Databricks using the CData SSIS Tasks for CampaignMonitor and Databricks.
-
Load Jira Assets Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Jira Assets data to a database.
-
Integrate Cline with Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP SuccessFactors data from within your IDE.
-
Integrate Strava Data in Pentaho Data Integration
Build ETL pipelines based on Strava data in the Pentaho Data Integration tool.
-
Automate AfterShip Data Replication to SAP HANA
Use CData Sync to customize and automate AfterShip data replication to SAP HANA.
-
Access Live Freshdesk 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 Freshdesk data through MCP integration.
-
How to connect to Chargebee Data from Spring Boot
Connect to Chargebee in a Spring Boot Application using the CData API Driver for JDBC
-
Access Live Campaigner Data in Excel 365 Online (Excel for the web)
Connect to Campaigner data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData ODBC Driver for IBM Cloud Object Storage from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for IBM Cloud Object Storage to connect to IBM Cloud Object Storage data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring IBM Cloud Object Storage data in Excel.
-
How to load Superchat data into Elasticsearch via Logstash
Introducing a simple method to load Superchat data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Cursor with Live MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MailChimp data from within the editor.
-
Connect to Asana Data in RapidMiner
Integrate Asana data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for MailChimp in MicroStrategy Web
Connect to MailChimp data in MicroStrategy Web using the CData Software ODBC Driver for MailChimp.
-
Integrate Retently with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Retently with External Services.
-
Integrate Power BI XMLA Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Power BI XMLA data and integrate live Power BI XMLA data into your Power Automate tasks.
-
Connecting Mastra with Quickbase 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 Quickbase data, no replication required.
-
Create YouTube Analytics-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to YouTube Analytics Data from Klipfolio and build custom visualizations using live YouTube Analytics data.
-
Connect to Workable Data in Ruby
Connect to Workable data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Placid Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Placid data from Node.js.
-
Connect to Real-Time Phoenix Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Phoenix and Dataflow to import and use Phoenix data in Power Apps.
-
Import Freshdesk Data Using Azure Data Factory
Use CData Connect AI to connect to Freshdesk Data from Azure Data Factory and import live Freshdesk data.
-
Design BIRT Reports on JotForm Data
Provide current JotForm data to your embedded analytics.
-
Automated Continuous Oracle HCM Cloud Replication to SingleStore
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to SingleStore.
-
Connect to TaxJar Data in Jaspersoft Studio
Execute SQL to remote TaxJar data in Jaspersoft Studio.
-
Automate ActiveCampaign Data Replication to SAP HANA
Use CData Sync to customize and automate ActiveCampaign data replication to SAP HANA.
-
Use the CData Software ODBC Driver for Pushbullet in MicroStrategy
Connect to Pushbullet data in MicroStrategy Developer using the CData Software ODBC Driver for Pushbullet.
-
Connect to ConstantContact Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ConstantContact data using standard SQL.
-
Access Live QuickBooks Online Data in TIBCO Data Virtualization
Use the QuickBooks Online Tibco DV Adapter to create a QuickBooks Online data data source in TIBCO Data Virtualization Studio and gain access to live QuickBooks Online data from your TDV Server.
-
Import Real-Time ZohoSubscriptions Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ZohoSubscriptions data in ColdFusion.
-
Create Data Visualizations in Cognos BI with Elasticsearch Data
Access Elasticsearch data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Oracle Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle data.
-
Connect to Raisers Edge NXT Data in HULFT Integrate
Connect to Raisers Edge NXT as a JDBC data source in HULFT Integrate
-
Migrating data from Sugar CRM to Google BigQuery using CData SSIS Components.
Easily push Sugar CRM data to Google BigQuery using the CData SSIS Tasks for Sugar CRM and Google BigQuery.
-
Build Visualizations of LinkedIn Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of LinkedIn data in Birst.
-
Automated Continuous Miro Replication to Databricks
Use CData Sync for automated, continuous, customizable Miro replication to Databricks.
-
Automated Continuous Cosmos DB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Azure SQL Database.
-
Analyze Twilio Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Twilio data with the CData JDBC Driver for Twilio.
-
Migrating data from Oracle HCM Cloud to Databricks using CData SSIS Components.
Easily push Oracle HCM Cloud data to Databricks using the CData SSIS Tasks for Oracle HCM Cloud and Databricks.
-
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 Dash to Build to Web Apps on Excel Online Data
Create Python applications that use pandas and Dash to build Excel Online-connected web apps.
-
Use the CData ODBC Driver for Square from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Square to connect to Square data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Square data in Excel.
-
Design BIRT Reports on Kafka Data
Provide current Kafka data to your embedded analytics.
-
Configure the CData JDBC Driver for Salesforce Data 360 in a Connection Pool in Tomcat
Connect to Salesforce Data 360 data from a connection pool in Tomcat.
-
Visualize Zuora Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zuora data.
-
Integrate SAP BusinessObjects BI Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP BusinessObjects BI data and integrate live SAP BusinessObjects BI data into your Power Automate tasks.
-
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.
-
How to create Visio diagrams from LDAP Objects
Automatically update LDAP objects with the changes you make to Visio master shapes.
-
Elorus Reporting in OBIEE with the Elorus JDBC Driver
Deploy the Elorus JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating LlamaIndex with Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Airtable data in real time.
-
Work with Gorgias Data in FoxPro
Load Gorgias data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect Avro Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Avro data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish Reports with ConstantContact Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ConstantContact data.
-
Replicate Multiple AfterShip Accounts via the CData Sync CLI
Replicate multiple AfterShip accounts to one or many databases.
-
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.