CData Software - Knowledge Base
Recent Articles
-
Publish Keap-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Keap data.
-
Create Dashboards and Visualize Live PolarTeamPro Data in Geckoboard
Use CData Connect AI to connect to live PolarTeamPro data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Interact with Live RSS Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live RSS feeds.
-
Use the CData ODBC Driver for Zoho CRM in Microsoft Power Query
You can use the CData Zoho CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoho CRM data into Microsoft Power Query.
-
How to create REST federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for REST data in MySQL .
-
Automated Continuous Wistia Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Wistia replication to AlloyDB.
-
Model Procore Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Procore, enabling the direct import of real-time Procore data.
-
Integrating LangChain with MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MYOB AccountRight data within automated workflows.
-
Integrate Live Google Drive Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Drive from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Drive data.
-
Connect to Elorus Data in Jaspersoft Studio
Execute SQL to remote Elorus data in Jaspersoft Studio.
-
Create a Data Access Object for OpenWeatherMap Data using JDBI
A brief overview of creating a SQL Object API for OpenWeatherMap data in JDBI.
-
Use the CData Software ODBC Driver for Oracle HCM Cloud in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle HCM Cloud data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle HCM Cloud.
-
Automated Continuous WooCommerce Replication to Vertica
Use CData Sync for automated, continuous, customizable WooCommerce replication to Vertica.
-
How to work with Customer.io Data in Apache Spark using SQL
Access and process Customer.io Data in Apache Spark using the CData Software JDBC Driver.
-
Consume SharePoint Excel Services OData Feeds in PowerBuilder
This article demonstrates how to consume SharePoint Excel Services data as OData feeds from PowerBuilder using the API Server.
-
A PostgreSQL Interface for Mode Data (MySQL Remoting via JDBC)
Use the Remoting features of the Mode JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to OnePageCrm Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for OnePageCrm data in the Denodo Virtual DataPort Administrator.
-
Use the CData Software ODBC Driver for Oracle in MicroStrategy
Connect to Oracle data in MicroStrategy Developer using the CData Software ODBC Driver for Oracle.
-
Migrating data from LightSpeedRetail to Snowflake using CData SSIS Components.
Easily push LightSpeedRetail data to Snowflake using the CData SSIS Tasks for LightSpeedRetail and Snowflake.
-
Connect to Pipeline CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pipeline CRM data.
-
How to Connect to Live Oracle Financials Cloud 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 Oracle Financials Cloud data for you.
-
Use Azure AI Foundry to Talk to Your MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your MailChimp data for you.
-
Analyze Workday Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Workday data in Microsoft R Open.
-
Analyze Datadog Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Datadog data in Microsoft R Open.
-
Create Dashboards and Visualize Live Sage Cloud Accounting Data in Geckoboard
Use CData Connect AI to connect to live Sage Cloud Accounting data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Spark Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Spark replication to Apache Kafka.
-
Automated Continuous ConstantContact Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ConstantContact replication to Google Cloud SQL.
-
How to update SAP HANA from Excel
This article explains how to transfer data from Excel to SAP HANA using the Excel Add-In for SAP HANA.
-
Interact with Live Guru Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Guru data.
-
A PostgreSQL Interface for Campaigner Data using the CData ODBC Driver
Use the SQL Gateway and Campaigner ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Build an ETL App for Sybase Data in Python with CData
Create ETL applications and real-time data pipelines for Sybase data in Python with petl.
-
Automated Continuous LinkedIn Replication to SQL Server
Use CData Sync for automated, continuous, customizable LinkedIn replication to SQL Server.
-
Bidirectional Access to Access Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Access data in Filemaker Pro for Mac or Windows.
-
Build AI/ML Models with Live JotForm Data using Dataiku
Connect JotForm Data with Dataiku using the CData API Driver for JDBC.
-
Integrate Dify with Live ADP Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live ADP data.
-
Getting Started with the CData Connect AI Python SDK for GraphQL
Install the CData Connect AI Python SDK to read live GraphQL data with standard DB-API 2.0 Python code.
-
How to connect to Bullhorn CRM Data in DBVisualizer
Integrate Bullhorn CRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Missive Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Missive replication to Google Cloud SQL.
-
Visualize Phoenix Data in TIBCO Spotfire through ADO.NET
Integrate Phoenix data into dashboards in TIBCO Spotfire.
-
Connect to Freshservice Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Freshservice.
-
Create Data Visualizations in Cognos BI with Scrapfly Data
Access Scrapfly data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Highrise Replication to SQL Server
Use CData Sync for automated, continuous, customizable Highrise replication to SQL Server.
-
Stream HelloSign Data into Apache Kafka Topics
Access and stream HelloSign data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate TaxJar Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to TaxJar data and integrate live TaxJar data into your Power Automate tasks.
-
Automated Continuous Act CRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Act CRM replication to Apache Cassandra.
-
Consume Facebook Ads OData Feeds in PowerBuilder
This article demonstrates how to consume Facebook Ads data as OData feeds from PowerBuilder using the API Server.
-
Integrate Theia IDE with Live HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live HBase data from within the development environment.
-
Connect to SAS Data Sets Data in RapidMiner
Integrate SAS Data Sets data with standard components and data source configuration wizards in RapidMiner Studio.
-
Provide OData Services of Excel Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Excel data by developing a WCF Service Application.
-
Analyze xBase Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze xBase data in Microsoft R Open.
-
Connect to Vault CRM Data in CloverDX (formerly CloverETL)
Transfer Vault CRM data using the visual workflow in the CloverDX data integration tool.
-
Integrating Claude Code CLI with BenchmarkEmail 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.
-
Write a Simple Go Application to work with SAP Hybris C4C Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Hybris C4C data.
-
Integrating Kiro with WordPress 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 Snowflake Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Snowflake data in the Denodo Virtual DataPort Administrator.
-
Connect to and Query Drip Data in QlikView over ODBC
Create data visualizations with Drip data in QlikView.
-
How to import Printful Data into Apache Solr
Use the CData Software JDBC Driver for Printful in Data Import Handler and create an automated import of Printful data to Apache Solr Enterprise Search platform.
-
Build MVC Applications with Connectivity to Microsoft Dataverse Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Microsoft Dataverse from an ASP.NET MVC application.
-
DataBind MySQL Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for MySQL with the DevExpress Windows Forms and Web controls to provide MySQL data to a chart.
-
Query FreeAgent Data in DataGrip
Create a Data Source for FreeAgent in DataGrip and use SQL to query live FreeAgent data.
-
Getting Started with the CData JDBC Driver for Freshteam
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Freshteam.
-
Visualize Live SAP HANA XS Advanced Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP HANA XS Advanced data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Stream MySQL Data into Apache Kafka Topics
Access and stream MySQL data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect Dropbox Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Dropbox data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software JDBC Driver for ActiveCampaign in MicroStrategy Web
Connect to ActiveCampaign data in MicroStrategy Web using the CData Software JDBC Driver for ActiveCampaign.
-
Getting Started with the CData Connect AI Python SDK for Asana
Install the CData Connect AI Python SDK to read live Asana data with standard DB-API 2.0 Python code.
-
Visualize Guru 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 Guru data into TIBCO Spotfire.
-
Connect to ZohoSubscriptions Data from Crystal Reports
Use CData Connect AI to connect to and report on live ZohoSubscriptions data from Crystal Reports.
-
Connect to SageHR Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SageHR.
-
Connect to Dynamics 365 Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Dynamics 365 Data and connect to Dynamics 365 data in Akorbi Digital RunMyProcess.
-
Connecting Agentforce with Cvent Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Cvent data for you.
-
Visualize Insightly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Insightly data.
-
Connecting Pipedream with Jumpseller Data 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 Jumpseller data in real time.
-
How to connect PolyBase to Missive
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Missive data.
-
Integrate PolarTeamPro Data into Power Automate Desktop using CData Connect
CData Connect for PolarTeamPro Data enables you to integrate PolarTeamPro data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Dataiku with Yelp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Yelp data.
-
Build AI/ML Models with Live Vault CRM Data using Dataiku
Connect Vault CRM Data with Dataiku using the CData JDBC Driver for Vault CRM.
-
How to Visualize Samanage Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Samanage data in Python.
-
Build an OLAP Cube in SSAS from Google Ads Data
Establish a connection to Google Ads data data from SQL Server Analysis Services, and use the Google Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Chargebee Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Chargebee data.
-
Analyze BigCommerce Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of BigCommerce data and visualize BigCommerce data in SAP Analytics Cloud.
-
How to load Postmark data into Elasticsearch via Logstash
Introducing a simple method to load Postmark data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for Chargebee in MicroStrategy Desktop
Connect to Chargebee data in MicroStrategy Desktop using the CData Software ODBC Driver for Chargebee.
-
Publish Reports with Klipfolio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Klipfolio data.
-
Analyze MailChimp Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of MailChimp data and visualize MailChimp data in SAP Analytics Cloud.
-
Connect to PagerDuty Data in RapidMiner
Integrate PagerDuty data with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData SSIS Components for HDFS
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HDFS.
-
Use Dash to Build Web Apps on Shortcut Data via CData Connect AI
Build interactive Dash web apps on live Shortcut data using pandas and the CData Connect AI Python SDK.
-
Query Blackbaud FE NXT Data in DataGrip
Create a Data Source for Blackbaud FE NXT in DataGrip and use SQL to query live Blackbaud FE NXT data.
-
Access Live Guru Data in Excel 365 Online (Excel for the web)
Connect to Guru data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData Tableau Connector for Google Directory
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Directory.
-
Build Semantic Layer Views for Discord Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Discord data.
-
How to Use a Microsoft Access Database to Update Sybase Data in Real Time
Update Sybase data by creating a linked table in Microsoft Access with the CData Sybase ODBC Driver.
-
Integrate Live Google Spanner Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Spanner data to Blue Prism using the CData ODBC Driver for Google Spanner to create automated workflows for repetitive business tasks.
-
Use Dash to Build to Web Apps on Epicor Kinetic Data
Create Python applications that use pandas and Dash to build Epicor Kinetic-connected web apps.
-
Create Templated Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Templated from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Build an ETL App for Shippo Data in Python with CData Connect AI
Extract and transform live Shippo data in Python with petl and the CData Connect AI Python SDK.
-
How to Connect to Live Microsoft Ads 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 Microsoft Ads data for you.
-
Establish a Live Connection with SAP Concur Data using Tableau Bridge
The CData ODBC Driver for SAP Concur enables you to integrate live SAP Concur data into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData ODBC Driver for Google Calendar
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Calendar.