CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Connect AI Python SDK for MySQL
Install the CData Connect AI Python SDK to read and write live MySQL data with standard DB-API 2.0 Python code.
-
Integrate Google's Vertex AI Agent with Live IBM Informix 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 IBM Informix data within intelligent workflows.
-
Validate Aweber Data with QuerySurge
Access and validate Aweber data in QuerySurge using the CData JDBC Driver.
-
Integrating GitHub Copilot with Guru 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.
-
Deploy the ADO.NET Provider for Paddle on an SSRS Report Server
Connect to Paddle data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build Charts with Aircall Data in Clear Analytics
Create dynamic charts and perform analytics based on Aircall data in Clear Analytics.
-
How to Use a Microsoft Access Database to Update SFTP Data in Real Time
Update SFTP data by creating a linked table in Microsoft Access with the CData SFTP ODBC Driver.
-
Build a Simple VCL Application for GitLab Data
How to build a simple VCL Application to view GitLab data in RAD Studio using the CData ODBC Driver for GitLab.
-
Create ShipEngine-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ShipEngine Data from OutSystems and build custom enterprise apps using live ShipEngine data.
-
Search External Bright Data Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Bright Data data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Bright Data Data objects that you can access from apps and the dashboard.
-
Use Dash to Build to Web Apps on Pipedrive Data
Create Python applications that use pandas and Dash to build Pipedrive-connected web apps.
-
How to update WooCommerce from Excel
This article explains how to transfer data from Excel to WooCommerce using the Excel Add-In for WooCommerce.
-
Connect to Teamgate Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Teamgate to connect to Teamgate data and execute queries in PowerBuilder.
-
Visualize Everhour Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Everhour data.
-
Automated Continuous Microsoft Planner Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to MongoDB.
-
How to Query Moosend Data in MySQL Workbench
Execute MySQL queries against live Moosend data from MySQL Workbench.
-
Work with Snapchat Ads Data in FoxPro
Load Snapchat Ads data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData ODBC Driver for NASA
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for NASA.
-
Build Dashboards with PostgreSQL Data in DBxtra
Create dynamic dashboards and perform analytics based on PostgreSQL data in DBxtra.
-
Connect to Zoho Inventory from Asprova with CData Software ODBC Driver for Zoho Inventory
This article shows how to connect faster to Zoho Inventory data from Asprova.
-
Create TaxJar-Connected Business Apps in AppSheet
Connect to TaxJar Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to TaxJar data.
-
Integrate Adobe Target Data in Pentaho Data Integration
Build ETL pipelines based on Adobe Target data in the Pentaho Data Integration tool.
-
Build Apps with Live Anaplan data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Anaplan data into the Adalo platform and build custom mobile and web applications with real-time Anaplan data.
-
Automated Continuous Microsoft Entra ID Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to delimited files (CSV/TSV).
-
Integrate Goose with Live Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Authorize.Net data from within the local AI agent.
-
Connect to and Visualize Live LinkedIn Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LinkedIn data.
-
Author and Share Power BI Reports on Live Google BigQuery Data
Use the CData ODBC Driver for Google BigQuery to visualize BigQuery data in Power BI Desktop and then upload to the Power BI service.
-
Connect to Oracle Sales Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle Sales and the SQL Gateway to access Oracle Sales data from Google Apps Script.
-
Create Reports with Strava Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Strava data.
-
Create Power BI Reports on Real-Time GitHub Data
Use the CData ODBC Driver for GitHub to visualize GitHub data in Power BI Desktop.
-
Access Google Drive Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Drive data from your Oracle system.
-
Connect to LDAP Objects as an External Source in Dremio
Use the CData JDBC Driver to connect to LDAP as an External Source in Dremio.
-
How to Connect Klipfolio 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 Klipfolio data in real time using natural language.
-
How to Connect to Live GitLab Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your GitLab data for you.
-
Natively Connect to GetResponse Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to GetResponse data. Leverage the native support for ODBC in PHP.
-
Integrate with live DB2 Data in Jitterbit
Use CData Connect AI to connect to and integrate live DB2 data in Jitterbit.
-
Connect to MongoDB Data from Crystal Reports
Use CData Connect AI to connect to and report on live MongoDB data from Crystal Reports.
-
Load FHIR Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load FHIR data to a database.
-
Use JayDeBeApi to access LightSpeedRetail Data in Python
Use standard Python scripting and the development environment of your choice to access live LightSpeedRetail data.
-
Excel Spreadsheet Automation on CloudConvert Data with the QUERY Formula
Pull data from CloudConvert, automate spreadsheets, and more with the QUERY formula.
-
Migrating data from PolarTeamPro to Databricks using CData SSIS Components.
Easily push PolarTeamPro data to Databricks using the CData SSIS Tasks for PolarTeamPro and Databricks.
-
Connect to Couchbase Data from PowerBuilder via JDBC
This article demonstrates how to access Couchbase data from PowerBuilder using the Couchbase JDBC Driver.
-
Connect Aircall to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Aircall with IBM WebSphere for seamless data integration and connectivity.
-
Replicate MailerLite Data from PowerShell
Write a quick PowerShell script to query MailerLite data. Use connectivity to the live data to replicate MailerLite data to SQL Server.
-
Query Box Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Box entities in PHP by modeling them as objects.
-
Connect to TaxJar Data in HULFT Integrate
Connect to TaxJar as a JDBC data source in HULFT Integrate
-
Automated Continuous OpenWeatherMap Replication to Databricks
Use CData Sync for automated, continuous, customizable OpenWeatherMap replication to Databricks.
-
Import Real-Time Jira Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Jira data in ColdFusion.
-
Access Live Recurly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Recurly data into the statistical analysis tools available in SAS JMP. This article shows how to use Recurly data in the Graph Builder and Query Builder.
-
Trigger SAP Netweaver Gateway IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAP Netweaver Gateway with standard wizards in Logic Apps.
-
Query SAS xpt Data as a MySQL Database in Node.js
Execute MySQL queries against SAS xpt data from Node.js.
-
Enable the Raisers Edge NXT JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Raisers Edge NXT data.
-
Build Voice Agents in ElevenLabs with access to Live Snowflake Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Snowflake data.
-
How to Seamlessly Import OpenWeatherMap Data into IBM SPSS Modeler
Integrate OpenWeatherMap data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect SharePoint with RSS Feeds through external lists
Provide RSS feeds to SharePoint users as an external list.
-
How to Connect to Live Blackbaud FE NXT Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Blackbaud FE NXT data without replication.
-
Use Biml to Build SSIS Tasks to Replicate Redis Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Redis data to SQL Server.
-
How to Connect to & Open Rootly Data in Microsoft Excel
This article uses the CData ODBC driver for Rootly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Sentry Data to Multiple Databases via the CData Sync CLI
Replicate Sentry data to disparate databases with a single configuration.
-
Interact with Live BenchmarkEmail Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live BenchmarkEmail data.
-
Access Live SFTP Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SFTP data from your Google Sheets.
-
Use Agno to Talk to Your Paylocity 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 Paylocity data for you.
-
Connect and Query Live Yelp Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Yelp data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Mouseflow Data in the Pentaho Report Designer
Publish reports based on Mouseflow data in the Pentaho BI tool.
-
Integrate Real-Time Access to Microsoft Dataverse in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Dataverse data in real time.
-
Publish Sybase IQ-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sybase IQ data.
-
Connect to GitLab Data in DBArtisan
Use wizards in DBArtisan to configure GitLab data as a data source.
-
How to import Cloudant Data into Apache Solr
Use the CData Software JDBC Driver for Cloudant in Data Import Handler and create an automated import of Cloudant data to Apache Solr Enterprise Search platform.
-
Connect to Apollo Data in HULFT Integrate
Connect to Apollo as a JDBC data source in HULFT Integrate
-
How to connect Amazon QuickSight to Zendesk Data
Create a connection to Zendesk data in CData Connect AI and insert Zendesk data into Amazon QuickSight SPICE to build interactive dashboards.
-
ETL JDBC-ODBC Bridge in Oracle Data Integrator
This article shows how to transfer JDBC-ODBC Bridge data into a data warehouse using Oracle Data Integrator.
-
LINQ to Kafka 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 Kafka Data Provider.
-
How to Work with Guru Data in ETL Validator JDBC
Connect to Guru from ETL Validator jobs using the CData Software JDBC Driver.
-
Deploy the ADO.NET Provider for Unbounce on an SSRS Report Server
Connect to Unbounce data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to connect to Google Directory Data in DBVisualizer
Integrate Google Directory data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect ShipEngine to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ShipEngine with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Live SAS Data Sets Data in MicroStrategy through CData Connect AI
Create a live connection to SAS Data Sets Data in CData Connect AI and connect to your SAS Data Sets data from MicroStrategy.
-
Easily Integrate Access Data in Lazarus Pascal IDE
Learn how to easily integrate live Access data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Stream SAP HANA Data into Apache Kafka Topics
Access and stream SAP HANA data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Work with Sugar CRM Data in ETL Validator JDBC
Connect to Sugar CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Using the CData Software ODBC Driver for Office 365 in PyCharm
Connect to Office 365 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Office 365.
-
Connect to SharePoint Excel Services Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SharePoint Excel Services data in the Denodo Virtual DataPort Administrator.
-
Build AI/ML Models with Live VWO Data using Dataiku
Connect VWO Data with Dataiku using the CData API Driver for JDBC.
-
Connect to RabbitMQ Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for RabbitMQ data in the Denodo Virtual DataPort Administrator.
-
Use the CData Software JDBC Driver for Workday in MicroStrategy Web
Connect to Workday data in MicroStrategy Web using the CData Software JDBC Driver for Workday.
-
Visualize Live SAP HANA XS Advanced Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP HANA XS Advanced data.
-
Access Live JotForm Data in Coginiti Pro
Connect to and query live JotForm data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Trello-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Trello data and build web apps with connectivity to live Trello data.
-
Connect to Wistia Data in Aqua Data Studio
Access Wistia data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating OpenCode with Google Cloud Storage 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 Apps from ShipStation Data in Qlik Sense Cloud
Use CData Connect AI to connect to ShipStation Data and build apps from live ShipStation data in Qlik Sense Cloud.
-
Automated Continuous ChargeOver Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ChargeOver replication to IBM DB2.
-
Connect to Codat Data in Aqua Data Studio
Access Codat data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to and Query CampaignMonitor Data in QlikView over ODBC
Create data visualizations with CampaignMonitor data in QlikView.
-
Visualize Live Redis Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Redis data into custom reports in Power BI.
-
Create Oracle HCM Cloud-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Oracle HCM Cloud Data from Klipfolio and build custom visualizations using live Oracle HCM Cloud data.
-
Connect to Samanage Data in JRuby
Create a simple JRuby app with access to live Samanage data.
-
Link Parquet with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Parquet data in Filemaker Pro for Mac or Windows.
-
Visualize Live ConvertAPI Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ConvertAPI data.
-
Visualize Reckon Accounts Hosted Data in TIBCO Spotfire through ADO.NET
Integrate Reckon Accounts Hosted data into dashboards in TIBCO Spotfire.