CData Software - Knowledge Base
Recent Articles
-
Query Databricks Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Databricks from Node.js.
-
Stream SAP Business One Data into Apache Kafka Topics
Access and stream SAP Business One in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to load QuickBooks Time data into Elasticsearch via Logstash
Introducing a simple method to load QuickBooks Time data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous ZohoDesk Replication to Databricks
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Databricks.
-
Import Real-Time SingleStore Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SingleStore in ColdFusion.
-
Use ChatGPT to Talk to Your Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Sheets for you.
-
How to Query Live Zoho Projects Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zoho Projects data in natural language using Python.
-
Integrating LangChain with PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on PayPal within automated workflows.
-
Connect to Paymo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Paymo and the SQL Gateway to access Paymo from Google Apps Script.
-
Access Demio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Demio from HeidiSQL.
-
Connect to Real-Time Templated Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Templated in Power Apps.
-
Connect to OneNote Data from a Connection Pool in JBoss
Integrate Microsoft OneNote into Java servlets: Use the Management Console in JBoss to install the OneNote JDBC Driver.
-
How to Import Data from SendGrid into Google Sheets
Import SendGrid into a Google spreadsheet that is automatically refreshed.
-
Automate CSV Data Replication to Azure Data Lake
Use CData Sync to customize and automate CSV/TSV Files replication to Azure Data Lake.
-
Connect to Real-Time Qualaroo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Qualaroo in Power Apps.
-
How to Connect to Live Microsoft Ads 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 Microsoft Ads for you.
-
Getting Started with the CData Excel Add-In for Typeform
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Typeform.
-
Automated Continuous Twilio Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Twilio replication to Amazon S3.
-
Enable the Avaza JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Avaza.
-
Connect to BenchmarkEmail Data from a Connection Pool in Jetty
The BenchmarkEmail JDBC Driver supports connection pooling: This article shows how to connect faster to BenchmarkEmail from Web apps in Jetty.
-
Getting Started with the CData ADO.NET Provider for xBase
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for xBase.
-
How to publish and share Adobe Commerce Data dashboards with Tableau Server
The CData ODBC driver for Adobe Commerce enables you integrate Adobe Commerce into Tableau dashboards.
-
Use the CData Software JDBC Driver for ConstantContact in MicroStrategy Desktop
Connect to ConstantContact in MicroStrategy Desktop using the CData Software JDBC Driver for ConstantContact.
-
Connect to Strava Data in CloverDX (formerly CloverETL)
Transfer Strava using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData Power BI Connector for Google Campaign Manager 360
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Campaign Manager 360.
-
Connect to Azure Data Lake Storage Data in NetBeans
Connect to Azure Data Lake Storage in NetBeans with the data source configuration wizard.
-
How to connect and process Qualaroo from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Qualaroo.
-
Integrating LangGraph with MariaDB Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on MariaDB within automated workflows.
-
Automated Continuous Elorus Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Elorus replication to Apache Cassandra.
-
Connect to ConstantContact Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ConstantContact.
-
Build NetSuite SuiteAnalytics Visualizations in Tableau Cloud
Use CData Connect AI to connect to live NetSuite SuiteAnalytics and build visualizations in Tableau Cloud.
-
Migrating data from Simplesat to Databricks using CData SSIS Components.
Easily push Simplesat to Databricks using the CData SSIS Tasks for Simplesat and Databricks.
-
Replicate Azure Data Catalog Data to Multiple Databases via the CData Sync CLI
Replicate Azure Data Catalog to disparate databases with a single configuration.
-
Connect to Sage Cloud Accounting in SpagoBI
Create reports featuring live Sage Business Cloud Accounting in SpagoBI Studio. Host Sage Cloud Accounting reports on SpagoBI Server.
-
Build Tally-Connected Apps in Choreo
Use CData Connect AI to connect to Tally Data from Choreo and build custom apps using live Tally ERP.
-
How to create Instagram federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Instagram in MySQL .
-
Working with CampaignMonitor Data in LINQPad
Execute LINQ queries to CampaignMonitor in LINQPad.
-
How to create an RPA flow for Microsoft Exchange Data in UiPath Studio
Use the Microsoft Exchange ODBC Driver to create workflows that access real-time Microsoft Exchange without any coding.
-
Establish a Live Connection with Jira Data using Tableau Bridge
The CData ODBC Driver for Jira enables you to integrate live Atlassian Jira into Tableau Cloud dashboards using the Tableau Bridge.
-
A PostgreSQL Interface for Strava Data using the CData ODBC Driver
Use the SQL Gateway and Strava ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate OneNote Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft OneNote replication to SAP HANA.
-
ShipEngine Reporting in OBIEE with the ShipEngine JDBC Driver
Deploy the ShipEngine JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
SendGrid Reporting in OBIEE with the SendGrid JDBC Driver
Deploy the SendGrid JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to import Okta Data into Apache Solr
Use the CData Software JDBC Driver for Okta in Data Import Handler and create an automated import of Okta to Apache Solr Enterprise Search platform.
-
Integrate Live FHIR Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live FHIR to Blue Prism using the CData ODBC Driver for FHIR to create automated workflows for repetitive business tasks.
-
Automated Continuous Hive Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Hive replication to AlloyDB.
-
Create Apps from Lakebase Data in Qlik Sense Cloud
Use CData Connect AI to connect to Lakebase Data and build apps from live Lakebase in Qlik Sense Cloud.
-
Operational Reporting on Parquet Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache Parquet.
-
Connect to Superchat from Asprova with CData Software ODBC Driver for Superchat
This article shows how to connect faster to Superchat data from Asprova.
-
Choosing the Best Method to Connect LinkedIn Ads to SQL Server: 5 Options Explained
Discover multiple ways to connect and use LinkedIn Ads from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate with live HCL Domino Data in Jitterbit
Use CData Connect AI to connect to and integrate live HCL Domino in Jitterbit.
-
Build Data Flows from Act-On to SQL Server using SSIS
Easily back up Act-On to SQL Server using the SSIS components for Act-On.
-
How to Work with Coinbase Data in ETL Validator JDBC
Connect to Coinbase from ETL Validator jobs using the CData Software JDBC Driver.
-
Consume Presto OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Presto feeds that reflect any changes in SAP Lumira.
-
Visualize BigCommerce Data in TIBCO Spotfire through ADO.NET
Integrate BigCommerce into dashboards in TIBCO Spotfire.
-
Edit and Search External Procore Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Procore to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Procore Data objects that you can access from apps and the dashboard.
-
Integrating Claude Code CLI with SAP SuccessFactors LMS 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.
-
Query Testmonitor Data in DataGrip
Create a Data Source for Testmonitor in DataGrip and use SQL to query live Testmonitor.
-
Integrate Live GetResponse Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live GetResponse to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating LangChain with Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Slack within automated workflows.
-
Operational Reporting on SparkPost Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SparkPost.
-
Visualize Live Billsby Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Billsby using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Rapidly Develop HDFS-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 HDFS.
-
Automated Continuous Mouseflow Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Mouseflow replication to AlloyDB.
-
How to integrate Cohere with Apache Airflow
Access and process Cohere in Apache Airflow using the CData JDBC Driver.
-
Publish PivotalTracker-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live PivotalTracker.
-
Integrating Claude Code CLI with SageHR 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.
-
Manage Datadog Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Datadog.
-
Connect to Perplexity Data from PowerBuilder via JDBC
This article demonstrates how to access Perplexity from PowerBuilder using the Perplexity JDBC Driver.
-
Integrate Basecamp with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Basecamp with External Services.
-
Enable the Missive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Missive.
-
Automate Jumpseller Data Replication to Azure Data Lake
Use CData Sync to customize and automate Jumpseller replication to Azure Data Lake.
-
Connecting Moonlit Workflow with Quickbase 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 Quickbase in real time.
-
A PostgreSQL Interface for XML Data (MySQL Remoting via JDBC)
Use the Remoting features of the XML JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Simplesat Data in DataGrip
Create a Data Source for Simplesat in DataGrip and use SQL to query live Simplesat.
-
Build Visualizations of Retently Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Retently in Birst.
-
Process & Analyze LightSpeedRetail Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live LightSpeedRetail Data.
-
Replicate Browserless Data from PowerShell
Write a quick PowerShell script to query Browserless. Use connectivity to the live data to replicate Browserless to SQL Server.
-
Connect to ElevenLabs Data in Aqua Data Studio
Access ElevenLabs from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Visualize Workable Data in Python with pandas
Use pandas and other modules to analyze and visualize live Workable in Python.
-
How to Easily Query ScrapingBee Data in OpenOffice Base
Connect to ScrapingBee data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous VWO Replication to AlloyDB
Use CData Sync for automated, continuous, customizable VWO replication to AlloyDB.
-
Use the CData Software ODBC Driver for Campaigner in MicroStrategy Web
Connect to Campaigner in MicroStrategy Web using the CData Software ODBC Driver for Campaigner.
-
Create Dynamic Oracle Eloqua Grids Using the Infragistics XamDataGrid
Learn how you can connect Oracle Eloqua to Infragistics XamDataGrid to build dynamic grids.
-
Access VWO Data from MySQL in PHP
Connect to VWO through the standard MySQL libraries in PHP.
-
Connect to MongoDB Data in Aqua Data Studio
Access MongoDB from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
DataBind Controls to Vault CRM Data in Delphi
DataBind to Veeva Vault & Vault CRM in Delphi with standard data access components and controls.
-
Automated Continuous Discord Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Discord replication to Amazon Redshift.
-
How to connect SharePoint with Presto Data through external lists
Provide Presto to SharePoint users as an external list.
-
Replicate Multiple Jodoo Accounts
Replicate multiple Jodoo accounts to one or many databases.
-
Analyze Attio Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Attio from Power Pivot. You will use the Table Import Wizard to load Attio. You can visually build the import query or use any SQL supported by the driver.
-
Seamlessly Bring QuickBooks Online Data into Retool Using CData Connect AI
Integrate QuickBooks Online data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Open WebUI with Live Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Apache Cassandra from within the chat interface.
-
Enable the Drip JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Drip.
-
Analyze Oracle Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Oracle Database with the CData JDBC Driver for Oracle.
-
Connect LeadDesk Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your LeadDesk using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to use SQLAlchemy ORM to access Bright Data Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Bright Data.
-
Import Real-Time Avalara AvaTax Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Avalara AvaTax in ColdFusion.
-
Access IBM Informix 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 IBM Informix.
-
How to Import Data from Anaplan into Google Sheets
Import Anaplan into a Google spreadsheet that is automatically refreshed.