CData Software - Knowledge Base
Recent Articles
-
Creating Airtable-Connected Applications in Unqork
You can use CData Connect AI to feed Airtable to Unqork and build custom business apps.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Gong
Provide connectivity to Gong through an SAP BusinessObjects universe.
-
How to Connect to Live Dropbox 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 Dropbox for you.
-
Integrating OpenCode Terminal with Exa 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 Postmark Data in DBeaver
Use the CData ODBC Driver to connect to Postmark in DBeaver.
-
Integrate Spark Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Apache Spark SQL and integrate live Apache Spark SQL into your Power Automate tasks.
-
How to Build an ETL App for ChartMogul Data in Python with CData
Create ETL applications and real-time data pipelines for ChartMogul in Python with petl.
-
Create Cosmos DB-Connected Applications in Appsmith
Connect to Cosmos DB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure Cosmos DB.
-
Configure the CData JDBC Driver for Zoho Inventory in a Connection Pool in Tomcat
Connect to Zoho Inventory from a connection pool in Tomcat.
-
Build Apps with Live Placid Data Using the Low-Code Development Platform of Mendix
Connect Placid with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Dynamics CRM Data in Ruby
Connect to Microsoft Dynamics CRM in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Bind Live Paddle Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Paddle data
-
Build a Singer.io Tap for Jodoo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Jodoo data using
-
Integrating OpenCode Terminal with MailChimp 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.
-
Moving Data from Wistia to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Wistia data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query Brex Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Brex and perform CRUD operations on Brex from Node.js.
-
How to Connect to TigerGraph Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to TigerGraph. Leverage the pyodbc module for ODBC in Python.
-
How to integrate Metabase with Bullhorn CRM Data
Use CData Connect AI to connect to live Bullhorn CRM and create an interactive dashboard in Metabase from Bullhorn CRM.
-
Access Facebook Ads Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Facebook Ads from HeidiSQL.
-
Automated Continuous Stripe Replication to Databricks
Use CData Sync for automated, continuous, customizable Stripe replication to Databricks.
-
Create Datasets from Intercom in Domo Workbench and Build Visualizations of Intercom Data in Domo
Use the CData Software ODBC Driver for Intercom to create datasets from Intercom in Domo Workbench and then build visualizations in the Domo service.
-
Integrate with Oracle Eloqua Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Oracle Eloqua to a JSON file on disk.
-
Query Live Gmail 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 Gmail directly from the development environment.
-
How to Easily Query Dynamics NAV Data in OpenOffice Base
Connect to Dynamics NAV data in OpenOffice Base using the CData ODBC Driver for Dynamics NAV and generate reports with live data insights.
-
Use the CData ODBC Driver for Billsby in Microsoft Power Query
You can use the CData Billsby ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Billsby into Microsoft Power Query.
-
Build Apps with Live Azure Table Data Using the Low-Code Development Platform of Mendix
Connect Azure Table Storage with Mendix to build apps using the CData JDBC Driver for Azure.
-
Publish Crystal Reports on Miro Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Miro.
-
Build AI/ML Models with Live Close Data using Dataiku
Connect Close Data with Dataiku using the CData API Driver for JDBC.
-
Write a Simple Go Application to work with Google Cloud Storage Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Cloud Storage.
-
How to work with Oracle Sales Data in Apache Spark using SQL
Access and process Oracle Sales Data in Apache Spark using the CData Software JDBC Driver.
-
Build Apps with Live Microsoft OneDrive Data Using the Low-Code Development Platform of Mendix
Connect Microsoft OneDrive with Mendix to build apps using the CData JDBC Driver for Microsoft OneDrive.
-
How to Connect to Live SAP ByDesign 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 SAP Business ByDesign for you.
-
Automated Continuous Zoho Creator Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Azure SQL Database.
-
Connect Amplitude to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Amplitude using the CData Python MCP Server.
-
How to Create Power BI Visual Reports with Real-Time Coinbase Data
Use CData Power BI Connectors to visualize Coinbase in Power BI.
-
Build Apps with Live Bitbucket Data Using the Low-Code Development Platform of Mendix
Connect Bitbucket with Mendix to build apps using the CData JDBC Driver for Bitbucket.
-
How to work with Slack Data in Apache Spark using SQL
Access and process Slack Data in Apache Spark using the CData Software JDBC Driver.
-
Automate Zoho CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho CRM replication to Azure Data Lake.
-
ETL Webflow in Oracle Data Integrator
This article shows how to transfer Webflow into a data warehouse using Oracle Data Integrator.
-
Automate Odoo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Odoo ERP replication to Azure Data Lake.
-
How to Query Autopilot Data in MySQL Workbench
Execute MySQL queries against live Autopilot from MySQL Workbench.
-
Bind Live Blackbaud FE NXT Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Blackbaud FE NXT data
-
Connect to FreeAgent Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time FreeAgent using standard SQL.
-
Automated Continuous SAS xpt Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAS xpt replication to Google Cloud SQL.
-
Connect to TigerGraph Data in DBeaver
Use the CData ODBC Driver to connect to TigerGraph in DBeaver.
-
Extract, Transform, and Load Microsoft OneDrive Data in Informatica PowerCenter
Create a simple Workflow for Microsoft OneDrive in Informatica PowerCenter.
-
Access Todoist 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 Todoist.
-
How to Access Live OData Services in Visual Studio Code via Cline
Run CData MCP Server for OData on Windows Subsytem for Linux (WSL) and connect to live OData from the Cline extension in Visual Studio Code.
-
Getting Started with the CData JDBC Driver for Planio
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Planio.
-
Create a Data Access Object for Spotify Data using JDBI
A brief overview of creating a SQL Object API for Spotify in JDBI.
-
Build Azure Synapse Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Synapse and build visualizations in Tableau Cloud.
-
Analyze Live Zendesk Data in SAS Viya
Use CData Connect AI to connect to Zendesk from SAS Viya and deploy self-service analytics using live Zendesk.
-
Create Dashboards and Visualize Live Zoho Books Data in Geckoboard
Use CData Connect AI to connect to live Zoho Books and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating Claude Code with IBM Cloud Object Storage Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on IBM Cloud Object Storage within assisted coding and automated development workflows.
-
Connect to SAP Fieldglass Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP Fieldglass.
-
Connect to HCL Domino Data as an External Source in Dremio
Use the CData JDBC Driver to connect to HCL Domino as an External Source in Dremio.
-
Visualize Accelo Data in Tableau
The CData ODBC driver for Accelo enables you integrate Accelo into Tableau dashboards.
-
Automated Continuous Testmonitor Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Testmonitor replication to AlloyDB.
-
Moving Data from Rebilly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Rebilly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Snowflake-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Snowflake Data from Klipfolio and build custom visualizations using live Snowflake.
-
Automated Continuous Impala Replication to SQL Server
Use CData Sync for automated, continuous, customizable Impala replication to SQL Server.
-
Working with SurveyMonkey Data in LINQPad
Execute LINQ queries to SurveyMonkey in LINQPad.
-
Excel Spreadsheet Automation on Shopify Data with the QUERY Formula
Pull data from Shopify, automate spreadsheets, and more with the QUERY formula.
-
Analyze Snapchat Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Snapchat Ads and visualize live Snapchat Ads in Infragistics Reveal.
-
DataBind Snowflake Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Snowflake with the DevExpress Windows Forms and Web controls to provide Snowflake to a chart.
-
Object-Relational Mapping (ORM) with Wistia 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 Wistia into a Java-based ORM framework, Hibernate.
-
Visualize Live GraphQL Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live GraphQL into custom reports in Power BI.
-
Build Dashboards with Paddle Data in DBxtra
Create dynamic dashboards and perform analytics based on Paddle in DBxtra.
-
Analyze Adobe Analytics Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Adobe Analytics and visualize live Adobe Analytics in Infragistics Reveal.
-
Build Data Flows from Google Search to SQL Server using SSIS
Easily back up Google Search to SQL Server using the SSIS components for Google Search.
-
Use the CData Software JDBC Driver for Trello in MicroStrategy Web
Connect to Trello in MicroStrategy Web using the CData Software JDBC Driver for Trello.
-
How to Query Live Sybase IQ Data in Claude Desktop
Connect to and query live Sybase IQ Data in Claude Desktop using CData MCP Server.
-
Explore Geographical Relationships in Azure Table Data with Power Map
Create data visualizations with Azure Table Storage in Power Map.
-
Create Sage Cloud Accounting-Connected Nintex Workflows
Use CData Connect AI to connect to Sage Cloud Accounting Data from Nintex Workflow Cloud and build custom workflows using live Sage Business Cloud Accounting.
-
Access Tavily Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Tavily from your Oracle system.
-
Use Biml to Build SSIS Tasks to Replicate EmailOctopus Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate EmailOctopus to SQL Server.
-
How to Connect to & Open PabblySubscriptions Data in Microsoft Excel
This article uses the CData ODBC driver for PabblySubscriptions to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect PolyBase to Bannerbear
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Bannerbear.
-
Visualize Pipeliner CRM Data in TIBCO Spotfire through ADO.NET
Integrate Pipeliner CRM into dashboards in TIBCO Spotfire.
-
Connect to Salesforce Data in HULFT Integrate
Connect to Salesforce as a JDBC data source in HULFT Integrate
-
Building Dynamic Web Pages with Samanage Data Using AngularJS
Create single-page applications with live connectivity to Samanage using the CData API Server.
-
Connect to Brex Data in Jaspersoft Studio
Execute SQL to remote Brex in Jaspersoft Studio.
-
Build Microsoft Planner-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Planner and build web apps with connectivity to live Microsoft Planner.
-
Build a Singer.io Tap for Keap With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Keap data using
-
Build Charts with SAP HANA Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP HANA in Clear Analytics.
-
Use Microsoft Copilot Studio to talk to your Trello 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 Trello for you.
-
Rapidly Develop Printify-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 Printify.
-
Connect to Live OneNote Data in PostGresSQL Interface through CData Connect AI
Create a live connection to OneNote in CData Connect AI and connect to your Microsoft OneNote from PostgreSQL.
-
Access SAS xpt Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAS XPORT from your Oracle system.
-
Migrating data from Google Cloud Storage to Databricks using CData SSIS Components.
Easily push Google Cloud Storage to Databricks using the CData SSIS Tasks for Google Cloud Storage and Databricks.
-
Migrating data from Google Analytics to Google BigQuery using CData SSIS Components.
Easily push Google Analytics to Google BigQuery using the CData SSIS Tasks for Google Analytics and Google BigQuery.
-
Connecting Pipedream with Couchbase 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 Couchbase data in real time.
-
How to Import Data from Amazon Marketplace into Google Sheets
Import Amazon Marketplace into a Google spreadsheet that is automatically refreshed.
-
Create Dynamic Reply.io Grids Using the Infragistics XamDataGrid
Learn how you can connect Reply.io to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Epicor Kinetic in SpagoBI
Create reports featuring live Epicor Kinetic in SpagoBI Studio. Host Epicor Kinetic reports on SpagoBI Server.
-
Create Testmonitor Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Testmonitor from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software ODBC Driver for Dynamics CRM in MicroStrategy Web
Connect to Microsoft Dynamics CRM in MicroStrategy Web using the CData Software ODBC Driver for Dynamics CRM.
-
Use the CData Software ODBC Driver for Demio in MicroStrategy Web
Connect to Demio in MicroStrategy Web using the CData Software ODBC Driver for Demio.
-
Visualize Live Instagram Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Instagram into custom reports in Power BI.
-
Create Data Visualizations Based On SurveyMonkey Data in Mode
Use CData Connect AI to connect to SurveyMonkey Data from Mode and build visualizations using live