CData Software - Knowledge Base
Recent Articles
-
Connect and Query Live SAP SuccessFactors Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors into Databricks
-
Connect to Greenplum Data in Aqua Data Studio
Access Pivotal GreenPlum from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Model, Search, and Visualize Live ShipStation Data in ThoughtSpot
Use CData Connect AI to connect to live ShipStation for modeling, searching, and visualizing.
-
Query Live HubSpot 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 HubSpot directly from the development environment.
-
Integrate LibreChat with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Twitter Ads from within the chat interface.
-
Connect to Quickbase Data from HeidiSQL
Use CData Connect AI to connect to and query live Quickbase from HeidiSQL.
-
Access Live HBase Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Apache HBase through MCP integration.
-
Integrating LangGraph with Marketo Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Marketo within automated workflows.
-
Replicate Zoom Data to Multiple Databases via the CData Sync CLI
Replicate Zoom to disparate databases with a single configuration.
-
Integrating Claude Code with BigQuery Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google BigQuery within assisted coding and automated development workflows.
-
Create Reports with Pinecone Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pinecone.
-
Automated Continuous Google Search Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Search replication to Apache Cassandra.
-
Working with ChargeOver Data in LINQPad
Execute LINQ queries to ChargeOver in LINQPad.
-
Prepare, Blend, and Analyze Delighted Data in Alteryx Designer (ODBC)
Build workflows to access live Delighted for self-service data analytics.
-
How to Create Power BI Visual Reports with Real-Time Acumatica Data
Use CData Power BI Connectors to visualize Acumatica ERP in Power BI.
-
Build Presto-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Presto to explore live Presto Data in GitHub Copilot to assist with building Presto-powered applications.
-
Integrate Supabase Data in Pentaho Data Integration
Build ETL pipelines based on Supabase in the Pentaho Data Integration tool.
-
Automated Continuous Microsoft Planner Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Apache Cassandra.
-
Integrate Live AlloyDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Integrate SparkPost Data in Pentaho Data Integration
Build ETL pipelines based on SparkPost in the Pentaho Data Integration tool.
-
Integrating Codex CLI with Azure Data Lake Storage 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 Apollo Data from Spring Boot
Connect to Apollo in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Egnyte Replication to MongoDB
Use CData Sync for automated, continuous, customizable Egnyte replication to MongoDB.
-
Query SAS xpt Data in ColdFusion
Write standard ColdFusion data access code to connect to SAS XPORT.
-
Feed Dotmailer Data into FineReport
How to set Dotmailer as a JDBC data source in FineReport.
-
Automate Mouseflow Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Mouseflow and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Write a Simple Go Application to work with Paddle Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Paddle.
-
How to Connect to Drift Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Drift. Leverage the pyodbc module for ODBC in Python.
-
Choosing the Best Method to Connect WooCommerce to SQL Server: 5 Options Explained
Discover multiple ways to connect and use WooCommerce from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate CockroachDB Data in the Pentaho Report Designer
Publish reports based on CockroachDB in the Pentaho BI tool.
-
Access Cvent Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Cvent from HeidiSQL.
-
Migrating data from OData to Snowflake using CData SSIS Components.
Easily push OData to Snowflake using the CData SSIS Tasks for OData and Snowflake.
-
How to create an RPA flow for Nethunt Data in UiPath Studio
Use the Nethunt ODBC Driver to create workflows that access real-time Nethunt without any coding.
-
Build SAP Ariba Procurement Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Ariba Procurement and build visualizations in Tableau.
-
Connect to Outlook Data in Jaspersoft Studio
Execute SQL to remote Outlook in Jaspersoft Studio.
-
Integrating Claude Code with WordPress Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on WordPress within assisted coding and automated development workflows.
-
Analyze OData Services in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of OData and visualize the live Services in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Live SAP Hybris C4C Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Hybris C4C and integrate live SAP Hybris C4C into apps built in Microsoft Power Apps.
-
Working with Cvent Data in LINQPad
Execute LINQ queries to Cvent in LINQPad.
-
How to Access LionDesk Data Using Entity Framework
This article shows how to access LionDesk using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to PhantomBuster Data in DBeaver
Use the CData ODBC Driver to connect to PhantomBuster in DBeaver.
-
Model SAP Netweaver Gateway Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Netweaver Gateway, enabling the direct import of real-time SAP Netweaver Gateway.
-
Access Live Adobe Analytics Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Adobe Analytics from your Excel spreadsheets.
-
Migrating data from MailerLite to Google BigQuery using CData SSIS Components.
Easily push MailerLite to Google BigQuery using the CData SSIS Tasks for MailerLite and Google BigQuery.
-
Build Sage Cloud Accounting-Connected Apps in Choreo
Use CData Connect AI to connect to Sage Cloud Accounting Data from Choreo and build custom apps using live Sage Business Cloud Accounting.
-
Build Data Flows from Mailjet to SQL Server using SSIS
Easily back up Mailjet to SQL Server using the SSIS components for Mailjet.
-
Access Live CockroachDB Data in Excel 365 Online (Excel for the web)
Connect to CockroachDB from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software JDBC Driver for CockroachDB in MicroStrategy Desktop
Connect to CockroachDB in MicroStrategy Desktop using the CData Software JDBC Driver for CockroachDB.
-
Automated Continuous Sage Cloud Accounting Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Apache Cassandra.
-
Analyze Pinecone Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Pinecone with the CData JDBC Driver for Pinecone.
-
Connect to CircleCI Data in Ruby
Connect to CircleCI in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating Cursor CLI with Gorgias 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.
-
Work with Live MarkLogic Data in Power Query
Use CData Connect AI to connect to MarkLogic and work with live MarkLogic in Microsoft Power Query.
-
Access Amazon Marketplace 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 Amazon Marketplace.
-
Consume Clockify OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Clockify feeds that reflect any changes in SAP Lumira.
-
How to create TaxJar federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for TaxJar in MySQL .
-
Perform Batch Operations with HubSpot Data in Apache NiFi
Connect to HubSpot and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Migrating data from Adobe Commerce to Databricks using CData SSIS Components.
Easily push Adobe Commerce to Databricks using the CData SSIS Tasks for Adobe Commerce and Databricks.
-
Access Live HBase Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live HBase data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Query Shopify Data as a MySQL Database in Node.js
Execute MySQL queries against Shopify from Node.js.
-
Create Apps from SAS xpt Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAS xpt Data and build apps from live SAS XPORT in Qlik Sense Cloud.
-
Visualize MarkLogic Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MarkLogic.
-
How to connect PolyBase to GitLab
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live GitLab.
-
How to Connect to Live SAS xpt Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAS XPORT without replication.
-
Connect to Cloudflare Data from a Connection Pool in Jetty
The Cloudflare JDBC Driver supports connection pooling: This article shows how to connect faster to Cloudflare from Web apps in Jetty.
-
Connect to Hugging Face from a Connection Pool in WebLogic
Use the CData JDBC Driver for Hugging Face to connect to Hugging Face from Web applications running on WebLogic.
-
Connect to NetSuite Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for NetSuite CRM & ERP in Airbyte.
-
How to publish and share ElevenLabs Data dashboards with Tableau Server
The CData ODBC driver for ElevenLabs enables you integrate ElevenLabs into Tableau dashboards.
-
How to Connect to Live MySQL 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 MySQL for you.
-
Connect to SQL Server Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SQL Server and the SQL Gateway to access Microsoft SQL Server from Google Apps Script.
-
Build Microsoft Teams Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Teams and build visualizations in Tableau.
-
Query Rebilly Data as a MySQL Database in Node.js
Execute MySQL queries against Rebilly from Node.js.
-
Manage ADP Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ADP.
-
How to Connect to & Open Testmonitor Data in Microsoft Excel
This article uses the CData ODBC driver for Testmonitor to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect Coda to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Coda using the CData Python MCP Server.
-
Access Live SendPulse Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SendPulse data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Hive Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Hive Data and connect to Apache Hive in Akorbi Digital RunMyProcess.
-
Integrating Claude Code CLI with SAP BusinessObjects BI 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.
-
Enable the Strava JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Strava.
-
Visualize JSON Services in Tableau
The CData ODBC driver for JSON enables you integrate JSON into Tableau dashboards.
-
Getting Started with the CData SSIS Components for Mailjet
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mailjet.
-
Build Dashboards with Browserless Data in Dundas BI
Create dynamic dashboards and perform analytics based on Browserless in Dundas BI.
-
How to connect to OData Services in DBVisualizer
Integrate OData with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Dynamics 365 Business Central Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Apache Cassandra.
-
How to Connect to Zoom Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoom. Leverage the pyodbc module for ODBC in Python.
-
Visualize QuickBooks Online Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to QuickBooks Online.
-
Add Telegram Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Telegram with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Coda Data from PowerBuilder via ADO.NET
This article demonstrates how to access Coda from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to SAP Ariba Source Data in Ruby
Connect to SAP Ariba Source in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Data Visualizations in Cognos BI with Bugsnag Data
Access Bugsnag as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Datasets from SendPulse in Domo Workbench and Build Visualizations of SendPulse Data in Domo
Use the CData Software ODBC Driver for SendPulse to create datasets from SendPulse in Domo Workbench and then build visualizations in the Domo service.
-
Query IBM Informix Data from Node.js
Use the OData endpoint of the CData API Server to connect to your IBM Informix and perform CRUD operations on IBM Informix from Node.js.
-
Query Exa Data in ColdFusion
Write standard ColdFusion data access code to connect to Exa.
-
How to Connect to Live WordPress Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live WordPress without replication.
-
Analyze Twitter Ads Data in Looker
Use CData Connect AI to connect to Twitter Ads Data from Looker and build custom apps using live Twitter Ads.
-
Feed SAP SuccessFactors LMS Data into FineReport
How to set SAP SuccessFactors LMS as a JDBC data source in FineReport.
-
Getting Started with the CData SSIS Components for Stripe
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Stripe.
-
Integrate Real-Time Access to Factorial in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Factorial in real time.
-
Visualize Live ADP Data in the Power BI Service
Use CData Connect AI to connect to live ADP and create custom reports in the Power BI Service through the On-Premises Gateway.
-
A PostgreSQL Interface for Moosend Data using the CData ODBC Driver
Use the SQL Gateway and Moosend ODBC Driver to create a PostgreSQL entry-point for data access.