CData Software - Knowledge Base
Recent Articles
-
Create Datasets from Square in Domo Workbench and Build Visualizations of Square Data in Domo
Use the CData Software ODBC Driver for Square to create datasets from Square in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Cline with Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Adobe Commerce from within your IDE.
-
Analyze Missive Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Missive and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build XML-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for XML to explore live XML Data in Cursor to assist with building XML-powered applications.
-
Publish Google Ads-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Ads.
-
Use Agno to Talk to Your Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Facebook for you.
-
Integrating Delighted Data in Talend Cloud Data Management Platform
Connect Delighted Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to connect to Marketo Data with Squirrel SQL client
Connect to Marketo and execute queries in the Squirrel SQL Client.
-
Build Apps with Live ZohoInvoice Data Using the Low-Code Development Platform of Mendix
Connect ZohoInvoice with Mendix to build apps using the CData API Driver for JDBC.
-
How to connect PolyBase to ZohoInvoice
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ZohoInvoice.
-
Connect to NetSuite Data from HeidiSQL
Use CData Connect AI to connect to and query live NetSuite CRM & ERP from HeidiSQL.
-
How to work with Mixpanel Data in Apache Spark using SQL
Access and process Mixpanel Data in Apache Spark using the CData Software JDBC Driver.
-
How to import ZarMoney Data into Apache Solr
Use the CData Software JDBC Driver for ZarMoney in Data Import Handler and create an automated import of ZarMoney to Apache Solr Enterprise Search platform.
-
Getting Started with the CData ODBC Driver for Onfleet
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Onfleet.
-
Natively Connect to Deel Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Deel. Leverage the native support for ODBC in PHP.
-
Create Google Drive Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Drive data access from reports, embedded analytics, and more.
-
Integrate Perigon with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Perigon with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Perigon.
-
Odoo Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Odoo ERP through CData Connect AI using different applications and tools.
-
Connect to Google Spanner Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Spanner from Crystal Reports.
-
A PostgreSQL Interface for Notion Data using the CData ODBC Driver
Use the SQL Gateway and Notion ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Microsoft Dataverse Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Dataverse (CDS) replication to OneLake in Microsoft Fabric.
-
Provide OData Services of Eventbrite Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Eventbrite by developing a WCF Service Application.
-
Natively Connect to Supabase Data in PHP
The CData ODBC driver for Supabase enables you to create PHP applications with connectivity to Supabase. Leverage the native support for ODBC in PHP.
-
Visualize Live CircleCI Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live CircleCI.
-
Seamlessly Bring Instagram Data into Retool Using CData Connect AI
Integrate Instagram data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use Grok to Talk to Your MailChimp 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 MailChimp for you.
-
Connect Cassandra Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Apache Cassandra using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Instagram Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Instagram using standard SQL.
-
Import Real-Time QuickBooks Time Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use QuickBooks Time in ColdFusion.
-
Integrate Typeform Data in Pentaho Data Integration
Build ETL pipelines based on Typeform in the Pentaho Data Integration tool.
-
Replicate Paymo Data to Multiple Databases
Replicate Paymo to disparate databases with a point-and-click configuration.
-
Automated Egnyte Data Replication to Teradata
Use CData Sync to Customize and automate Egnyte replication to Teradata.
-
Process & Analyze Eventbrite Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Eventbrite Data.
-
Create Informatica Mappings From/To a JDBC Data Source for Gong
Create Gong data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Certinia Data in TIBCO Spotfire through OData
Integrate Certinia into dashboards in TIBCO Spotfire.
-
Enable the Greenhouse JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Greenhouse.
-
How to Visualize Zendesk Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zendesk in Python.
-
How to Build an ETL App for Campaigner Data in Python with CData
Create ETL applications and real-time data pipelines for Campaigner in Python with petl.
-
Create Informatica Mappings From/To a JDBC Data Source for Ontraport
Create Ontraport data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Back Up Scrapfly to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Scrapfly data.
-
Integrating Gumloop with Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Search within automated workflows.
-
Integrating Dataiku with FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live FHIR.
-
Using the CData Software ODBC Driver for Google Contacts in PyCharm
Connect to Google Contacts as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Contacts.
-
Configure the CData JDBC Driver for Hubstaff in a Connection Pool in Tomcat
Connect to Hubstaff from a connection pool in Tomcat.
-
Connect Drift to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Drift using the CData Python MCP Server.
-
Publish Perplexity-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Perplexity.
-
Build Visualizations of Webflow Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Webflow in Birst.
-
Integrating OpenCode Terminal with ChartMogul 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 Work with Teamwork Data in ETL Validator JDBC
Connect to Teamwork from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Wrike Replication to Vertica
Use CData Sync for automated, continuous, customizable Wrike replication to Vertica.
-
Build Amazon Athena Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Amazon Athena and build visualizations in Tableau.
-
Automated Continuous Billsby Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Billsby replication to Google Cloud SQL.
-
Build Google Drive-Connected Apps in Choreo
Use CData Connect AI to connect to Google Drive Data from Choreo and build custom apps using live Google Drive.
-
Automated Continuous Wistia Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Wistia replication to IBM DB2.
-
Create JotForm Dataflows on PowerBI.com
Connect to the CData Power BI Connector for JotForm from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Smartsheet Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Smartsheet as an External Source in Dremio.
-
Connecting Moonlit Workflow with Cloudant Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your IBM Cloudant in real time.
-
Excel Spreadsheet Automation on Microsoft Dataverse Data with the QUERY Formula
Pull data from Microsoft Dataverse, automate spreadsheets, and more with the QUERY formula.
-
Edit and Search Telegram External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Telegram to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Telegram objects that you can access from apps and the dashboard.
-
Query Amazon DynamoDB Data in DataGrip
Create a Data Source for Amazon DynamoDB in DataGrip and use SQL to query live Amazon DynamoDB.
-
Excel Spreadsheet Automation on Templated Data with the QUERY Formula
Pull data from Templated, automate spreadsheets, and more with the QUERY formula.
-
Connect to SAP Concur Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Concur from HeidiSQL.
-
Stream Jira Assets Data into Apache Kafka Topics
Access and stream Jira Assets in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a Simple VCL Application for Gong Data
How to build a simple VCL Application to view Gong in RAD Studio using the CData ODBC Driver for Gong.
-
Edit and Search Google Sheets External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Sheets to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Sheets objects that you can access from apps and the dashboard.
-
Visualize Live Google Analytics Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Analytics using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Quickbase Data Replication to Teradata
Use CData Sync to Customize and automate Quickbase replication to Teradata.
-
Connect to Paylocity Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Paylocity in the Denodo Virtual DataPort Administrator.
-
Integrate with Act CRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Act CRM to a JSON file on disk.
-
How to Connect to Live QuickBooks Time 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 QuickBooks Time for you.
-
How to Seamlessly Import FreeAgent Data into IBM SPSS Modeler
Integrate FreeAgent data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build SAP Business Warehouse-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SAP Business Warehouse to explore live SAP Business Warehouse Data in Cursor to assist with building SAP Business Warehouse-powered applications.
-
Access Live Chargebee Data in AWS Lambda
Connect to live Chargebee in AWS Lambda using the CData JDBC Driver.
-
Create Dashboards and Visualize Live Sage Intacct Data in Geckoboard
Use CData Connect AI to connect to live Sage Intacct and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access HubDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live HubDB from HeidiSQL.
-
Integrate Real-Time Access to SAP Ariba Procurement in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Ariba Procurement in real time.
-
Create Reports from Epicor Kinetic Data in Looker Studio
Use CData Connect AI to gain access to live Epicor Kinetic and create custom reports in Looker Studio.
-
Connecting Mastra with Phoenix 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 Apache Phoenix, no replication required.
-
Scrapfly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Scrapfly facts in real time.
-
How to Work with Salesforce Data 360 Data in ETL Validator JDBC
Connect to Salesforce Data 360 from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate Wave Financial Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Wave Financial and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build SharePoint-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft SharePoint.
-
Build Power BI XMLA-Connected Apps in Choreo
Use CData Connect AI to connect to Power BI XMLA Data from Choreo and build custom apps using live Power BI XMLA.
-
Connect to Zoho Books Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Books and the SQL Gateway to access Zoho Books from Google Apps Script.
-
Build NetSuite SuiteAnalytics-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live NetSuite SuiteAnalytics.
-
Connect to Insightly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Insightly from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Zendesk-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Zendesk to explore live Zendesk Data in Claude Code to assist with building Zendesk-powered applications.
-
How to use SQLAlchemy ORM to access HubDB Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of HubDB.
-
Integrate Open WebUI with Live Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure DevOps from within the chat interface.
-
Extend Google Sheets with SQL Analysis Services Data
Make calls to SQL Analysis Services from Google Apps Script via the API Server.
-
Connect to Oracle Financials Cloud from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Financials Cloud, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to MYOB AccountRight Data in DBArtisan
Use wizards in DBArtisan to configure MYOB AccountRight as a data source.
-
Build Dashboards with Typeform Data in DBxtra
Create dynamic dashboards and perform analytics based on Typeform in DBxtra.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP HANA XS Advanced
Create SAP HANA XS Advanced data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Microsoft Planner Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Amazon S3.
-
Create Data Visualizations in Cognos BI with Highrise Data
Access Highrise CRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to QuickBooks Data in Claris FileMaker Pro
Use the CData ODBC Driver for QuickBooks in FileMaker Pro to connect to QuickBooks and work with QuickBooks Desktop in your FileMaker applications.
-
Integrating Cursor CLI with Redshift 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.
-
Getting Started with the CData Tableau Connector for Campaigner
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Analyze ServiceDesk Plus Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ServiceDesk Plus in Microsoft R Open.