CData Software - Knowledge Base
Recent Articles
-
Connecting Mastra with Azure Table 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 Azure Table data, no replication required.
-
Rapidly Develop Twilio-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 Twilio.
-
Establish a Live Connection with Microsoft Planner Data using Tableau Bridge
The CData ODBC Driver for Microsoft Planner enables you to integrate live Microsoft Planner data into Tableau Cloud dashboards using the Tableau Bridge.
-
View Reports on Real-Time TaxJar Data in Power BI Report Server
Use the CData ODBC Driver for TaxJar to visualize TaxJar data in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Google Analytics Data from MySQL in PHP
Connect to Google Analytics through the standard MySQL libraries in PHP.
-
Visualize eBay Analytics Data in Tableau
The CData ODBC driver for eBay Analytics enables you integrate eBay Analytics data into Tableau dashboards.
-
Import Real-Time Cvent Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Cvent data in ColdFusion.
-
Visualize SAP SuccessFactors LMS Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP SuccessFactors LMS data.
-
Visualize Email Data in Tableau
The CData ODBC driver for Email enables you integrate Email data into Tableau dashboards.
-
Connect to HubSpot Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for HubSpot data.
-
Build Pipelines with Live SAP BusinessObjects BI Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP BusinessObjects BI from Google Cloud Data Fusion, enabling the integration of live SAP BusinessObjects BI data into the building and management of effective data pipelines.
-
Connect to Google Search Results in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Google Search.
-
Build a Singer.io Tap for ZohoInvoice With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ZohoInvoice data using the CData Python Connector.
-
Manage Freshteam Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Freshteam.
-
Connect to Sage Intacct Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sage Intacct Data and connect to Sage Intacct data in Akorbi Digital RunMyProcess.
-
Load Mailjet Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Mailjet data to a database.
-
Integrating LangGraph with Sugar CRM Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Sugar CRM data within automated workflows.
-
Automated Continuous HubSpot Replication to Databricks
Use CData Sync for automated, continuous, customizable HubSpot replication to Databricks.
-
Integrate Goose with Live XML Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live XML data from within the local AI agent.
-
Connect and Visualize Live Coda Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Coda data into the Databricks platform and create visualization dashboards with real-time Coda data.
-
Build Twitter Ads-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Twitter Ads data and build web apps with connectivity to live Twitter Ads data.
-
Create Reports with Keap Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Keap data.
-
Create Apps from Testmonitor Data in Qlik Sense Cloud
Use CData Connect AI to connect to Testmonitor Data and build apps from live Testmonitor data in Qlik Sense Cloud.
-
Connect Printify to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Printify data using the CData Python MCP Server.
-
Create ZohoInvoice-Connected Nintex Workflows
Use CData Connect AI to connect to ZohoInvoice Data from Nintex Workflow Cloud and build custom workflows using live ZohoInvoice data.
-
Integrating Claude Code CLI with Hive 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.
-
Using the CData Software ODBC Driver for Snowflake in PyCharm
Connect to Snowflake as an ODBC data source in PyCharm using the CData Software ODBC Driver for Snowflake.
-
Connect to IBM Informix Data in Claris FileMaker Pro
Use the CData ODBC Driver for IBM Informix in FileMaker Pro to connect to IBM Informix and work with IBM Informix data in your FileMaker applications.
-
Create SendPulse-Connected Dashboards in Grafana
Connect to SendPulse Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SendPulse data.
-
Integrating Boomi Agentstudio with ZohoInvoice Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ZohoInvoice data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Kintone Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Kintone data.
-
Deploy the ADO.NET Provider for Recurly on an SSRS Report Server
Connect to Recurly 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.
-
Automated Continuous Adobe Commerce Replication to SingleStore
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to SingleStore.
-
Integrate Discourse Data in Pentaho Data Integration
Build ETL pipelines based on Discourse data in the Pentaho Data Integration tool.
-
Build Adobe Commerce-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Adobe Commerce Data and create custom apps in Bubble.
-
Connect Tally to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Tally data using the CData Python MCP Server.
-
Connect to Salesforce Marketing in SpagoBI
Create reports featuring live Salesforce Marketing data in SpagoBI Studio. Host Salesforce Marketing reports on SpagoBI Server.
-
Use the CData Software JDBC Driver for Google Sheets in MicroStrategy Web
Connect to Google Sheets data in MicroStrategy Web using the CData Software JDBC Driver for Google Sheets.
-
Work with Mocean Data in FoxPro
Load Mocean data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Trae with Live ShipStation Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ShipStation data from within the AI-powered IDE.
-
Getting Started with the CData Excel Add-In for Wistia
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Wistia.
-
LINQ to QuickBooks Online 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 QuickBooks Online Data Provider.
-
How to publish and share Mouseflow Data dashboards with Tableau Server
The CData ODBC driver for Mouseflow enables you integrate Mouseflow data into Tableau dashboards.
-
Analyze Amazon Marketplace Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Amazon Marketplace data in Microsoft R Open.
-
Access Live Office 365 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Office 365 data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Migrating data from Act-On to Google BigQuery using CData SSIS Components.
Easily push Act-On data to Google BigQuery using the CData SSIS Tasks for Act-On and Google BigQuery.
-
Automated Continuous Salesforce Pardot Replication to SQL Server
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to SQL Server.
-
How to Create Power BI Visual Reports with Real-Time Spotify Data
Use CData Power BI Connectors to visualize Spotify data in Power BI.
-
How to Connect to Live SAP Netweaver Gateway 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 SAP Netweaver Gateway data for you.
-
Query eBay Data as a SQL Server Database in Node.js
Execute SQL Server queries against eBay data from Node.js.
-
A PostgreSQL Interface for Stack Exchange Data using the CData ODBC Driver
Use the SQL Gateway and Stack Exchange ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time ZohoExpense Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZohoExpense data in ColdFusion.
-
Use Agno to Talk to Your Amazon DynamoDB 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 Amazon DynamoDB data for you.
-
Model, Search, and Visualize Live HDFS Data in ThoughtSpot
Use CData Connect AI to connect to live HDFS data for modeling, searching, and visualizing.
-
Integrating Codex with Impala 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.
-
Building Dynamic Web Pages with QuickBooks Time Data Using AngularJS
Create single-page applications with live connectivity to QuickBooks Time using the CData API Server.
-
Build MVC Applications with Connectivity to Email Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Email from an ASP.NET MVC application.
-
How to Easily Query Browserless Data in OpenOffice Base
Connect to Browserless data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build Dashboards with Act-On Data in DBxtra
Create dynamic dashboards and perform analytics based on Act-On data in DBxtra.
-
Analyze Grafana Data in Looker
Use CData Connect AI to connect to Grafana Data from Looker and build custom apps using live Grafana data.
-
Access SAS xpt Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAS xpt data from HeidiSQL.
-
Connect to Live ZohoPeople Data in MicroStrategy through CData Connect AI
Create a live connection to ZohoPeople Data in CData Connect AI and connect to your ZohoPeople data from MicroStrategy.
-
DataBind SAP SuccessFactors Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP SuccessFactors with the DevExpress Windows Forms and Web controls to provide SAP SuccessFactors data to a chart.
-
Migrating data from Quaderno to Google BigQuery using CData SSIS Components.
Easily push Quaderno data to Google BigQuery using the CData SSIS Tasks for Quaderno and Google BigQuery.
-
Integrate Google's Antigravity Agent with Live Supabase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Supabase data using the Model Context Protocol.
-
Use Grok to Talk to Your Bright Data 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 Bright Data data for you.
-
Connect to Exact Online Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Exact Online data from Filemaker Pro on Mac.
-
Work with ShipEngine Data in FoxPro
Load ShipEngine data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Deel Data to Multiple Databases
Replicate Deel data to disparate databases with a point-and-click configuration.
-
Create Dynamic Printify Grids Using the Infragistics XamDataGrid
Learn how you can connect Printify to Infragistics XamDataGrid to build dynamic grids.
-
Build Data Flows from SQL Server to Greenplum through SSIS
Easily push SQL Server data to Greenplum using the CData SSIS Tasks for Greenplum.
-
Design BIRT Reports on Highrise Data
Provide current Highrise data to your embedded analytics.
-
Automated Continuous OneNote Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable OneNote data replication to OneLake in Microsoft Fabric.
-
Build SurveyMonkey Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SurveyMonkey data and build visualizations in Tableau.
-
Integrating Gumloop with Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Cloudflare data within automated workflows.
-
Create Reports from NetSuite Data in Looker Studio
Use CData Connect AI to gain access to live NetSuite data and create custom reports in Looker Studio.
-
How to connect to HubDB Data from Spring Boot
Connect to HubDB in a Spring Boot Application using the CData JDBC Driver for HubDB
-
Getting Started with the CData Power BI Connector for Teamgate
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Tanda 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 Tanda data.
-
Query Elasticsearch Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Elasticsearch data from Node.js.
-
DataBind Charts to SAP Ariba Source Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Ariba Source 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.
-
Back Up Oracle Service Cloud data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Service Cloud. In this article, we will employ an SSIS workflow to populate a database with Oracle Service Cloud data data.
-
Explore Geographical Relationships in ZohoPeople Data with Power Map
Create data visualizations with ZohoPeople data in Power Map.
-
Access LeadDesk Data from MySQL in PHP
Connect to LeadDesk through the standard MySQL libraries in PHP.
-
Visualize Live Elasticsearch Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Elasticsearch data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Dashboards with SAP Business One Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Business One data in DBxtra.
-
Connect to and Visualize Live Avalara AvaTax Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Avalara AvaTax data.
-
Connect to LaunchDarkly Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for LaunchDarkly and the SQL Gateway to access LaunchDarkly data from Google Apps Script.
-
Connect to QuickBooks Time Data in NetBeans
Connect to QuickBooks Time data in NetBeans with the data source configuration wizard.
-
Replicate ADP Data in Heroku for Use in Salesforce Connect
Replicate ADP data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to & Open Highrise Data in Microsoft Excel
This article uses the CData ODBC driver for Highrise to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to import ShipEngine Data into Apache Solr
Use the CData Software JDBC Driver for ShipEngine in Data Import Handler and create an automated import of ShipEngine data to Apache Solr Enterprise Search platform.
-
Visualize ServiceDesk Plus Data in Tableau
The CData ODBC driver for ServiceDesk Plus enables you integrate ServiceDesk Plus data into Tableau dashboards.
-
Getting Started with the CData JDBC Driver for Basecamp
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Basecamp.
-
Integrating LlamaIndex with OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on OneNote data in real time.
-
Create Dashboards and Visualize Live Salesforce Marketing Data in Geckoboard
Use CData Connect AI to connect to live Salesforce Marketing data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Bridge Aircall Connectivity with Apache NiFi
Access and process Aircall data in Apache NiFi using the CData JDBC Driver.
-
Visualize SAP Netweaver Gateway Data in TIBCO Spotfire through OData
Integrate SAP Netweaver Gateway data into dashboards in TIBCO Spotfire.
-
Create SSAS Tabular Models from AgileCRM Data
How to build a SQL Server Analysis Service Tabular Model from AgileCRM data using CData drivers.
-
Build Semantic Layer Views for Azure Analysis Services Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Analysis Services data.