CData Software - Knowledge Base
Recent Articles
-
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.
-
Integrate Cursor with Live Bright Data Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Bright Data data from within the editor.
-
Automated Continuous BigCommerce Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable BigCommerce replication to delimited files (CSV/TSV).
-
How to Visualize Bannerbear 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 Bannerbear data in Python.
-
Query Chargebee Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Chargebee data from Node.js.
-
Work with Okta Data in FoxPro
Load Okta data 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 data 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 data into Tableau dashboards.
-
Replicate Pipeliner CRM Data to Multiple Databases via the CData Sync CLI
Replicate Pipeliner CRM data to disparate databases with a single configuration.
-
Integrating Kiro 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 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.
-
Analyze PolarTeamPro Data in Cognos Analytics
Use CData Connect AI to connect to PolarTeamPro Data from Cognos Analytics and analyze live PolarTeamPro data.
-
How to connect to Discord Data with Squirrel SQL client
Connect to Discord data and execute queries in the Squirrel SQL Client.
-
Create Apps from Discord Data in Qlik Sense Cloud
Use CData Connect AI to connect to Discord Data and build apps from live Discord data in Qlik Sense Cloud.
-
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 data through MCP integration.
-
Enable the SAP JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP data.
-
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 data within intelligent agent workflows.
-
Automate Sage 200 Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sage 200 data 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 data into Databricks and enable direct, live querying and analysis without replication.
-
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 data to Apache Solr Enterprise Search platform.
-
Connecting Moonlit Workflow with ShipEngine 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 ShipEngine data in real time.
-
Automated Continuous Demio Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Demio replication to Google BigQuery.
-
Integrate Devin with Live Cassandra Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Cassandra data.
-
Getting Started with the CData Python Connector for Hive
Learn to install and license the CData Python Connector and configure a connection to live Hive data.
-
Replicate Dropbox Data from PowerShell
Write a quick PowerShell script to query Dropbox data. Use connectivity to the live data to replicate Dropbox data 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 data 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 data to a chart.
-
Easily Integrate Egnyte Data in Lazarus Pascal IDE
Learn how to easily integrate live Egnyte data 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 data 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 Spark data from your Excel spreadsheets.
-
How to connect to ZohoMarketingHub Data from IntelliJ
Integrate connectivity to ZohoMarketingHub data with wizards in IntelliJ.
-
How to Visualize Codat Data in Python with pandas
Use pandas and other modules to analyze and visualize live Codat data 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 data.
-
Automated Continuous Monday.com Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Monday.com data 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 data 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 data in Python with petl and the CData Connect AI Python SDK.
-
Use Grok to Talk to Your Adobe Target 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 Adobe Target data for you.
-
Bind Live Certinia Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Certinia data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
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 Cassandra data 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 Cassandra data data.
-
Integrating GitHub Copilot with Shippo 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 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 Cosmos DB data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Query, Visualize, and Share live Salesloft Data in Redash
Use CData Connect AI to connect to live Salesloft data in Redash for querying, visualizing, and sharing.
-
Visualize Google Sheets Data in TIBCO Spotfire through OData
Integrate Google Sheets data 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 data for you.
-
Connect to Short.io Data from a Connection Pool in JBoss
Integrate Short.io data 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 data 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 data for you.
-
Query Live MailerLite 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 MailerLite data directly from the development environment.
-
Visualize Live MailerLite Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MailerLite data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Back Up Webflow data 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 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 data and execute queries in PowerBuilder.
-
Analyze Yelp Data in Looker
Use CData Connect AI to connect to Yelp Data from Looker and build custom apps using live Yelp data.
-
Analyze Salesforce Pardot Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Salesforce Pardot data in Microsoft R Open.
-
Connect to Epicor Kinetic Data in Google Apps Script via Connect AI
Use CData Connect AI to access Epicor Kinetic data 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 data to Blue Prism using the CData ODBC Driver for Google Calendar to create automated workflows for repetitive business tasks.
-
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 data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Confluence Data in ACL Analytics
Connect to Confluence data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Confluence data.
-
Connect to Strava Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Strava.
-
Integrate Google's Vertex AI Agent with Live BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live BambooHR data 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 data 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 data 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 data within automated workflows.
-
How to connect to Presto Data with Squirrel SQL client
Connect to Presto data 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 data.
-
Connect to Azure DevOps Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Azure DevOps data.
-
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 data 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 data 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 data for self-service data analytics.
-
Deploy the ADO.NET Provider for Box on an SSRS Report Server
Connect to Box data 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 data.
-
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 data to a chart.
-
How to integrate Azure Data Catalog with Apache Airflow
Access and process Azure Data Catalog data 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 data into Tableau dashboards.
-
Automated Continuous Paddle Replication to Databricks
Use CData Sync for automated, continuous, customizable Paddle replication to Databricks.
-
Access SuiteCRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SuiteCRM data 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 data.
-
Connect to and Query LeadDesk Data in QlikView over ODBC
Create data visualizations with LeadDesk data in QlikView.
-
Access Todoist Data from MySQL in Amazon QuickSight
Connect to Todoist and build visualizations of Todoist data 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 data 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 data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Workday Data in Aqua Data Studio
Access Workday data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.