CData Software - Knowledge Base
Recent Articles
-
Query LaunchDarkly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against LaunchDarkly data from Node.js.
-
Visualize BigCommerce Data in TIBCO Spotfire through OData
Integrate BigCommerce data into dashboards in TIBCO Spotfire.
-
Automated Continuous IBM Informix Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable IBM Informix replication to PostgreSQL.
-
How to connect and process NASA data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live NASA data.
-
Access Monday.com Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Monday.com data from your Oracle system.
-
Connect to Factorial Data from PowerBuilder via JDBC
This article demonstrates how to access Factorial data from PowerBuilder using the Factorial JDBC Driver.
-
How to Access Live ZohoInvoice Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ZohoInvoice enables you to integrate ZohoInvoice data into workflows built using Microsoft Power Automate Desktop.
-
Viewing Reckon Accounts Hosted Data in RAD Studio Data Explorer
How to view Reckon Accounts Hosted data in RAD Studio Data Explorer using the CData ODBC Driver for Reckon Accounts Hosted.
-
Query Freshservice Data as a MySQL Database in Node.js
Execute MySQL queries against Freshservice data from Node.js.
-
How to Connect to Live AlloyDB Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your AlloyDB data through natural language.
-
How to Query Live Grafana Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Grafana data data in natural language using Python.
-
Visualize xBase Data in TIBCO Spotfire through OData
Integrate xBase data into dashboards in TIBCO Spotfire.
-
Connecting Moonlit Workflow with Kafka 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 Kafka data in real time.
-
Analyze Pipedrive Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pipedrive data in Microsoft R Open.
-
Consume Xero OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Xero feeds that reflect any changes in SAP Lumira.
-
Create Informatica Mappings From/To an ODBC Data Source for ScrapingBee
Create an ODBC connection to ScrapingBee in Informatica and browse and transfer ScrapingBee data.
-
Access Live Azure Synapse Data in AWS Lambda
Connect to live Azure Synapse data in AWS Lambda using the CData JDBC Driver.
-
Edit and Search External CouchDB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of CouchDB data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create CouchDB Data objects that you can access from apps and the dashboard.
-
Build Dashboards with Salesforce CRM Analytics Data in DBxtra
Create dynamic dashboards and perform analytics based on Salesforce CRM Analytics data in DBxtra.
-
Use the CData ODBC Driver for LDAP from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LDAP to connect to LDAP objects from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LDAP objects in Excel.
-
Access Live Marketo Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Marketo data from your Excel spreadsheets.
-
Back Up Amplitude 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 Amplitude data data.
-
Connect to Azure Data Catalog Data in NetBeans
Connect to Azure Data Catalog data in NetBeans with the data source configuration wizard.
-
Use the CData Software ODBC Driver for Toggl in SAS for Real-Time Reporting and Analytics
Connect to real-time Toggl data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Toggl.
-
Connect to Google Analytics in SpagoBI
Create reports featuring live Google Analytics data in SpagoBI Studio. Host Google Analytics reports on SpagoBI Server.
-
Automate Stripe Data Replication to Azure Synapse
Use CData Sync to customize and automate Stripe data replication to Azure Synapse.
-
Connect to Cloudflare Data from Crystal Reports
Use CData Connect AI to connect to and report on live Cloudflare data from Crystal Reports.
-
How to Work with Azure Table Data in AWS Glue Jobs Using JDBC
Connect to Azure Table from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Query Live Simplesat Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Simplesat data data in natural language using Python.
-
Integrate Samanage with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Samanage with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Samanage data.
-
How to Visualize Simplesat Data in Python with pandas
Use pandas and other modules to analyze and visualize live Simplesat data in Python.
-
Connect SageHR Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SageHR data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live Cloudant Data in Excel 365 Online (Excel for the web)
Connect to Cloudant data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create FreeAgent Dataflows on PowerBI.com
Connect to the CData Power BI Connector for FreeAgent from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use Claude to Talk to Your Printify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Printify data for you.
-
Prepare, Blend, and Analyze ZohoExpense Data in Alteryx Designer (ODBC)
Build workflows to access live ZohoExpense data for self-service data analytics.
-
Connecting Mastra with Cvent 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 Cvent data, no replication required.
-
Analyze Google Analytics Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Analytics data with the CData JDBC Driver for Google Analytics.
-
Automate Zoho Inventory Data Replication to Azure Synapse
Use CData Sync to customize and automate Zoho Inventory data replication to Azure Synapse.
-
Connect to and Query Amazon Marketplace Data in QlikView over ODBC
Create data visualizations with Amazon Marketplace data in QlikView.
-
A PostgreSQL Interface for SAS xpt Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAS xpt JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Mailjet Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Mailjet replication to delimited files (CSV/TSV).
-
Connect to PingOne Data from a Connection Pool in Jetty
The PingOne JDBC Driver supports connection pooling: This article shows how to connect faster to PingOne data from Web apps in Jetty.
-
Create Dynamic Mocean Grids Using the Infragistics XamDataGrid
Learn how you can connect Mocean to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Open WebUI with Live PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live PostgreSQL data from within the chat interface.
-
Automated Continuous Deel Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Deel replication to PostgreSQL.
-
Deploy the ADO.NET Provider for Exact Online on an SSRS Report Server
Connect to Exact Online 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.
-
Access Live Elasticsearch 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 Elasticsearch data through MCP integration.
-
Integrating Codex with FreshBooks 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.
-
WooCommerce Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to WooCommerce data through CData Connect AI using different applications and tools.
-
How to Query Live HubDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live HubDB data data in natural language using Python.
-
How to load Microsoft Planner data into Elasticsearch via Logstash
Introducing a simple method to load Microsoft Planner data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Datasets from Odoo in Domo Workbench and Build Visualizations of Odoo Data in Domo
Use the CData Software ODBC Driver for Odoo to create datasets from Odoo data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Ontraport Replication to Snowflake
Use CData Sync for automated, continuous, customizable Ontraport replication to Snowflake.
-
Create Dynamic Sentry Grids Using the Infragistics XamDataGrid
Learn how you can connect Sentry to Infragistics XamDataGrid to build dynamic grids.
-
Query Live Amazon Athena 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 Amazon Athena data directly from the development environment.
-
Integrate Dify with Live Quickbase 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 Quickbase data.
-
Model HCL Domino Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and HCL Domino, enabling the direct import of real-time HCL Domino data.
-
Create Attio-Connected Dashboards in Grafana
Connect to Attio Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Attio data.
-
Build Sybase IQ-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Sybase IQ data.
-
Access Freshsales Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Freshsales data from HeidiSQL.
-
Create Dynamic Cassandra Grids Using the Infragistics XamDataGrid
Learn how you can connect Cassandra to Infragistics XamDataGrid to build dynamic grids.
-
Query Authorize.Net Data in DataGrip
Create a Data Source for Authorize.Net in DataGrip and use SQL to query live Authorize.Net data.
-
Visualize Live Salesforce Data in the Power BI Service
Use CData Connect AI to connect to live Salesforce data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Teradata Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Teradata data from Informatica Cloud.
-
Build a Simple VCL Application for LeadDesk Data
How to build a simple VCL Application to view LeadDesk data in RAD Studio using the CData ODBC Driver for LeadDesk.
-
Google Calendar Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Calendar data through CData Connect AI using different applications and tools.
-
Integrate Azure Table Data in the Pentaho Report Designer
Publish reports based on Azure Table data in the Pentaho BI tool.
-
Build Marketo-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 Marketo data without replication.
-
How to Connect to Live MarkLogic 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 MarkLogic data for you.
-
Integrate Outreach.io Data in Pentaho Data Integration
Build ETL pipelines based on Outreach.io data in the Pentaho Data Integration tool.
-
How to Access Workday Data Using Entity Framework
This article shows how to access Workday data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Biml to Build SSIS Tasks to Replicate Salesloft Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Salesloft data to SQL Server.
-
Connect to Power BI XMLA from a Connection Pool in WebLogic
Use the CData JDBC Driver for Power BI XMLA to connect to Power BI XMLA data from Web applications running on WebLogic.
-
Automated Continuous CockroachDB Replication to SQLite
Use CData Sync for automated, continuous, customizable CockroachDB replication to SQLite.
-
Build AI/ML Models with Live Slack Data using Dataiku
Connect Slack Data with Dataiku using the CData JDBC Driver for Slack.
-
Perform Batch Operations with Odoo Data in Apache NiFi
Connect to Odoo data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Consume WooCommerce OData Feeds in SAP Lumira
Use the API Server to create data visualizations on WooCommerce feeds that reflect any changes in SAP Lumira.
-
Use Agno to Talk to Your SparkPost Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SparkPost data for you.
-
Creating Shopify-Connected Applications in Unqork
You can use CData Connect AI to feed Shopify data to Unqork and build custom business apps.
-
Connect to Rootly Data in NetBeans
Connect to Rootly data in NetBeans with the data source configuration wizard.
-
Load Facebook Ads Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Facebook Ads data to a database.
-
Connect to Redshift Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Redshift as an External Source in Dremio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Telegram
Provide connectivity to Telegram data through an SAP BusinessObjects universe.
-
Automated Continuous AlloyDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable AlloyDB replication to Snowflake.
-
Use ChatGPT to Talk to Your Discord 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 Discord data for you.
-
Create Apps from Instagram Data in Qlik Sense Cloud
Use CData Connect AI to connect to Instagram Data and build apps from live Instagram data in Qlik Sense Cloud.
-
Automate LaunchDarkly Data Replication to Azure Data Lake
Use CData Sync to customize and automate LaunchDarkly data replication to Azure Data Lake.
-
Connect to Google Campaign Manager 360 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Campaign Manager 360 data.
-
ETL PabblySubscriptions in Oracle Data Integrator
This article shows how to transfer PabblySubscriptions data into a data warehouse using Oracle Data Integrator.
-
Build Toggl Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Toggl data and build visualizations in Tableau Cloud.
-
Connect to NetSuite Data from PowerBuilder via JDBC
This article demonstrates how to access NetSuite data from PowerBuilder using the NetSuite JDBC Driver.
-
Access Tanda Data from MySQL in PHP
Connect to Tanda through the standard MySQL libraries in PHP.
-
Build Dashboards with Bright Data Data in DBxtra
Create dynamic dashboards and perform analytics based on Bright Data data in DBxtra.
-
Create Power BI Reports on Real-Time Tavily Data
Use the CData ODBC Driver for Tavily to visualize Tavily data in Power BI Desktop.
-
Connect to Google Analytics Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Analytics and the Script function in FileMaker Pro to connect to Google Analytics and work with Google Analytics data in your FileMaker application.
-
Build SQL Server-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 SQL Server data without replication.
-
Access Live CSV Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live CSV data from your Google Sheets.
-
Integrate with Bright Data Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Bright Data data in SnapLogic.
-
Integrating Claude Code CLI with ConvertAPI 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.