CData Software - Knowledge Base
Recent Articles
-
Integrate with Live Asana Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Asana from the MuleSoft Anypoint Platform to integrate live Asana into custom reports and dashboards.
-
Build a Singer.io Tap for ActiveCampaign With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ActiveCampaign data using
-
How to Connect to Freshteam Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Freshteam. Leverage the pyodbc module for ODBC in Python.
-
Build Semantic Layer Views for Azure Analysis Services Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Analysis Services.
-
Automate HubDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access HubDB from PowerShell? This article demonstrates how to utilize the HubDB Cmdlets for tasks like connecting to HubDB, automating operations, downloading data, and more.
-
Analyze API Data in Cognos Analytics
Use CData Connect AI to connect to API Data from Cognos Analytics and analyze live API.
-
Integrating Claude Code CLI with SpaceX 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.
-
Connect to Nuclia Data from PowerBuilder via ADO.NET
This article demonstrates how to access Nuclia from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use CData Connect AI to Access SQL Server Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft SQL Server in the Power Pivot business intelligence tool.
-
How to Connect to Live Google Calendar 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 Google Calendar for you.
-
How to Access Live Epicor Kinetic Data in Visual Studio Code via Cline
Run CData MCP Server for Epicor Kinetic on Windows Subsytem for Linux (WSL) and connect to live Epicor Kinetic from the Cline extension in Visual Studio Code.
-
How to connect Amazon QuickSight to Redis Data
Create a connection to Redis in CData Connect AI and insert Redis into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Excel Online Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Excel Online.
-
Connecting Pipedream with OData Services via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on OData data in real time.
-
Getting Started with the CData ADO.NET Provider for FormSite
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connecting Mastra with Google Cloud Storage 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 Google Cloud Storage, no replication required.
-
Visualize Datadog 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 Datadog into TIBCO Spotfire.
-
Video: Connecting to Google BigQuery Data from Microsoft Excel
This video shows how to use the CData ODBC Driver for Google BigQuery to connect to Google BigQuery. You will create a DSN and then use the Data Connection Wizard in Excel to retrieve BigQuery data.
-
Build AI/ML Models with Live BenchmarkEmail Data using Dataiku
Connect BenchmarkEmail Data with Dataiku using the CData API Driver for JDBC.
-
Visualize MailChimp Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MailChimp.
-
Create Freshdesk-Connected Applications in Appsmith
Connect to Freshdesk Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Freshdesk.
-
Connect to ZendeskSell Data in RazorSQL
Connect to ZendeskSell from wizards and query ZendeskSell from the GUI in the RazorSQL database management tool.
-
Create Apps from Elasticsearch Data in Qlik Sense Cloud
Use CData Connect AI to connect to Elasticsearch Data and build apps from live Elasticsearch in Qlik Sense Cloud.
-
How to Query Live Access Data in Perplexity MacOS Desktop
Connect to and query live Access Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Tanda Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Tanda replication to Apache Cassandra.
-
How to integrate SAP with Apache Airflow
Access and process SAP ERP/NetWeaver in Apache Airflow using the CData JDBC Driver.
-
Integrating Gumloop with Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Email within automated workflows.
-
Create Data Visualizations Based On FTP Data in Mode
Use CData Connect AI to connect to FTP Data from Mode and build visualizations using live
-
Migrating data from Shippo to Snowflake using CData SSIS Components.
Easily push Shippo to Snowflake using the CData SSIS Tasks for Shippo and Snowflake.
-
Access NetSuite Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live NetSuite CRM & ERP from HeidiSQL.
-
Automated Continuous DocuSign Replication to Amazon S3
Use CData Sync for automated, continuous, customizable DocuSign replication to Amazon S3.
-
How to update MailChimp from Excel
This article explains how to transfer data from Excel to MailChimp using the Excel Add-In for MailChimp.
-
Create a Data Access Object for Missive Data using JDBI
A brief overview of creating a SQL Object API for Missive in JDBI.
-
Visualize Live Highrise Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Highrise CRM.
-
Use Biml to Build SSIS Tasks to Replicate Spark Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache Spark SQL to SQL Server.
-
Connect to Zuora Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zuora.
-
Create Reports with SAP BusinessObjects BI Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP BusinessObjects BI.
-
Automated Continuous Discord Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Discord replication to PostgreSQL.
-
DataBind Charts to Foursquare Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Foursquare 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.
-
Build Cassandra Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Apache Cassandra and build visualizations in Tableau Cloud.
-
Use the CData Software ODBC Driver for SAP Hybris C4C in MicroStrategy Desktop
Connect to SAP Hybris C4C in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Hybris C4C.
-
Connect to Exact Online Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Exact Online using standard SQL.
-
Automated Continuous Excel Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Excel replication to Apache Kafka.
-
Replicate Microsoft OneLake Data in Heroku for Use in Salesforce Connect
Replicate Microsoft OneLake to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query Live Cvent 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 Cvent directly from the development environment.
-
Create Dynamic Excel Online Grids Using the Infragistics XamDataGrid
Learn how you can connect Excel Online to Infragistics XamDataGrid to build dynamic grids.
-
Access Live Missive Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Missive data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
LINQ to Hive 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 Hive Data Provider.
-
Create eBay Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time eBay Analytics data access from reports, embedded analytics, and more.
-
Connect to HBase Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache HBase.
-
Work with Onfleet Data in FoxPro
Load Onfleet into a FoxPro database. This article includes full code and a walk-through of the process.
-
Consume SQL Analysis Services OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SQL Analysis Services feeds that reflect any changes in SAP Lumira.
-
Load Planio Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Planio to a database.
-
Rapidly Develop Postmark-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 Postmark.
-
Use CData Connect AI to Access Salesforce Marketing Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Salesforce Marketing Cloud in the Power Pivot business intelligence tool.
-
Build Apps with Live Sage Intacct in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sage Intacct into the Adalo platform and build custom mobile and web applications with real-time Sage Intacct.
-
Query Google Campaign Manager 360 Data as a MySQL Database in Node.js
Execute MySQL queries against Google Campaign Manager 360 from Node.js.
-
Access FormSite 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 FormSite.
-
Provide OData Services of Clio Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Clio by developing a WCF Service Application.
-
DataBind Charts to Twilio Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Twilio 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.
-
Replicate Clockify Data to Multiple Databases via the CData Sync CLI
Replicate Clockify to disparate databases with a single configuration.
-
Create Google Contacts-Connected Applications in Appsmith
Connect to Google Contacts Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Contacts.
-
Connect to Quickbase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Quickbase and the SQL Gateway to access Quickbase from Google Apps Script.
-
Create SSAS Tabular Models from MailerSend Data
How to build a SQL Server Analysis Service Tabular Model from MailerSend using CData drivers.
-
How to connect and process Stack Exchange from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Stack Exchange.
-
Integrate ZohoMarketingHub Data in the Pentaho Report Designer
Publish reports based on ZohoMarketingHub in the Pentaho BI tool.
-
Connect Reply.io to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Reply.io with IBM WebSphere for seamless data integration and connectivity.
-
Bidirectional Access to Bugsnag Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bugsnag in Filemaker Pro for Mac or Windows.
-
How to connect to Microsoft Dataverse Data from Spring Boot
Connect to Microsoft Dataverse in a Spring Boot Application using the CData JDBC Driver for Microsoft Dataverse
-
Create Confluence-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Confluence Data from OutSystems and build custom enterprise apps using live Atlassian Confluence.
-
How to integrate Amplitude with Apache Airflow
Access and process Amplitude in Apache Airflow using the CData JDBC Driver.
-
How to create an RPA flow for Shopify Data in UiPath Studio
Use the Shopify ODBC Driver to create workflows that access real-time Shopify without any coding.
-
Connect to Salesforce CRM Analytics Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Salesforce CRM Analytics Data and connect to Salesforce CRM Analytics in Akorbi Digital RunMyProcess.
-
Integrate Pipeliner CRM Data in the Pentaho Report Designer
Publish reports based on Pipeliner CRM in the Pentaho BI tool.
-
Connect to SAP Hybris C4C Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Hybris C4C from PowerBuilder using the SAP Hybris C4C JDBC Driver.
-
Integrating Codex CLI with Telegram 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 an OLAP Cube in SSAS from Zoho Inventory Data
Establish a connection to Zoho Inventory data from SQL Server Analysis Services, and use the Zoho Inventory Data Provider to build OLAP cubes for use in analytics and reporting.
-
ETL Sugar CRM in Oracle Data Integrator
This article shows how to transfer Sugar CRM into a data warehouse using Oracle Data Integrator.
-
Build Wistia-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Wistia Data in Claude Code to assist with building Wistia-powered applications.
-
Integrate with Pinterest Data in JReport Designer
Create charts and reports based on Pinterest in JReport Designer.
-
Getting Started with the CData ADO.NET Provider for Missive
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Basecamp Data in RapidMiner
Integrate Basecamp with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Vault CRM Data in Google Apps Script via Connect AI
Use CData Connect AI to access Veeva Vault & Vault CRM in Google Apps Script.
-
Build Automated SAP Fieldglass-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Fieldglass and build automated workflows in Zapier.
-
Use Biml to Build SSIS Tasks to Replicate Presto Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Presto to SQL Server.
-
Publish Reports with Mixpanel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mixpanel.
-
Connect to SAP ByDesign Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Business ByDesign from PowerBuilder using the SAP ByDesign JDBC Driver.
-
Connect to Retently Data in Jaspersoft Studio
Execute SQL to remote Retently in Jaspersoft Studio.
-
Prepare, Blend, and Analyze Google Directory Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Directory for self-service data analytics.
-
Import Clockify Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Clockify. In this article, you will use the OData format to import Clockify into Microsoft Power Query.
-
Build AI/ML Models with Live MYOB AccountRight Data using Dataiku
Connect MYOB AccountRight Data with Dataiku using the CData JDBC Driver for MYOB AccountRight.
-
Build Agents in Relevance AI with Access to Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAS XPORT within intelligent agent workflows.
-
Enable the ShipEngine JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ShipEngine.
-
Build Dashboards with Helpscout Data in DBxtra
Create dynamic dashboards and perform analytics based on Helpscout in DBxtra.
-
Automate Snapchat Ads Data Replication to Azure Synapse
Use CData Sync to customize and automate Snapchat Ads replication to Azure Synapse.
-
DataBind Charts to Microsoft OneDrive Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft OneDrive 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.
-
Process & Analyze Float Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Float Data.
-
How to Connect to Live HCL Domino Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your HCL Domino for you.
-
Access Live QuickBooks Data in AWS Lambda (with IntelliJ IDEA)
Connect to live QuickBooks Desktop in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create SSAS Tabular Models from Vimeo Data
How to build a SQL Server Analysis Service Tabular Model from Vimeo using CData drivers.