CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ADO.NET Provider for REST
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for REST.
-
Access Live ActiveCampaign Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ActiveCampaign data from your Google Sheets.
-
Visualize Avaza Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Avaza data into TIBCO Spotfire.
-
Access Live BenchmarkEmail Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live BenchmarkEmail data from your Excel spreadsheets.
-
Design BIRT Reports on Spark Data
Provide current Spark data to your embedded analytics.
-
How to Query Live SAP Ariba Procurement Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Ariba Procurement data data in natural language using Python.
-
Integrating Codex with Epicor Kinetic 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 Asana Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Asana data from Filemaker Pro on Mac.
-
How to create Grafana federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Grafana data in MySQL .
-
Connect to Rebilly Data in NetBeans
Connect to Rebilly data in NetBeans with the data source configuration wizard.
-
Use Grok to Talk to Your Square 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 Square data for you.
-
Automated Continuous SingleStore Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SingleStore replication to Amazon Redshift.
-
How to Access Live Impala Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Impala enables you to integrate Impala data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Azure Analysis Services in MicroStrategy Desktop
Connect to Azure Analysis Services data in MicroStrategy Desktop using the CData Software ODBC Driver for Azure Analysis Services.
-
Build Pipelines with Live Yelp Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Yelp from Google Cloud Data Fusion, enabling the integration of live Yelp data into the building and management of effective data pipelines.
-
Use Microsoft Copilot Studio to talk to your SFTP 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 SFTP data for you.
-
Extract, Transform, and Load Google Ad Manager Data in Informatica PowerCenter
Create a simple Workflow for Google Ad Manager data in Informatica PowerCenter.
-
Build Apps with Live PingOne data in Adalo using CData Connect AI
Use CData Connect AI to integrate live PingOne data into the Adalo platform and build custom mobile and web applications with real-time PingOne data.
-
Create Cohere Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Cohere from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Supabase Data in ACL Analytics
Connect to Supabase data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Supabase data.
-
Automated Continuous Tavily Replication to SQLite
Use CData Sync for automated, continuous, customizable Tavily replication to SQLite.
-
Integrate with Monday.com Data in JReport Designer
Create charts and reports based on Monday.com data in JReport Designer.
-
Analyze Parquet Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Parquet from Power Pivot. You will use the Table Import Wizard to load Parquet data. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software ODBC Driver for Authorize.Net in MicroStrategy
Connect to Authorize.Net data in MicroStrategy Developer using the CData Software ODBC Driver for Authorize.Net.
-
Build AI Agents with Google Directory Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Google Directory data through CData Connect AI.
-
Import ADP Data Using Azure Data Factory
Use CData Connect AI to connect to ADP Data from Azure Data Factory and import live ADP data.
-
Rapidly Develop ZohoInvoice-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 ZohoInvoice.
-
Connect to Greenhouse Data from HeidiSQL
Use CData Connect AI to connect to and query live Greenhouse data from HeidiSQL.
-
Stream SAP Netweaver Gateway Data into Apache Kafka Topics
Access and stream SAP Netweaver Gateway data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Asana Data in NetBeans
Connect to Asana data in NetBeans with the data source configuration wizard.
-
Integrate Open WebUI with Live Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Highrise data from within the chat interface.
-
Excel Spreadsheet Automation on Amazon S3 Data with the QUERY Formula
Pull data from Amazon S3, automate spreadsheets, and more with the QUERY formula.
-
Replicate Multiple Freshservice Accounts
Replicate multiple Freshservice accounts to one or many databases.
-
Access Live Azure Data Catalog Data in AWS Lambda
Connect to live Azure Data Catalog data in AWS Lambda using the CData JDBC Driver.
-
Integrating Kiro with eBay 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 Zendesk Data in RapidMiner
Integrate Zendesk data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Reports with Cohere Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cohere data.
-
Import Real-Time Pingdom Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pingdom data in ColdFusion.
-
Use the CData Software ODBC Driver for IBM Cloud Object Storage in SAS for Real-Time Reporting and Analytics
Connect to real-time IBM Cloud Object Storage data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for IBM Cloud Object Storage.
-
Getting Started with the CData Tableau Connector for Monday.com
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Monday.com.
-
Migrating data from Teamwork to Snowflake using CData SSIS Components.
Easily push Teamwork data to Snowflake using the CData SSIS Tasks for Teamwork and Snowflake.
-
Query SAP Business Warehouse Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Business Warehouse data from Node.js.
-
Connect to Excel Online Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Excel Online data using standard SQL.
-
Automated Continuous SAP Business One Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP Business One replication to SingleStore.
-
Establish a Live Connection with eBay Analytics Data using Tableau Bridge
The CData ODBC Driver for eBay Analytics enables you to integrate live eBay Analytics data into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze SAP Business Warehouse Data in Looker
Use CData Connect AI to connect to SAP Business Warehouse Data from Looker and build custom apps using live SAP Business Warehouse data.
-
Working with Coinbase Data in LINQPad
Execute LINQ queries to Coinbase data in LINQPad.
-
Access Live REST Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate REST data into the statistical analysis tools available in SAS JMP. This article shows how to use REST data in the Graph Builder and Query Builder.
-
Integrating GitHub Copilot with Bugsnag 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.
-
Load Clari Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Clari data to a database.
-
Create Reports from ConstantContact Data in Looker Studio
Use CData Connect AI to gain access to live ConstantContact data and create custom reports in Looker Studio.
-
Create Data Visualizations in Cognos BI with Sage Cloud Accounting Data
Access Sage Cloud Accounting data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build YouTube Analytics-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live YouTube Analytics data.
-
Connect to BenchmarkEmail Data in RapidMiner
Integrate BenchmarkEmail data with standard components and data source configuration wizards in RapidMiner Studio.
-
Email Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Email data through CData Connect AI using different applications and tools.
-
How to connect PolyBase to Dynamics NAV
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Dynamics NAV data.
-
Import Tavily Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Tavily Data and provide access to live Tavily data for custom reports in the Power BI Service.
-
How to integrate Acumatica with Apache Airflow
Access and process Acumatica data in Apache Airflow using the CData JDBC Driver.
-
Create Apps from Microsoft Entra ID Data in Qlik Sense Cloud
Use CData Connect AI to connect to Microsoft Entra ID Data and build apps from live Microsoft Entra ID data in Qlik Sense Cloud.
-
Process & Analyze MailerLite Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MailerLite Data.
-
Visualize Live Box Data in the Power BI Service
Use CData Connect AI to connect to live Box data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to ZohoPeople Data in RapidMiner
Integrate ZohoPeople data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for SAP ByDesign in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP ByDesign data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP ByDesign.
-
Automate Beeminder Data Replication to SAP HANA
Use CData Sync to customize and automate Beeminder data replication to SAP HANA.
-
Automated Continuous Zoom Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoom replication to Apache Cassandra.
-
Use Dash to Build to Web Apps on GetResponse Data
Create Python applications that use pandas and Dash to build GetResponse-connected web apps.
-
Automated Continuous Office 365 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Office 365 replication to Google Cloud SQL.
-
How to Connect to Live Smartsheet Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Smartsheet data securely in real time.
-
Process & Analyze eBay Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live eBay Data.
-
Use Manus AI to Talk to Your IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on IBM Cloud Object Storage data.
-
Publish Reports with Zoho CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho CRM data.
-
Use Claude to Talk to Your Oracle Financials Cloud 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 Oracle Financials Cloud data for you.
-
Explore Geographical Relationships in Mouseflow Data with Power Map
Create data visualizations with Mouseflow data in Power Map.
-
Create Data Visualizations in Cognos BI with ElevenLabs Data
Access ElevenLabs data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish Reports with Harvest Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Harvest data.
-
Create Salesforce Data 360-Connected Nintex Workflows
Use CData Connect AI to connect to Salesforce Data 360 Data from Nintex Workflow Cloud and build custom workflows using live Salesforce Data 360 data.
-
Visualize Live Paymo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Paymo data into custom reports in Power BI.
-
Explore Geographical Relationships in FreshBooks Data with Power Map
Create data visualizations with FreshBooks data in Power Map.
-
Analyze Adobe Target Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Adobe Target data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect and Visualize Live PingOne Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live PingOne data into the Databricks platform and create visualization dashboards with real-time PingOne data.
-
Visualize Clari Data in Sisense
Create an ElastiCube in Sisense app with access to Clari data.
-
Create Google Directory-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Directory Data from OutSystems and build custom enterprise apps using live Google Directory data.
-
Import and Visualize HBase Data in Power View
Create data visualizations based on HBase data in Excel.
-
Integrate Cline with Live IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live IBM Informix data from within your IDE.
-
Connecting Agentforce with ZohoSubscriptions 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 ZohoSubscriptions data for you.
-
Access Live CouchDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live CouchDB data from your Excel spreadsheets.
-
Connecting Moonlit Workflow with Anaplan 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 Anaplan data in real time.
-
Access Live Simplesat Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Simplesat data into the statistical analysis tools available in SAS JMP. This article shows how to use Simplesat data in the Graph Builder and Query Builder.
-
Connect to ZeroBounce Data in HULFT Integrate
Connect to ZeroBounce as a JDBC data source in HULFT Integrate
-
Automated Continuous Avalara AvaTax Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Amazon Redshift.
-
How to Connect Flowise AI Agents to Live Dynamics NAV 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 Dynamics NAV data without replication.
-
How to integrate REST with Apache Airflow
Access and process REST data in Apache Airflow using the CData JDBC Driver.
-
How to Connect to Live VWO 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 VWO data for you.
-
Use the CData SSIS Components to Insert New or Update Existing Lakebase Records from SQL Server
Easily push SQL Server data to Lakebase using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Lakebase or update existing records with data from a SQL Server database.
-
Build Dashboards with Jira Assets Data in DBxtra
Create dynamic dashboards and perform analytics based on Jira Assets data in DBxtra.
-
Build Pipelines with Live Oracle Service Cloud Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle Service Cloud from Google Cloud Data Fusion, enabling the integration of live Oracle Service Cloud data into the building and management of effective data pipelines.
-
Integrate Devin with Live Impala Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Impala data.
-
Access Live Lakebase Data in Coginiti Pro
Connect to and query live Lakebase data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating LangGraph with SAP Fieldglass Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP Fieldglass data within automated workflows.
-
How to Connect to Live Amazon DynamoDB Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Amazon DynamoDB data without replication.