CData Software - Knowledge Base
Recent Articles
-
DataBind Charts to Mocean Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mocean 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.
-
Use the CData Software JDBC Driver for ZeroBounce in MicroStrategy Desktop
Connect to ZeroBounce in MicroStrategy Desktop using the CData Software JDBC Driver for ZeroBounce.
-
Create Informatica Mappings From/To a JDBC Data Source for Azure Data Lake Storage
Create Azure Data Lake Storage data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Load Dropbox Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Dropbox to a database.
-
Bridge Everhour Connectivity with Apache NiFi
Access and process Everhour in Apache NiFi using the CData JDBC Driver.
-
Access Live Jira Assets Data in Coginiti Pro
Connect to and query live Jira Assets from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automate Pipeliner CRM Data Replication to Azure Synapse
Use CData Sync to customize and automate Pipeliner CRM replication to Azure Synapse.
-
Analyze FTP Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of FTP Servers and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
A PostgreSQL Interface for SurveyMonkey Data using the CData ODBC Driver
Use the SQL Gateway and SurveyMonkey ODBC Driver to create a PostgreSQL entry-point for data access.
-
Configure the CData JDBC Driver for Zuora in a Connection Pool in Tomcat
Connect to Zuora from a connection pool in Tomcat.
-
Build Semantic Layer Views for Impala Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Apache Impala.
-
Access Live Intercom Data in Coginiti Pro
Connect to and query live Intercom from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Databricks Data in TIBCO Spotfire through ADO.NET
Integrate Databricks into dashboards in TIBCO Spotfire.
-
Connect to Perplexity Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Perplexity as an External Source in Dremio.
-
How to connect PolyBase to Yelp
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Yelp.
-
Build an OLAP Cube in SSAS from MessageBird Data
Establish a connection to MessageBird data from SQL Server Analysis Services, and use the MessageBird Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous SAP Concur Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP Concur replication to Google Cloud SQL.
-
Connect to Retently Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Retently and work with Retently in your FileMaker application.
-
Create Reports with Cosmos DB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Cosmos DB.
-
Automated Continuous Jira Assets Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Jira Assets replication to Apache Cassandra.
-
Integrate Telegram with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Telegram with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Telegram.
-
Design BIRT Reports on RSS Feeds
Provide current RSS Feeds to your embedded analytics.
-
Import Greenplum Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Greenplum Data and provide access to live Pivotal GreenPlum for custom reports in the Power BI Service.
-
Replicate ShipEngine Data in Heroku for Use in Salesforce Connect
Replicate ShipEngine to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Gumroad Data in Pentaho Data Integration
Build ETL pipelines based on Gumroad in the Pentaho Data Integration tool.
-
Connect to Jira Data in JRuby
Create a simple JRuby app with access to live Atlassian Jira.
-
Connect Google Forms Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Forms using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Bidirectional Access to Procore Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Procore in Filemaker Pro for Mac or Windows.
-
Integrating Cursor CLI with HelloSign 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.
-
Integrate Open WebUI with Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live CSV/TSV Files from within the chat interface.
-
Build Visualizations of Zoho CRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho CRM in Birst.
-
Automated Continuous Azure Data Lake Storage Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to delimited files (CSV/TSV).
-
Integrating Dataiku with Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Redis.
-
Connect to LinkedIn Ads Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LinkedIn Ads using standard SQL.
-
Query Miro Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Miro from Node.js.
-
Access Datadog Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Datadog.
-
Analyze Act CRM Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Act CRM and visualize Act CRM in SAP Analytics Cloud.
-
Integrating Boomi Agentstudio with SAP BusinessObjects BI Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP BusinessObjects BI, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Working with Bullhorn CRM Data in LINQPad
Execute LINQ queries to Bullhorn CRM in LINQPad.
-
ETL Amplitude in Oracle Data Integrator
This article shows how to transfer Amplitude into a data warehouse using Oracle Data Integrator.
-
Access Ontraport Data from MySQL in Amazon QuickSight
Connect to Ontraport and build visualizations of Ontraport using a MySQL Connection in Amazon QuickSight.
-
Integrating LangChain with SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP Business ByDesign within automated workflows.
-
How to Import Data from MongoDB into Google Sheets
Import MongoDB into a Google spreadsheet that is automatically refreshed.
-
Use Claude to Talk to Your Okta 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 Okta for you.
-
Connect to Redis Data in Claris FileMaker Pro
Use the CData ODBC Driver for Redis in FileMaker Pro to connect to Redis and work with Redis in your FileMaker applications.
-
How to Work with OnePageCrm Data in ETL Validator JDBC
Connect to OnePageCrm from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Nethunt Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Nethunt replication to IBM DB2.
-
Analyze SAP HANA Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP HANA with the CData JDBC Driver for SAP HANA.
-
Viewing Parallel Data in RAD Studio Data Explorer
How to view Parallel in RAD Studio Data Explorer using the CData ODBC Driver for Parallel.
-
Integrating Claude Code CLI 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.
-
Connect to HelloSign Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for HelloSign in the Denodo Virtual DataPort Administrator.
-
Build Google Ad Manager-Connected Apps in Choreo
Use CData Connect AI to connect to Google Ad Manager Data from Choreo and build custom apps using live Google Ad Manager.
-
Automated Continuous Dotmailer Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Dotmailer replication to Azure SQL Database.
-
Use the CData Software JDBC Driver for Anaplan in MicroStrategy Desktop
Connect to Anaplan in MicroStrategy Desktop using the CData Software JDBC Driver for Anaplan.
-
Deploy the ADO.NET Provider for ZohoSubscriptions on an SSRS Report Server
Connect to ZohoSubscriptions 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.
-
How to Connect to Live Marketo 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 Marketo for you.
-
Access Live Impala Data in Coginiti Pro
Connect to and query live Apache Impala from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Build an ETL App for SAP Business One Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP Business One in Python with petl and the CData Connect AI Python SDK.
-
Build AlloyDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google AlloyDB.
-
How to Access Live xBase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for xBase enables you to integrate xBase into workflows built using Microsoft Power Automate Desktop.
-
Import and Visualize Avaza Data in Power View
Create data visualizations based on Avaza in Excel.
-
Access Guru Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Guru from HeidiSQL.
-
Connect to HDFS Data in JRuby
Create a simple JRuby app with access to live Apache HDFS.
-
Getting Started with the CData Power BI Connector for Amazon S3
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Amazon S3.
-
How to connect and process Greenhouse from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Greenhouse.
-
Connect to GetResponse Data in DBeaver
Use the CData ODBC Driver to connect to GetResponse in DBeaver.
-
Integrating Codex CLI with Oracle Financials Cloud 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 QuickBooks Time Data through ODBC in Node.js
Use node-odbc to execute SQL queries against QuickBooks Time from Node.js.
-
A Comparison of JDBC Drivers for BigQuery
A performance comparison of the CData JDBC Driver for Google BigQuery and the Google JDBC Driver for Google BigQuery (updated September 2019)
-
Replicate SharePoint Excel Services Data in Heroku for Use in Salesforce Connect
Replicate SharePoint Excel Services to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build an OLAP Cube in SSAS from Sage Cloud Accounting Data
Establish a connection to Sage Business Cloud Accounting data from SQL Server Analysis Services, and use the Sage Cloud Accounting Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create PagerDuty Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PagerDuty data access from reports, embedded analytics, and more.
-
Use Manus AI to Talk to Your Presto 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 Presto.
-
How to create AdRoll federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for AdRoll in MySQL .
-
Publish Reports with JobNimbus Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date JobNimbus.
-
How to Connect to & Open Deel Data in Microsoft Excel
This article uses the CData ODBC driver for Deel to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Twilio Data from AWS Glue
Use CData Connect AI to gain access to live Twilio from your AWS Glue jobs.
-
How to connect Amazon QuickSight to Dynamics CRM Data
Create a connection to Microsoft Dynamics CRM in CData Connect AI and insert Microsoft Dynamics CRM into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to SAP BusinessObjects BI Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP BusinessObjects BI to connect to SAP BusinessObjects BI and execute queries in PowerBuilder.
-
Automate Accelo Data Replication to SAP HANA
Use CData Sync to customize and automate Accelo replication to SAP HANA.
-
Automated Continuous RSS Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable RSS replication to Apache Cassandra.
-
Visualize CouchDB Data in TIBCO Spotfire through ADO.NET
Integrate Apache CouchDB into dashboards in TIBCO Spotfire.
-
Build Data Flows from SQL Server to Quickbase through SSIS
Easily push SQL Server data to Quickbase using the CData SSIS Tasks for Quickbase.
-
Use the CData Software ODBC Driver for Klipfolio in SAS for Real-Time Reporting and Analytics
Connect to real-time Klipfolio in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Klipfolio.
-
Integrate Live Scrapfly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Scrapfly to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Seamlessly Import Bugsnag Data into IBM SPSS Modeler
Integrate Bugsnag data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Process & Analyze Zoho Recruit Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoho Recruit Data.
-
How to Query Live Gong Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Gong data in natural language using Python.
-
Replicate Everhour Data to Multiple Databases via the CData Sync CLI
Replicate Everhour to disparate databases with a single configuration.
-
Access Google Ads Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Ads from HeidiSQL.
-
Integrating Microsoft Teams Data in Talend Cloud Data Management Platform
Connect Microsoft Teams Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Microsoft Teams.
-
Connect to Pipeliner CRM Data in HULFT Integrate
Connect to Pipeliner CRM as a JDBC data source in HULFT Integrate
-
Access Live Workable Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Workable into the statistical analysis tools available in SAS JMP. This article shows how to use Workable in the Graph Builder and Query Builder.
-
Build Semantic Layer Views for Zoho CRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zoho CRM.
-
Access Live MailChimp Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to MailChimp from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build a Simple VCL Application for Google Directory Data
How to build a simple VCL Application to view Google Directory in RAD Studio using the CData ODBC Driver for Google Directory.
-
How to Connect to Live Excel Online 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 Microsoft Excel Online for you.
-
Automate Adobe Analytics Data Replication to SAP HANA
Use CData Sync to customize and automate Adobe Analytics replication to SAP HANA.
-
Connect to Tavily Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Tavily and the SQL Gateway to access Tavily from Google Apps Script.
-
Integrating Codex CLI with Close 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.