CData Software - Knowledge Base
Recent Articles
-
Replicate GitLab Data in Heroku for Use in Salesforce Connect
Replicate GitLab to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use Microsoft Copilot Studio to talk to your MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your MYOB AccountRight for you.
-
Create Reports with Planio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Planio.
-
How to Query Google Calendar Data in MySQL Workbench
Execute MySQL queries against live Google Calendar from MySQL Workbench.
-
How to connect to Intercom Data from Spring Boot
Connect to Intercom in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Databricks Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Databricks replication to PostgreSQL.
-
Create Data Visualizations Based On Vertica Data in Mode
Use CData Connect AI to connect to Vertica Data from Mode and build visualizations using live
-
How to Build an ETL App for Wistia Data in Python with CData
Create ETL applications and real-time data pipelines for Wistia in Python with petl.
-
Connect to Reckon Data in HULFT Integrate
Connect to Reckon as a JDBC data source in HULFT Integrate
-
Access Azure DevOps 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 Azure DevOps.
-
Connect to Salesforce Data in Google Apps Script via Connect AI
Use CData Connect AI to access Salesforce & Force.com in Google Apps Script.
-
Automated Continuous Stripe Replication to MySQL
Use CData Sync for automated, continuous, customizable Stripe replication to MySQL.
-
Automated Continuous Autopilot Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Autopilot replication to Apache Kafka.
-
Build Apps with Live Greenhouse in Adalo using CData Connect AI
Use CData Connect AI to integrate live Greenhouse into the Adalo platform and build custom mobile and web applications with real-time Greenhouse.
-
Integrating OpenCode Terminal with Webflow 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 Adobe Analytics Data in AWS Glue Jobs Using JDBC
Connect to Adobe Analytics from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Live Insightly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Insightly using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Salesforce CRM Analytics Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Cohere
Provide connectivity to Cohere through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for SAS xpt in MicroStrategy Web
Connect to SAS XPORT in MicroStrategy Web using the CData Software JDBC Driver for SAS xpt.
-
Connect to Hive Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apache Hive in the Denodo Virtual DataPort Administrator.
-
Load BigCommerce Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load BigCommerce to a database.
-
Getting Started with the CData SSIS Components for Apollo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Apollo.
-
Viewing ZeroBounce Data in RAD Studio Data Explorer
How to view ZeroBounce in RAD Studio Data Explorer using the CData ODBC Driver for ZeroBounce.
-
Connect to Azure Data Lake Storage Data from HeidiSQL
Use CData Connect AI to connect to and query live Azure Data Lake Storage from HeidiSQL.
-
Connect to Trello Data in DBArtisan
Use wizards in DBArtisan to configure Trello as a data source.
-
Analyze Excel Online Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Excel Online and visualize live Microsoft Excel Online in Infragistics Reveal.
-
Automated Continuous Bannerbear Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Bannerbear replication to Apache Cassandra.
-
Automated Continuous Azure DevOps Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure DevOps replication to OneLake in Microsoft Fabric.
-
Query Grafana Data in DataGrip
Create a Data Source for Grafana in DataGrip and use SQL to query live Grafana.
-
Access Live ShipStation 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 ShipStation through MCP integration.
-
Establish a Live Connection with GitHub Data using Tableau Bridge
The CData ODBC Driver for GitHub enables you to integrate live GitHub into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to MySQL Data in Claris FileMaker Pro
Use the CData ODBC Driver for MySQL in FileMaker Pro to connect to MySQL and work with MySQL in your FileMaker applications.
-
Analyze Marketo Data in Looker
Use CData Connect AI to connect to Marketo Data from Looker and build custom apps using live Marketo.
-
Connect to SparkPost Data in DBeaver
Use the CData ODBC Driver to connect to SparkPost in DBeaver.
-
How to Query Adobe Experience Manager Data in MySQL Workbench
Execute MySQL queries against live Adobe Experience Manager from MySQL Workbench.
-
Access Live Azure Synapse 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 Azure Synapse through MCP integration.
-
Connect to ADP Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live ADP.
-
Connect to MySQL Data in RapidMiner
Integrate MySQL with standard components and data source configuration wizards in RapidMiner Studio.
-
Connecting Mastra with Exact Online 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 Exact Online, no replication required.
-
Integrate LibreChat with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Act-On from within the chat interface.
-
How to Use a Microsoft Access Database to Update Google Sheets Data in Real Time
Update Google Sheets data by creating a linked table in Microsoft Access with the CData Google Sheets ODBC Driver.
-
How to use SQLAlchemy ORM to access Discord Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Discord.
-
Query Perigon Data as a MySQL Database in Node.js
Execute MySQL queries against Perigon from Node.js.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for OData
Provide connectivity to OData through an SAP BusinessObjects universe.
-
How to Access Live Snowflake Data in Visual Studio Code via Cline
Run CData MCP Server for Snowflake on Windows Subsytem for Linux (WSL) and connect to live Snowflake from the Cline extension in Visual Studio Code.
-
Replicate Multiple SendGrid Accounts via the CData Sync CLI
Replicate multiple SendGrid accounts to one or many databases.
-
How to connect to Helpscout Data with Squirrel SQL client
Connect to Helpscout and execute queries in the Squirrel SQL Client.
-
Import Real-Time OneNote Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft OneNote in ColdFusion.
-
How to Connect to & Open Clio Data in Microsoft Excel
This article uses the CData ODBC driver for Clio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
A Performance Comparison of Drivers for Salesforce.com
An article comparing the read performance of CData Software Drivers for Salesforce with comparable drivers by other vendors.
-
Query BenchmarkEmail Data in DataGrip
Create a Data Source for BenchmarkEmail in DataGrip and use SQL to query live BenchmarkEmail.
-
Connect to Act CRM Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Act CRM in Airbyte.
-
Import and Visualize Pipeliner CRM Data in Power View
Create data visualizations based on Pipeliner CRM in Excel.
-
Build AI/ML Models with Live Productboard Data using Dataiku
Connect Productboard Data with Dataiku using the CData API Driver for JDBC.
-
Integrate with Salesloft Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Salesloft to a JSON file on disk.
-
Connect to Superchat Data in Ruby
Connect to Superchat in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build a Singer.io Tap for Planio With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Planio data using
-
Load Mouseflow Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Mouseflow to a database.
-
Replicate Multiple WooCommerce Accounts
Replicate multiple WooCommerce accounts to one or many databases.
-
Edit and Search External SAP Netweaver Gateway Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Netweaver Gateway to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Netweaver Gateway Data objects that you can access from apps and the dashboard.
-
Publish Reports with Oracle Eloqua Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Eloqua.
-
Create Data Visualizations in Cognos BI with MYOB AccountRight Data
Access MYOB AccountRight as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use Manus AI to Talk to Your PostgreSQL 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 PostgreSQL.
-
Automated Continuous Mailjet Replication to SQLite
Use CData Sync for automated, continuous, customizable Mailjet replication to SQLite.
-
Use JayDeBeApi to access MongoDB Data in Python
Use standard Python scripting and the development environment of your choice to access live MongoDB.
-
Access Live Paylocity Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Paylocity from your Excel spreadsheets.
-
Automated Continuous OnePageCrm Replication to Snowflake
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Snowflake.
-
Attio Reporting in OBIEE with the Attio JDBC Driver
Deploy the Attio JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build SAP BusinessObjects BI-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP BusinessObjects BI to explore live SAP BusinessObjects BI Data in GitHub Copilot to assist with building SAP BusinessObjects BI-powered applications.
-
Connect Discourse to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Discourse using the CData Python MCP Server.
-
Analyze SAP Hybris C4C Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Hybris C4C in Microsoft R Open.
-
Viewing Qualaroo Data in RAD Studio Data Explorer
How to view Qualaroo in RAD Studio Data Explorer using the CData ODBC Driver for Qualaroo.
-
How to work with Pipeline CRM Data in Apache Spark using SQL
Access and process Pipeline CRM Data in Apache Spark using the CData Software JDBC Driver.
-
Create Data Visualizations Based On Airtable Data in Mode
Use CData Connect AI to connect to Airtable Data from Mode and build visualizations using live
-
Connect to Raisers Edge NXT Data from PowerBuilder via ADO.NET
This article demonstrates how to access Raisers Edge NXT from Appeon PowerBuilder using the CData ADO.NET Provider for Raisers Edge NXT.
-
Automate Act CRM Data Replication to Couchbase
Use CData Sync to Customize and automate Act CRM replication to Couchbase.
-
Import Cosmos DB Data Using Azure Data Factory
Use CData Connect AI to connect to Cosmos DB Data from Azure Data Factory and import live Azure Cosmos DB.
-
Build Excel Online-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Excel Online to explore live Excel Online Data in Cursor to assist with building Excel Online-powered applications.
-
Automate GitLab Data Replication to Azure Data Lake
Use CData Sync to customize and automate GitLab replication to Azure Data Lake.
-
Visualize ElevenLabs Data in TIBCO Spotfire through ADO.NET
Integrate ElevenLabs into dashboards in TIBCO Spotfire.
-
Analyze Outreach.io Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Outreach.io and visualize live Outreach.io in Infragistics Reveal.
-
Use the CData Software JDBC Driver for LaunchDarkly in MicroStrategy Desktop
Connect to LaunchDarkly in MicroStrategy Desktop using the CData Software JDBC Driver for LaunchDarkly.
-
Prepare, Blend, and Analyze Adobe Analytics Data in Alteryx Designer (ODBC)
Build workflows to access live Adobe Analytics for self-service data analytics.
-
Access Live Epicor Kinetic Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Epicor Kinetic into the statistical analysis tools available in SAS JMP. This article shows how to use Epicor Kinetic in the Graph Builder and Query Builder.
-
Getting Started with the CData Python Connector for ZeroBounce
Learn to install and license the CData Python Connector
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Apache Spark SQL using the Model Context Protocol.
-
Query Oracle Eloqua Reporting Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle Eloqua Reporting entities in PHP by modeling them as objects.
-
Integrating Kiro CLI with FreeAgent 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 Twilio Data in Apache Spark using SQL
Access and process Twilio Data in Apache Spark using the CData Software JDBC Driver.
-
Query Quaderno Data in ColdFusion
Write standard ColdFusion data access code to connect to Quaderno.
-
Work with Microsoft Entra ID Data in FoxPro
Load Microsoft Entra ID into a FoxPro database. This article includes full code and a walk-through of the process.
-
DataBind Controls to Google Ads Data in Delphi
DataBind to Google Ads in Delphi with standard data access components and controls.
-
Create Datasets from SAP Concur in Domo Workbench and Build Visualizations of SAP Concur Data in Domo
Use the CData Software ODBC Driver for SAP Concur to create datasets from SAP Concur in Domo Workbench and then build visualizations in the Domo service.
-
Integrating LlamaIndex with Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Neo4J in real time.
-
How to Connect DBeaver to TaxJar via a JDBC Driver
Manage TaxJar with visual tools in DBeaver like the query browser.
-
Integrate Google Search Results into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Search and integrate live Google Search into your Power Automate tasks.
-
Integrate Goose with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Azure Synapse from within the local AI agent.
-
How to Easily Query Greenhouse Data in OpenOffice Base
Connect to Greenhouse data in OpenOffice Base using the CData ODBC Driver for Greenhouse and generate reports with live data insights.
-
How to Create Power BI Visual Reports with Real-Time Klipfolio Data
Use CData Power BI Connectors to visualize Klipfolio in Power BI.