CData Software - Knowledge Base
Recent Articles
-
Publish Samanage-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Samanage data.
-
How to connect to Perigon Data with Squirrel SQL client
Connect to Perigon data and execute queries in the Squirrel SQL Client.
-
LINQ to Grafana 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 Grafana Data Provider.
-
Connect to SFTP Data from a Connection Pool in JBoss
Integrate SFTP data into Java servlets: Use the Management Console in JBoss to install the SFTP JDBC Driver.
-
Integrate Cloudflare Data in the Pentaho Report Designer
Publish reports based on Cloudflare data in the Pentaho BI tool.
-
Connect to Ontraport Data from a Connection Pool in Jetty
The Ontraport JDBC Driver supports connection pooling: This article shows how to connect faster to Ontraport data from Web apps in Jetty.
-
Migrating data from Front to Google BigQuery using CData SSIS Components.
Easily push Front data to Google BigQuery using the CData SSIS Tasks for Front and Google BigQuery.
-
Integrate Open WebUI with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Vault CRM data from within the chat interface.
-
Integrate WordPress Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live WordPress data from Informatica Cloud.
-
Use Dash to Build Web Apps on HubDB Data via CData Connect AI
Build interactive Dash web apps on live HubDB data using pandas and the CData Connect AI Python SDK.
-
Getting Started with the CData ADO.NET Provider for Parallel
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Import ADP Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ADP Data and provide access to live ADP data for custom reports in the Power BI Service.
-
Prepare, Blend, and Analyze Databricks Data in Alteryx Designer (Connect AI)
Build workflows to access live Databricks data for self-service data analytics.
-
Migrating data from ScrapingBee to Databricks using CData SSIS Components.
Easily push ScrapingBee data to Databricks using the CData SSIS Tasks for ScrapingBee and Databricks.
-
Integrating Cursor with Parquet 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 Tavily Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Tavily data and visualize Tavily data in SAP Analytics Cloud.
-
How to Access Live Microsoft Planner Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Microsoft Planner enables you to integrate Microsoft Planner data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Sage 200 Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sage 200 replication to AlloyDB.
-
Automated ShipEngine Data Replication to Teradata
Use CData Sync to Customize and automate ShipEngine data replication to Teradata.
-
Build Data Flows from ConvertAPI to SQL Server using SSIS
Easily back up ConvertAPI data to SQL Server using the SSIS components for ConvertAPI.
-
Analyze DocuSign Data in Looker
Use CData Connect AI to connect to DocuSign Data from Looker and build custom apps using live DocuSign data.
-
Getting Started with the CData Python Connector for Salesforce CRM Analytics
Learn to install and license the CData Python Connector and configure a connection to live Salesforce CRM Analytics data.
-
Automated Continuous Templated Replication to MongoDB
Use CData Sync for automated, continuous, customizable Templated replication to MongoDB.
-
Consume Zendesk OData Feeds in PowerBuilder
This article demonstrates how to consume Zendesk data as OData feeds from PowerBuilder using the API Server.
-
Integrate Open WebUI with Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Elasticsearch data from within the chat interface.
-
Connect to ServiceNow Data in RapidMiner
Integrate ServiceNow data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Reports from Adobe Commerce Data in Looker Studio
Use CData Connect AI to gain access to live Adobe Commerce data and create custom reports in Looker Studio.
-
Visualize Cohere 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 Cohere data into TIBCO Spotfire.
-
Automated PhantomBuster Data Replication to Teradata
Use CData Sync to Customize and automate PhantomBuster data replication to Teradata.
-
Connect to and Query SAP Business One Data in QlikView over ODBC
Create data visualizations with SAP Business One data in QlikView.
-
Creating OneNote-Connected Applications in Unqork
You can use CData Connect AI to feed OneNote data to Unqork and build custom business apps.
-
Model, Search, and Visualize Live Salesforce Data 360 Data in ThoughtSpot
Use CData Connect AI to connect to live Salesforce Data 360 data for modeling, searching, and visualizing.
-
Automated Continuous Dynamics 365 Business Central Replication to Oracle
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Oracle.
-
Build Grafana-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Grafana data.
-
Integrating Antigravity CLI with Adobe Target data via CData CLI
Connect Adobe Target data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Seamlessly Bring Workday Data into Retool Using CData Connect AI
Integrate Workday data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Typeform-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Typeform data.
-
Integrate Live Azure Analysis Services Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Azure Analysis Services data and integrate live Azure Analysis Services data into apps built in Microsoft Power Apps.
-
Query Short.io Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Short.io data from Node.js.
-
How to connect SharePoint with HubDB Data through external lists
Provide HubDB data to SharePoint users as an external list.
-
How to create an RPA flow for Printful Data in UiPath Studio
Use the Printful ODBC Driver to create workflows that access real-time Printful data without any coding.
-
Access Live Couchbase 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 Couchbase data through MCP integration.
-
Connect MySQL to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MySQL data using the CData Python MCP Server.
-
Visualize Paddle 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 Paddle data into TIBCO Spotfire.
-
How to Create Power BI Visual Reports with Real-Time LinkedIn Data
Use CData Power BI Connectors to visualize LinkedIn data in Power BI.
-
Connect to ShipStation Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ShipStation Data and connect to ShipStation data in Akorbi Digital RunMyProcess.
-
Analyze Jumpseller Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Jumpseller data and visualize Jumpseller data in SAP Analytics Cloud.
-
How to Connect to & Open Google Directory Data in Microsoft Excel
This article uses the CData ODBC driver for Google Directory to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect to Gorgias Data in DBVisualizer
Integrate Gorgias data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Cursor with Live Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Ads data from within the editor.
-
Explore Geographical Relationships in Teradata Data with Power Map
Create data visualizations with Teradata data in Power Map.
-
Access Live FreshBooks Data in AWS Lambda
Connect to live FreshBooks data in AWS Lambda using the CData JDBC Driver.
-
Query Omnisend Data as a MySQL Database in Node.js
Execute MySQL queries against Omnisend data from Node.js.
-
Access Live Certinia 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 Certinia data through MCP integration.
-
Query Chargebee Data in DataGrip
Create a Data Source for Chargebee in DataGrip and use SQL to query live Chargebee data.
-
Build Data Flows from SQL Server to Salesloft through SSIS
Easily push SQL Server data to Salesloft using the CData SSIS Tasks for Salesloft.
-
Getting Started with the CData Excel Add-In for RabbitMQ
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for RabbitMQ.
-
Integrate with Teradata Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Teradata data in SnapLogic.
-
DataBind Controls to Oracle SCM Data in C++Builder
DataBind to Oracle SCM data in C++Builder with standard components and controls.
-
How to use SQLAlchemy ORM to access SpaceX Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SpaceX data.
-
Integrate Live Printify Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Printify data and integrate live Printify data into apps built in Microsoft Power Apps.
-
Automated Continuous Auth0 Replication to Snowflake
Use CData Sync for automated, continuous, customizable Auth0 replication to Snowflake.
-
How to connect to Opsgenie Data from IntelliJ
Integrate connectivity to Opsgenie data with wizards in IntelliJ.
-
Create Power BI Reports on Real-Time Gorgias Data
Use the CData ODBC Driver for Gorgias to visualize Gorgias data in Power BI Desktop.
-
Connect PabblySubscriptions to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PabblySubscriptions with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Live Microsoft OneDrive Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft OneDrive data to Blue Prism using the CData ODBC Driver for Microsoft OneDrive to create automated workflows for repetitive business tasks.
-
Build Pipelines with Live eBay Analytics Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to eBay Analytics from Google Cloud Data Fusion, enabling the integration of live eBay Analytics data into the building and management of effective data pipelines.
-
Process & Analyze Zendesk Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zendesk Data.
-
Connect to CockroachDB Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with CockroachDB Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Microsoft Entra ID Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Entra ID data from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Entra ID.
-
Build Salesforce Marketing-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Salesforce Marketing data and build Salesforce Marketing-connected web apps with Axios.
-
Connect to Vimeo Data in CloverDX (formerly CloverETL)
Transfer Vimeo data using the visual workflow in the CloverDX data integration tool.
-
Natively Connect to PayPal Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PayPal data. Leverage the native support for ODBC in PHP.
-
Connect to Marketo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Marketo data using standard SQL.
-
Automated Continuous Zuora Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zuora replication to Snowflake.
-
Integrate Real-Time Access to Azure Table in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure Table data in real time.
-
How to work with PingOne Data in Apache Spark using SQL
Access and process PingOne Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Retently Data to Multiple Databases
Replicate Retently data to disparate databases with a point-and-click configuration.
-
Integrate Dify with Live Google Ad Manager 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 Google Ad Manager data.
-
Build Charts with Campaigner Data in Clear Analytics
Create dynamic charts and perform analytics based on Campaigner data in Clear Analytics.
-
Create HubDB-Connected Dashboards in Grafana
Connect to HubDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to HubDB data.
-
Integrating Claude Code CLI with CouchDB 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Tickspot
Provide connectivity to Tickspot data through an SAP BusinessObjects universe.
-
Query SparkPost Data as a MySQL Database in Node.js
Execute MySQL queries against SparkPost data from Node.js.
-
Integrate with SageHR Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SageHR data to a JSON file on disk.
-
Use Manus AI to Talk to Your SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on SendGrid data.
-
Create a Data Access Object for Insightly Data using JDBI
A brief overview of creating a SQL Object API for Insightly data in JDBI.
-
Access Live Sybase Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sybase data from your Excel spreadsheets.
-
How to create PagerDuty federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for PagerDuty data in MySQL .
-
Connect to ZohoDesk Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZohoDesk data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Google Contacts Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Contacts data.
-
Create Data Visualizations Based On HubDB Data in Mode
Use CData Connect AI to connect to HubDB Data from Mode and build visualizations using live HubDB data.
-
Integrate LibreChat with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Monday.com data from within the chat interface.
-
Integrating Boomi Agentstudio with GitLab Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to GitLab data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect NetSuite SuiteAnalytics Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live NetSuite SuiteAnalytics data in real time using natural language.
-
Integrate Bitbucket with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Bitbucket with External Services.
-
Integrating Kiro with Productboard 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.
-
View Reports on Real-Time Google Sheets Data in Power BI Report Server
Use the CData ODBC Driver for Google Sheets to visualize Google Sheets data in Power BI Desktop and then publish them to Power BI Report Server.
-
Bind Live Databricks Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Databricks data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Configure the CData JDBC Driver for ZohoExpense in a Connection Pool in Tomcat
Connect to ZohoExpense data from a connection pool in Tomcat.