CData Software - Knowledge Base
Recent Articles
-
How to connect and process IBM Cloud Object Storage from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live IBM Cloud Object Storage.
-
Getting Started with the CData Power BI Connector for Strava
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData Tableau Connector for Strava
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Bannerbear Replication to SQLite
Use CData Sync for automated, continuous, customizable Bannerbear replication to SQLite.
-
Automated Continuous BigCommerce Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable BigCommerce replication to delimited files (CSV/TSV).
-
Query Chargebee Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Chargebee from Node.js.
-
Work with Okta Data in FoxPro
Load Okta into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Notion Replication to Vertica
Use CData Sync for automated, continuous, customizable Notion replication to Vertica.
-
Stream Rootly Data into Apache Kafka Topics
Access and stream Rootly in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to publish and share Adobe Experience Manager Data dashboards with Tableau Server
The CData ODBC driver for Adobe Experience Manager enables you integrate Adobe Experience Manager into Tableau dashboards.
-
Query Twilio Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Twilio and perform CRUD operations on Twilio from Node.js.
-
Replicate Pipeliner CRM Data to Multiple Databases via the CData Sync CLI
Replicate Pipeliner CRM to disparate databases with a single configuration.
-
Integrating Kiro CLI with Oracle Service Cloud 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.
-
Integrating OpenCode Terminal with Helpscout 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 connect to Discord Data with Squirrel SQL client
Connect to Discord and execute queries in the Squirrel SQL Client.
-
Access Live Act CRM Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Act CRM through MCP integration.
-
Enable the SAP JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP ERP/NetWeaver.
-
Build Agents in Relevance AI with Access to Live QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on QuickBooks Online within intelligent agent workflows.
-
Automate Sage 200 Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sage 200 replication to Azure Data Lake.
-
Connect and Query Live SAP Netweaver Gateway Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP Netweaver Gateway into Databricks
-
How to import SQL Analysis Services Data into Apache Solr
Use the CData Software JDBC Driver for SQL Analysis Services in Data Import Handler and create an automated import of SQL Analysis Services to Apache Solr Enterprise Search platform.
-
Getting Started with the CData Python Connector for Hive
Learn to install and license the CData Python Connector
-
Replicate Dropbox Data from PowerShell
Write a quick PowerShell script to query Dropbox. Use connectivity to the live data to replicate Dropbox to SQL Server.
-
Query Live GitHub 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 GitHub directly from the development environment.
-
DataBind SAP Hybris C4C Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP Hybris C4C with the DevExpress Windows Forms and Web controls to provide SAP Hybris C4C to a chart.
-
Easily Integrate Egnyte Data in Lazarus Pascal IDE
Learn how to easily integrate live Egnyte in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Provide OData Services of Raisers Edge NXT Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Raisers Edge NXT by developing a WCF Service Application.
-
How to Seamlessly Import Billsby Data into IBM SPSS Modeler
Integrate Billsby data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Salesloft Replication to MySQL
Use CData Sync for automated, continuous, customizable Salesloft replication to MySQL.
-
Access Live Spark Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Spark SQL from your Excel spreadsheets.
-
How to connect to ZohoMarketingHub Data from IntelliJ
Integrate connectivity to ZohoMarketingHub with wizards in IntelliJ.
-
How to Visualize Codat Data in Python with pandas
Use pandas and other modules to analyze and visualize live Codat in Python.
-
Create WooCommerce-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to WooCommerce Data from Klipfolio and build custom visualizations using live WooCommerce.
-
Automated Continuous Monday.com Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Monday.com replication to OneLake in Microsoft Fabric.
-
Automated Continuous Monday.com Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Monday.com replication to Amazon S3.
-
Automated Mode Data Replication to Teradata
Use CData Sync to Customize and automate Mode replication to Teradata.
-
How to Build an ETL App for Blackbaud FE NXT Data in Python with CData Connect AI
Build ETL pipelines that read and write live Blackbaud FE NXT in Python with petl and the CData Connect AI Python SDK.
-
Bind Live Certinia Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Certinia data
-
A PostgreSQL Interface for Landbot Data (MySQL Remoting via JDBC)
Use the Remoting features of the Landbot JDBC Driver to create a PostgreSQL entry-point for data access.
-
Back Up Apache Cassandra to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Cassandra. In this article, we will employ an SSIS workflow to populate a database with Apache Cassandra data.
-
How to Access Live Adobe Target Data in Visual Studio Code via Cline
Run CData MCP Server for Adobe Target on Windows Subsytem for Linux (WSL) and connect to live Adobe Target from the Cline extension in Visual Studio Code.
-
Integrating GitHub Copilot CLI with Shippo 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 Cosmos DB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Azure Cosmos DB, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Google Sheets Data in TIBCO Spotfire through OData
Integrate Google Sheets into dashboards in TIBCO Spotfire.
-
How to Connect to Live CockroachDB Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your CockroachDB for you.
-
Connect to Short.io Data from a Connection Pool in JBoss
Integrate Short.io into Java servlets: Use the Management Console in JBoss to install the Short.io JDBC Driver.
-
Build WordPress Visualizations in Tableau Desktop
Use CData Connect AI to connect to live WordPress and build visualizations in Tableau.
-
How to Connect to Live Dynamics 365 Business Central Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Dynamics 365 Business Central for you.
-
Visualize Live MailerLite Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MailerLite using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Back Up Webflow to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Webflow data.
-
Connect to Jira Assets Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Jira Assets to connect to Jira Assets and execute queries in PowerBuilder.
-
Analyze Salesforce Pardot Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Salesforce Pardot in Microsoft R Open.
-
Connect to Epicor Kinetic Data in Google Apps Script via Connect AI
Use CData Connect AI to access Epicor Kinetic in Google Apps Script.
-
Automated Continuous Procore Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Procore replication to AlloyDB.
-
Integrate Live Google Calendar Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Calendar to Blue Prism using the CData ODBC Driver for Google Calendar to create automated workflows for repetitive business tasks.
-
Automate Google Sheets Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Sheets and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Manage Databricks Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Databricks.
-
Getting Started with the CData Tableau Connector for Optimizely
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Establish a Live Connection with Snowflake Data using Tableau Bridge
The CData ODBC Driver for Snowflake enables you to integrate live Snowflake into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Confluence Data in ACL Analytics
Connect to Atlassian Confluence via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Atlassian Confluence.
-
Connect to Strava Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live BambooHR within intelligent workflows.
-
Connect Salesloft to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Salesloft using the CData Python MCP Server.
-
Connect to Microsoft Entra ID Data in HULFT Integrate
Connect to Microsoft Entra ID as a JDBC data source in HULFT Integrate
-
Replicate Shippo Data to Multiple Databases via the CData Sync CLI
Replicate Shippo to disparate databases with a single configuration.
-
How to Work with Autopilot Data in AWS Glue Jobs Using JDBC
Connect to Autopilot from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating LangChain with Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Cloud Storage within automated workflows.
-
How to connect to Presto Data with Squirrel SQL client
Connect to Presto and execute queries in the Squirrel SQL Client.
-
Integrate Postmark with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Postmark with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Postmark.
-
Connect to Azure DevOps Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Azure DevOps.
-
How to Connect to Live CockroachDB 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 CockroachDB for you.
-
Getting Started with the CData Excel Add-In for Mocean
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Mocean.
-
Build Visualizations of Toggl Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Toggl in Birst.
-
LINQ to Databricks Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Databricks Data Provider.
-
Automated Continuous Microsoft OneLake Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to AlloyDB.
-
Prepare, Blend, and Analyze Dotmailer Data in Alteryx Designer (ODBC)
Build workflows to access live Dotmailer for self-service data analytics.
-
Deploy the ADO.NET Provider for Box on an SSRS Report Server
Connect to Box 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.
-
How to connect PolyBase to Microsoft Planner
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Planner.
-
DataBind QuickBooks Online Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for QuickBooks Online with the DevExpress Windows Forms and Web controls to provide QuickBooks Online to a chart.
-
How to integrate Azure Data Catalog with Apache Airflow
Access and process Azure Data Catalog in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Wrike Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Wrike replication to Google BigQuery.
-
Build Epicor Kinetic-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Epicor Kinetic Data and create custom apps in Bubble.
-
Visualize Microsoft Teams Data in Tableau
The CData ODBC driver for Microsoft Teams enables you integrate Microsoft Teams into Tableau dashboards.
-
Access SuiteCRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SuiteCRM from your Oracle system.
-
Automated Continuous Timely Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Timely replication to IBM DB2.
-
Integrate QuickBooks with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate QuickBooks with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to QuickBooks Desktop.
-
Connect to and Query LeadDesk Data in QlikView over ODBC
Create data visualizations with LeadDesk in QlikView.
-
Access Todoist Data from MySQL in Amazon QuickSight
Connect to Todoist and build visualizations of Todoist using a MySQL Connection in Amazon QuickSight.
-
Query Snowflake Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Snowflake entities in PHP by modeling them as objects.
-
Automated Continuous Freshdesk Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Freshdesk replication to Google BigQuery.
-
Connect to and Query Outreach.io Data in QlikView over ODBC
Create data visualizations with Outreach.io in QlikView.
-
Integrate Oracle Service Cloud Data into Power Automate Desktop using CData Connect
CData Connect for Oracle Service Cloud Data enables you to integrate Oracle Service Cloud into workflows built using Microsoft Power Automate Desktop.
-
Connect to Workday Data in Aqua Data Studio
Access Workday from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software ODBC Driver for SharePoint in MicroStrategy Web
Connect to Microsoft SharePoint in MicroStrategy Web using the CData Software ODBC Driver for SharePoint.
-
Integrating Codex CLI with Shopify 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.
-
Automated Continuous Flowlu Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Flowlu replication to Apache Kafka.
-
How to Work with Aweber Data in ETL Validator JDBC
Connect to Aweber from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Apps with Live RabbitMQ Data Using the Low-Code Development Platform of Mendix
Connect RabbitMQ with Mendix to build apps using the CData API Driver for JDBC.
-
Getting Started with the CData Connect AI Python SDK for FTP
Install the CData Connect AI Python SDK to read and write live FTP Servers with standard DB-API 2.0 Python code.
-
Bridge Datadog Connectivity with Apache NiFi
Access and process Datadog in Apache NiFi using the CData JDBC Driver.