CData Software - Knowledge Base
Recent Articles
-
Connect to ZohoSubscriptions from Asprova with CData Software ODBC Driver for ZohoSubscriptions
This article shows how to connect faster to ZohoSubscriptions data from Asprova.
-
Replicate Multiple ZeroBounce Accounts
Replicate multiple ZeroBounce accounts to one or many databases.
-
Prepare, Blend, and Analyze Gong Data in Alteryx Designer (ODBC)
Build workflows to access live Gong data for self-service data analytics.
-
Connect to SAP Netweaver Gateway Data in HULFT Integrate
Connect to SAP Netweaver Gateway as a JDBC data source in HULFT Integrate
-
Use the CData ODBC Driver for Sentry from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sentry to connect to Sentry data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sentry data in Excel.
-
Integrate Cline with Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Planner data from within your IDE.
-
Access Live Notion Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Notion data through MCP integration.
-
Enable the Printify JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Printify data.
-
Connect to Excel Online Data in DBeaver
Use the CData ODBC Driver to connect to Excel Online data in DBeaver.
-
Automated Continuous ChargeOver Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ChargeOver replication to Apache Kafka.
-
Operational Reporting on Gumroad Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Gumroad data.
-
Integrate Theia IDE with Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SAP Concur data from within the development environment.
-
DataBind Controls to EmailOctopus Data in Delphi
DataBind to EmailOctopus data in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Simplesat in MicroStrategy Desktop
Connect to Simplesat data in MicroStrategy Desktop using the CData Software ODBC Driver for Simplesat.
-
Access Live Presto Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Presto data from your Excel spreadsheets.
-
How to load Bright Data data into Elasticsearch via Logstash
Introducing a simple method to load Bright Data data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze BambooHR Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze BambooHR data with the CData JDBC Driver for BambooHR.
-
How to Work with Demio Data in ETL Validator JDBC
Connect to Demio from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate SQL Analysis Services with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SQL Analysis Services with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SQL Analysis Services data.
-
Create Monday.com-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Monday.com Data from Klipfolio and build custom visualizations using live Monday.com data.
-
Create Facebook Ads Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Facebook Ads from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Cursor with Blackbaud FE NXT 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.
-
Access Live Discord Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Discord data from your Excel spreadsheets.
-
Create Datasets from Cloudant in Domo Workbench and Build Visualizations of Cloudant Data in Domo
Use the CData Software ODBC Driver for Cloudant to create datasets from Cloudant data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate GraphQL Data in Pentaho Data Integration
Build ETL pipelines based on GraphQL data in the Pentaho Data Integration tool.
-
Automated Continuous SAP ByDesign Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to MySQL.
-
How to Query Telegram Data in MySQL Workbench
Execute MySQL queries against live Telegram data from MySQL Workbench.
-
Visualize Billsby Data in Tableau
The CData ODBC driver for Billsby enables you integrate Billsby data into Tableau dashboards.
-
Bridge Sybase IQ Connectivity with Apache NiFi
Access and process Sybase IQ data in Apache NiFi using the CData JDBC Driver.
-
Build Semantic Layer Views for Avaza Data in APOS Live Data Gateway
Use the CData Connector for Avaza in APOS Live Data Gateway to build Semantic Layer Views for Avaza data.
-
Connect to Invoiced Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Invoiced data using standard SQL.
-
Create BigCommerce-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to BigCommerce Data from OutSystems and build custom enterprise apps using live BigCommerce data.
-
Build MVC Applications with Connectivity to Google Ads Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Ads from an ASP.NET MVC application.
-
Connect to Kintone Data in Google Apps Script via Connect AI
Use CData Connect AI to access Kintone data in Google Apps Script.
-
Connecting GenSpark with Klipfolio Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Klipfolio data without any replication or custom integration required.
-
How to Connect to Live Discord Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Discord data for you.
-
How to Connect to Live Epicor Kinetic Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Epicor Kinetic data through natural language.
-
Getting Started with the CData JDBC Driver for Superchat
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Superchat.
-
Interact with Live Apify Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Apify data.
-
Bind Live SurveyMonkey Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SurveyMonkey data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Xero Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Xero data through CData Connect AI using different applications and tools.
-
Build Charts with Mixpanel Data in Clear Analytics
Create dynamic charts and perform analytics based on Mixpanel data in Clear Analytics.
-
Prepare, Blend, and Analyze Moosend Data in Alteryx Designer (ODBC)
Build workflows to access live Moosend data for self-service data analytics.
-
Access Live Azure DevOps Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure DevOps data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Impala Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Impala data through MCP integration.
-
Automated Continuous ZeroBounce Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZeroBounce replication to Amazon S3.
-
Working with Act-On Data in LINQPad
Execute LINQ queries to Act-On data in LINQPad.
-
Access Live Email Data in AWS Lambda
Connect to live Email data in AWS Lambda using the CData JDBC Driver.
-
Analyze SAS xpt Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAS xpt data with the CData JDBC Driver for SAS xpt.
-
Publish Reports with Aha! Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Aha! data.
-
DataBind Controls to Asana Data in C++Builder
DataBind to Asana data in C++Builder with standard components and controls.
-
Publish Crystal Reports on Teradata Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Teradata data.
-
Object-Relational Mapping (ORM) with Moosend Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Moosend data into a Java-based ORM framework, Hibernate.
-
How to Connect to & Open Aweber Data in Microsoft Excel
This article uses the CData ODBC driver for Aweber to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access LinkedIn Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LinkedIn data from HeidiSQL.
-
Integrate Lakebase Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Lakebase data and integrate live Lakebase data into your Power Automate tasks.
-
Connect to SAP Ariba Procurement in SpagoBI
Create reports featuring live SAP Ariba Procurement data in SpagoBI Studio. Host SAP Ariba Procurement reports on SpagoBI Server.
-
How to create an RPA flow for SAP Ariba Source Data in UiPath Studio
Use the SAP Ariba Source ODBC Driver to create workflows that access real-time SAP Ariba Source data without any coding.
-
Build Visualizations of Redshift Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Redshift data in Birst.
-
Getting Started with the CData ADO.NET Provider for Jumpseller
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Connect to Live Impala Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Impala data for you.
-
Integrate Cline with Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Impala data from within your IDE.
-
Replicate Multiple GitHub Accounts
Replicate multiple GitHub accounts to one or many databases.
-
Rapidly Develop Codat-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 Codat.
-
How to Connect to & Open Sugar CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Sugar CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating GitHub Copilot with SAP HANA XS Advanced 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Square
Provide connectivity to Square data through an SAP BusinessObjects universe.
-
Integrating Codex with Highrise 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.
-
Use Dash to Build to Web Apps on Hacker News Data
Create Python applications that use pandas and Dash to build Hacker News-connected web apps.
-
Automated Continuous Oracle Replication to MongoDB
Use CData Sync for automated, continuous, customizable Oracle replication to MongoDB.
-
Replicate Keap Data in Heroku for Use in Salesforce Connect
Replicate Keap data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Visualize Outreach.io Data in TIBCO Spotfire through OData
Integrate Outreach.io data into dashboards in TIBCO Spotfire.
-
Connect to and Query Certinia Data in QlikView over ODBC
Create data visualizations with Certinia data in QlikView.
-
Integrating Codex with SAP Ariba Source 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.
-
Integrating GitHub Copilot with SharePoint Excel Services 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.
-
Link HDFS with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate HDFS data in Filemaker Pro for Mac or Windows.
-
Connect Landbot to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Landbot with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to & Open Reply.io Data in Microsoft Excel
This article uses the CData ODBC driver for Reply.io to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Add Landbot Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Landbot with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Authorize.Net Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Authorize.Net data replication to OneLake in Microsoft Fabric.
-
Automate ZohoSubscriptions Data Replication to SAP HANA
Use CData Sync to customize and automate ZohoSubscriptions data replication to SAP HANA.
-
Object-Relational Mapping (ORM) with BigCommerce Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to BigCommerce data into a Java-based ORM framework, Hibernate.
-
Design BIRT Reports on YouTube Analytics Data
Provide current YouTube Analytics data to your embedded analytics.
-
Getting Started with the CData Power BI Connector for PostgreSQL
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for PostgreSQL.
-
Integrate Theia IDE with Live ZohoMarketingHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live ZohoMarketingHub data from within the development environment.
-
Analyze Pinecone Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pinecone data in Microsoft R Open.
-
Use Grok to Talk to Your Dropbox 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 Dropbox data for you.
-
Integrating Claude Code CLI with Perplexity 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.
-
How to create an RPA flow for Chargebee Data in UiPath Studio
Use the Chargebee ODBC Driver to create workflows that access real-time Chargebee data without any coding.
-
Create Data Visualizations Based On Greenplum Data in Mode
Use CData Connect AI to connect to Greenplum Data from Mode and build visualizations using live Greenplum data.
-
Connect to NetSuite SuiteAnalytics Data in Google Apps Script via Connect AI
Use CData Connect AI to access NetSuite SuiteAnalytics data in Google Apps Script.
-
Access Live Okta Data in Coginiti Pro
Connect to and query live Okta data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
A PostgreSQL Interface for Perplexity Data using the CData ODBC Driver
Use the SQL Gateway and Perplexity ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Pipedrive Data in Aqua Data Studio
Access Pipedrive data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to integrate Metabase with Raisers Edge NXT Data
Use CData Connect AI to connect to live Raisers Edge NXT data and create an interactive dashboard in Metabase from Raisers Edge NXT data.
-
Connect to Browserless Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Browserless to connect to Browserless data and execute queries in PowerBuilder.
-
Access Live BigCommerce Data in TIBCO Data Virtualization
Use the BigCommerce Tibco DV Adapter to create a BigCommerce data data source in TIBCO Data Virtualization Studio and gain access to live BigCommerce data from your TDV Server.
-
How to Connect to & Open Paymo Data in Microsoft Excel
This article uses the CData ODBC driver for Paymo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous ChartMogul Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ChartMogul replication to Amazon S3.
-
Connect to Google Drive Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Drive data from HeidiSQL.