CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Twilio Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Twilio replication to delimited files (CSV/TSV).
-
Integrate Google's Antigravity Agent with Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Reckon Accounts Hosted data using the Model Context Protocol.
-
Analyze Humanity Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Humanity from Power Pivot. You will use the Table Import Wizard to load Humanity data. You can visually build the import query or use any SQL supported by the driver.
-
Deploy the ADO.NET Provider for Sentry on an SSRS Report Server
Connect to Sentry data 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.
-
Write a Simple Go Application to work with QuickBooks Online Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to QuickBooks Online data.
-
Automated Continuous SpaceX Replication to Snowflake
Use CData Sync for automated, continuous, customizable SpaceX replication to Snowflake.
-
Build Apps with Live Oracle data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle data into the Adalo platform and build custom mobile and web applications with real-time Oracle data.
-
Build Apps with Live Box data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Box data into the Adalo platform and build custom mobile and web applications with real-time Box data.
-
Create Datasets from FHIR in Domo Workbench and Build Visualizations of FHIR Data in Domo
Use the CData Software ODBC Driver for FHIR to create datasets from FHIR data in Domo Workbench and then build visualizations in the Domo service.
-
Create a Data Access Object for PostgreSQL Data using JDBI
A brief overview of creating a SQL Object API for PostgreSQL data in JDBI.
-
Integrate OpenCode with Live OData Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live OData services from within your AI coding agent.
-
Automate Autopilot Data Replication to Couchbase
Use CData Sync to Customize and automate Autopilot data replication to Couchbase.
-
Configure the CData JDBC Driver for Bullhorn CRM in a Connection Pool in Tomcat
Connect to Bullhorn CRM data from a connection pool in Tomcat.
-
Use Claude to Talk to Your Dynamics 365 Business Central 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 Dynamics 365 Business Central data for you.
-
Extending QuickBooks Desktop Reporting
The CData ADO.NET Provider for QuickBooks Desktop make it easy for you to create new reports and customize existing ones. This article demonstrates how to create a new Profit and Loss Report. Using the ADO.NET provider, you can then retrieve it directly from Server Explorer in Visual Studio.
-
Integrate Google's Vertex AI Agent with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft OneDrive data within intelligent workflows.
-
Automated Continuous SpaceX Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SpaceX replication to Google Cloud SQL.
-
Automated Dynamics CRM Data Replication to Teradata
Use CData Sync to Customize and automate Dynamics CRM data replication to Teradata.
-
How to Connect to Live ShipStation 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 ShipStation data for you.
-
Azure Table Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Azure Table facts in real time.
-
Automated Continuous Trello Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Trello replication to Amazon S3.
-
Connect to Marketo from Asprova with CData Software ODBC Driver for Marketo
This article shows how to connect faster to Marketo data from Asprova.
-
Build a PostgreSQL Interface for Webex Data using the CData JDBC Driver
Use the Remoting features of the Webex JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Oracle Eloqua Replication to SingleStore
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to SingleStore.
-
Connect Reckon to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Reckon data using the CData Python MCP Server.
-
Connect and Visualize Live Zuora Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zuora data into the Databricks platform and create visualization dashboards with real-time Zuora data.
-
Build Voice Agents in ElevenLabs with access to Live Hive Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Hive data.
-
Build Data Flows from SQL Server to CouchDB through SSIS
Easily push SQL Server data to CouchDB using the CData SSIS Tasks for CouchDB.
-
Automated Continuous ZohoSubscriptions Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Google Cloud SQL.
-
How to Work with Authorize.Net Data in AWS Glue Jobs Using JDBC
Connect to Authorize.Net from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Apify Data in Talend Cloud Data Management Platform
Connect Apify Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Aircall with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Aircall with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Aircall data.
-
Automated Continuous DocuSign Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable DocuSign data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Factorial Replication to Vertica
Use CData Sync for automated, continuous, customizable Factorial replication to Vertica.
-
Analyze QuickBooks Online Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of QuickBooks Online data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate SAP Data in Pentaho Data Integration
Build ETL pipelines based on SAP data in the Pentaho Data Integration tool.
-
Analyze Google Ad Manager Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Ad Manager data in Microsoft R Open.
-
Integrating OpenCode with Zoom 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 Browserless Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Browserless from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Strava
Provide connectivity to Strava data through an SAP BusinessObjects universe.
-
Prepare, Blend, and Analyze OneNote Data in Alteryx Designer (Connect AI)
Build workflows to access live OneNote data for self-service data analytics.
-
Automated Continuous Aircall Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Aircall replication to Amazon S3.
-
How to Easily Query Jumpseller Data in OpenOffice Base
Connect to Jumpseller data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Grafana-Connected Applications in Appsmith
Connect to Grafana Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Grafana data.
-
How to Access Live IBM Cloud Object Storage Data in Power Automate Desktop via ODBC
The CData ODBC Driver for IBM Cloud Object Storage enables you to integrate IBM Cloud Object Storage data into workflows built using Microsoft Power Automate Desktop.
-
Connect to ZohoDesk Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZohoDesk as an External Source in Dremio.
-
Use the CData Software JDBC Driver for Azure DevOps in MicroStrategy
Connect to Azure DevOps data in MicroStrategy Developer using the CData Software JDBC Driver for Azure DevOps.
-
Automated Continuous SharePoint Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SharePoint replication to Azure SQL Database.
-
Bridge Google Spanner Connectivity with Apache NiFi
Access and process Google Spanner data in Apache NiFi using the CData JDBC Driver.
-
Automate Cosmos DB Data Replication to SAP HANA
Use CData Sync to customize and automate Cosmos DB data replication to SAP HANA.
-
Getting Started with the CData Excel Add-In for QuickBooks
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for QuickBooks.
-
How to connect to Google Forms Data with Squirrel SQL client
Connect to Google Forms data and execute queries in the Squirrel SQL Client.
-
DataBind Reply.io Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Reply.io data to a chart.
-
Access Office 365 Data from MySQL in Amazon QuickSight
Connect to Office 365 and build visualizations of Office 365 data using a MySQL Connection in Amazon QuickSight.
-
Connect to Rootly Data in RapidMiner
Integrate Rootly data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Azure Data Catalog in SpagoBI
Create reports featuring live Azure Data Catalog data in SpagoBI Studio. Host Azure Data Catalog reports on SpagoBI Server.
-
Automated Continuous NASA Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable NASA replication to PostgreSQL.
-
Analyze Azure DevOps Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Azure DevOps from Power Pivot. You will use the Table Import Wizard to load Azure DevOps data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Open WebUI with Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Impala data from within the chat interface.
-
Automate SurveyMonkey Data Replication to Azure Data Lake
Use CData Sync to customize and automate SurveyMonkey data replication to Azure Data Lake.
-
Bind Live Amazon DynamoDB Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Amazon DynamoDB data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to connect SharePoint with Office 365 Data through external lists
Provide Office 365 data to SharePoint users as an external list.
-
View Reports on Real-Time Cloudflare Data in Power BI Report Server
Use the CData ODBC Driver for Cloudflare to visualize Cloudflare data in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Highrise Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Highrise data from Node.js.
-
Build a Singer.io Tap for Blackbaud FE NXT With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Blackbaud FE NXT data using the CData Python Connector.
-
Connect to BenchmarkEmail Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for BenchmarkEmail Data and connect to BenchmarkEmail data in Akorbi Digital RunMyProcess.
-
Connect to Snowflake Data from a Connection Pool in JBoss
Integrate Snowflake data into Java servlets: Use the Management Console in JBoss to install the Snowflake JDBC Driver.
-
Access Live Sugar CRM 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 Sugar CRM data through MCP integration.
-
How to Connect Flowise AI Agents to Live Avro Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Avro data without replication.
-
How to Connect DBeaver to SAP BusinessObjects BI via a JDBC Driver
Manage SAP BusinessObjects BI data with visual tools in DBeaver like the query browser.
-
Automated Continuous PostgreSQL Replication to Oracle
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Oracle.
-
Build Charts with ADP Data in Clear Analytics
Create dynamic charts and perform analytics based on ADP data in Clear Analytics.
-
Operational Reporting on ZohoInvoice Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ZohoInvoice data.
-
Connect Keap to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Keap with IBM WebSphere for seamless data integration and connectivity.
-
Connect to SAP SuccessFactors Data in DBeaver
Use the CData ODBC Driver to connect to SAP SuccessFactors data in DBeaver.
-
Build Amazon DynamoDB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Amazon DynamoDB Data from Zoho Analytics and import live Amazon DynamoDB data.
-
Automated Continuous Mailgun Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Mailgun replication to Apache Cassandra.
-
Connect to Klaviyo Data from a Connection Pool in Jetty
The Klaviyo JDBC Driver supports connection pooling: This article shows how to connect faster to Klaviyo data from Web apps in Jetty.
-
Create Informatica Mappings From/To an ODBC Data Source for Slack
Create an ODBC connection to Slack in Informatica and browse and transfer Slack data.
-
How to load Azure Synapse data into Elasticsearch via Logstash
Introducing a simple method to load Azure Synapse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect SharePoint with Zoho Creator Data through external lists
Provide Zoho Creator data to SharePoint users as an external list.
-
Use the CData Software JDBC Driver for SurveyMonkey in MicroStrategy Desktop
Connect to SurveyMonkey data in MicroStrategy Desktop using the CData Software JDBC Driver for SurveyMonkey.
-
Connect to MariaDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from MariaDB data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Visualizations of FTP Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of FTP data in Birst.
-
Integrating Antigravity CLI with Eventbrite data via CData CLI
Connect Eventbrite data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Oracle Eloqua Data from Crystal Reports
Use CData Connect AI to connect to and report on live Oracle Eloqua data from Crystal Reports.
-
Connect to Copper Data in Aqua Data Studio
Access Copper data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software JDBC Driver for Azure DevOps in MicroStrategy Web
Connect to Azure DevOps data in MicroStrategy Web using the CData Software JDBC Driver for Azure DevOps.
-
Replicate Exact Online Data to Multiple Databases
Replicate Exact Online data to disparate databases with a point-and-click configuration.
-
Connect to Cloudant Data in DBeaver
Use the CData ODBC Driver to connect to Cloudant data in DBeaver.
-
How to Connect to Live SharePoint Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SharePoint data for you.
-
Automated Continuous Marketo Replication to Oracle
Use CData Sync for automated, continuous, customizable Marketo replication to Oracle.
-
How to Connect to Live PolarTeamPro Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your PolarTeamPro data for you.
-
Integrating Cursor with Cloudant 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 Power BI Reports on Real-Time SAP Ariba Source Data
Use the CData ODBC Driver for SAP Ariba Source to visualize SAP Ariba Source data in Power BI Desktop.
-
Connect and Visualize Live CouchDB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live CouchDB data into the Databricks platform and create visualization dashboards with real-time CouchDB data.
-
Connect to Reply.io Data in Aqua Data Studio
Access Reply.io data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Open WebUI with Live Moosend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Moosend data from within the chat interface.
-
Automate Xero Data Replication to Azure Data Lake
Use CData Sync to customize and automate Xero data replication to Azure Data Lake.
-
Load Salesforce Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesforce data to a database.