CData Software - Knowledge Base
Recent Articles
-
Automated Continuous ZendeskSell Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Amazon S3.
-
Back Up Gmail to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Gmail. In this article, we will employ an SSIS workflow to populate a database with Gmail data.
-
Use the CData Software ODBC Driver for Webex in SAS for Real-Time Reporting and Analytics
Connect to real-time Webex in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Webex.
-
Build Dashboards with Paymo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Paymo in Dundas BI.
-
How to Query Live Confluence Data in Claude Desktop
Connect to and query live Confluence Data in Claude Desktop using CData MCP Server.
-
Working with ServiceDesk Plus Data in LINQPad
Execute LINQ queries to ServiceDesk Plus in LINQPad.
-
Access Harvest Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Harvest from HeidiSQL.
-
Connect to Discord Data in DBeaver
Use the CData ODBC Driver to connect to Discord in DBeaver.
-
Rapidly Develop SAP Business One-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 SAP Business One.
-
Use CData Connect AI to Access QuickBooks Online Data in Microsoft Power Pivot
Use CData Connect AI to connect to live QuickBooks Online in the Power Pivot business intelligence tool.
-
Deploy the ADO.NET Provider for Salesforce Marketing on an SSRS Report Server
Connect to Salesforce Marketing Cloud 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.
-
Replicate Neo4J Data to Multiple Databases
Replicate Neo4J to disparate databases with a point-and-click configuration.
-
How to Connect to Live Freshservice 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 Freshservice for you.
-
Migrating data from OnePageCrm to Databricks using CData SSIS Components.
Easily push OnePageCrm to Databricks using the CData SSIS Tasks for OnePageCrm and Databricks.
-
Build AI/ML Models with Live Amazon Marketplace Data using Dataiku
Connect Amazon Marketplace Data with Dataiku using the CData JDBC Driver for Amazon Marketplace.
-
How to Work with Opsgenie Data in AWS Glue Jobs Using JDBC
Connect to Opsgenie from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to EmailOctopus Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for EmailOctopus.
-
Build Snowflake-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Snowflake.
-
Connect to ClickUp from Asprova with CData Software ODBC Driver for ClickUp
This article shows how to connect faster to ClickUp data from Asprova.
-
Integrate Cosmos DB Data in the Pentaho Report Designer
Publish reports based on Azure Cosmos DB in the Pentaho BI tool.
-
Design BIRT Reports on eBay Analytics Data
Provide current eBay Analytics to your embedded analytics.
-
Build Apps with Live Kintone Data Using the Low-Code Development Platform of Mendix
Connect Kintone with Mendix to build apps using the CData JDBC Driver for Kintone.
-
Create Greenplum-Connected Applications in Appsmith
Connect to Greenplum Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Pivotal GreenPlum.
-
Import Outreach.io Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Outreach.io Data and provide access to live Outreach.io for custom reports in the Power BI Service.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live OData within intelligent workflows.
-
Query Live Freshdesk 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 Freshdesk directly from the development environment.
-
Integrating GitHub Copilot CLI with Jira Assets 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 GetResponse Replication to IBM DB2
Use CData Sync for automated, continuous, customizable GetResponse replication to IBM DB2.
-
Connect to Tickspot Data in CloverDX (formerly CloverETL)
Transfer Tickspot using the visual workflow in the CloverDX data integration tool.
-
Connect to Airtable Data in RapidMiner
Integrate Airtable with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to ActiveCampaign from Asprova with CData Software ODBC Driver for ActiveCampaign
This article shows how to connect faster to ActiveCampaign data from Asprova.
-
How to use SQLAlchemy ORM to access Databricks Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Databricks.
-
Natively Connect to CircleCI Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CircleCI. Leverage the native support for ODBC in PHP.
-
Build Visualizations of Nuclia Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Nuclia in Birst.
-
Build Charts with Suadeo Data in Clear Analytics
Create dynamic charts and perform analytics based on Suadeo in Clear Analytics.
-
Automate Helpscout Data Replication to Azure Synapse
Use CData Sync to customize and automate Helpscout replication to Azure Synapse.
-
Connecting Mastra with Active Directory 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 Active Directory, no replication required.
-
Write a Simple Go Application to work with Epicor Kinetic Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Epicor Kinetic.
-
How to integrate Metabase with LinkedIn Ads Data
Use CData Connect AI to connect to live LinkedIn Ads and create an interactive dashboard in Metabase from LinkedIn Ads.
-
Build a PostgreSQL Interface for Okta Data using the CData JDBC Driver
Use the Remoting features of the Okta JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Monday.com Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Monday.com from Node.js.
-
Access Live Microsoft Ads Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Ads from your Excel spreadsheets.
-
Design BIRT Reports on OneNote Data
Provide current Microsoft OneNote to your embedded analytics.
-
Integrate SAP Hybris C4C Data into Power Automate Desktop using CData Connect
CData Connect for SAP Hybris C4C Data enables you to integrate SAP Hybris C4C into workflows built using Microsoft Power Automate Desktop.
-
Create Power BI Reports on Real-Time SAP BusinessObjects BI Data
Use the CData ODBC Driver for SAP BusinessObjects BI to visualize SAP BusinessObjects BI in Power BI Desktop.
-
Build Automated Workflows with Live eBay Data in Workato
Use CData Connect AI to connect to live eBay and build automated workflows in Workato.
-
Integrating Codex CLI with RabbitMQ 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 MariaDB-Connected Nintex Workflows
Use CData Connect AI to connect to MariaDB Data from Nintex Workflow Cloud and build custom workflows using live MariaDB.
-
Integrating AdRoll Data in Talend Cloud Data Management Platform
Connect AdRoll Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Live Zoho Creator Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zoho Creator to Blue Prism using the CData ODBC Driver for Zoho Creator to create automated workflows for repetitive business tasks.
-
Video: API Server Setup
An introduction to the use and features of the API Server - instant APIs for your databases.
-
Automated Continuous DB2 Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable IBM DB2 replication to OneLake in Microsoft Fabric.
-
Use the CData ODBC Driver for Certinia in Microsoft Power Query
You can use the CData Certinia ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Certinia into Microsoft Power Query.
-
Build MVC Applications with Connectivity to Salesforce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Salesforce from an ASP.NET MVC application.
-
Automated Continuous SparkPost Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SparkPost replication to delimited files (CSV/TSV).
-
How to Work with Perplexity Data in AWS Glue Jobs Using JDBC
Connect to Perplexity from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Data Visualizations Based On Zendesk Data in Mode
Use CData Connect AI to connect to Zendesk Data from Mode and build visualizations using live
-
Integrate HBase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate HBase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache HBase.
-
Establish a Live Connection with JobNimbus Data using Tableau Bridge
The CData ODBC Driver for JobNimbus enables you to integrate live JobNimbus into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Live Impala Data in the Power BI Service
Use CData Connect AI to connect to live Apache Impala and create custom reports in the Power BI Service through the On-Premises Gateway.
-
LINQ to Reckon Accounts Hosted Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Reckon Accounts Hosted Data Provider.
-
Connect to Oracle Data from a Connection Pool in Jetty
The Oracle JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle Database from Web apps in Jetty.
-
Build Voice Agents in ElevenLabs with access to Live Kintone Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Kintone.
-
How to Work with Twilio Data in AWS Glue Jobs Using JDBC
Connect to Twilio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating OpenCode Terminal with NASA 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 the CData Software JDBC Driver for Landbot in MicroStrategy Desktop
Connect to Landbot in MicroStrategy Desktop using the CData Software JDBC Driver for Landbot.
-
Connect to Clari Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Clari as an External Source in Dremio.
-
Build AI Agents with Highrise 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 Highrise CRM through CData Connect AI.
-
Build AI/ML Models with Live PDFMonkey Data using Dataiku
Connect PDFMonkey Data with Dataiku using the CData API Driver for JDBC.
-
Use the CData Software ODBC Driver for OpenWeatherMap in MicroStrategy Desktop
Connect to OpenWeatherMap in MicroStrategy Desktop using the CData Software ODBC Driver for OpenWeatherMap.
-
Automated Continuous Twilio Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Twilio replication to Apache Cassandra.
-
Getting Started with the CData JDBC Driver for Vault CRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Vault CRM.
-
Connect to Optimizely Data in JRuby
Create a simple JRuby app with access to live Optimizely.
-
Create Reports with Nuclia Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Nuclia.
-
Connect to HelloSign Data in Aqua Data Studio
Access HelloSign from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build LinkedIn Ads-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to LinkedIn Ads Data from Zoho Analytics and import live LinkedIn Ads.
-
Explore Geographical Relationships in ConvertAPI Data with Power Map
Create data visualizations with ConvertAPI in Power Map.
-
Integrate with Microsoft Dataverse Data in JReport Designer
Create charts and reports based on Microsoft Dataverse (CDS) in JReport Designer.
-
Visualize GitLab Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load GitLab into TIBCO Spotfire.
-
Use the CData Software ODBC Driver for SAP BusinessObjects BI in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP BusinessObjects BI in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP BusinessObjects BI.
-
Automated Continuous Timely Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Timely replication to Azure SQL Database.
-
Use the CData Software ODBC Driver for Onfleet in MicroStrategy
Connect to Onfleet in MicroStrategy Developer using the CData Software ODBC Driver for Onfleet.
-
Connecting GenSpark with Microsoft Exchange Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Microsoft Exchange without any replication or custom integration required.
-
Connect to Scrapfly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Scrapfly using standard SQL.
-
Getting Started with the CData Connect AI Python SDK for SAP BusinessObjects BI
Install the CData Connect AI Python SDK to read and write live SAP BusinessObjects BI with standard DB-API 2.0 Python code.
-
Getting Started with the CData Tableau Connector for Freshdesk
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Freshdesk.
-
Integrating Dataiku with NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live NetSuite SuiteAnalytics.
-
Integrating Claude Code CLI with QuickBooks Time 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 Connect Flowise AI Agents to Live SAP Hybris C4C 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 SAP Hybris C4C without replication.
-
Use Claude to Talk to Your Marketo 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 Marketo for you.
-
Use Dash to Build Web Apps on Box Data via CData Connect AI
Build interactive Dash web apps on live Box using pandas and the CData Connect AI Python SDK.
-
Configure the CData JDBC Driver for Azure Data Catalog in a Connection Pool in Tomcat
Connect to Azure Data Catalog from a connection pool in Tomcat.
-
Access SQL Server Data from MySQL in PHP
Connect to SQL Server through the standard MySQL libraries in PHP.
-
Create Dashboards and Visualize Live SAP BusinessObjects BI Data in Geckoboard
Use CData Connect AI to connect to live SAP BusinessObjects BI and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating Claude Code CLI with Google Ads 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.
-
Build AI Agents with ActiveCampaign 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 ActiveCampaign through CData Connect AI.
-
Replicate Google Spanner Data from PowerShell
Write a quick PowerShell script to query Google Spanner. Use connectivity to the live data to replicate Google Spanner to SQL Server.
-
Create Dynamic Azure Table Grids Using the Infragistics XamDataGrid
Learn how you can connect Azure Table to Infragistics XamDataGrid to build dynamic grids.
-
Operational Reporting on Dropbox Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Dropbox.
-
Connect to Pushbullet Data in RazorSQL
Connect to Pushbullet from wizards and query Pushbullet from the GUI in the RazorSQL database management tool.