CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for Aircall Data in APOS Live Data Gateway
Use the CData Connector for Aircall in APOS Live Data Gateway to build Semantic Layer Views for Aircall.
-
Build a Simple VCL Application for Sentry Data
How to build a simple VCL Application to view Sentry in RAD Studio using the CData ODBC Driver for Sentry.
-
How to Connect to & Open Ontraport Data in Microsoft Excel
This article uses the CData ODBC driver for Ontraport to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Publish SendInBlue-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SendInBlue.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Authorize.Net to Power BI dashboards. Simply drag and drop Authorize.Net into data visuals on the Power BI canvas.
-
Getting Started with the CData SSIS Components for Templated
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Templated.
-
Integrating OpenCode Terminal with Acumatica 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.
-
Use the CData Software JDBC Driver for CSV in MicroStrategy Web
Connect to CSV/TSV Files in MicroStrategy Web using the CData Software JDBC Driver for CSV.
-
A PostgreSQL Interface for Omnisend Data (MySQL Remoting via JDBC)
Use the Remoting features of the Omnisend JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Chargebee Data in CloverDX (formerly CloverETL)
Transfer Chargebee using the visual workflow in the CloverDX data integration tool.
-
Build Shopify-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Shopify to explore live Shopify Data in GitHub Copilot to assist with building Shopify-powered applications.
-
Access Live Microsoft Planner Data 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 Microsoft Planner through MCP integration.
-
Excel Spreadsheet Automation on Google Translate Data with the QUERY Formula
Pull data from Google Translate, automate spreadsheets, and more with the QUERY formula.
-
Import Phoenix Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Phoenix Data and provide access to live Apache Phoenix for custom reports in the Power BI Service.
-
Create Discourse Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Discourse data access from reports, embedded analytics, and more.
-
Getting Started with the CData Power BI Connector for JSON
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for JSON.
-
How to connect and process eBay Analytics from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live eBay Analytics.
-
Automated Continuous MariaDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MariaDB replication to PostgreSQL.
-
Excel Spreadsheet Automation on Google Sheets Data with the QUERY Formula
Pull data from Google Sheets, automate spreadsheets, and more with the QUERY formula.
-
How to connect SharePoint with Sybase Data through external lists
Provide Sybase to SharePoint users as an external list.
-
Rapidly Develop Zoho Inventory-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 Zoho Inventory.
-
Working with Gorgias Data in LINQPad
Execute LINQ queries to Gorgias in LINQPad.
-
Connect to Mailgun Data in DBeaver
Use the CData ODBC Driver to connect to Mailgun in DBeaver.
-
Automated Continuous HBase Replication to Oracle
Use CData Sync for automated, continuous, customizable HBase replication to Oracle.
-
Analyze Google Contacts Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Contacts and visualize live Google Contacts in Infragistics Reveal.
-
Automated Continuous Klipfolio Replication to SQLite
Use CData Sync for automated, continuous, customizable Klipfolio replication to SQLite.
-
How to Build an ETL App for Zoom Data in Python with CData Connect AI
Build ETL pipelines that read and write live Zoom in Python with petl and the CData Connect AI Python SDK.
-
Bidirectional Access to Cohere Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Cohere in Filemaker Pro for Mac or Windows.
-
Integrating Kiro CLI with Codat 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.
-
Automated Continuous Spark Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Spark replication to Apache Cassandra.
-
How to Import Data from Slack into Google Sheets
Import Slack into a Google spreadsheet that is automatically refreshed.
-
Analyze LinkedIn Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of LinkedIn and visualize live LinkedIn in Infragistics Reveal.
-
Getting Started with the CData Tableau Connector for AgileCRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Establish a Live Connection with Google Campaign Manager 360 Data using Tableau Bridge
The CData ODBC Driver for Google Campaign Manager 360 enables you to integrate live Google Campaign Manager 360 into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live AlloyDB Data in Excel 365 Online (Excel for the web)
Connect to Google AlloyDB from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Query Live Adobe Analytics Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Adobe Analytics directly from the development environment.
-
Feed BigQuery Data into FineReport
How to set Google BigQuery as a JDBC data source in FineReport.
-
Access Live Access Data in TIBCO Data Virtualization
Use the Access Tibco DV Adapter to create a Microsoft Access data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Access from your TDV Server.
-
Connect Zoho Recruit to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zoho Recruit with IBM WebSphere for seamless data integration and connectivity.
-
Build SharePoint Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Microsoft SharePoint and build visualizations in Tableau Cloud.
-
How to Seamlessly Import Ontraport Data into IBM SPSS Modeler
Integrate Ontraport data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to VWO Data in JRuby
Create a simple JRuby app with access to live VWO.
-
Natively Connect to ZendeskSell Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZendeskSell. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Trello in MicroStrategy
Connect to Trello in MicroStrategy Developer using the CData Software JDBC Driver for Trello.
-
Connect to Google Forms from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Forms to connect to Google Forms from Web applications running on WebLogic.
-
How to Connect to Live Dynamics 365 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 Microsoft Dynamics 365 for you.
-
Build a PostgreSQL Interface for SQL Server Data using the CData JDBC Driver
Use the Remoting features of the SQL Server JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous YouTube Analytics Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to OneLake in Microsoft Fabric.
-
How to integrate Metabase with Azure Data Lake Storage Data
Use CData Connect AI to connect to live Azure Data Lake Storage and create an interactive dashboard in Metabase from Azure Data Lake Storage.
-
Use Microsoft Copilot Studio to talk to your SAP Ariba Procurement 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 SAP Ariba Procurement for you.
-
Build Dashboards with Facebook Data in Dundas BI
Create dynamic dashboards and perform analytics based on Facebook in Dundas BI.
-
Connect to SFTP Data in CloverDX (formerly CloverETL)
Transfer SFTP using the visual workflow in the CloverDX data integration tool.
-
Build Dashboards with PayPal Data in Dundas BI
Create dynamic dashboards and perform analytics based on PayPal in Dundas BI.
-
How to Use a Microsoft Access Database to Update Reckon Data in Real Time
Update Reckon data by creating a linked table in Microsoft Access with the CData Reckon ODBC Driver.
-
Query Keap Data as a MySQL Database in Node.js
Execute MySQL queries against Keap from Node.js.
-
Use the CData Software JDBC Driver for ZohoSubscriptions in MicroStrategy Web
Connect to ZohoSubscriptions in MicroStrategy Web using the CData Software JDBC Driver for ZohoSubscriptions.
-
Publish Exa-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Exa.
-
Automated Continuous Teradata Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Teradata replication to Google Cloud SQL.
-
Integrating Codex CLI with Quickbase 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.
-
Automate Hive Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Apache Hive and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build a PostgreSQL Interface for Factorial Data using the CData JDBC Driver
Use the Remoting features of the Factorial JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Dynamics 365 Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Dynamics 365 into dashboards in TIBCO Spotfire.
-
Integrating Cursor CLI with Zoho Books 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.
-
Automated Continuous Exact Online Replication to Snowflake
Use CData Sync for automated, continuous, customizable Exact Online replication to Snowflake.
-
Build Microsoft Teams-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Microsoft Teams to explore live Microsoft Teams Data in Cursor to assist with building Microsoft Teams-powered applications.
-
How to Work with Bannerbear Data in AWS Glue Jobs Using JDBC
Connect to Bannerbear from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to integrate Webex with Apache Airflow
Access and process Webex in Apache Airflow using the CData JDBC Driver.
-
Build SAS xpt-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAS xpt to explore live SAS xpt Data in Claude Code to assist with building SAS xpt-powered applications.
-
How to Query Confluence Data in MySQL Workbench
Execute MySQL queries against live Atlassian Confluence from MySQL Workbench.
-
Query, Visualize, and Share live OData Services in Redash
Use CData Connect AI to connect to live OData in Redash for querying, visualizing, and sharing.
-
Visualize Live ClickTime Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ClickTime using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Extract, Transform, and Load GitLab Data in Informatica PowerCenter
Create a simple Workflow for GitLab in Informatica PowerCenter.
-
Analyze SAP BusinessObjects BI Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP BusinessObjects BI and visualize live SAP BusinessObjects BI in Infragistics Reveal.
-
Build Automated YouTube Analytics-Connected Workflows in Zapier
Use CData Connect AI to connect to live YouTube Analytics and build automated workflows in Zapier.
-
Automated Continuous Timely Replication to MySQL
Use CData Sync for automated, continuous, customizable Timely replication to MySQL.
-
Connect to Retently Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Retently.
-
Access Live Square Data in AWS Lambda
Connect to live Square in AWS Lambda using the CData JDBC Driver.
-
Query BigQuery Data in ColdFusion
Write standard ColdFusion data access code to connect to Google BigQuery.
-
Visualize SharePoint Excel Services Data in Tableau
The CData ODBC driver for SharePoint Excel Services enables you integrate SharePoint Excel Services into Tableau dashboards.
-
Natively Connect to Mixpanel Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Mixpanel. Leverage the native support for ODBC in PHP.
-
LINQ to Coinbase 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 Coinbase Data Provider.
-
How to Work with SQL Analysis Services Data in ETL Validator JDBC
Connect to SQL Analysis Services from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Dynamic Instagram Grids Using the Infragistics XamDataGrid
Learn how you can connect Instagram to Infragistics XamDataGrid to build dynamic grids.
-
Automate SQL Server Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft SQL Server replication to Azure Synapse.
-
Object-Relational Mapping (ORM) with Suadeo Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Suadeo into a Java-based ORM framework, Hibernate.
-
How to connect PolyBase to Flowlu
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Flowlu.
-
How to connect to Slack Data from Spring Boot
Connect to Slack in a Spring Boot Application using the CData JDBC Driver for Slack
-
Feed SAS Data Sets Data into FineReport
How to set SAS Data Sets as a JDBC data source in FineReport.
-
Publish Mailjet-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Mailjet.
-
How to Query Live HubSpot Data in Claude Desktop
Connect to and query live HubSpot Data in Claude Desktop using CData MCP Server.
-
Connect to and Query Sage 200 Data in QlikView over ODBC
Create data visualizations with Sage 200 in QlikView.
-
Visualize Odoo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Odoo ERP.
-
Connect to Live Outreach.io Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Outreach.io in CData Connect AI and connect to your Outreach.io from PostgreSQL.
-
Use Microsoft Copilot Studio to talk to your Oracle SCM 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 Oracle SCM for you.
-
Connect to Mode Data in NetBeans
Connect to Mode in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Excel Add-In for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Amazon Athena.
-
Publish Jumpseller-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Jumpseller.
-
How to connect to Landbot Data from Spring Boot
Connect to Landbot in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze Grafana Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Grafana in Microsoft R Open.
-
Connect to and Visualize Live Sage Cloud Accounting Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage Business Cloud Accounting.