CData Software - Knowledge Base
Recent Articles
-
Connect to MYOB AccountRight from Asprova with CData Software ODBC Driver for MYOB AccountRight
This article shows how to connect faster to MYOB AccountRight data from Asprova.
-
Build Voice Agents in ElevenLabs with access to Live Sage Cloud Accounting Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sage Cloud Accounting data.
-
Query Google Sheets Data as a MySQL Database in Node.js
Execute MySQL queries against Google Sheets data from Node.js.
-
Connect to ADP Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ADP to connect to ADP data and execute queries in PowerBuilder.
-
Work with Live SAP SuccessFactors Data in Power Query
Use CData Connect AI to connect to SAP SuccessFactors data and work with live SAP SuccessFactors data in Microsoft Power Query.
-
How to work with Autopilot Data in Apache Spark using SQL
Access and process Autopilot Data in Apache Spark using the CData Software JDBC Driver.
-
Build Dynamics NAV-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Dynamics NAV Data from Zoho Analytics and import live Dynamics NAV data.
-
Connect to Live Egnyte Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Egnyte in CData Connect AI and connect to your Egnyte data from PostgreSQL.
-
Query Oracle Sales Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle Sales entities in PHP by modeling them as objects.
-
Integrating LangChain with Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Drive data within automated workflows.
-
How to create an RPA flow for Sage Intacct Data in UiPath Studio
Use the Sage Intacct ODBC Driver to create workflows that access real-time Sage Intacct data without any coding.
-
How to Use a Microsoft Access Database to Update Outreach.io Data in Real Time
Update Outreach.io data by creating a linked table in Microsoft Access with the CData Outreach.io ODBC Driver.
-
Replicate Eventbrite Data from PowerShell
Write a quick PowerShell script to query Eventbrite data. Use connectivity to the live data to replicate Eventbrite data to SQL Server.
-
Use Databricks Agent Bricks to Talk to Your Google Sheets Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Sheets data for you.
-
Create a Data Access Object for Outlook Data using JDBI
A brief overview of creating a SQL Object API for Outlook data in JDBI.
-
Integrate Google's Antigravity Agent with Live VWO Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live VWO data using the Model Context Protocol.
-
Integrate Live Vimeo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Vimeo data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Visualize SFTP Data in TIBCO Spotfire through OData
Integrate SFTP data into dashboards in TIBCO Spotfire.
-
Build Data Flows from FreeAgent to SQL Server using SSIS
Easily back up FreeAgent data to SQL Server using the SSIS components for FreeAgent.
-
Getting Started with the CData Python Connector for Coda
Learn to install and license the CData Python Connector and configure a connection to live Coda data.
-
Integrate Devin with Live Google Ad Manager Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Google Ad Manager data.
-
Integrate Dify with Live Freshdesk Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Freshdesk data.
-
Connect to Sage 300 from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sage 300 to connect to Sage 300 data from Web applications running on WebLogic.
-
Getting Started with the CData SSIS Components for Aircall
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Aircall.
-
How to Connect to Live Adobe Experience Manager Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Adobe Experience Manager data without replication.
-
Use the CData Software ODBC Driver for Egnyte in SAS for Real-Time Reporting and Analytics
Connect to real-time Egnyte data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Egnyte.
-
Build Automated Procore-Connected Workflows in Zapier
Use CData Connect AI to connect to live Procore data and build automated workflows in Zapier.
-
Integrate Slack with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Slack with External Services.
-
Rapidly Develop HelloSign-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 HelloSign.
-
Add Slack Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Slack with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Pipelines with Live Wistia Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Wistia from Google Cloud Data Fusion, enabling the integration of live Wistia data into the building and management of effective data pipelines.
-
Automated Continuous Egnyte Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Egnyte replication to Google BigQuery.
-
Integrating Kiro with Opsgenie 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 load Missive data into Elasticsearch via Logstash
Introducing a simple method to load Missive data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect and process Templated data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Templated data.
-
Integrate Live Google Search Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Google Search results from within the IDE.
-
Build an OLAP Cube in SSAS from Opsgenie Data
Establish a connection to Opsgenie data data from SQL Server Analysis Services, and use the Opsgenie Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Sybase IQ Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sybase IQ data from Node.js.
-
Query Live Blackbaud FE NXT Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Blackbaud FE NXT data directly from the development environment.
-
Connect to Zoho Creator from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoho Creator data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Use a Microsoft Access Database to Update WooCommerce Data in Real Time
Update WooCommerce data by creating a linked table in Microsoft Access with the CData WooCommerce ODBC Driver.
-
Replicate Multiple Excel Online Accounts via the CData Sync CLI
Replicate multiple Excel Online accounts to one or many databases.
-
How to Connect to Live Oracle Service Cloud Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Oracle Service Cloud data for you.
-
Integrating Kiro with Avro 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 Google Drive-Connected Nintex Workflows
Use CData Connect AI to connect to Google Drive Data from Nintex Workflow Cloud and build custom workflows using live Google Drive data.
-
Seamlessly Bring GitLab Data into Retool Using CData Connect AI
Integrate GitLab data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
SFTP Reporting in OBIEE with the SFTP JDBC Driver
Deploy the SFTP JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to SAP Ariba Source Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Ariba Source as an External Source in Dremio.
-
Connect to Typeform Data in HULFT Integrate
Connect to Typeform as a JDBC data source in HULFT Integrate
-
Analyze CouchDB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for CouchDB from Power Pivot. You will use the Table Import Wizard to load CouchDB data. You can visually build the import query or use any SQL supported by the driver.
-
Create ShipStation-Connected Business Apps in AppSheet
Connect to ShipStation Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ShipStation data.
-
Trigger SFTP IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SFTP with standard wizards in Logic Apps.
-
Integrate Live Dropbox Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Dropbox data to Blue Prism using the CData ODBC Driver for Dropbox to create automated workflows for repetitive business tasks.
-
Integrating Claude Code CLI with ADP 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.
-
Automated Continuous DB2 Replication to Oracle
Use CData Sync for automated, continuous, customizable DB2 replication to Oracle.
-
Build Visualizations of WooCommerce Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of WooCommerce data in Birst.
-
Microsoft Exchange Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Exchange data through CData Connect AI using different applications and tools.
-
Publish Reports with Splunk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Splunk data.
-
Object-Relational Mapping (ORM) with ZeroBounce 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 ZeroBounce data into a Java-based ORM framework, Hibernate.
-
Use Azure AI Foundry to Talk to Your IBM Informix 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 IBM Informix data for you.
-
Use Grok to Talk to Your Oracle Service Cloud 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 Oracle Service Cloud data for you.
-
Integrating Cursor with Drip 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.
-
Automated Continuous Humanity Replication to Oracle
Use CData Sync for automated, continuous, customizable Humanity replication to Oracle.
-
Build Azure Data Lake Storage-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Azure Data Lake Storage data and build web apps with connectivity to live Azure Data Lake Storage data.
-
Feed Adobe Experience Manager Data into FineReport
How to set Adobe Experience Manager data as a JDBC data source in FineReport.
-
Integrate Dynamics 365 Data in Pentaho Data Integration
Build ETL pipelines based on Dynamics 365 data in the Pentaho Data Integration tool.
-
Access Adobe Analytics Data from MySQL in PHP
Connect to Adobe Analytics through the standard MySQL libraries in PHP.
-
Analyze Gmail Data in Cognos Analytics
Use CData Connect AI to connect to Gmail Data from Cognos Analytics and analyze live Gmail data.
-
Visualize Live Freshteam Data in the Power BI Service
Use CData Connect AI to connect to live Freshteam data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze RSS Feeds in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of RSS feeds and visualize RSS feeds in SAP Analytics Cloud.
-
Connect to Active Directory Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Active Directory and the SQL Gateway to access Active Directory data from Google Apps Script.
-
How to connect and process SendPulse data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SendPulse data.
-
Use Dash to Build to Web Apps on Perplexity Data
Create Python applications that use pandas and Dash to build Perplexity-connected web apps.
-
Automated Continuous ServiceNow Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ServiceNow replication to Google Cloud SQL.
-
Import and Visualize eBay Data in Power View
Create data visualizations based on eBay data in Excel.
-
Integrate Live ShipStation Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ShipStation from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ShipStation data.
-
Connect to Real-Time Teamgate Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Teamgate data in Power Apps.
-
Getting Started with the CData Python Connector for Sage Cloud Accounting
Learn to install and license the CData Python Connector and configure a connection to live Sage Cloud Accounting data.
-
Integrate with Paymo Data in JReport Designer
Create charts and reports based on Paymo data in JReport Designer.
-
Create Data Visualizations Based On Sugar CRM Data in Mode
Use CData Connect AI to connect to Sugar CRM Data from Mode and build visualizations using live Sugar CRM data.
-
Connecting Mastra with Workday 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 Workday data, no replication required.
-
Use Agno to Talk to Your Slack 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 Slack data for you.
-
Connect to and Query CouchDB Data in QlikView over ODBC
Create data visualizations with CouchDB data in QlikView.
-
Natively Connect to CouchDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CouchDB data. Leverage the native support for ODBC in PHP.
-
Automate Postmark Data Replication to Azure Data Lake
Use CData Sync to customize and automate Postmark data replication to Azure Data Lake.
-
Integrate Live Guru Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Guru data and integrate live Guru data into apps built in Microsoft Power Apps.
-
Build Automated Workflows with Live Lakebase Data in Workato
Use CData Connect AI to connect to live Lakebase data and build automated workflows in Workato.
-
Connect Salesforce CRM Analytics Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Salesforce CRM Analytics data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData SSIS Components for Couchbase
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Couchbase.
-
Create Dashboards and Visualize Live Discord Data in Geckoboard
Use CData Connect AI to connect to live Discord data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to SAP HANA Data from PowerBuilder via JDBC
This article demonstrates how to access SAP HANA data from PowerBuilder using the SAP HANA JDBC Driver.
-
Connect to Azure Data Catalog Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Data Catalog data.
-
Use the CData Software ODBC Driver for Scrapfly in SAS for Real-Time Reporting and Analytics
Connect to real-time Scrapfly data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Scrapfly.
-
How to Access Live Amazon S3 Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Amazon S3 enables you to integrate Amazon S3 data into workflows built using Microsoft Power Automate Desktop.
-
How to Visualize Redshift Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Redshift data in Python.
-
Connect to TaxJar Data in RazorSQL
Connect to TaxJar from wizards and query TaxJar data from the GUI in the RazorSQL database management tool.
-
Build Automated Cloudant-Connected Workflows in Zapier
Use CData Connect AI to connect to live Cloudant data and build automated workflows in Zapier.
-
Add Bugsnag Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Bugsnag with the Informatica Enterprise Data Catalog to classify and organize data.
-
Visualize SingleStore Data in Tableau
The CData ODBC driver for SingleStore enables you integrate SingleStore data into Tableau dashboards.
-
Access Live Teradata 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 Teradata data through MCP integration.