CData Software - Knowledge Base
Recent Articles
-
Integrate Real-Time Access to Zendesk in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zendesk data in real time.
-
Integrate Optimizely Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Optimizely data from Informatica Cloud.
-
DataBind Controls to Bannerbear Data in Delphi
DataBind to Bannerbear data in Delphi with standard data access components and controls.
-
Connect to BambooHR Data in Ruby
Connect to BambooHR data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with Live SFTP Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SFTP from the MuleSoft Anypoint Platform to integrate live SFTP data into custom reports and dashboards.
-
Automate Gorgias Data Replication to Azure Data Lake
Use CData Sync to customize and automate Gorgias data replication to Azure Data Lake.
-
How to Create Power BI Visual Reports with Real-Time Mixpanel Data
Use CData Power BI Connectors to visualize Mixpanel data in Power BI.
-
Getting Started with the CData SSIS Components for Coinbase
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Coinbase.
-
Establish a Live Connection with Beeminder Data using Tableau Bridge
The CData ODBC Driver for Beeminder enables you to integrate live Beeminder data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect PolyBase to Access
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Access data.
-
Build a Simple VCL Application for Moosend Data
How to build a simple VCL Application to view Moosend data in RAD Studio using the CData ODBC Driver for Moosend.
-
Getting Started with the CData ODBC Driver for Wistia
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Wistia.
-
Migrating data from Rebilly to Databricks using CData SSIS Components.
Easily push Rebilly data to Databricks using the CData SSIS Tasks for Rebilly and Databricks.
-
Integrating LangChain with GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on GitLab data within automated workflows.
-
How to Access Live Printify Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Printify enables you to integrate Printify data into workflows built using Microsoft Power Automate Desktop.
-
Connect Guru to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Guru data using the CData Python MCP Server.
-
Connect to Testmonitor Data in RapidMiner
Integrate Testmonitor data with standard components and data source configuration wizards in RapidMiner Studio.
-
Publish Zuora-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zuora data.
-
Build Charts with Redshift Data in Clear Analytics
Create dynamic charts and perform analytics based on Redshift data in Clear Analytics.
-
Replicate OneNote Data in Heroku for Use in Salesforce Connect
Replicate OneNote data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to SAP ByDesign Data in Jaspersoft Studio
Execute SQL to remote SAP ByDesign data in Jaspersoft Studio.
-
Getting Started with the CData Python Connector for Jodoo
Learn to install and license the CData Python Connector and configure a connection to live Jodoo data.
-
Analyze Apollo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apollo data with the CData JDBC Driver for Apollo.
-
Create Reports from BenchmarkEmail Data in Looker Studio
Use CData Connect AI to gain access to live BenchmarkEmail data and create custom reports in Looker Studio.
-
How to Build an ETL App for Trello Data in Python with CData Connect AI
Extract and transform live Trello data in Python with petl and the CData Connect AI Python SDK.
-
Access Live Google Search Results 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 Google Search results through MCP integration.
-
Automated Continuous Dynamics CRM Replication to Databricks
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Databricks.
-
How to connect Amazon QuickSight to JSON Services
Create a connection to JSON services in CData Connect AI and insert JSON services into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData ODBC Driver for CockroachDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for CockroachDB to connect to CockroachDB data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CockroachDB data in Excel.
-
Access Live Sentry Data in AWS Lambda
Connect to live Sentry data in AWS Lambda using the CData JDBC Driver.
-
Use Microsoft Copilot Studio to talk to your Microsoft Exchange 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 Microsoft Exchange data for you.
-
Connect to MySQL Data in JRuby
Create a simple JRuby app with access to live MySQL data.
-
Back Up LinkedIn Ads data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for LinkedIn Ads. In this article, we will employ an SSIS workflow to populate a database with LinkedIn Ads data data.
-
Use Azure AI Foundry to Talk to Your Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Okta data for you.
-
Natively Connect to HBase Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to HBase data. Leverage the native support for ODBC in PHP.
-
Rapidly Develop LinkedIn-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 LinkedIn.
-
Automated Continuous LightSpeedRetail Replication to Snowflake
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Snowflake.
-
Automated Continuous Amazon DynamoDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Apache Cassandra.
-
Connect to Unbounce Data in Aqua Data Studio
Access Unbounce data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Access Tanda Data Using Entity Framework
This article shows how to access Tanda data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Seamlessly Import Salesforce Data 360 Data into IBM SPSS Modeler
Integrate Salesforce Data 360 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Link Sendwithus with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sendwithus data in Filemaker Pro for Mac or Windows.
-
How to Visualize MongoDB 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 MongoDB data in Python.
-
Integrate Cursor with Live Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Salesforce CRM Analytics data from within the editor.
-
Access Live Salesforce Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce data from your Excel spreadsheets.
-
Use the CData ODBC Driver for NetSuite in Microsoft Power Query
You can use the CData NetSuite ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import NetSuite data into Microsoft Power Query.
-
Integrating Cursor with SQL Server 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.
-
DataBind Controls to Microsoft Exchange Data in Delphi
DataBind to Microsoft Exchange data in Delphi with standard data access components and controls.
-
Integrating LangGraph with Monday.com Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Monday.com data within automated workflows.
-
Integrate ConstantContact with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ConstantContact with External Services.
-
Build Automated ZohoInvoice-Connected Workflows in Zapier
Use CData Connect AI to connect to live ZohoInvoice data and build automated workflows in Zapier.
-
Analyze Azure DevOps Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Azure DevOps data and visualize live Azure DevOps data in Infragistics Reveal.
-
Integrating Cursor with ZohoMarketingHub 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 Odoo Data from a Connection Pool in Jetty
The Odoo JDBC Driver supports connection pooling: This article shows how to connect faster to Odoo data from Web apps in Jetty.
-
How to Connect DBeaver to SAP Ariba Procurement via a JDBC Driver
Manage SAP Ariba Procurement data with visual tools in DBeaver like the query browser.
-
Import Google Ads Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Ads Data and provide access to live Google Ads data for custom reports in the Power BI Service.
-
How to Connect to & Open YouTube Analytics Data in Microsoft Excel
This article uses the CData ODBC driver for YouTube Analytics to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Claude Code CLI with Vercel 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.
-
Integrate PabblySubscriptions with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PabblySubscriptions with External Services.
-
Create Bitly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Bitly data access from reports, embedded analytics, and more.
-
Use Azure AI Foundry to Talk to Your SAP HANA XS Advanced Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP HANA XS Advanced data for you.
-
Natively Connect to Gorgias Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Gorgias data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Timely Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Timely replication to Apache Cassandra.
-
Build an OLAP Cube in SSAS from DB2 Data
Establish a connection to DB2 data data from SQL Server Analysis Services, and use the DB2 Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate LibreChat with Live Kafka Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Kafka data from within the chat interface.
-
Connect to Chargebee Data in Jaspersoft Studio
Execute SQL to remote Chargebee data in Jaspersoft Studio.
-
Replicate Scrapfly Data from PowerShell
Write a quick PowerShell script to query Scrapfly data. Use connectivity to the live data to replicate Scrapfly data to SQL Server.
-
QuickBooks Online Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on QuickBooks Online facts in real time.
-
How to Connect to Live SendPulse 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 SendPulse data for you.
-
Create Data Visualizations in Cognos BI with Discourse Data
Access Discourse data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Load Omnisend Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Omnisend data to a database.
-
ETL Oracle Eloqua Reporting in Oracle Data Integrator
This article shows how to transfer Oracle Eloqua Reporting data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Drip Replication to Snowflake
Use CData Sync for automated, continuous, customizable Drip replication to Snowflake.
-
Integrating Codex with Couchbase 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.
-
Connecting Mastra with ZohoDesk Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time ZohoDesk data, no replication required.
-
How to connect to Gmail Data with Squirrel SQL client
Connect to Gmail data and execute queries in the Squirrel SQL Client.
-
Connect to PingOne Data from a Connection Pool in JBoss
Integrate PingOne data into Java servlets: Use the Management Console in JBoss to install the PingOne JDBC Driver.
-
Choosing the Best Method to Connect Deel to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Deel data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Microsoft Copilot Studio to talk to your Adobe Commerce 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 Adobe Commerce data for you.
-
How to publish and share Productboard Data dashboards with Tableau Server
The CData ODBC driver for Productboard enables you integrate Productboard data into Tableau dashboards.
-
How to Connect to Live Trello 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 Trello data for you.
-
Visualize Live SendPulse Data in the Power BI Service
Use CData Connect AI to connect to live SendPulse data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access VWO Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access VWO data from your Oracle system.
-
Create Lakebase-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Lakebase Data from Klipfolio and build custom visualizations using live Lakebase data.
-
Integrate with live Neo4J Data in Jitterbit
Use CData Connect AI to connect to and integrate live Neo4J data in Jitterbit.
-
Build Shippo-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Shippo data without replication.
-
Use ChatGPT to Talk to Your Mailjet 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 Mailjet data for you.
-
Access Lakebase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Lakebase data from HeidiSQL.
-
Integrating LangChain with Testmonitor Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Testmonitor data within automated workflows.
-
Integrate Open WebUI with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live eBay data from within the chat interface.
-
Access Live Klaviyo Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Klaviyo data from your Excel spreadsheets.
-
Bridge Quickbase Connectivity with Apache NiFi
Access and process Quickbase data in Apache NiFi using the CData JDBC Driver.
-
Build Automated Optimizely-Connected Workflows in Zapier
Use CData Connect AI to connect to live Optimizely data and build automated workflows in Zapier.
-
Access Google Drive 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 Google Drive data.
-
Consume Freshdesk OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Freshdesk feeds that reflect any changes in SAP Lumira.
-
Visualize Live JSON Services in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live JSON services into custom reports in Power BI.
-
Getting Started with the CData Excel Add-In for Azure DevOps
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure DevOps.
-
Replicate Gorgias Data in Heroku for Use in Salesforce Connect
Replicate Gorgias data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Live Instagram 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 Instagram data for you.
-
How to Query Live Presto Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Presto data data in natural language using Python.