CData Software - Knowledge Base
Recent Articles
-
Connect to Smartsheet Data in DBeaver
Use the CData ODBC Driver to connect to Smartsheet data in DBeaver.
-
How to connect PolyBase to YouTube Analytics
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live YouTube Analytics data.
-
Use JayDeBeApi to access Ontraport Data in Python
Use standard Python scripting and the development environment of your choice to access live Ontraport data.
-
How to Connect to Live VWO 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 VWO data for you.
-
Stream Codat Data into Apache Kafka Topics
Access and stream Codat data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query XML Data as a SQL Server Database in Node.js
Execute SQL Server queries against XML data from Node.js.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Wistia
Provide connectivity to Wistia data through an SAP BusinessObjects universe.
-
Connecting Pipedream with Supabase 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 Supabase data in real time.
-
Connect to Zuora Data in CloverDX (formerly CloverETL)
Transfer Zuora data using the visual workflow in the CloverDX data integration tool.
-
How to Use a Microsoft Access Database to Update Office 365 Data in Real Time
Update Office 365 data by creating a linked table in Microsoft Access with the CData Office 365 ODBC Driver.
-
Build Semantic Layer Views for CampaignMonitor Data in APOS Live Data Gateway
Use the CData Connector for CampaignMonitor in APOS Live Data Gateway to build Semantic Layer Views for CampaignMonitor data.
-
Integrate OpenCode with Live Salesforce Data 360 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Salesforce Data 360 data from within your AI coding agent.
-
Visualize Live Qualaroo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Qualaroo data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate PabblySubscriptions Data in the Pentaho Report Designer
Publish reports based on PabblySubscriptions data in the Pentaho BI tool.
-
Build an OLAP Cube in SSAS from Oracle Service Cloud Data
Establish a connection to Oracle Service Cloud data data from SQL Server Analysis Services, and use the Oracle Service Cloud Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Aha! Data in Aqua Data Studio
Access Aha! data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData SSIS Components for Cloudflare
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Cloudflare.
-
Integrate Live LinkedIn Ads Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to LinkedIn Ads data and integrate live LinkedIn Ads data into apps built in Microsoft Power Apps.
-
Load Superchat Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Superchat data to a database.
-
How to Connect to Live Certinia 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 Certinia data for you.
-
Create Reports from Impala Data in Looker Studio
Use CData Connect AI to gain access to live Impala data and create custom reports in Looker Studio.
-
Use Microsoft Copilot Studio to talk to your Google Cloud Storage 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 Google Cloud Storage data for you.
-
Visualize Aha! Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Aha! data into TIBCO Spotfire.
-
Integrate with Optimizely Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Optimizely data in SnapLogic.
-
Work with Live Amazon Marketplace Data in Power Query
Use CData Connect AI to connect to Amazon Marketplace data and work with live Amazon Marketplace data in Microsoft Power Query.
-
Integrating Antigravity CLI with Gorgias data via CData CLI
Connect Gorgias data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Live HBase Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live HBase data from within the IDE.
-
Create Blackbaud FE NXT-Connected Dashboards in Grafana
Connect to Blackbaud FE NXT Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Blackbaud FE NXT data.
-
Create SSAS Tabular Models from Bannerbear Data
How to build a SQL Server Analysis Service Tabular Model from Bannerbear data using CData drivers.
-
Create Dynamic MySQL Grids Using the Infragistics XamDataGrid
Learn how you can connect MySQL to Infragistics XamDataGrid to build dynamic grids.
-
Prepare, Blend, and Analyze Box Data in Alteryx Designer (Connect AI)
Build workflows to access live Box data for self-service data analytics.
-
Easily Integrate Coda Data in Lazarus Pascal IDE
Learn how to easily integrate live Coda data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Paymo from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Paymo data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live Bullhorn CRM Data in AWS Lambda
Connect to live Bullhorn CRM data in AWS Lambda using the CData JDBC Driver.
-
Connect to Power BI XMLA Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Power BI XMLA data using standard SQL.
-
ETL Slack in Oracle Data Integrator
This article shows how to transfer Slack data into a data warehouse using Oracle Data Integrator.
-
Access Live Oracle Financials Cloud Data in Excel 365 Online (Excel for the web)
Connect to Oracle Financials Cloud data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated ConvertKit Data Replication to Teradata
Use CData Sync to Customize and automate ConvertKit data replication to Teradata.
-
How to Visualize OData Services in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live OData services in Python.
-
Query HubSpot Data as a MySQL Database in Node.js
Execute MySQL queries against HubSpot data from Node.js.
-
Integrating Boomi Agentstudio with Moosend Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Moosend data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access SAP ByDesign Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP ByDesign data from HeidiSQL.
-
LINQ to Beeminder 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 Beeminder Data Provider.
-
How to Work with MailerSend Data in ETL Validator JDBC
Connect to MailerSend from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Apps with Live Salesforce Data 360 data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Salesforce Data 360 data into the Adalo platform and build custom mobile and web applications with real-time Salesforce Data 360 data.
-
How to use SQLAlchemy ORM to access Reckon Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Reckon data.
-
Automated Continuous Webflow Replication to MySQL
Use CData Sync for automated, continuous, customizable Webflow replication to MySQL.
-
Access Mailgun Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mailgun data from HeidiSQL.
-
Visualize Live SharePoint Data in the Power BI Service
Use CData Connect AI to connect to live SharePoint data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Validate Amazon Athena Data with QuerySurge
Access and validate Amazon Athena data in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData JDBC Driver for FormSite
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for FormSite.
-
Access Productboard Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Productboard data from your Oracle system.
-
How to Seamlessly Import Scrapfly Data into IBM SPSS Modeler
Integrate Scrapfly data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Microsoft OneLake Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to IBM DB2.
-
Connect to Impala Data in RapidMiner
Integrate Impala data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Cursor with Copper 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.
-
Automated Continuous Kintone Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Kintone replication to delimited files (CSV/TSV).
-
Provide OData Services of SAP Business Warehouse Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Business Warehouse data by developing a WCF Service Application.
-
Access Live Cosmos DB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Cosmos DB data from your Excel spreadsheets.
-
Integrate MarkLogic Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to MarkLogic data and integrate live MarkLogic data into your Power Automate tasks.
-
Integrate SFTP Data in the Pentaho Report Designer
Publish reports based on SFTP data in the Pentaho BI tool.
-
Integrate with Sage Cloud Accounting Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sage Cloud Accounting data in SnapLogic.
-
Connect to Grafana Data in CloverDX (formerly CloverETL)
Transfer Grafana data using the visual workflow in the CloverDX data integration tool.
-
Automate Browserless Data Replication to Azure Data Lake
Use CData Sync to customize and automate Browserless data replication to Azure Data Lake.
-
Visualize Azure Analysis Services Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Azure Analysis Services data into TIBCO Spotfire.
-
Access Live ShipEngine Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ShipEngine data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous MongoDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MongoDB data replication to OneLake in Microsoft Fabric.
-
How to import Paddle Data into Apache Solr
Use the CData Software JDBC Driver for Paddle in Data Import Handler and create an automated import of Paddle data to Apache Solr Enterprise Search platform.
-
Creating Basecamp-Connected Applications in Unqork
You can use CData Connect AI to feed Basecamp data to Unqork and build custom business apps.
-
Integrate Dify with Live Oracle Service Cloud Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Oracle Service Cloud data.
-
How to create an RPA flow for Retently Data in UiPath Studio
Use the Retently ODBC Driver to create workflows that access real-time Retently data without any coding.
-
Build MailerSend-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MailerSend data and build web apps with connectivity to live MailerSend data.
-
Use the CData ODBC Driver for Freshdesk from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Freshdesk to connect to Freshdesk data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Freshdesk data in Excel.
-
Build ZohoMarketingHub-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ZohoMarketingHub Data and create custom apps in Bubble.
-
Create Landbot Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Landbot data access from reports, embedded analytics, and more.
-
Migrating data from PagerDuty to Google BigQuery using CData SSIS Components.
Easily push PagerDuty data to Google BigQuery using the CData SSIS Tasks for PagerDuty and Google BigQuery.
-
Create Vault CRM-Connected Business Apps in AppSheet
Connect to Vault CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Vault CRM data.
-
Automated Continuous Tally Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Tally replication to Apache Kafka.
-
Integrating Cursor with Splunk 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 Build an ETL App for Microsoft Exchange Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft Exchange data in Python with petl and the CData Connect AI Python SDK.
-
Query Live Couchbase 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 Couchbase data directly from the development environment.
-
Choosing the Best Method to Connect Snapchat Ads to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Snapchat Ads data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Dash to Build to Web Apps on OnePageCrm Data
Create Python applications that use pandas and Dash to build OnePageCrm-connected web apps.
-
Seamlessly Bring Google Campaign Manager 360 Data into Retool Using CData Connect AI
Integrate Google Campaign Manager 360 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect Hubstaff Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Hubstaff data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Access PostgreSQL Through an SSH Server (No PuTTY Required): CData PostgreSQL ODBC Driver
Learn how to connect securely to PostgreSQL (e.g., AWS RDS) via an SSH server using the CData PostgreSQL ODBC Driver — no PuTTY or manual port forwarding required.
-
Build Automated Box-Connected Workflows in Zapier
Use CData Connect AI to connect to live Box data and build automated workflows in Zapier.
-
Analyze NetSuite SuiteAnalytics Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of NetSuite SuiteAnalytics data and visualize live NetSuite SuiteAnalytics data in Infragistics Reveal.
-
Connect to ZohoExpense Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZohoExpense data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Getting Started with the CData Excel Add-In for Bitly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Bitly.
-
Visualize Lakebase Data in TIBCO Spotfire through ADO.NET
Integrate Lakebase data into dashboards in TIBCO Spotfire.
-
Use Dash to Build Web Apps on Instagram Data via CData Connect AI
Build interactive Dash web apps on live Instagram data using pandas and the CData Connect AI Python SDK.
-
Integrate Cline with Live GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live GitHub data from within your IDE.
-
Replicate Multiple Instagram Accounts via the CData Sync CLI
Replicate multiple Instagram accounts to one or many databases.
-
Write a Simple Go Application to work with Ontraport Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Ontraport data.
-
Connect to IBM Informix Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for IBM Informix data in Airbyte.
-
Access ClickUp 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 ClickUp data.
-
Create Dynamic Avaza Grids Using the Infragistics XamDataGrid
Learn how you can connect Avaza to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Google's Vertex AI Agent with Live Phoenix 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 Phoenix data within intelligent workflows.
-
Moving Data from Salesforce Pardot to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Salesforce Pardot data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.