CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Sugar CRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sugar CRM replication to SQL Server.
-
Connecting GenSpark with IBM Cloud Object Storage Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to IBM Cloud Object Storage data without any replication or custom integration required.
-
Use Agno to Talk to Your Tally 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 Tally data for you.
-
Connect Placid to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Placid with IBM WebSphere for seamless data integration and connectivity.
-
Connect SQL Server to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SQL Server with IBM WebSphere for seamless data integration and connectivity.
-
Integrating GitHub Copilot with BambooHR 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 import OneNote Data into Apache Solr
Use the CData Software JDBC Driver for OneNote in Data Import Handler and create an automated import of OneNote data to Apache Solr Enterprise Search platform.
-
Automated Continuous Coda Replication to Databricks
Use CData Sync for automated, continuous, customizable Coda replication to Databricks.
-
Getting Started with the CData ODBC Driver for HubDB
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for HubDB.
-
Build Google Directory Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Directory data and build visualizations in Tableau.
-
Getting Started with the CData Excel Add-In for Simplesat
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Simplesat.
-
Use the CData ODBC Driver for OneNote in Microsoft Power Query
You can use the CData OneNote ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import OneNote data into Microsoft Power Query.
-
Getting Started with the CData Power BI Connector for JotForm
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Query Live DB2 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live DB2 data data in natural language using Python.
-
Moving Data from Salesforce Marketing to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Salesforce Marketing data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect SharePoint with Jira Data through external lists
Provide Jira data to SharePoint users as an external list.
-
Access Live Suadeo Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Suadeo data from your Excel spreadsheets.
-
Build MessageBird-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MessageBird data and build web apps with connectivity to live MessageBird data.
-
Automated Continuous ZendeskSell Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ZendeskSell replication to PostgreSQL.
-
Connecting Mastra with SendPulse 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 SendPulse data, no replication required.
-
Automated Continuous Amplitude Replication to Oracle
Use CData Sync for automated, continuous, customizable Amplitude replication to Oracle.
-
Query Vault CRM Data as a MySQL Database in Node.js
Execute MySQL queries against Vault CRM data from Node.js.
-
Visualize Live SAS xpt Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAS xpt data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software JDBC Driver for Samanage in MicroStrategy Desktop
Connect to Samanage data in MicroStrategy Desktop using the CData Software JDBC Driver for Samanage.
-
Connect to FreshBooks Data in CloverDX (formerly CloverETL)
Transfer FreshBooks data using the visual workflow in the CloverDX data integration tool.
-
Connect to DocuSign Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for DocuSign to connect to DocuSign data and execute queries in PowerBuilder.
-
Deploy the ADO.NET Provider for Billsby on an SSRS Report Server
Connect to Billsby 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.
-
Use Grok to Talk to Your ZohoPeople 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 ZohoPeople data for you.
-
Connect to ZarMoney Data in RazorSQL
Connect to ZarMoney from wizards and query ZarMoney data from the GUI in the RazorSQL database management tool.
-
Connect to Sage Cloud Accounting Data from PowerBuilder via JDBC
This article demonstrates how to access Sage Cloud Accounting data from PowerBuilder using the Sage Cloud Accounting JDBC Driver.
-
Automated Continuous Campaigner Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Campaigner replication to Google Cloud SQL.
-
Connect to Notion from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Notion data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build AI Agents with Suadeo Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Suadeo data through CData Connect AI.
-
Connecting Mastra with Paylocity 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 Paylocity data, no replication required.
-
Import and Visualize Acumatica Data in Power View
Create data visualizations based on Acumatica data in Excel.
-
Connect Impala to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Impala data using the CData Python MCP Server.
-
Integrate Google's Antigravity Agent with Live Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Azure Table data using the Model Context Protocol.
-
Connect to and Visualize Live Vimeo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Vimeo data.
-
Use the CData Software ODBC Driver for Instantly in MicroStrategy Web
Connect to Instantly data in MicroStrategy Web using the CData Software ODBC Driver for Instantly.
-
Build a PostgreSQL Interface for Microsoft Exchange Data using the CData JDBC Driver
Use the Remoting features of the Microsoft Exchange JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Monday.com-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Monday.com Data and create custom apps in Bubble.
-
Integrating Gumloop with Mailjet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Mailjet data within automated workflows.
-
Automated Continuous SAP BusinessObjects BI Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Google BigQuery.
-
Build Mailjet Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Mailjet data and build visualizations in Tableau.
-
A PostgreSQL Interface for Sage 300 Data using the CData ODBC Driver
Use the SQL Gateway and Sage 300 ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Testmonitor Data from a Connection Pool in Jetty
The Testmonitor JDBC Driver supports connection pooling: This article shows how to connect faster to Testmonitor data from Web apps in Jetty.
-
Connect to and Visualize Live Wrike Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Wrike data.
-
RabbitMQ Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on RabbitMQ facts in real time.
-
Connect to Zoho CRM Data from HeidiSQL
Use CData Connect AI to connect to and query live Zoho CRM data from HeidiSQL.
-
Process & Analyze Front Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Front Data.
-
Connect to Email Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Email data.
-
DataBind Controls to Samanage Data in C++Builder
DataBind to Samanage data in C++Builder with standard components and controls.
-
Feed Microsoft Entra ID Data into FineReport
How to set Microsoft Entra ID data as a JDBC data source in FineReport.
-
Build Voice Agents in ElevenLabs with access to Live ZohoExpense Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ZohoExpense data.
-
Integrating Cursor with XML 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.
-
Use Microsoft Copilot Studio to talk to your Google Ad Manager 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 Google Ad Manager data for you.
-
Create Apps from LinkedIn Ads Data in Qlik Sense Cloud
Use CData Connect AI to connect to LinkedIn Ads Data and build apps from live LinkedIn Ads data in Qlik Sense Cloud.
-
Configure the CData JDBC Driver for Unbounce in a Connection Pool in Tomcat
Connect to Unbounce data from a connection pool in Tomcat.
-
Connect to Bitbucket Data in Aqua Data Studio
Access Bitbucket data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Boomi Agentstudio with MongoDB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MongoDB data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Load Google Calendar Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Calendar data to a database.
-
Manage SendInBlue Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SendInBlue.
-
Write a Simple Go Application to work with Toggl Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Toggl data.
-
PayPal Reporting in OBIEE with the PayPal JDBC Driver
Deploy the PayPal JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Deploy the ADO.NET Provider for Supabase on an SSRS Report Server
Connect to Supabase 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.
-
Build Semantic Layer Views for Postmark Data in APOS Live Data Gateway
Use the CData Connector for Postmark in APOS Live Data Gateway to build Semantic Layer Views for Postmark data.
-
How to import Guru Data into Apache Solr
Use the CData Software JDBC Driver for Guru in Data Import Handler and create an automated import of Guru data to Apache Solr Enterprise Search platform.
-
Use CData Connect AI to Access Facebook Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Facebook data in the Power Pivot business intelligence tool.
-
Model NetSuite SuiteAnalytics Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and NetSuite SuiteAnalytics, enabling the direct import of real-time NetSuite SuiteAnalytics data.
-
Import Microsoft Ads Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Microsoft Ads Data and provide access to live Microsoft Ads data for custom reports in the Power BI Service.
-
Use the CData Software JDBC Driver for ActiveCampaign in MicroStrategy
Connect to ActiveCampaign data in MicroStrategy Developer using the CData Software JDBC Driver for ActiveCampaign.
-
Build Agents in Relevance AI with Access to Live Salesforce Data 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Salesforce Data 360 data within intelligent agent workflows.
-
Build Semantic Layer Views for Pipeliner CRM Data in APOS Live Data Gateway
Use the CData Connector for Pipeliner CRM in APOS Live Data Gateway to build Semantic Layer Views for Pipeliner CRM data.
-
Integrating Claude Code CLI with Foursquare 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 LibreChat with Live Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Hive data from within the chat interface.
-
Query BigQuery Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume BigQuery entities in PHP by modeling them as objects.
-
Integrate Goose with Live AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live AlloyDB data from within the local AI agent.
-
Query SAS Data Sets Data in DataGrip
Create a Data Source for SAS Data Sets in DataGrip and use SQL to query live SAS Data Sets data.
-
How to Connect to Live ConstantContact Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your ConstantContact data for you.
-
Create Datasets from Zoho Projects in Domo Workbench and Build Visualizations of Zoho Projects Data in Domo
Use the CData Software ODBC Driver for Zoho Projects to create datasets from Zoho Projects data in Domo Workbench and then build visualizations in the Domo service.
-
Use Agno to Talk to Your HDFS 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 HDFS data for you.
-
How to integrate Printful with Apache Airflow
Access and process Printful data in Apache Airflow using the CData JDBC Driver.
-
ETL Freshteam in Oracle Data Integrator
This article shows how to transfer Freshteam data into a data warehouse using Oracle Data Integrator.
-
How to Connect to & Open MailerLite Data in Microsoft Excel
This article uses the CData ODBC driver for MailerLite to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live SparkPost Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SparkPost data from your Excel spreadsheets.
-
How to Seamlessly Import Google Cloud Storage Data into IBM SPSS Modeler
Integrate Google Cloud Storage data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Snapchat Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Google BigQuery.
-
Replicate Multiple Missive Accounts
Replicate multiple Missive accounts to one or many databases.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Jumpseller
Provide connectivity to Jumpseller data through an SAP BusinessObjects universe.
-
Use CData Connect AI to Access Zoom Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zoom data in the Power Pivot business intelligence tool.
-
Create Datasets from Cassandra in Domo Workbench and Build Visualizations of Cassandra Data in Domo
Use the CData Software ODBC Driver for Cassandra to create datasets from Cassandra data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Avalara AvaTax Data with Squirrel SQL client
Connect to Avalara AvaTax data and execute queries in the Squirrel SQL Client.
-
Feed Zoho Books Data into FineReport
How to set Zoho Books data as a JDBC data source in FineReport.
-
Validate Instagram Data with QuerySurge
Access and validate Instagram data in QuerySurge using the CData JDBC Driver.
-
Stream Aha! Data into Apache Kafka Topics
Access and stream Aha! data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Bitbucket from a Connection Pool in WebLogic
Use the CData JDBC Driver for Bitbucket to connect to Bitbucket data from Web applications running on WebLogic.
-
Visualize Qualaroo Data in Tableau
The CData ODBC driver for Qualaroo enables you integrate Qualaroo data into Tableau dashboards.
-
Connect to Azure Data Catalog from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure Data Catalog to connect to Azure Data Catalog data from Web applications running on WebLogic.
-
How to Connect DBeaver to OnePageCrm via a JDBC Driver
Manage OnePageCrm data with visual tools in DBeaver like the query browser.
-
DataBind Charts to Workday Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Workday data 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.