CData Software - Knowledge Base
Recent Articles
-
DataBind Cohere Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Cohere to a chart.
-
Connect to Missive Data in DBeaver
Use the CData ODBC Driver to connect to Missive in DBeaver.
-
Build Microsoft Entra ID-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Microsoft Entra ID to explore live Microsoft Entra ID Data in Cursor to assist with building Microsoft Entra ID-powered applications.
-
Operational Reporting on EmailOctopus Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote EmailOctopus.
-
Query IBM Informix Data as a MySQL Database in Node.js
Execute MySQL queries against IBM Informix from Node.js.
-
Replicate GraphQL Data from PowerShell
Write a quick PowerShell script to query GraphQL. Use connectivity to the live data to replicate GraphQL to SQL Server.
-
Analyze Jodoo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Jodoo in Microsoft R Open.
-
Configure the CData JDBC Driver for Azure Table in a Connection Pool in Tomcat
Connect to Azure Table Storage from a connection pool in Tomcat.
-
How to Visualize Dynamics 365 Business Central 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 Dynamics 365 Business Central in Python.
-
Use Dash to Build Web Apps on Microsoft Exchange Data via CData Connect AI
Build interactive Dash web apps on live Microsoft Exchange using pandas and the CData Connect AI Python SDK.
-
Connect to Instantly Data in RapidMiner
Integrate Instantly with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Real-Time Access to Zendesk in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zendesk in real time.
-
DataBind Controls to Datadog Data in C++Builder
DataBind to Datadog in C++Builder with standard components and controls.
-
Visualize Microsoft Teams Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Teams.
-
Automated Continuous Amazon Athena Replication to SingleStore
Use CData Sync for automated, continuous, customizable Amazon Athena replication to SingleStore.
-
Automate BambooHR Data Replication to Couchbase
Use CData Sync to Customize and automate BambooHR replication to Couchbase.
-
How to import JobNimbus Data into Apache Solr
Use the CData Software JDBC Driver for JobNimbus in Data Import Handler and create an automated import of JobNimbus to Apache Solr Enterprise Search platform.
-
Connect to Spotify Data in Jaspersoft Studio
Execute SQL to remote Spotify in Jaspersoft Studio.
-
Analyze SQL Analysis Services Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SQL Analysis Services and visualize live SQL Analysis Services in Infragistics Reveal.
-
Prepare, Blend, and Analyze Bitbucket Data in Alteryx Designer (ODBC)
Build workflows to access live Bitbucket for self-service data analytics.
-
Model Lakebase Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Lakebase, enabling the direct import of real-time Lakebase.
-
Build a Singer.io Tap for NASA With the CData Python Connector
Learn how to easily build a Singer.io Tap for live NASA data using
-
Query Live Sybase IQ 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 Sybase IQ directly from the development environment.
-
Analyze Salesforce Data 360 Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Salesforce Data 360 and visualize live Salesforce Data 360 in Infragistics Reveal.
-
Automated Continuous Oracle SCM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Azure SQL Database.
-
Prepare, Blend, and Analyze Google Ads Data in Alteryx Designer (ODBC)
Build workflows to access live Google Ads for self-service data analytics.
-
How to Access Live PayPal Data in Visual Studio Code via Cline
Run CData MCP Server for PayPal on Windows Subsytem for Linux (WSL) and connect to live PayPal from the Cline extension in Visual Studio Code.
-
How to Connect Monday.com Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Monday.com data in real time using natural language.
-
Use the CData Software ODBC Driver for Discourse in MicroStrategy Web
Connect to Discourse in MicroStrategy Web using the CData Software ODBC Driver for Discourse.
-
Connect to Basecamp Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Basecamp.
-
Build Apps with Live SAS XPORT in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAS XPORT into the Adalo platform and build custom mobile and web applications with real-time SAS XPORT.
-
How to work with NetSuite Data in Apache Spark using SQL
Access and process NetSuite Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Drift Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Drift and work with Drift in your FileMaker applications.
-
Connect Wrike to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Wrike using the CData Python MCP Server.
-
Query Hive Data as a MySQL Database in Node.js
Execute MySQL queries against Apache Hive from Node.js.
-
Automated Continuous Elorus Replication to SingleStore
Use CData Sync for automated, continuous, customizable Elorus replication to SingleStore.
-
How to Connect to SAP Concur Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Concur. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software ODBC Driver for HDFS in MicroStrategy Web
Connect to Apache HDFS in MicroStrategy Web using the CData Software ODBC Driver for HDFS.
-
Create Data Visualizations in Cognos BI with MailChimp Data
Access MailChimp as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Object-Relational Mapping (ORM) with Raisers Edge NXT Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Raisers Edge NXT into a Java-based ORM framework, Hibernate.
-
Connecting Moonlit Workflow with Smartsheet Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Smartsheet in real time.
-
How to Build an ETL App for Trello Data in Python with CData Connect AI
Build ETL pipelines that read and write live Trello in Python with petl and the CData Connect AI Python SDK.
-
Use the CData Software JDBC Driver for SageHR in MicroStrategy Desktop
Connect to SageHR in MicroStrategy Desktop using the CData Software JDBC Driver for SageHR.
-
Import Real-Time eBay Analytics Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use eBay Analytics in ColdFusion.
-
Stream SparkPost Data into Apache Kafka Topics
Access and stream SparkPost in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Outreach.io Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Outreach.io using standard SQL.
-
How to Query Live QuickBooks Online Data in Claude Desktop
Connect to and query live QuickBooks Online Data in Claude Desktop using CData MCP Server.
-
Build Agents in Relevance AI with Access to Live Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Bullhorn CRM within intelligent agent workflows.
-
Connect to Freshservice Data in RapidMiner
Integrate Freshservice with standard components and data source configuration wizards in RapidMiner Studio.
-
Add ZendeskSell Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZendeskSell with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData Power BI Connector for Adobe Commerce
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Adobe Commerce.
-
Connect to Confluence Data in DBArtisan
Use wizards in DBArtisan to configure Atlassian Confluence as a data source.
-
Build Apps with Live ConstantContact Data Using the Low-Code Development Platform of Mendix
Connect ConstantContact with Mendix to build apps using the CData API Driver for JDBC.
-
Deploy the ADO.NET Provider for SAP Fieldglass on an SSRS Report Server
Connect to SAP Fieldglass 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.
-
Access Snapchat Ads Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Snapchat Ads from HeidiSQL.
-
Access Dynamics NAV Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Dynamics NAV from your Oracle system.
-
Working with Humanity Data in LINQPad
Execute LINQ queries to Humanity in LINQPad.
-
Moving Data from Couchbase to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Couchbase data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Cursor CLI with SQL Server 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 Query Live Square Data in Perplexity MacOS Desktop
Connect to and query live Square Data in Perplexity Desktop using CData MCP Server.
-
Use Grok to Talk to Your MariaDB 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 MariaDB for you.
-
Connect to Cloudflare Data in NetBeans
Connect to Cloudflare in NetBeans with the data source configuration wizard.
-
Getting Started with the CData ADO.NET Provider for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Microsoft OneDrive.
-
Automate LightSpeedRetail Data Replication to SAP HANA
Use CData Sync to customize and automate LightSpeedRetail replication to SAP HANA.
-
Import Real-Time SAS Data Sets Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAS Data Sets in ColdFusion.
-
Replicate Tanda Data to Multiple Databases via the CData Sync CLI
Replicate Tanda to disparate databases with a single configuration.
-
Building Dynamic Web Pages with Sage Cloud Accounting Data Using AngularJS
Create single-page applications with live connectivity to Sage Cloud Accounting using the CData API Server.
-
Integrate Stripe Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Stripe from Informatica Cloud.
-
Build MVC Applications with Connectivity to Airtable Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Airtable from an ASP.NET MVC application.
-
Create Drift Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Drift from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData SSIS Components to Insert New or Update Existing Reckon Accounts Hosted Records from SQL Server
Easily push SQL Server data to Reckon Accounts Hosted using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Reckon Accounts Hosted or update existing records with data from a SQL Server database.
-
Create Power BI Reports on Real-Time NetSuite Data
Use the CData ODBC Driver for NetSuite to visualize NetSuite CRM & ERP in Power BI Desktop.
-
Work with Live Tally Data in Power Query
Use CData Connect AI to connect to Tally ERP and work with live Tally ERP in Microsoft Power Query.
-
Connect to Oracle Service Cloud Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle Service Cloud from Filemaker Pro on Mac.
-
Automated Continuous Printful Replication to MySQL
Use CData Sync for automated, continuous, customizable Printful replication to MySQL.
-
Process & Analyze Tavily Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Tavily Data.
-
Integrating Codex CLI with Couchbase 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.
-
Enable the PDFMonkey JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PDFMonkey.
-
A PostgreSQL Interface for Opsgenie Data using the CData ODBC Driver
Use the SQL Gateway and Opsgenie ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Todoist Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Todoist. Leverage the pyodbc module for ODBC in Python.
-
Connect to Spark Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apache Spark SQL in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Snapchat Ads Replication to MySQL
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to MySQL.
-
Integrate with Live YouTube Analytics Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to YouTube Analytics from the MuleSoft Anypoint Platform to integrate live YouTube Analytics into custom reports and dashboards.
-
Access VWO Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access VWO from your Oracle system.
-
Getting Started with the CData Python Connector for Raisers Edge NXT
Learn to install and license the CData Python Connector
-
Automated Continuous LightSpeedRetail Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Google Cloud SQL.
-
Integrating OpenCode Terminal with Power BI XMLA 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 Deel Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Deel as an External Source in Dremio.
-
Connect to PolarTeamPro Data in Ruby
Connect to PolarTeamPro in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Rapidly Develop Xero-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 Xero.
-
How to import Salesforce Pardot Data into Apache Solr
Use the CData Software JDBC Driver for Salesforce Pardot in Data Import Handler and create an automated import of Salesforce Pardot to Apache Solr Enterprise Search platform.
-
Build Data Flows from Landbot to SQL Server using SSIS
Easily back up Landbot to SQL Server using the SSIS components for Landbot.
-
Model, Search, and Visualize Live QuickBooks Online Data in ThoughtSpot
Use CData Connect AI to connect to live QuickBooks Online for modeling, searching, and visualizing.
-
Automate Splunk Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Splunk and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use Dash to Build Web Apps on Kintone Data via CData Connect AI
Build interactive Dash web apps on live Kintone using pandas and the CData Connect AI Python SDK.
-
A PostgreSQL Interface for Adobe Experience Manager Data using the CData ODBC Driver
Use the SQL Gateway and Adobe Experience Manager ODBC Driver to create a PostgreSQL entry-point for data access.
-
Blackbaud FE NXT Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Blackbaud FE NXT facts in real time.
-
Access Live Klaviyo Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Klaviyo from your Excel spreadsheets.
-
Use the CData Software JDBC Driver for Notion in MicroStrategy Web
Connect to Notion in MicroStrategy Web using the CData Software JDBC Driver for Notion.
-
Using the CData Software ODBC Driver for SAP Business Warehouse in PyCharm
Connect to SAP Business Warehouse as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Business Warehouse.