CData Software - Knowledge Base
Recent Articles
-
Integrate Live Google Cloud Storage Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Cloud Storage from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Cloud Storage data.
-
Publish Reports with Missive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Missive data.
-
Connect to Jira Assets Data in CloverDX (formerly CloverETL)
Transfer Jira Assets data using the visual workflow in the CloverDX data integration tool.
-
How to work with ZohoDesk Data in Apache Spark using SQL
Access and process ZohoDesk Data in Apache Spark using the CData Software JDBC Driver.
-
Build Data Flows from MailerLite to SQL Server using SSIS
Easily back up MailerLite data to SQL Server using the SSIS components for MailerLite.
-
Import Real-Time Trello Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Trello data in ColdFusion.
-
DataBind Snapchat Ads Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Snapchat Ads with the DevExpress Windows Forms and Web controls to provide Snapchat Ads data to a chart.
-
Object-Relational Mapping (ORM) with Sentry Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Sentry data into a Java-based ORM framework, Hibernate.
-
Build MVC Applications with Connectivity to Drip Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Drip from an ASP.NET MVC application.
-
Import Real-Time Grafana Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Grafana data in ColdFusion.
-
Connect to AgileCRM Data in DBeaver
Use the CData ODBC Driver to connect to AgileCRM data in DBeaver.
-
Getting Started with the CData Excel Add-In for MongoDB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MongoDB.
-
Access Couchbase Data from MySQL in PHP
Connect to Couchbase through the standard MySQL libraries in PHP.
-
How to connect to ConvertAPI Data with Squirrel SQL client
Connect to ConvertAPI data and execute queries in the Squirrel SQL Client.
-
Connect to SAP HANA XS Advanced Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP HANA XS Advanced Data and connect to SAP HANA XS Advanced data in Akorbi Digital RunMyProcess.
-
Automated Continuous Klipfolio Replication to Vertica
Use CData Sync for automated, continuous, customizable Klipfolio replication to Vertica.
-
Bridge Superchat Connectivity with Apache NiFi
Access and process Superchat data in Apache NiFi using the CData JDBC Driver.
-
Query Humanity Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Humanity data from Node.js.
-
Integrate LibreChat with Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Cosmos DB data from within the chat interface.
-
How to Connect to Live SuiteCRM Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SuiteCRM data through natural language.
-
Connect to Paylocity Data from a Connection Pool in Jetty
The Paylocity JDBC Driver supports connection pooling: This article shows how to connect faster to Paylocity data from Web apps in Jetty.
-
Integrate Google's Antigravity Agent with Live Shippo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Shippo data using the Model Context Protocol.
-
Connect SAP HANA XS Advanced to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP HANA XS Advanced data using the CData Python MCP Server.
-
Visualize Oracle HCM Cloud 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 Oracle HCM Cloud data into TIBCO Spotfire.
-
Connecting Mastra with MariaDB 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 MariaDB data, no replication required.
-
Integrating Claude Code CLI with Microsoft Exchange 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.
-
Design BIRT Reports on Helpscout Data
Provide current Helpscout data to your embedded analytics.
-
How to Connect to & Open PolarTeamPro Data in Microsoft Excel
This article uses the CData ODBC driver for PolarTeamPro to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use JayDeBeApi to access Amazon Marketplace Data in Python
Use standard Python scripting and the development environment of your choice to access live Amazon Marketplace data.
-
Getting Started with the CData Power BI Connector for Helpscout
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Connect to Live ZohoDesk 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 ZohoDesk data for you.
-
Explore Geographical Relationships in Greenplum Data with Power Map
Create data visualizations with Greenplum data in Power Map.
-
Integrate Real-Time Access to Databricks in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Databricks data in real time.
-
Create Zuora-Connected Dashboards in Grafana
Connect to Zuora Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zuora data.
-
Create Informatica Mappings From/To a JDBC Data Source for Mistral AI
Create Mistral AI data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Webflow Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Webflow and work with Webflow data in your FileMaker application.
-
How to Connect QuickBooks Time 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 QuickBooks Time data in real time using natural language.
-
Connect to Live Salesforce CRM Analytics Data in MicroStrategy through CData Connect AI
Create a live connection to Salesforce CRM Analytics Data in CData Connect AI and connect to your Salesforce CRM Analytics data from MicroStrategy.
-
ETL ADP in Oracle Data Integrator
This article shows how to transfer ADP data into a data warehouse using Oracle Data Integrator.
-
Use Agno to Talk to Your Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Azure Data Lake Storage data for you.
-
Integrating Cursor with ZeroBounce 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 Real-Time Access to Redshift in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Redshift data in real time.
-
Access Live SAP Ariba Source Data in Excel 365 Online (Excel for the web)
Connect to SAP Ariba Source data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData Excel Add-In for AfterShip
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for AfterShip.
-
Establish a Live Connection with Invoiced Data using Tableau Bridge
The CData ODBC Driver for Invoiced enables you to integrate live Invoiced data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Live TaxJar Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live TaxJar data to Blue Prism using the CData ODBC Driver for TaxJar to create automated workflows for repetitive business tasks.
-
Connect to Google Contacts Data in JRuby
Create a simple JRuby app with access to live Google Contacts data.
-
Build QuickBooks-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live QuickBooks data and build QuickBooks-connected web apps with Axios.
-
Create Google Calendar-Connected Dashboards in Grafana
Connect to Google Calendar Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Calendar data.
-
Visualize Live ZeroBounce Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZeroBounce data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Templated Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Templated data in Microsoft R Open.
-
Integrate Live ElevenLabs Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ElevenLabs data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create SSAS Tabular Models from AlloyDB Data
How to build a SQL Server Analysis Service Tabular Model from AlloyDB data using CData drivers.
-
Access Deel Data from MySQL in Amazon QuickSight
Connect to Deel and build visualizations of Deel data using a MySQL Connection in Amazon QuickSight.
-
Build Dashboards with AdRoll Data in DBxtra
Create dynamic dashboards and perform analytics based on AdRoll data in DBxtra.
-
Build Pipelines with Live Exact Online Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Exact Online from Google Cloud Data Fusion, enabling the integration of live Exact Online data into the building and management of effective data pipelines.
-
View Reports on Real-Time Azure DevOps Data in Power BI Report Server
Use the CData ODBC Driver for Azure DevOps to visualize Azure DevOps data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Semantic Layer Views for Zoho Projects Data in APOS Live Data Gateway
Use the CData Connector for Zoho Projects in APOS Live Data Gateway to build Semantic Layer Views for Zoho Projects data.
-
Build Automated Workflows with Live Bright Data Data in Workato
Use CData Connect AI to connect to live Bright Data data and build automated workflows in Workato.
-
Integrate Open WebUI with Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Analytics data from within the chat interface.
-
Connect SharePoint to SQL Server through SSIS
Easily back-up SharePoint data to SQL Server using the SharePoint Data Provider for ADO.NET. This example uses an SSIS workflow to populate a database with SharePoint data using the SharePoint ADO.NET Data Provider.
-
Create Data Visualizations in Cognos BI with JotForm Data
Access JotForm data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to publish and share Teamwork Data dashboards with Tableau Server
The CData ODBC driver for Teamwork enables you integrate Teamwork data into Tableau dashboards.
-
Create Informatica Mappings From/To a JDBC Data Source for Anaplan
Create Anaplan data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate OpenCode with Live HBase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live HBase data from within your AI coding agent.
-
How to Query Gong Data in MySQL Workbench
Execute MySQL queries against live Gong data from MySQL Workbench.
-
How to connect to Asana Data with Squirrel SQL client
Connect to Asana data and execute queries in the Squirrel SQL Client.
-
Access Live Excel Online Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Excel Online data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Voice Agents in ElevenLabs with access to Live Microsoft Exchange Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Exchange data.
-
How to Work with ElevenLabs Data in ETL Validator JDBC
Connect to ElevenLabs from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to PabblySubscriptions Data in JRuby
Create a simple JRuby app with access to live PabblySubscriptions data.
-
Integrate with Live XML Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to XML from the MuleSoft Anypoint Platform to integrate live XML data into custom reports and dashboards.
-
Visualize OnePageCrm 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 OnePageCrm data into TIBCO Spotfire.
-
Access Neo4J Data from MySQL in PHP
Connect to Neo4J through the standard MySQL libraries in PHP.
-
Integrating Kiro with xBase 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 BigCommerce Replication to AlloyDB
Use CData Sync for automated, continuous, customizable BigCommerce replication to AlloyDB.
-
Query SAP HANA XS Advanced Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP HANA XS Advanced entities in PHP by modeling them as objects.
-
Automated Continuous YouTube Analytics Replication to SQLite
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to SQLite.
-
Build Automated Smartsheet-Connected Workflows in Zapier
Use CData Connect AI to connect to live Smartsheet data and build automated workflows in Zapier.
-
How to Connect to Live Zoho Creator Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Zoho Creator data for you.
-
Connect to Oracle Data in RazorSQL
Connect to Oracle from wizards and query Oracle data from the GUI in the RazorSQL database management tool.
-
Connect to Real-Time WooCommerce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for WooCommerce and Dataflow to import and use WooCommerce data in Power Apps.
-
Work with Live SAP Business One Data in Power Query
Use CData Connect AI to connect to SAP Business One data and work with live SAP Business One data in Microsoft Power Query.
-
Integrate with live Apollo Data in Jitterbit
Use CData Connect AI to connect to and integrate live Apollo data in Jitterbit.
-
Automated Continuous SharePoint Excel Services Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Google BigQuery.
-
Build LinkedIn-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live LinkedIn data and build LinkedIn-connected web apps with Axios.
-
Use the CData Software ODBC Driver for Factorial in MicroStrategy Desktop
Connect to Factorial data in MicroStrategy Desktop using the CData Software ODBC Driver for Factorial.
-
Connect to Pushbullet Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Pushbullet data in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData ODBC Driver for Email
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Email.
-
Getting Started with the CData ADO.NET Provider for PayPal
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for PayPal.
-
Access Live Outreach.io Data in Coginiti Pro
Connect to and query live Outreach.io data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect Amazon DynamoDB 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 Amazon DynamoDB data in real time using natural language.
-
Integrating Claude Code CLI with AlloyDB 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 Use a Microsoft Access Database to Update HubSpot Data in Real Time
Update HubSpot data by creating a linked table in Microsoft Access with the CData HubSpot ODBC Driver.
-
Provide OData Services of Opsgenie Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Opsgenie data by developing a WCF Service Application.
-
Visualize Live Google Tasks Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Tasks data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Tableau Connector for XML
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for XML.
-
Use Grok to Talk to Your Stripe 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 Stripe data for you.
-
Automated Continuous Placid Replication to Oracle
Use CData Sync for automated, continuous, customizable Placid replication to Oracle.
-
How to create an RPA flow for CockroachDB Data in UiPath Studio
Use the CockroachDB ODBC Driver to create workflows that access real-time CockroachDB data without any coding.