CData Software - Knowledge Base
Recent Articles
-
Build Automated SAP SuccessFactors LMS-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP SuccessFactors LMS data and build automated workflows in Zapier.
-
Query OpenWeatherMap Data through ODBC in Node.js
Use node-odbc to execute SQL queries against OpenWeatherMap data from Node.js.
-
Load Google Ad Manager Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Ad Manager data to a database.
-
How to Create Power BI Visual Reports with Real-Time CouchDB Data
Use CData Power BI Connectors to visualize CouchDB data in Power BI.
-
Connecting Mastra with Outreach.io 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 Outreach.io data, no replication required.
-
How to Work with FreshBooks Data in AWS Glue Jobs Using JDBC
Connect to FreshBooks from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Replicate AdRoll Data from PowerShell
Write a quick PowerShell script to query AdRoll data. Use connectivity to the live data to replicate AdRoll data to SQL Server.
-
How to work with Campaigner Data in Apache Spark using SQL
Access and process Campaigner Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Pipeline CRM Data in DBeaver
Use the CData ODBC Driver to connect to Pipeline CRM data in DBeaver.
-
Connect to Amazon Marketplace Data in ACL Analytics
Connect to Amazon Marketplace data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon Marketplace data.
-
Viewing Chargebee Data in RAD Studio Data Explorer
How to view Chargebee data in RAD Studio Data Explorer using the CData ODBC Driver for Chargebee.
-
Build Voice Agents in ElevenLabs with access to Live PostgreSQL Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live PostgreSQL data.
-
How to create an RPA flow for Hacker News Data in UiPath Studio
Use the Hacker News ODBC Driver to create workflows that access real-time Hacker News data without any coding.
-
Publish Chargebee-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Chargebee data.
-
Analyze ZohoPeople Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ZohoPeople data and visualize live ZohoPeople data in Infragistics Reveal.
-
Build a Simple VCL Application for Quickbase Data
How to build a simple VCL Application to view Quickbase data in RAD Studio using the CData ODBC Driver for Quickbase.
-
Validate SAP Hybris C4C Data with QuerySurge
Access and validate SAP Hybris C4C data in QuerySurge using the CData JDBC Driver.
-
Integrate Live Azure Table Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Azure Table data to Blue Prism using the CData ODBC Driver for Azure Table to create automated workflows for repetitive business tasks.
-
Create Dynamic Active Directory Grids Using the Infragistics XamDataGrid
Learn how you can connect Active Directory to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Moosend Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Moosend as an External Source in Dremio.
-
Build Exa-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Exa data.
-
Integrate Real-Time Access to MYOB AccountRight in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to MYOB AccountRight data in real time.
-
Integrate Dify with Live Mailjet Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Mailjet data.
-
Rapidly Develop Clockify-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 Clockify.
-
Getting Started with the CData ADO.NET Provider for Highrise
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Highrise.
-
Build MVC Applications with Connectivity to Google Spanner Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Spanner from an ASP.NET MVC application.
-
Connect to Adobe Analytics Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Adobe Analytics Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Grafana Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Grafana data in the Denodo Virtual DataPort Administrator.
-
How to work with Samanage Data in Apache Spark using SQL
Access and process Samanage Data in Apache Spark using the CData Software JDBC Driver.
-
Connect and Query Live Freshdesk Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Freshdesk data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to and Visualize Live Billsby Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Billsby data.
-
Integrate OpenCode with Live SQL Server Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SQL Server data from within your AI coding agent.
-
Build Dashboards with ZohoPeople Data in DBxtra
Create dynamic dashboards and perform analytics based on ZohoPeople data in DBxtra.
-
Access Live Splunk Data in Excel 365 Online (Excel for the web)
Connect to Splunk data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Active Directory-Connected Nintex Workflows
Use CData Connect AI to connect to Active Directory Data from Nintex Workflow Cloud and build custom workflows using live Active Directory data.
-
How to Visualize SAP Hybris C4C 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 SAP Hybris C4C data in Python.
-
Import and Visualize Datadog Data in Power View
Create data visualizations based on Datadog data in Excel.
-
Excel Spreadsheet Automation on HBase Data with the QUERY Formula
Pull data from HBase, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for SAP HANA in MicroStrategy
Connect to SAP HANA data in MicroStrategy Developer using the CData Software ODBC Driver for SAP HANA.
-
Use Manus AI to Talk to Your Mailgun Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Mailgun data.
-
Connect to Google Campaign Manager 360 Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Google Campaign Manager 360 data.
-
How to work with Paddle Data in Apache Spark using SQL
Access and process Paddle Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Goose with Live Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Active Directory data from within the local AI agent.
-
Integrate ZohoExpense Data into Power Automate Desktop using CData Connect
CData Connect for ZohoExpense Data enables you to integrate ZohoExpense data into workflows built using Microsoft Power Automate Desktop.
-
Build SAP ByDesign Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP ByDesign data and build visualizations in Tableau.
-
Analyze Wistia Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Wistia data with the CData JDBC Driver for Wistia.
-
Integrate with GitLab Data in JReport Designer
Create charts and reports based on GitLab data in JReport Designer.
-
Validate Sentry Data with QuerySurge
Access and validate Sentry data in QuerySurge using the CData JDBC Driver.
-
How to Visualize Azure Table Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Table data in Python.
-
Visualize Salesforce Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesforce data.
-
Connecting Pipedream with ServiceDesk Plus Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ServiceDesk Plus data in real time.
-
How to Access MariaDB Data Using Entity Framework
This article shows how to access MariaDB data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create SSAS Tabular Models from Shopify Data
How to build a SQL Server Analysis Service Tabular Model from Shopify data using CData drivers.
-
Create XML-Connected Applications in Appsmith
Connect to XML Data via CData Connect AI in Appsmith and create custom business applications with real-time access to XML data.
-
Replicate Microsoft Exchange Data from PowerShell
Write a quick PowerShell script to query Microsoft Exchange data. Use connectivity to the live data to replicate Microsoft Exchange data to SQL Server.
-
Building Dynamic Web Pages with Zoho Projects Data Using AngularJS
Create single-page applications with live connectivity to Zoho Projects using the CData API Server.
-
Replicate Multiple BigCommerce Accounts
Replicate multiple BigCommerce accounts to one or many databases.
-
Integrate Facebook Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Facebook Ads data and integrate live Facebook Ads data into your Power Automate tasks.
-
Getting Started with the CData SSIS Components for MYOB AccountRight
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MYOB AccountRight.
-
Use JayDeBeApi to access Bright Data Data in Python
Use standard Python scripting and the development environment of your choice to access live Bright Data data.
-
Automate ZarMoney Data Replication to Azure Synapse
Use CData Sync to customize and automate ZarMoney data replication to Azure Synapse.
-
Excel Spreadsheet Automation on Oracle SCM Data with the QUERY Formula
Pull data from Oracle SCM, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous PabblySubscriptions Replication to MySQL
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to MySQL.
-
Access Live AgileCRM Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live AgileCRM data from your Google Sheets.
-
Build a PostgreSQL Interface for Freshservice Data using the CData JDBC Driver
Use the Remoting features of the Freshservice JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Gong Data in Cognos Analytics
Use CData Connect AI to connect to Gong Data from Cognos Analytics and analyze live Gong data.
-
Prepare, Blend, and Analyze Redshift Data in Alteryx Designer (Connect AI)
Build workflows to access live Redshift data for self-service data analytics.
-
Connect Spreadsheets Getting Started Guide
A basic guide to setting up and connecting to data through Connect Spreadsheets by CData
-
Replicate Jumpseller Data in Heroku for Use in Salesforce Connect
Replicate Jumpseller data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Google Search Results in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Search results in the Denodo Virtual DataPort Administrator.
-
Connect to Azure DevOps Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure DevOps data using standard SQL.
-
Build Tavily-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Tavily data without replication.
-
Integrating LangChain with Toggl Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Toggl data within automated workflows.
-
Integrating Claude Code CLI with Elasticsearch 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 Jira Assets Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Jira Assets data and visualize live Jira Assets data in Infragistics Reveal.
-
Create Data Visualizations in Cognos BI with Attio Data
Access Attio data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Reports from VWO Data in Looker Studio
Use CData Connect AI to gain access to live VWO data and create custom reports in Looker Studio.
-
How to import Wistia Data into Apache Solr
Use the CData Software JDBC Driver for Wistia in Data Import Handler and create an automated import of Wistia data to Apache Solr Enterprise Search platform.
-
How to Connect to & Open BigCommerce Data in Microsoft Excel
This article uses the CData ODBC driver for BigCommerce to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Microsoft Ads Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Ads data from HeidiSQL.
-
Analyze Wave Financial Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Wave Financial data and visualize Wave Financial data in SAP Analytics Cloud.
-
Analyze LeadDesk Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze LeadDesk data with the CData JDBC Driver for LeadDesk.
-
Integrate Real-Time Access to Zoho Creator in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zoho Creator data in real time.
-
Connect to Stripe Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Stripe data.
-
Connecting Moonlit Workflow with SAP Concur Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP Concur data in real time.
-
How to Seamlessly Import Sage Cloud Accounting Data into IBM SPSS Modeler
Integrate Sage Cloud Accounting data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate OpenCode with Live Sybase IQ Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Sybase IQ data from within your AI coding agent.
-
Connect to ClickUp Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live ClickUp data.
-
Prepare, Blend, and Analyze Jira Assets Data in Alteryx Designer (ODBC)
Build workflows to access live Jira Assets data for self-service data analytics.
-
Working with REST Data in LINQPad
Execute LINQ queries to REST data in LINQPad.
-
Create SSAS Tabular Models from SendInBlue Data
How to build a SQL Server Analysis Service Tabular Model from SendInBlue data using CData drivers.
-
Getting Started with the CData JDBC Driver for SendInBlue
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SendInBlue.
-
Create SAP Ariba Source Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Ariba Source from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Microsoft Dataverse
Provide connectivity to Microsoft Dataverse data through an SAP BusinessObjects universe.
-
Integrate Devin with Live AfterShip Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live AfterShip data.
-
Manage Salesforce Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Salesforce.
-
Build AI Agents with Bitly Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Bitly data through CData Connect AI.
-
Getting Started with the CData ADO.NET Provider for Moosend
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous SharePoint Excel Services Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to PostgreSQL.
-
Integrating Boomi Agentstudio with Cosmos DB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Cosmos DB data, enabling AI agents to act on live enterprise data within your integration and automation workflows.