CData Software - Knowledge Base
Recent Articles
-
Connect to Zoho Books Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho Books data using standard SQL.
-
Deploy the ADO.NET Provider for Strava on an SSRS Report Server
Connect to Strava 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.
-
Use the CData Software ODBC Driver for ZohoExpense in MicroStrategy Desktop
Connect to ZohoExpense data in MicroStrategy Desktop using the CData Software ODBC Driver for ZohoExpense.
-
Integrate Dify with Live Procore 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 Procore data.
-
Automated Continuous LeadDesk Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable LeadDesk replication to Google BigQuery.
-
How to create an RPA flow for MessageBird Data in UiPath Studio
Use the MessageBird ODBC Driver to create workflows that access real-time MessageBird data without any coding.
-
Publish Reports with Telegram Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Telegram data.
-
Create Reports from Microsoft Entra ID Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft Entra ID data and create custom reports in Looker Studio.
-
Connecting Mastra with QuickBooks Time 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 QuickBooks Time data, no replication required.
-
Connect to AfterShip Data as an External Source in Dremio
Use the CData JDBC Driver to connect to AfterShip as an External Source in Dremio.
-
Connect to GitHub Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to GitHub.
-
Connect to SAP Concur from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Concur data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrating OpenCode with GraphQL 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 Telegram Data in NetBeans
Connect to Telegram data in NetBeans with the data source configuration wizard.
-
How to Connect to Live Egnyte 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 Egnyte data for you.
-
Use the CData Software ODBC Driver for ZendeskSell in MicroStrategy Desktop
Connect to ZendeskSell data in MicroStrategy Desktop using the CData Software ODBC Driver for ZendeskSell.
-
Build Semantic Layer Views for PayPal Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for PayPal data.
-
Access Live Klipfolio Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Klipfolio data from your Excel spreadsheets.
-
Integrating CampaignMonitor Data in Talend Cloud Data Management Platform
Connect CampaignMonitor Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrating Claude Code CLI with Missive 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.
-
Publish FormSite-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live FormSite data.
-
Create Reports with Factorial Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Factorial data.
-
Getting Started with the CData Tableau Connector for Tally
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Tally.
-
Create Dashboards and Visualize Live WordPress Data in Geckoboard
Use CData Connect AI to connect to live WordPress data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Automated Workflows with Live Act CRM Data in Workato
Use CData Connect AI to connect to live Act CRM data and build automated workflows in Workato.
-
Build Visualizations of SAP SuccessFactors LMS Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP SuccessFactors LMS data in Birst.
-
Publish Crystal Reports on Oracle SCM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle SCM data.
-
Build an OLAP Cube in SSAS from Reckon Accounts Hosted Data
Establish a connection to Reckon Accounts Hosted data data from SQL Server Analysis Services, and use the Reckon Accounts Hosted Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query BenchmarkEmail Data as a SQL Server Database in Node.js
Execute SQL Server queries against BenchmarkEmail data from Node.js.
-
Trigger Airtable IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Airtable with standard wizards in Logic Apps.
-
How to create Visio diagrams from QuickBooks Online Data
Automatically update QuickBooks Online data with the changes you make to Visio master shapes.
-
Integrating Claude Code CLI with Apollo 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.
-
How to work with Testmonitor Data in Apache Spark using SQL
Access and process Testmonitor Data in Apache Spark using the CData Software JDBC Driver.
-
Use Azure AI Foundry to Talk to Your Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Redis data for you.
-
Parallel Reporting in OBIEE with the Parallel JDBC Driver
Deploy the Parallel JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Klaviyo Data in Pentaho Data Integration
Build ETL pipelines based on Klaviyo data in the Pentaho Data Integration tool.
-
How to Access Live Google Contacts Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Contacts enables you to integrate Google Contacts data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Anaplan Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Anaplan Data and connect to Anaplan data in Akorbi Digital RunMyProcess.
-
Back Up ZohoSubscriptions data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ZohoSubscriptions data data.
-
How to connect to FormSite Data with Squirrel SQL client
Connect to FormSite data and execute queries in the Squirrel SQL Client.
-
Query Facebook Data as a SQL Server Database in Node.js
Execute SQL Server queries against Facebook data from Node.js.
-
Build an OLAP Cube in SSAS from CSV Data
Establish a connection to CSV data data from SQL Server Analysis Services, and use the CSV Data Provider to build OLAP cubes for use in analytics and reporting.
-
DataBind Charts to AgileCRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to AgileCRM 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.
-
How to integrate Metabase with Oracle Service Cloud Data
Use CData Connect AI to connect to live Oracle Service Cloud data and create an interactive dashboard in Metabase from Oracle Service Cloud data.
-
Publish Crystal Reports on HBase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date HBase data.
-
Build MVC Applications with Connectivity to Authorize.Net Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Authorize.Net from an ASP.NET MVC application.
-
Create Amazon Athena-Connected Applications in Appsmith
Connect to Amazon Athena Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Amazon Athena data.
-
Replicate BigCommerce Data to Multiple Databases
Replicate BigCommerce data to disparate databases with a point-and-click configuration.
-
Automated Continuous Trello Replication to MongoDB
Use CData Sync for automated, continuous, customizable Trello replication to MongoDB.
-
Access Live AgileCRM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate AgileCRM data into the statistical analysis tools available in SAS JMP. This article shows how to use AgileCRM data in the Graph Builder and Query Builder.
-
Automated Continuous Aha! Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Aha! replication to Google BigQuery.
-
Visualize Shippo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Shippo data.
-
Replicate Multiple Todoist Accounts via the CData Sync CLI
Replicate multiple Todoist accounts to one or many databases.
-
Use the CData Software JDBC Driver for CockroachDB in MicroStrategy Web
Connect to CockroachDB data in MicroStrategy Web using the CData Software JDBC Driver for CockroachDB.
-
Connect to Azure DevOps Data in DBArtisan
Use wizards in DBArtisan to configure Azure DevOps data as a data source.
-
Integrate Goose with Live Kafka Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Kafka data from within the local AI agent.
-
Automated Continuous Copper Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Copper replication to Amazon S3.
-
Replicate Dynamics 365 Data in Heroku for Use in Salesforce Connect
Replicate Dynamics 365 data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData SSIS Components for Databricks
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Databricks.
-
Automated Continuous Azure Blob Storage Replication to MongoDB
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to MongoDB.
-
How to Work with Deel Data in AWS Glue Jobs Using JDBC
Connect to Deel from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Feed Egnyte Data into FineReport
How to set Egnyte data as a JDBC data source in FineReport.
-
Trigger Outreach.io IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Outreach.io with standard wizards in Logic Apps.
-
Import Real-Time Procore Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Procore data in ColdFusion.
-
How to load Oracle Eloqua Reporting data into Elasticsearch via Logstash
Introducing a simple method to load Oracle Eloqua Reporting data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Query Avro Data in MySQL Workbench
Execute MySQL queries against live Avro data from MySQL Workbench.
-
Use the CData Software ODBC Driver for CircleCI in MicroStrategy Desktop
Connect to CircleCI data in MicroStrategy Desktop using the CData Software ODBC Driver for CircleCI.
-
Getting Started with the CData ADO.NET Provider for SharePoint Excel Services
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SharePoint Excel Services.
-
Use Grok to Talk to Your Mode 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 Mode data for you.
-
Connect to Amazon Athena Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Amazon Athena.
-
Access Opsgenie Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Opsgenie data from HeidiSQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dropbox
Provide connectivity to Dropbox data through an SAP BusinessObjects universe.
-
Choosing the Best Method to Connect WordPress to SQL Server: 5 Options Explained
Discover multiple ways to connect and use WordPress data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for ClickUp in SAS for Real-Time Reporting and Analytics
Connect to real-time ClickUp data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ClickUp.
-
Getting Started with the CData Tableau Connector for Blackbaud FE NXT
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Blackbaud FE NXT.
-
Create a Data Access Object for Discord Data using JDBI
A brief overview of creating a SQL Object API for Discord data in JDBI.
-
How to connect to Oracle Eloqua Data from Spring Boot
Connect to Oracle Eloqua in a Spring Boot Application using the CData JDBC Driver for Oracle Eloqua
-
Access Live XML Data in Coginiti Pro
Connect to and query live XML data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Deploy the ADO.NET Provider for Cassandra on an SSRS Report Server
Connect to Cassandra 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.
-
Connect to Microsoft Exchange Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Exchange data in Airbyte.
-
Build an OLAP Cube in SSAS from ConvertKit Data
Establish a connection to ConvertKit data data from SQL Server Analysis Services, and use the ConvertKit Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Dify with Live PingOne 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 PingOne data.
-
Analyze Miro Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Miro data with the CData JDBC Driver for Miro.
-
Establish a Live Connection with Hugging Face Data using Tableau Bridge
The CData ODBC Driver for Hugging Face enables you to integrate live Hugging Face data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to work with Discord Data in Apache Spark using SQL
Access and process Discord Data in Apache Spark using the CData Software JDBC Driver.
-
How to use SQLAlchemy ORM to access Google Ads Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Ads data.
-
Build Freshservice Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Freshservice data and build visualizations in Tableau Cloud.
-
Connect to Webex Data from a Connection Pool in JBoss
Integrate Webex data into Java servlets: Use the Management Console in JBoss to install the Webex JDBC Driver.
-
Migrating data from Salesloft to Snowflake using CData SSIS Components.
Easily push Salesloft data to Snowflake using the CData SSIS Tasks for Salesloft and Snowflake.
-
Connect to Redis from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Redis data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Query Adobe Experience Manager Data in ColdFusion
Write standard ColdFusion data access code to connect to Adobe Experience Manager data.
-
Integrate Freshservice with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Freshservice with External Services.
-
Getting Started with the CData SSIS Components for ZohoMarketingHub
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZohoMarketingHub.
-
Publish SpaceX-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SpaceX data.
-
Access Testmonitor Data from MySQL in Amazon QuickSight
Connect to Testmonitor and build visualizations of Testmonitor data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous CloudConvert Replication to SingleStore
Use CData Sync for automated, continuous, customizable CloudConvert replication to SingleStore.
-
Query, Visualize, and Share live Dropbox Data in Redash
Use CData Connect AI to connect to live Dropbox data in Redash for querying, visualizing, and sharing.
-
Deploy the ADO.NET Provider for Google Directory on an SSRS Report Server
Connect to Google Directory 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.
-
Integrate OpenCode with Live SAP Business One Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SAP Business One data from within your AI coding agent.
-
Model Sage 200 Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Sage 200, enabling the direct import of real-time Sage 200 data.