CData Software - Knowledge Base
Recent Articles
-
Integrate LibreChat with Live ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ZohoPeople data from within the chat interface.
-
Connect to and Visualize Live Phoenix Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Phoenix data.
-
Access Live MySQL 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 MySQL data through MCP integration.
-
How to Connect Flowise AI Agents to Live Salesloft Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Salesloft data without replication.
-
Automated Continuous Couchbase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Couchbase replication to Google BigQuery.
-
Build Semantic Layer Views for ZohoInvoice Data in APOS Live Data Gateway
Use the CData Connector for ZohoInvoice in APOS Live Data Gateway to build Semantic Layer Views for ZohoInvoice data.
-
Use Microsoft Copilot Studio to talk to your NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data for you.
-
Use the CData Software ODBC Driver for Mailjet in MicroStrategy
Connect to Mailjet data in MicroStrategy Developer using the CData Software ODBC Driver for Mailjet.
-
Connect to Epicor Kinetic Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Epicor Kinetic data in the Denodo Virtual DataPort Administrator.
-
Integrating Antigravity CLI with ZohoInvoice data via CData CLI
Connect ZohoInvoice data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect DBeaver to WooCommerce via a JDBC Driver
Manage WooCommerce data with visual tools in DBeaver like the query browser.
-
Connect to Instagram Data from HeidiSQL
Use CData Connect AI to connect to and query live Instagram data from HeidiSQL.
-
Publish Reports with Salesforce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce data.
-
Connect to Egnyte Data from a Connection Pool in Jetty
The Egnyte JDBC Driver supports connection pooling: This article shows how to connect faster to Egnyte data from Web apps in Jetty.
-
Build ZohoExpense-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ZohoExpense Data and create custom apps in Bubble.
-
Use Databricks Agent Bricks to Talk to Your XML Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your XML data for you.
-
Build Outlook-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Outlook data.
-
Automated Continuous ShipStation Replication to Snowflake
Use CData Sync for automated, continuous, customizable ShipStation replication to Snowflake.
-
How to connect and process Oracle Eloqua Reporting data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Eloqua Reporting data.
-
Connect and Visualize Live Egnyte Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Egnyte data into the Databricks platform and create visualization dashboards with real-time Egnyte data.
-
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.
-
DataBind Charts to Oracle Sales Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Sales 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 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.
-
Extract, Transform, and Load EnterpriseDB Data in Informatica PowerCenter
Create a simple Workflow for EnterpriseDB data in Informatica PowerCenter.
-
How to connect to PayPal Data in DBVisualizer
Integrate PayPal data with visual data analysis tools and data connection wizards in DBVisualizer
-
Rapidly Develop Everhour-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 Everhour.
-
Use Dash to Build Web Apps on Timely Data via CData Connect AI
Build interactive Dash web apps on live Timely data using pandas and the CData Connect AI Python SDK.
-
Getting Started with the CData SSIS Components for Templated
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Templated.
-
How to Connect to Live JSON Services 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 JSON services for you.
-
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.
-
How to Connect to Live Microsoft Planner Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Microsoft Planner data for you.
-
Connect to DB2 Data in NetBeans
Connect to DB2 data in NetBeans with the data source configuration wizard.
-
Object-Relational Mapping (ORM) with AgileCRM 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 AgileCRM data into a Java-based ORM framework, Hibernate.
-
Build Charts with Avaza Data in Clear Analytics
Create dynamic charts and perform analytics based on Avaza data in Clear Analytics.
-
Create Hubstaff Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Hubstaff data access from reports, embedded analytics, and more.
-
Connect to ConvertAPI Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ConvertAPI and work with ConvertAPI data in your FileMaker applications.
-
Query Smartsheet Data as a SQL Server Database in Node.js
Execute SQL Server queries against Smartsheet data from Node.js.
-
Seamlessly Bring Microsoft Teams Data into Retool Using CData Connect AI
Integrate Microsoft Teams data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Excel Spreadsheet Automation on Google Translate Data with the QUERY Formula
Pull data from Google Translate, automate spreadsheets, and more with the QUERY formula.
-
Integrate Trae with Live LDAP Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live LDAP objects from within the AI-powered IDE.
-
Connect to Google Cloud Storage from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Cloud Storage to connect to Google Cloud Storage data from Web applications running on WebLogic.
-
Query Workday Data as a MySQL Database in Node.js
Execute MySQL queries against Workday data from Node.js.
-
How to connect to Moosend Data from Spring Boot
Connect to Moosend in a Spring Boot Application using the CData API Driver for JDBC
-
Migrating data from Bullhorn CRM to Databricks using CData SSIS Components.
Easily push Bullhorn CRM data to Databricks using the CData SSIS Tasks for Bullhorn CRM and Databricks.
-
How to Access SpaceX Data Using Entity Framework
This article shows how to access SpaceX data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
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.
-
Create Datasets from EmailOctopus in Domo Workbench and Build Visualizations of EmailOctopus Data in Domo
Use the CData Software ODBC Driver for EmailOctopus to create datasets from EmailOctopus data in Domo Workbench and then build visualizations in the Domo service.
-
A PostgreSQL Interface for SAS xpt Data using the CData ODBC Driver
Use the SQL Gateway and SAS xpt ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Visualize Google Contacts Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Contacts data in Python.
-
Sybase IQ Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sybase IQ facts in real time.
-
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.
-
How to Visualize Microsoft Planner 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 Microsoft Planner data in Python.
-
How to import Sybase Data into Apache Solr
Use the CData Software JDBC Driver for Sybase in Data Import Handler and create an automated import of Sybase data to Apache Solr Enterprise Search platform.
-
Choosing the Best Method to Connect PostgreSQL to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PostgreSQL data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Supabase Data in JRuby
Create a simple JRuby app with access to live Supabase data.
-
Connect to Flowlu from a Connection Pool in WebLogic
Use the CData JDBC Driver for Flowlu to connect to Flowlu data from Web applications running on WebLogic.
-
Access Live Couchbase Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Couchbase data into the statistical analysis tools available in SAS JMP. This article shows how to use Couchbase data in the Graph Builder and Query Builder.
-
Build Dashboards with SharePoint Data in DBxtra
Create dynamic dashboards and perform analytics based on SharePoint data in DBxtra.
-
Access Live Exact Online Data in AWS Lambda
Connect to live Exact Online data in AWS Lambda using the CData JDBC Driver.
-
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.
-
Create Microsoft Exchange-Connected Business Apps in AppSheet
Connect to Microsoft Exchange Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Exchange data.
-
Analyze Microsoft Teams Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Teams data in Microsoft R Open.
-
Build FreshBooks-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to FreshBooks Data from Zoho Analytics and import live FreshBooks data.
-
Integrating Claude Code CLI with ElevenLabs 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.
-
Integrate Google's Antigravity Agent with Live Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Cloudant data using the Model Context Protocol.
-
Access Live Teamwork Data in AWS Lambda
Connect to live Teamwork data in AWS Lambda using the CData JDBC Driver.
-
Connecting Mastra with Dynamics 365 Business Central 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 Dynamics 365 Business Central data, no replication required.
-
How to Work with Jira Assets Data in ETL Validator JDBC
Connect to Jira Assets from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate with Zoom Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zoom data to a JSON file on disk.
-
Add Gmail Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Gmail with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use ChatGPT to Talk to Your Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Freshservice data for you.
-
How to integrate Metabase with Yelp Data
Use CData Connect AI to connect to live Yelp data and create an interactive dashboard in Metabase from Yelp data.
-
Object-Relational Mapping (ORM) with HubSpot 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 HubSpot data into a Java-based ORM framework, Hibernate.
-
A PostgreSQL Interface for Eventbrite Data (MySQL Remoting via JDBC)
Use the Remoting features of the Eventbrite JDBC Driver to create a PostgreSQL entry-point for data access.
-
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.
-
Automated Continuous Unbounce Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Unbounce replication to Google BigQuery.
-
Connect to Live Salesloft Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Salesloft in CData Connect AI and connect to your Salesloft data from PostgreSQL.
-
Query Blackbaud FE NXT Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Blackbaud FE NXT data from Node.js.
-
Integrate HDFS Data into Power Automate Desktop using CData Connect
CData Connect for HDFS Data enables you to integrate HDFS data into workflows built using Microsoft Power Automate Desktop.
-
Build Dashboards with Facebook Data in Dundas BI
Create dynamic dashboards and perform analytics based on Facebook data in Dundas BI.
-
Replicate Sybase Data to Multiple Databases via the CData Sync CLI
Replicate Sybase data to disparate databases with a single configuration.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Twitter Ads
Provide connectivity to Twitter Ads data through an SAP BusinessObjects universe.
-
Bridge Keap Connectivity with Apache NiFi
Access and process Keap data in Apache NiFi using the CData JDBC Driver.
-
Connect to Amazon Marketplace Data from HeidiSQL
Use CData Connect AI to connect to and query live Amazon Marketplace data from HeidiSQL.
-
Connect to Freshdesk Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Freshdesk and the SQL Gateway to access Freshdesk data from Google Apps Script.
-
Access Harvest Data from MySQL in Amazon QuickSight
Connect to Harvest and build visualizations of Harvest data using a MySQL Connection in Amazon QuickSight.
-
Connect to Google Analytics Data in JRuby
Create a simple JRuby app with access to live Google Analytics data.
-
Visualize Live Microsoft Planner Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Planner data into custom reports in Power BI.
-
Integrate with Elasticsearch Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Elasticsearch data in SnapLogic.
-
Build Trello Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Trello data and build visualizations in Tableau Cloud.
-
A PostgreSQL Interface for MailChimp Data using the CData ODBC Driver
Use the SQL Gateway and MailChimp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Pinecone Data in Jaspersoft Studio
Execute SQL to remote Pinecone data in Jaspersoft Studio.
-
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.
-
Integrate Mailgun with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Mailgun with External Services.
-
Visualize Greenplum Data in Tableau
The CData ODBC driver for Greenplum enables you integrate Greenplum data into Tableau dashboards.
-
How to connect to Flowlu Data from Spring Boot
Connect to Flowlu in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Microsoft Ads Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Ads data in Airbyte.
-
Publish Figshare-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Figshare data.
-
LINQ to Accelo 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 Accelo Data Provider.
-
Build an OLAP Cube in SSAS from Office 365 Data
Establish a connection to Office 365 data data from SQL Server Analysis Services, and use the Office 365 Data Provider to build OLAP cubes for use in analytics and reporting.