CData Software - Knowledge Base
Recent Articles
-
Connect to ZohoPeople Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZohoPeople data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating LangChain with Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Oracle Financials Cloud data within automated workflows.
-
Integrate Live Dropbox Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Dropbox data and integrate live Dropbox data into apps built in Microsoft Power Apps.
-
Bridge Lakebase Connectivity with Apache NiFi
Access and process Lakebase data in Apache NiFi using the CData JDBC Driver.
-
Connect to SparkPost Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SparkPost data in the Denodo Virtual DataPort Administrator.
-
How to Build an ETL App for NetSuite SuiteAnalytics Data in Python with CData Connect AI
Extract and transform live NetSuite SuiteAnalytics data in Python with petl and the CData Connect AI Python SDK.
-
Query Databricks Data as a MySQL Database in Node.js
Execute MySQL queries against Databricks data from Node.js.
-
Integrating OpenCode with Apify 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.
-
Integrating LangGraph with VWO Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on VWO data within automated workflows.
-
Connect to CSV Data from Crystal Reports
Use CData Connect AI to connect to and report on live CSV data from Crystal Reports.
-
Automate FreshBooks Data Replication to Azure Synapse
Use CData Sync to customize and automate FreshBooks data replication to Azure Synapse.
-
Create Dashboards and Visualize Live GitHub Data in Geckoboard
Use CData Connect AI to connect to live GitHub data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
LINQ to Teradata 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 Teradata Data Provider.
-
How to Connect to Live Sendwithus Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Sendwithus data for you.
-
Connect to Exact Online Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Exact Online to connect to Exact Online data and execute queries in PowerBuilder.
-
How to Connect to Live Excel Online 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 Excel Online data through natural language.
-
Automated Continuous Zoom Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Zoom replication to Apache Kafka.
-
Connect to SAP HANA Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP HANA Data and connect to SAP HANA data in Akorbi Digital RunMyProcess.
-
Use the CData Software JDBC Driver for Oracle Financials Cloud in MicroStrategy
Connect to Oracle Financials Cloud data in MicroStrategy Developer using the CData Software JDBC Driver for Oracle Financials Cloud.
-
Connect to JSON Services from HeidiSQL
Use CData Connect AI to connect to and query live JSON services from HeidiSQL.
-
Prepare, Blend, and Analyze YouTube Analytics Data in Alteryx Designer (Connect AI)
Build workflows to access live YouTube Analytics data for self-service data analytics.
-
Add Instagram Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Instagram with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to import Hubstaff Data into Apache Solr
Use the CData Software JDBC Driver for Hubstaff in Data Import Handler and create an automated import of Hubstaff data to Apache Solr Enterprise Search platform.
-
How to Connect Slack Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Slack data in real time using natural language.
-
Build Agents in Relevance AI with Access to Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on FTP data within intelligent agent workflows.
-
Use the CData Software ODBC Driver for LaunchDarkly in SAS for Real-Time Reporting and Analytics
Connect to real-time LaunchDarkly data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for LaunchDarkly.
-
Integrate Trae with Live Typeform Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Typeform data from within the AI-powered IDE.
-
Integrate Devin with Live Typeform 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 Typeform data.
-
Automated Continuous Hugging Face Replication to MySQL
Use CData Sync for automated, continuous, customizable Hugging Face replication to MySQL.
-
Visualize Calendly Data in Sisense
Create an ElastiCube in Sisense app with access to Calendly data.
-
Connect to Sybase IQ from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Sybase IQ data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Datasets from Yelp in Domo Workbench and Build Visualizations of Yelp Data in Domo
Use the CData Software ODBC Driver for Yelp to create datasets from Yelp data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate SAP HANA XS Advanced Data into Power Automate Desktop using CData Connect
CData Connect for SAP HANA XS Advanced Data enables you to integrate SAP HANA XS Advanced data into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to Omnisend Data in Delphi
DataBind to Omnisend data in Delphi with standard data access components and controls.
-
Connect to and Visualize Live Instagram Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Instagram data.
-
DataBind Controls to ZohoSubscriptions Data in C++Builder
DataBind to ZohoSubscriptions data in C++Builder with standard components and controls.
-
Query Live Avro 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 Avro data directly from the development environment.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ZohoPeople
Provide connectivity to ZohoPeople data through an SAP BusinessObjects universe.
-
Connect to and Visualize Live Greenhouse Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Greenhouse data.
-
Publish Helpscout-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Helpscout data.
-
How to Access Airtable Data Using Entity Framework
This article shows how to access Airtable data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Power BI Reports on Real-Time CloudConvert Data
Use the CData ODBC Driver for CloudConvert to visualize CloudConvert data in Power BI Desktop.
-
Create Reports with Impala Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Impala data.
-
Use JayDeBeApi to access Clari Data in Python
Use standard Python scripting and the development environment of your choice to access live Clari data.
-
Analyze SAP SuccessFactors Data in Looker
Use CData Connect AI to connect to SAP SuccessFactors Data from Looker and build custom apps using live SAP SuccessFactors data.
-
Integrate Snapchat Ads Data into Power Automate Desktop using CData Connect
CData Connect for Snapchat Ads Data enables you to integrate Snapchat Ads data into workflows built using Microsoft Power Automate Desktop.
-
How to create Google Directory federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Directory data in MySQL .
-
Connect to Avalara AvaTax Data in Claris FileMaker Pro
Use the CData ODBC Driver for Avalara AvaTax in FileMaker Pro to connect to Avalara AvaTax and work with Avalara AvaTax data in your FileMaker applications.
-
Query Live Paymo 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 Paymo data through a conversational interface.
-
Viewing Klipfolio Data in RAD Studio Data Explorer
How to view Klipfolio data in RAD Studio Data Explorer using the CData ODBC Driver for Klipfolio.
-
Automated Continuous Stack Exchange Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Stack Exchange replication to delimited files (CSV/TSV).
-
How to integrate SQL Analysis Services with Apache Airflow
Access and process SQL Analysis Services data in Apache Airflow using the CData JDBC Driver.
-
Work with Live MySQL Data in Power Query
Use CData Connect AI to connect to MySQL data and work with live MySQL data in Microsoft Power Query.
-
How to connect SharePoint with Zoho Projects Data through external lists
Provide Zoho Projects data to SharePoint users as an external list.
-
Integrate Anaplan Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Anaplan data and integrate live Anaplan data into your Power Automate tasks.
-
Create Power BI Reports on Real-Time Azure Data Lake Storage Data
Use the CData ODBC Driver for Azure Data Lake Storage to visualize Azure Data Lake Storage data in Power BI Desktop.
-
Easily Integrate SAP Concur Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Concur data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Python Connector for Microsoft Entra ID
Learn to install and license the CData Python Connector and configure a connection to live Microsoft Entra ID data.
-
Use the CData Software JDBC Driver for ClickTime in MicroStrategy
Connect to ClickTime data in MicroStrategy Developer using the CData Software JDBC Driver for ClickTime.
-
Create Cloudflare-Connected Nintex Workflows
Use CData Connect AI to connect to Cloudflare Data from Nintex Workflow Cloud and build custom workflows using live Cloudflare data.
-
How to Connect to Live VWO Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your VWO data for you.
-
Perform Batch Operations with Square Data in Apache NiFi
Connect to Square data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Visualize Live ZohoDesk Data in the Power BI Service
Use CData Connect AI to connect to live ZohoDesk data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for GitLab in MicroStrategy Desktop
Connect to GitLab data in MicroStrategy Desktop using the CData Software ODBC Driver for GitLab.
-
Automated Continuous ElevenLabs Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ElevenLabs replication to Amazon Redshift.
-
Create Data Visualizations in Cognos BI with HubSpot Data
Access HubSpot data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Viewing Perplexity Data in RAD Studio Data Explorer
How to view Perplexity data in RAD Studio Data Explorer using the CData ODBC Driver for Perplexity.
-
Use the CData Software ODBC Driver for Workday in MicroStrategy Web
Connect to Workday data in MicroStrategy Web using the CData Software ODBC Driver for Workday.
-
Connect to MailerLite Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MailerLite data using standard SQL.
-
How to create Sentry federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Sentry data in MySQL .
-
Use the CData Software ODBC Driver for AgileCRM in MicroStrategy
Connect to AgileCRM data in MicroStrategy Developer using the CData Software ODBC Driver for AgileCRM.
-
Connecting GenSpark with Dynamics CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Dynamics CRM data without any replication or custom integration required.
-
Integrating Kiro with MySQL 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 Redis Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Redis as an External Source in Dremio.
-
Operational Reporting on HBase Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote HBase data.
-
How to Connect to Live MongoDB Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your MongoDB data for you.
-
Build Dynamics 365 Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Dynamics 365 data and build visualizations in Tableau.
-
How to connect to FormSite Data in DBVisualizer
Integrate FormSite data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Postmark Data in Talend Cloud Data Management Platform
Connect Postmark Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to BigCommerce Data in ACL Analytics
Connect to BigCommerce data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to BigCommerce data.
-
How to use SQLAlchemy ORM to access Wrike Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Wrike data.
-
How to Connect DBeaver to Highrise via a JDBC Driver
Manage Highrise data with visual tools in DBeaver like the query browser.
-
How to publish and share Impala Data dashboards with Tableau Server
The CData ODBC driver for Impala enables you integrate Impala data into Tableau dashboards.
-
How to connect to Everhour Data from Spring Boot
Connect to Everhour in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Everhour Data in Jaspersoft Studio
Execute SQL to remote Everhour data in Jaspersoft Studio.
-
How to create Databricks federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Databricks data in MySQL .
-
Integrate Goose with Live Google Search Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Search results from within the local AI agent.
-
Connect to LightSpeedRetail Data in RazorSQL
Connect to LightSpeedRetail from wizards and query LightSpeedRetail data from the GUI in the RazorSQL database management tool.
-
Automated Authorize.Net Data Replication to Teradata
Use CData Sync to Customize and automate Authorize.Net data replication to Teradata.
-
Integrate Trae with Live Google Sheets Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Google Sheets data from within the AI-powered IDE.
-
DataBind Controls to Helpscout Data in C++Builder
DataBind to Helpscout data in C++Builder with standard components and controls.
-
Access Live SAP Netweaver Gateway Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Netweaver Gateway data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Netweaver Gateway data in the Graph Builder and Query Builder.
-
Create Data Visualizations in Cognos BI with Oracle Sales Data
Access Oracle Sales data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Choosing the Best Method to Connect QuickBooks Time to SQL Server: 5 Options Explained
Discover multiple ways to connect and use QuickBooks Time data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Feed Beeminder Data into FineReport
How to set Beeminder data as a JDBC data source in FineReport.
-
Connect Helpscout to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Helpscout with IBM WebSphere for seamless data integration and connectivity.
-
Object-Relational Mapping (ORM) with Confluence 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 Confluence data into a Java-based ORM framework, Hibernate.
-
Object-Relational Mapping (ORM) with eBay Analytics 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 eBay Analytics data into a Java-based ORM framework, Hibernate.
-
ETL PhantomBuster in Oracle Data Integrator
This article shows how to transfer PhantomBuster data into a data warehouse using Oracle Data Integrator.
-
Build AI/ML Models with Live Shopify Data using Dataiku
Connect Shopify Data with Dataiku using the CData JDBC Driver for Shopify.