CData Software - Knowledge Base
Recent Articles
-
Connect to Jodoo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Jodoo to connect to Jodoo and execute queries in PowerBuilder.
-
Work with CouchDB Data in FoxPro
Load Apache CouchDB into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Sybase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sybase and the SQL Gateway to access Sybase from Google Apps Script.
-
Process & Analyze Reckon Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Reckon Data.
-
Build Agents in Relevance AI with Access to Live Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sage 200 within intelligent agent workflows.
-
How to Visualize Pipeliner CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pipeliner CRM in Python.
-
Connect Google Drive to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Drive with IBM WebSphere for seamless data integration and connectivity.
-
Integrating Kiro CLI with Calendly 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 Google Tasks Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Tasks from Power Pivot. You will use the Table Import Wizard to load Google Tasks. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect DBeaver to ShipStation via a JDBC Driver
Manage ShipStation with visual tools in DBeaver like the query browser.
-
Natively Connect to ClickTime Data in PHP
The CData ODBC driver for ClickTime enables you to create PHP applications with connectivity to ClickTime. Leverage the native support for ODBC in PHP.
-
Connect to PabblySubscriptions Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Trello to Power BI dashboards. Simply drag and drop Trello into data visuals on the Power BI canvas.
-
DataBind Charts to Drip Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Drip 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.
-
Excel Spreadsheet Automation on ElevenLabs Data with the QUERY Formula
Pull data from ElevenLabs, automate spreadsheets, and more with the QUERY formula.
-
Connect to Amplitude Data from a Connection Pool in Jetty
The Amplitude JDBC Driver supports connection pooling: This article shows how to connect faster to Amplitude from Web apps in Jetty.
-
Visualize Live LeadDesk Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live LeadDesk using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import Real-Time WooCommerce Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use WooCommerce in ColdFusion.
-
Getting Started with the CData Excel Add-In for Shortcut
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Shortcut.
-
Use Microsoft Copilot Studio to talk to your Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Zoho CRM for you.
-
Connect to Templated Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Templated.
-
Query AlloyDB Data as a MySQL Database in Node.js
Execute MySQL queries against Google AlloyDB from Node.js.
-
Consume Slack OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Slack feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Azure Blob Storage Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to delimited files (CSV/TSV).
-
Create SSAS Tabular Models from Contentful Data
How to build a SQL Server Analysis Service Tabular Model from Contentful using CData drivers.
-
Publish Reports with Google Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Ads.
-
Create Dynamic eBay Analytics Grids Using the Infragistics XamDataGrid
Learn how you can connect eBay Analytics to Infragistics XamDataGrid to build dynamic grids.
-
Bind Live HubSpot Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live HubSpot data
-
Integrate with Google Directory Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Directory in SnapLogic.
-
Analyze Certinia Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Certinia and visualize live Certinia in Infragistics Reveal.
-
Bind Live Zoho Creator Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Zoho Creator data
-
Connect to CouchDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Apache CouchDB in Airbyte.
-
Connect to Oracle Financials Cloud Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle Financials Cloud and the SQL Gateway to access Oracle Financials Cloud from Google Apps Script.
-
Create Datasets from HelloSign in Domo Workbench and Build Visualizations of HelloSign Data in Domo
Use the CData Software ODBC Driver for HelloSign to create datasets from HelloSign in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Stack Exchange Data with Squirrel SQL client
Connect to Stack Exchange and execute queries in the Squirrel SQL Client.
-
How to connect to Spark Data from Spring Boot
Connect to Spark in a Spring Boot Application using the CData JDBC Driver for Spark
-
Connect to Smartsheet Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Smartsheet using standard SQL.
-
Access Live Epicor Kinetic 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 Epicor Kinetic through MCP integration.
-
Use the CData Software ODBC Driver for Google Ad Manager in MicroStrategy Desktop
Connect to Google Ad Manager in MicroStrategy Desktop using the CData Software ODBC Driver for Google Ad Manager.
-
Build Pipelines with Live Twitter Ads Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Twitter Ads from Google Cloud Data Fusion, enabling the integration of live Twitter Ads into the building and management of effective data pipelines.
-
Analyze Live Microsoft Entra ID Data in SAS Viya
Use CData Connect AI to connect to Microsoft Entra ID from SAS Viya and deploy self-service analytics using live Microsoft Entra ID.
-
Zoho Books Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zoho Books facts in real time.
-
Getting Started with the CData ADO.NET Provider for BigCommerce
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for BigCommerce.
-
How to connect to Eventbrite Data with Squirrel SQL client
Connect to Eventbrite and execute queries in the Squirrel SQL Client.
-
Build Apps with Live Customer.io Data Using the Low-Code Development Platform of Mendix
Connect Customer.io with Mendix to build apps using the CData API Driver for JDBC.
-
DataBind Controls to Postmark Data in C++Builder
DataBind to Postmark in C++Builder with standard components and controls.
-
Publish Reports with Qualaroo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Qualaroo.
-
Access Live Adobe Analytics 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 Adobe Analytics through MCP integration.
-
Automated Continuous Sage Cloud Accounting Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Azure SQL Database.
-
Build BigQuery-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for BigQuery to explore live BigQuery Data in Cursor to assist with building BigQuery-powered applications.
-
Create Apps from Confluence Data in Qlik Sense Cloud
Use CData Connect AI to connect to Confluence Data and build apps from live Atlassian Confluence in Qlik Sense Cloud.
-
Bidirectional Access to Float Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Float in Filemaker Pro for Mac or Windows.
-
Connect to Vault CRM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Vault CRM in FileMaker Pro to connect to Vault CRM and work with Veeva Vault & Vault CRM in your FileMaker applications.
-
Integrate Live Optimizely Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Optimizely to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Bridge BigQuery Connectivity with Apache NiFi
Access and process Google BigQuery in Apache NiFi using the CData JDBC Driver.
-
Access SageHR Data from MySQL in Amazon QuickSight
Connect to SageHR and build visualizations of SageHR using a MySQL Connection in Amazon QuickSight.
-
Natively Connect to Qualaroo Data in PHP
The CData ODBC driver for Qualaroo enables you to create PHP applications with connectivity to Qualaroo. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Avro in MicroStrategy Web
Connect to Apache Avro in MicroStrategy Web using the CData Software JDBC Driver for Avro.
-
Access Google Campaign Manager 360 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Campaign Manager 360 from HeidiSQL.
-
Migrating data from Attio to Databricks using CData SSIS Components.
Easily push Attio to Databricks using the CData SSIS Tasks for Attio and Databricks.
-
How to Access Live Clari Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Clari enables you to integrate Clari into workflows built using Microsoft Power Automate Desktop.
-
Access Live OData Services in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live OData through MCP integration.
-
Edit and Search HubSpot External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of HubSpot to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create HubSpot objects that you can access from apps and the dashboard.
-
Connect to Reckon Accounts Hosted Data from a Connection Pool in Jetty
The Reckon Accounts Hosted JDBC Driver supports connection pooling: This article shows how to connect faster to Reckon Accounts Hosted from Web apps in Jetty.
-
Import and Visualize MYOB AccountRight Data in Power View
Create data visualizations based on MYOB AccountRight in Excel.
-
Build Visualizations of LeadDesk Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of LeadDesk in Birst.
-
Build Semantic Layer Views for SharePoint Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft SharePoint.
-
Create a Data Access Object for Teradata Data using JDBI
A brief overview of creating a SQL Object API for Teradata in JDBI.
-
Visualize Live OneNote Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft OneNote and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Work with Mailgun Data in ETL Validator JDBC
Connect to Mailgun from ETL Validator jobs using the CData Software JDBC Driver.
-
Working with SAP Netweaver Gateway Data in LINQPad
Execute LINQ queries to SAP Netweaver Gateway in LINQPad.
-
How to Connect to Live Zoho Inventory 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 Zoho Inventory for you.
-
Access Live Odoo Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Odoo ERP from your Google Sheets.
-
A PostgreSQL Interface for Trello Data (MySQL Remoting via JDBC)
Use the Remoting features of the Trello JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Outlook Data in DBxtra
Create dynamic dashboards and perform analytics based on Outlook in DBxtra.
-
Connect to Wave Financial Data in Jaspersoft Studio
Execute SQL to remote Wave Financial in Jaspersoft Studio.
-
View Reports on Real-Time DocuSign Data in Power BI Report Server
Use the CData ODBC Driver for DocuSign to visualize DocuSign in Power BI Desktop and then publish them to Power BI Report Server.
-
Replicate Figshare Data to Multiple Databases
Replicate Figshare to disparate databases with a point-and-click configuration.
-
Access Live GraphQL Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to GraphQL from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Extract, Transform, and Load AgileCRM Data in Informatica PowerCenter
Create a simple Workflow for AgileCRM in Informatica PowerCenter.
-
Create Power BI Reports on Real-Time Google Ad Manager Data
Use the CData ODBC Driver for Google Ad Manager to visualize Google Ad Manager in Power BI Desktop.
-
Integrate Cursor with Live ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ServiceNow from within the editor.
-
Use the CData Software ODBC Driver for Webflow in MicroStrategy
Connect to Webflow in MicroStrategy Developer using the CData Software ODBC Driver for Webflow.
-
Connecting Mastra with BigCommerce 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 BigCommerce, no replication required.
-
How to Seamlessly Import Postmark Data into IBM SPSS Modeler
Integrate Postmark data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
LINQ to TaxJar 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 TaxJar Data Provider.
-
Getting Started with the CData Power BI Connector for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Microsoft Ads.
-
Query RabbitMQ Data as a MySQL Database in Node.js
Execute MySQL queries against RabbitMQ from Node.js.
-
Getting Started with the CData ADO.NET Provider for Notion
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Establish a Live Connection with Clio Data using Tableau Bridge
The CData ODBC Driver for Clio enables you to integrate live Clio into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous MailChimp Replication to SQLite
Use CData Sync for automated, continuous, customizable MailChimp replication to SQLite.
-
How to Query Live Adobe Experience Manager Data in Claude Desktop
Connect to and query live Adobe Experience Manager Data in Claude Desktop using CData MCP Server.
-
Rapidly Develop BenchmarkEmail-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 BenchmarkEmail.
-
How to Query Pipeline CRM Data in MySQL Workbench
Execute MySQL queries against live Pipeline CRM from MySQL Workbench.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Gong within intelligent workflows.
-
Use Databricks Agent Bricks to Talk to Your Email Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Email for you.
-
Excel Spreadsheet Automation on Mocean Data with the QUERY Formula
Pull data from Mocean, automate spreadsheets, and more with the QUERY formula.
-
Connect to Copper Data in RapidMiner
Integrate Copper with standard components and data source configuration wizards in RapidMiner Studio.
-
Build an OLAP Cube in SSAS from Marketo Data
Establish a connection to Marketo data from SQL Server Analysis Services, and use the Marketo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Apache HBase within intelligent workflows.