CData Software - Knowledge Base
Recent Articles
-
How to create an RPA flow for Amazon DynamoDB Data in UiPath Studio
Use the Amazon DynamoDB ODBC Driver to create workflows that access real-time Amazon DynamoDB without any coding.
-
How to Connect to & Open Microsoft Planner Data in Microsoft Excel
This article uses the CData ODBC driver for Microsoft Planner to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Process & Analyze SAP Ariba Source Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Ariba Source Data.
-
Connect to Adobe Analytics Data from HeidiSQL
Use CData Connect AI to connect to and query live Adobe Analytics from HeidiSQL.
-
Connect to Telegram Data in RapidMiner
Integrate Telegram with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Apps from Twilio Data in Qlik Sense Cloud
Use CData Connect AI to connect to Twilio Data and build apps from live Twilio in Qlik Sense Cloud.
-
Build a Singer.io Tap for Google Drive With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Drive data using
-
Connect to SparkPost Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SparkPost to connect to SparkPost and execute queries in PowerBuilder.
-
Build a Singer.io Tap for Customer.io With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Customer.io data using
-
How to publish and share Freshteam Data dashboards with Tableau Server
The CData ODBC driver for Freshteam enables you integrate Freshteam into Tableau dashboards.
-
Connect to Xero Data in Claris FileMaker Pro
Use the CData ODBC Driver for Xero in FileMaker Pro to connect to Xero and work with Xero Accounting in your FileMaker applications.
-
Replicate Discord Data from PowerShell
Write a quick PowerShell script to query Discord. Use connectivity to the live data to replicate Discord to SQL Server.
-
Use Claude to Talk to Your Revenue Operations Data
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your revenue operations data for you
-
Build a Simple VCL Application for NetSuite Data
How to build a simple VCL Application to view NetSuite CRM & ERP in RAD Studio using the CData ODBC Driver for NetSuite.
-
Import DocuSign Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access DocuSign. In this article, you will use the OData format to import DocuSign into Microsoft Power Query.
-
Connect to Google Campaign Manager 360 Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Campaign Manager 360 in Airbyte.
-
Build a Singer.io Tap for Pushbullet With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Pushbullet data using
-
Build Charts with Slack Data in Clear Analytics
Create dynamic charts and perform analytics based on Slack in Clear Analytics.
-
How to Connect Flowise AI Agents to Live Microsoft OneDrive 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 Microsoft OneDrive without replication.
-
Publish DocuSign-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live DocuSign.
-
Build Highrise-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Highrise CRM.
-
How to create Dynamics 365 Business Central federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Dynamics 365 Business Central in MySQL .
-
How to Query BambooHR Data in MySQL Workbench
Execute MySQL queries against live BambooHR from MySQL Workbench.
-
How to Access Live Aweber Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Aweber enables you to integrate Aweber into workflows built using Microsoft Power Automate Desktop.
-
A PostgreSQL Interface for ZohoExpense Data (MySQL Remoting via JDBC)
Use the Remoting features of the ZohoExpense JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Clockify Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Clockify from Node.js.
-
Integrating Dataiku with IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live IBM Informix.
-
Use the CData Software ODBC Driver for Timely in MicroStrategy Desktop
Connect to Timely in MicroStrategy Desktop using the CData Software ODBC Driver for Timely.
-
Prepare, Blend, and Analyze ClickUp Data in Alteryx Designer (ODBC)
Build workflows to access live ClickUp for self-service data analytics.
-
Integrating OpenCode Terminal with MailerSend 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 Charts with Okta Data in Clear Analytics
Create dynamic charts and perform analytics based on Okta in Clear Analytics.
-
Connect to PagerDuty Data from a Connection Pool in Jetty
The PagerDuty JDBC Driver supports connection pooling: This article shows how to connect faster to PagerDuty from Web apps in Jetty.
-
Integrate Kafka Data in Pentaho Data Integration
Build ETL pipelines based on Apache Kafka in the Pentaho Data Integration tool.
-
Write a Simple Go Application to work with Wistia Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Wistia.
-
Viewing MailChimp Data in RAD Studio Data Explorer
How to view MailChimp in RAD Studio Data Explorer using the CData ODBC Driver for MailChimp.
-
Connect to and Query GraphQL Data in QlikView over ODBC
Create data visualizations with GraphQL in QlikView.
-
Integrating Antigravity CLI with SendPulse via CData CLI
Connect SendPulse to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Blackbaud FE NXT Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Amazon Redshift.
-
Access WordPress Data from MySQL in PHP
Connect to WordPress through the standard MySQL libraries in PHP.
-
Integrating Claude Code CLI with NetSuite 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 Redis from a Connection Pool in WebLogic
Use the CData JDBC Driver for Redis to connect to Redis from Web applications running on WebLogic.
-
Establish a Live Connection with Sage Cloud Accounting Data using Tableau Bridge
The CData ODBC Driver for Sage Cloud Accounting enables you to integrate live Sage Business Cloud Accounting into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Visualize Chargebee Data in Python with pandas
Use pandas and other modules to analyze and visualize live Chargebee in Python.
-
How to Query Live OData Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live OData data in natural language using Python.
-
Automated Continuous XML Replication to Oracle
Use CData Sync for automated, continuous, customizable XML replication to Oracle.
-
Integrating Cursor CLI with Spark 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.
-
Access MailerLite Data from MySQL in PHP
Connect to MailerLite through the standard MySQL libraries in PHP.
-
Create Sage Intacct-Connected Dashboards in Grafana
Connect to Sage Intacct Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Sage Intacct.
-
Avalara AvaTax Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Avalara AvaTax through CData Connect AI using different applications and tools.
-
How to Access Live Sage 200 Data in Visual Studio Code via Cline
Run CData MCP Server for Sage 200 on Windows Subsytem for Linux (WSL) and connect to live Sage 200 from the Cline extension in Visual Studio Code.
-
Connect to Perigon from Asprova with CData Software ODBC Driver for Perigon
This article shows how to connect faster to Perigon data from Asprova.
-
Integrate Timely with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Timely with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Timely.
-
Access Live Pipedrive Data in Coginiti Pro
Connect to and query live Pipedrive from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Redshift Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Redshift Data and connect to Amazon Redshift in Akorbi Digital RunMyProcess.
-
Connect to Kintone from Asprova with CData Software ODBC Driver for Kintone
This article shows how to connect faster to Kintone data from Asprova.
-
Query ZohoInvoice Data as a MySQL Database in Node.js
Execute MySQL queries against ZohoInvoice from Node.js.
-
How to connect SharePoint with Excel Data through external lists
Provide Microsoft Excel to SharePoint users as an external list.
-
Integrate Demio with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Demio with External Services.
-
Automated Continuous HCL Domino Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable HCL Domino replication to Google BigQuery.
-
Use Dash to Build Web Apps on HubSpot Data via CData Connect AI
Build interactive Dash web apps on live HubSpot using pandas and the CData Connect AI Python SDK.
-
Connect to Odoo Data in Jaspersoft Studio
Execute SQL to remote Odoo ERP in Jaspersoft Studio.
-
Connect to Greenplum Data in DBArtisan
Use wizards in DBArtisan to configure Pivotal GreenPlum as a data source.
-
Create Data Visualizations Based On Oracle HCM Cloud Data in Mode
Use CData Connect AI to connect to Oracle HCM Cloud Data from Mode and build visualizations using live
-
Access Salesforce Pardot 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 Salesforce Pardot.
-
Integrate Goose with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft OneDrive from within the local AI agent.
-
Connect DB2 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your IBM DB2 using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Live ZeroBounce Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ZeroBounce to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Phoenix in SpagoBI
Create reports featuring live Apache Phoenix in SpagoBI Studio. Host Phoenix reports on SpagoBI Server.
-
How to Query Live Adobe Analytics Data in Perplexity MacOS Desktop
Connect to and query live Adobe Analytics Data in Perplexity Desktop using CData MCP Server.
-
Build a PostgreSQL Interface for Short.io Data using the CData JDBC Driver
Use the Remoting features of the Short.io JDBC Driver to create a PostgreSQL entry-point for data access.
-
Explore Geographical Relationships in Microsoft Planner Data with Power Map
Create data visualizations with Microsoft Planner in Power Map.
-
Create SSAS Tabular Models from LaunchDarkly Data
How to build a SQL Server Analysis Service Tabular Model from LaunchDarkly using CData drivers.
-
Access Elasticsearch 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 Elasticsearch.
-
Analyze Salesloft Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesloft with the CData JDBC Driver for Salesloft.
-
Use Dash to Build to Web Apps on Printful Data
Create Python applications that use pandas and Dash to build Printful-connected web apps.
-
Integrating Kiro CLI with Cosmos DB 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.
-
Access Live BigQuery Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google BigQuery in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Access Live Parquet Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Parquet enables you to integrate Apache Parquet into workflows built using Microsoft Power Automate Desktop.
-
Connect to FormSite Data from PowerBuilder via JDBC
This article demonstrates how to access FormSite from PowerBuilder using the FormSite JDBC Driver.
-
Connect to Flowlu Data in DBeaver
Use the CData ODBC Driver to connect to Flowlu in DBeaver.
-
How to create an RPA flow for Productboard Data in UiPath Studio
Use the Productboard ODBC Driver to create workflows that access real-time Productboard without any coding.
-
Add Brex Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Brex with the Informatica Enterprise Data Catalog to classify and organize data.
-
Analyze Shortcut Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Shortcut from Power Pivot. You will use the Table Import Wizard to load Shortcut. You can visually build the import query or use any SQL supported by the driver.
-
How to use SQLAlchemy ORM to access SharePoint Excel Services Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SharePoint Excel Services.
-
Build Adobe Analytics-Connected Apps in Choreo
Use CData Connect AI to connect to Adobe Analytics Data from Choreo and build custom apps using live Adobe Analytics.
-
DataBind Charts to PingOne Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PingOne 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.
-
Access Blackbaud FE NXT Data from MySQL in Amazon QuickSight
Connect to Blackbaud FE NXT and build visualizations of Blackbaud FE NXT using a MySQL Connection in Amazon QuickSight.
-
Comparing Insert Methods in BigQuery: Streaming, DML, and Bulk Loading with the CData BigQuery Driver
Learn how to choose the best insert method for Google BigQuery—Streaming, DML, or Bulk Loading—using the CData BigQuery Driver. Improve your data integration and ETL workflows with optimized strategies.
-
How to integrate Metabase with Slack Data
Use CData Connect AI to connect to live Slack and create an interactive dashboard in Metabase from Slack.
-
Automated Continuous LinkedIn Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LinkedIn replication to Amazon S3.
-
Automated Continuous Redis Replication to Oracle
Use CData Sync for automated, continuous, customizable Redis replication to Oracle.
-
Create Instagram-Connected Applications in Appsmith
Connect to Instagram Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Instagram.
-
Access Live SAP Hybris C4C Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP Hybris C4C from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate with Aweber Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Aweber to a JSON file on disk.
-
Automated Continuous Nethunt Replication to Vertica
Use CData Sync for automated, continuous, customizable Nethunt replication to Vertica.
-
Integrate Drift with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Drift with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Drift.
-
Automated Continuous Omnisend Replication to Databricks
Use CData Sync for automated, continuous, customizable Omnisend replication to Databricks.
-
How to Work with Clari Data in AWS Glue Jobs Using JDBC
Connect to Clari from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect to FreeAgent Data with Squirrel SQL client
Connect to FreeAgent and execute queries in the Squirrel SQL Client.
-
Replicate SuiteCRM Data to Multiple Databases
Replicate SuiteCRM to disparate databases with a point-and-click configuration.