CData Software - Knowledge Base
Recent Articles
-
Access Shopify Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Shopify data from HeidiSQL.
-
Access Live Apify Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Apify data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Visualize Salesloft Data in TIBCO Spotfire through OData
Integrate Salesloft data into dashboards in TIBCO Spotfire.
-
Migrating data from Coda to Google BigQuery using CData SSIS Components.
Easily push Coda data to Google BigQuery using the CData SSIS Tasks for Coda and Google BigQuery.
-
Connect to Bannerbear Data from a Connection Pool in Jetty
The Bannerbear JDBC Driver supports connection pooling: This article shows how to connect faster to Bannerbear data from Web apps in Jetty.
-
Build ConstantContact Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ConstantContact data and build visualizations in Tableau.
-
Connect to Adobe Commerce Data in DBArtisan
Use wizards in DBArtisan to configure Adobe Commerce data as a data source.
-
Migrating data from Freshdesk to Databricks using CData SSIS Components.
Easily push Freshdesk data to Databricks using the CData SSIS Tasks for Freshdesk and Databricks.
-
Choosing the Best Method to Connect ZohoMarketingHub to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoMarketingHub data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Claude to Talk to Your SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SendGrid data for you.
-
Automated Continuous Certinia Replication to Vertica
Use CData Sync for automated, continuous, customizable Certinia replication to Vertica.
-
Create Reports from ZohoExpense Data in Looker Studio
Use CData Connect AI to gain access to live ZohoExpense data and create custom reports in Looker Studio.
-
Query YouTube Analytics Data through ODBC in Node.js
Use node-odbc to execute SQL queries against YouTube Analytics data from Node.js.
-
Access Bright Data 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 Bright Data data.
-
Create a Data Access Object for Lakebase Data using JDBI
A brief overview of creating a SQL Object API for Lakebase data in JDBI.
-
How to Connect to Live xBase 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 xBase data for you.
-
Create JSON-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to JSON Services from OutSystems and build custom enterprise apps using live JSON services.
-
How to Visualize Oracle Service Cloud 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 Oracle Service Cloud data in Python.
-
Access AdRoll Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access AdRoll data from your Oracle system.
-
Link ZeroBounce with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZeroBounce data in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData Python Connector for Salesforce
Learn to install and license the CData Python Connector and configure a connection to live Salesforce data.
-
How to connect to Parquet Data from IntelliJ
Integrate connectivity to Parquet data with wizards in IntelliJ.
-
Query Google Cloud Storage Data as a MySQL Database in Node.js
Execute MySQL queries against Google Cloud Storage data from Node.js.
-
Create Salesforce Pardot Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Salesforce Pardot from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Vercel Data in RazorSQL
Connect to Vercel from wizards and query Vercel data from the GUI in the RazorSQL database management tool.
-
Connect to and Visualize Live Brex Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Brex data.
-
How to Connect Flowise AI Agents to Live VWO Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live VWO data without replication.
-
How to Work with Oracle HCM Cloud Data in ETL Validator JDBC
Connect to Oracle HCM Cloud from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Short.io in MicroStrategy Web
Connect to Short.io data in MicroStrategy Web using the CData Software ODBC Driver for Short.io.
-
Automate SQL Server Data Replication to Couchbase
Use CData Sync to Customize and automate SQL Server data replication to Couchbase.
-
Integrating LlamaIndex with Bitly Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Bitly data in real time.
-
Automate Google Ad Manager Data Replication to SAP HANA
Use CData Sync to customize and automate Google Ad Manager data replication to SAP HANA.
-
Deploy the ADO.NET Provider for Excel Online on an SSRS Report Server
Connect to Excel Online 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.
-
Working with Pinterest Data in LINQPad
Execute LINQ queries to Pinterest data in LINQPad.
-
Analyze Mode Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Mode data and visualize Mode data in SAP Analytics Cloud.
-
Work with Productboard Data in FoxPro
Load Productboard data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Live Kafka Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Kafka data through a conversational interface.
-
Connect to SAP HANA XS Advanced Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP HANA XS Advanced data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP HANA XS Advanced.
-
How to Visualize Zuora 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 Zuora data in Python.
-
Integrating OpenCode with Clari 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 Oracle SCM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle SCM data from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle SCM.
-
Use Claude to Talk to Your Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Smartsheet data for you.
-
Connect to FreeAgent Data in JRuby
Create a simple JRuby app with access to live FreeAgent data.
-
How to Easily Query Tanda Data in OpenOffice Base
Connect to Tanda data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Live JDBC-ODBC Bridge Data in Coginiti Pro
Connect to and query live JDBC-ODBC Bridge data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Float Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Float replication to Azure SQL Database.
-
Connecting Mastra with SAP ByDesign 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 SAP ByDesign data, no replication required.
-
How to Connect Flowise AI Agents to Live Cosmos DB Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Cosmos DB data without replication.
-
Automate Mode Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Mode data from PowerShell? This article demonstrates how to utilize the Mode Cmdlets for tasks like connecting to Mode data, automating operations, downloading data, and more.
-
Build ShipStation Visualizations in Tableau Cloud
Use CData Connect AI to connect to live ShipStation data and build visualizations in Tableau Cloud.
-
DataBind Charts to Landbot Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Landbot data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to Shortcut Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Shortcut data in the Denodo Virtual DataPort Administrator.
-
Build Apps with Live Optimizely Data Using the Low-Code Development Platform of Mendix
Connect Optimizely data with Mendix to build apps using the CData API Driver for JDBC.
-
Access Live ServiceNow 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 ServiceNow data through MCP integration.
-
Enable the Snapchat Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Snapchat Ads data.
-
Connect to Real-Time PingOne Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for PingOne and Dataflow to import and use PingOne data in Power Apps.
-
How to Connect to Live PingOne 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 PingOne data through natural language.
-
How to Connect to Live Monday.com Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Monday.com data for you.
-
Automated Continuous Mixpanel Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Mixpanel replication to Google Cloud SQL.
-
Getting Started with the CData Excel Add-In for Jira
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Jira.
-
Use Dash to Build to Web Apps on Rootly Data
Create Python applications that use pandas and Dash to build Rootly-connected web apps.
-
Connect to IBM Cloud Object Storage Data from Crystal Reports
Use CData Connect AI to connect to and report on live IBM Cloud Object Storage data from Crystal Reports.
-
How to Connect DBeaver to XML via a JDBC Driver
Manage XML data with visual tools in DBeaver like the query browser.
-
Choosing the Best Method to Connect xBase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use xBase data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connecting GenSpark with Greenplum Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Greenplum data without any replication or custom integration required.
-
Integrating Kiro with FHIR 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.
-
Access Live xBase Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate xBase data into the statistical analysis tools available in SAS JMP. This article shows how to use xBase data in the Graph Builder and Query Builder.
-
Create Informatica Mappings From/To a JDBC Data Source for Harvest
Create Harvest data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData ODBC Driver for Miro in Microsoft Power Query
You can use the CData Miro ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Miro data into Microsoft Power Query.
-
Connect to Live CockroachDB Data in MicroStrategy through CData Connect AI
Create a live connection to CockroachDB Data in CData Connect AI and connect to your CockroachDB data from MicroStrategy.
-
Integrate with Teamwork Data in JReport Designer
Create charts and reports based on Teamwork data in JReport Designer.
-
ETL Flowlu in Oracle Data Integrator
This article shows how to transfer Flowlu data into a data warehouse using Oracle Data Integrator.
-
Build Charts with Square Data in Clear Analytics
Create dynamic charts and perform analytics based on Square data in Clear Analytics.
-
Connect and Query Live Jumpseller Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Jumpseller data into Databricks and enable direct, live querying and analysis without replication.
-
How to Easily Query Avaza Data in OpenOffice Base
Connect to Avaza data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Mode Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mode facts in real time.
-
Connect to CSV from a Connection Pool in WebLogic
Use the CData JDBC Driver for CSV to connect to CSV data from Web applications running on WebLogic.
-
How to Work with Jodoo Data in ETL Validator JDBC
Connect to Jodoo from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Connect AI Python SDK for Optimizely
Install the CData Connect AI Python SDK to read live Optimizely data with standard DB-API 2.0 Python code.
-
Create Reports with Stripe Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Stripe data.
-
How to Create Power BI Visual Reports with Real-Time MarkLogic Data
Use CData Power BI Connectors to visualize MarkLogic data in Power BI.
-
Build ZohoExpense-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for ZohoExpense Data and create custom apps in Mendix.
-
Integrate HDFS with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate HDFS with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to HDFS data.
-
Query Teradata Data as a SQL Server Database in Node.js
Execute SQL Server queries against Teradata data from Node.js.
-
Access Google Ad Manager Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Ad Manager data from HeidiSQL.
-
Explore Geographical Relationships in Google Campaign Manager 360 Data with Power Map
Create data visualizations with Google Campaign Manager 360 data in Power Map.
-
Integrate Theia IDE with Live Mode Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Mode data from within the development environment.
-
Publish Google Campaign Manager 360-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Campaign Manager 360 data.
-
Build Freshteam-Connected Apps in Choreo
Use CData Connect AI to connect to Freshteam Data from Choreo and build custom apps using live Freshteam data.
-
Build AI/ML Models with Live Retently Data using Dataiku
Connect Retently Data with Dataiku using the CData API Driver for JDBC.
-
How to Connect Flowise AI Agents to Live Slack Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Slack data without replication.
-
Publish Reports with Zuora Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zuora data.
-
Use Dash to Build to Web Apps on Elasticsearch Data
Create Python applications that use pandas and Dash to build Elasticsearch-connected web apps.
-
Connect to DB2 Data in DBeaver
Use the CData ODBC Driver to connect to DB2 data in DBeaver.
-
Integrate Instagram Data in the Pentaho Report Designer
Publish reports based on Instagram data in the Pentaho BI tool.
-
Use JayDeBeApi to access GitLab Data in Python
Use standard Python scripting and the development environment of your choice to access live GitLab data.
-
Manage Front Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Front.
-
Automated Continuous Cohere Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Cohere replication to Apache Cassandra.
-
Migrating data from Paddle to Google BigQuery using CData SSIS Components.
Easily push Paddle data to Google BigQuery using the CData SSIS Tasks for Paddle and Google BigQuery.
-
Edit and Search External Square Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Square data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Square Data objects that you can access from apps and the dashboard.