CData Software - Knowledge Base
Recent Articles
-
Query Live Freshservice Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Freshservice data through a conversational interface.
-
Connect to Perplexity Data in DBArtisan
Use wizards in DBArtisan to configure Perplexity data as a data source.
-
Connect to HBase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for HBase and the SQL Gateway to access HBase data from Google Apps Script.
-
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 data.
-
Build a Simple VCL Application for Sentry Data
How to build a simple VCL Application to view Sentry data 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 data.
-
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 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 data 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 data using the visual workflow in the CloverDX data integration tool.
-
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 data 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 Phoenix data 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 data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live eBay Analytics data.
-
Build Workday-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 Workday data without replication.
-
Automated Continuous JobNimbus Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable JobNimbus replication to Azure SQL Database.
-
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 data 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 data in LINQPad.
-
Connect to Mailgun Data in DBeaver
Use the CData ODBC Driver to connect to Mailgun data 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 data and visualize live Google Contacts data 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
Extract and transform live Zoom data in Python with petl and the CData Connect AI Python SDK.
-
Link Cohere with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Cohere data in Filemaker Pro for Mac or Windows.
-
Integrating Kiro 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.
-
Analyze LinkedIn Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of LinkedIn data and visualize live LinkedIn data 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 data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live AlloyDB Data in Excel 365 Online (Excel for the web)
Connect to AlloyDB data 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 data directly from the development environment.
-
Feed BigQuery Data into FineReport
How to set BigQuery data as a JDBC data source in FineReport.
-
Access Live Access Data in TIBCO Data Virtualization
Use the Access Tibco DV Adapter to create a Access data data source in TIBCO Data Virtualization Studio and gain access to live Access data 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 SharePoint data 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 data.
-
Natively Connect to ZendeskSell Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZendeskSell data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Trello in MicroStrategy
Connect to Trello data in MicroStrategy Developer using the CData Software JDBC Driver for Trello.
-
Analyze ConstantContact Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ConstantContact data and visualize ConstantContact data in SAP Analytics Cloud.
-
Connect to Google Forms from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Forms to connect to Google Forms data 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 Dynamics 365 data 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 data 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 data and create an interactive dashboard in Metabase from Azure Data Lake Storage data.
-
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 data for you.
-
Build Dashboards with Facebook Data in Dundas BI
Create dynamic dashboards and perform analytics based on Facebook data in Dundas BI.
-
Connect to SFTP Data in CloverDX (formerly CloverETL)
Transfer SFTP data 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 data 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 data from Node.js.
-
Use the CData Software JDBC Driver for ZohoSubscriptions in MicroStrategy Web
Connect to ZohoSubscriptions data 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 data.
-
Automated Continuous Teradata Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Teradata replication to Google Cloud SQL.
-
Integrating Codex with Quickbase 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.
-
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 Dynamics 365 data into dashboards in TIBCO Spotfire.
-
Integrating Cursor 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.
-
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 data in Apache Airflow using the CData JDBC Driver.
-
Connecting Agentforce with Grafana Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Grafana data for you.
-
How to Query Confluence Data in MySQL Workbench
Execute MySQL queries against live Confluence data from MySQL Workbench.
-
Query, Visualize, and Share live OData Services in Redash
Use CData Connect AI to connect to live OData services 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 data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Live Omnisend Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Omnisend in CData Connect AI and connect to your Omnisend data from PostgreSQL.
-
Extract, Transform, and Load GitLab Data in Informatica PowerCenter
Create a simple Workflow for GitLab data 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 data and visualize live SAP BusinessObjects BI data in Infragistics Reveal.
-
Build Automated YouTube Analytics-Connected Workflows in Zapier
Use CData Connect AI to connect to live YouTube Analytics data 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 data.
-
Access Live Square Data in AWS Lambda
Connect to live Square data in AWS Lambda using the CData JDBC Driver.
-
Access Live Typeform 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 Typeform data through MCP integration.
-
Query BigQuery Data in ColdFusion
Write standard ColdFusion data access code to connect to BigQuery data.
-
Visualize SharePoint Excel Services Data in Tableau
The CData ODBC driver for SharePoint Excel Services enables you integrate SharePoint Excel Services data into Tableau dashboards.
-
Natively Connect to Mixpanel Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Mixpanel data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Mocean Replication to Oracle
Use CData Sync for automated, continuous, customizable Mocean replication to Oracle.
-
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 SQL Server data 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 data 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 data.
-
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 data as a JDBC data source in FineReport.
-
Build Voice Agents in ElevenLabs with access to Live ZohoPeople Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ZohoPeople data.
-
Publish Mailjet-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Mailjet data.
-
Connect to and Query Sage 200 Data in QlikView over ODBC
Create data visualizations with Sage 200 data in QlikView.
-
Visualize Odoo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Odoo data.
-
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 data 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 data for you.
-
Connect to Mode Data in NetBeans
Connect to Mode data 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.