CData Software - Knowledge Base
Recent Articles
-
Connect to HDFS Data in NetBeans
Connect to Apache HDFS in NetBeans with the data source configuration wizard.
-
Integrating Dataiku with Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure DevOps.
-
Build Data Flows from SQL Server to Oracle through SSIS
Easily push SQL Server data to Oracle using the CData SSIS Tasks for Oracle.
-
Query, Visualize, and Share live MySQL Data in Redash
Use CData Connect AI to connect to live MySQL in Redash for querying, visualizing, and sharing.
-
How to Access Live eBay Analytics Data in Power Automate Desktop via ODBC
The CData ODBC Driver for eBay Analytics enables you to integrate eBay Analytics into workflows built using Microsoft Power Automate Desktop.
-
A PostgreSQL Interface for ZendeskSell Data (MySQL Remoting via JDBC)
Use the Remoting features of the ZendeskSell JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Antigravity CLI with LightSpeedRetail via CData CLI
Connect LightSpeedRetail to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Retently Data in Tableau
The CData ODBC driver for Retently enables you integrate Retently into Tableau dashboards.
-
Build Rootly-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Rootly.
-
Automated Continuous Sage 300 Replication to Databricks
Use CData Sync for automated, continuous, customizable Sage 300 replication to Databricks.
-
How to Easily Query JobNimbus Data in OpenOffice Base
Connect to JobNimbus data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Live FHIR Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to FHIR from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Egnyte
Provide connectivity to Egnyte through an SAP BusinessObjects universe.
-
Explore Geographical Relationships in JSON Services with Power Map
Create data visualizations with JSON in Power Map.
-
Use the CData Software ODBC Driver for MariaDB in SAS for Real-Time Reporting and Analytics
Connect to real-time MariaDB in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MariaDB.
-
Object-Relational Mapping (ORM) with Dotmailer 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 Dotmailer into a Java-based ORM framework, Hibernate.
-
Visualize Webex 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 Webex into TIBCO Spotfire.
-
Connect to Wave Financial Data in JRuby
Create a simple JRuby app with access to live Wave Financial.
-
DataBind Controls to Grafana Data in Delphi
DataBind to Grafana in Delphi with standard data access components and controls.
-
Build Data Flows from SQL Server to JSON through SSIS
Easily push SQL Server data to JSON using the CData SSIS Tasks for JSON.
-
Automated Continuous Flowlu Replication to SingleStore
Use CData Sync for automated, continuous, customizable Flowlu replication to SingleStore.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Clockify to Power BI dashboards. Simply drag and drop Clockify into data visuals on the Power BI canvas.
-
Rapidly Develop Avaza-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 Avaza.
-
Configure the CData JDBC Driver for Hugging Face in a Connection Pool in Tomcat
Connect to Hugging Face from a connection pool in Tomcat.
-
Migrating data from Impala to Google BigQuery using CData SSIS Components.
Easily push Apache Impala to Google BigQuery using the CData SSIS Tasks for Impala and Google BigQuery.
-
Getting Started with the CData Power BI Connector for SAP Ariba Procurement
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Ariba Procurement.
-
Build a Simple VCL Application for Browserless Data
How to build a simple VCL Application to view Browserless in RAD Studio using the CData ODBC Driver for Browserless.
-
How to Query Live Epicor Kinetic Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Epicor Kinetic data in natural language using Python.
-
Connect to Amazon Athena from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon Athena, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Bidirectional Access to Oracle Financials Cloud Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Financials Cloud in Filemaker Pro for Mac or Windows.
-
DataBind Charts to SAS Data Sets Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAS Data Sets 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.
-
Back Up Odoo ERP to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Odoo. In this article, we will employ an SSIS workflow to populate a database with Odoo ERP data.
-
Connect to Hugging Face in SpagoBI
Create reports featuring live Hugging Face in SpagoBI Studio. Host Hugging Face reports on SpagoBI Server.
-
How to use SQLAlchemy ORM to access Vault CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Veeva Vault & Vault CRM.
-
Work with Basecamp Data in FoxPro
Load Basecamp into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create SSAS Tabular Models from Sage 200 Data
How to build a SQL Server Analysis Service Tabular Model from Sage 200 using CData drivers.
-
Create Reports with ServiceNow Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ServiceNow.
-
Integrate Live Epicor Kinetic Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Epicor Kinetic to Blue Prism using the CData ODBC Driver for Epicor Kinetic to create automated workflows for repetitive business tasks.
-
Access Excel Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Excel from your Oracle system.
-
Edit and Search External Avro Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Apache Avro to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Avro Data objects that you can access from apps and the dashboard.
-
Automate Azure DevOps Data Replication to Azure Synapse
Use CData Sync to customize and automate Azure DevOps replication to Azure Synapse.
-
How to use SQLAlchemy ORM to access YouTube Analytics Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of YouTube Analytics.
-
Create Reports with WooCommerce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date WooCommerce.
-
Analyze RSS Feeds in Infragistics Reveal
Use the CData API Server to create an OData API on top of RSS Feeds and visualize live RSS Feeds in Infragistics Reveal.
-
Feed XML Data into FineReport
How to set XML Files as a JDBC data source in FineReport.
-
Connect to Salesforce CRM Analytics Data in DBArtisan
Use wizards in DBArtisan to configure Salesforce CRM Analytics as a data source.
-
Automated Continuous SingleStore Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SingleStore replication to IBM DB2.
-
Import Webex Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Webex. In this article, you will use the OData format to import Webex into Microsoft Power Query.
-
Connect to Adobe Commerce Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Adobe Commerce in Airbyte.
-
Build Apollo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apollo and build web apps with connectivity to live Apollo.
-
Import Real-Time Productboard Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Productboard in ColdFusion.
-
Getting Started with the CData JDBC Driver for OneNote
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for OneNote.
-
Use Biml to Build SSIS Tasks to Replicate WooCommerce Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate WooCommerce to SQL Server.
-
Model, Search, and Visualize Live SAP ByDesign Data in ThoughtSpot
Use CData Connect AI to connect to live SAP Business ByDesign for modeling, searching, and visualizing.
-
Work with ClickTime Data in FoxPro
Load ClickTime into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous PabblySubscriptions Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to delimited files (CSV/TSV).
-
Automate Presto Data Replication to Azure Data Lake
Use CData Sync to customize and automate Presto replication to Azure Data Lake.
-
Access SAP Business One Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Business One from HeidiSQL.
-
Create SSAS Tabular Models from Sugar CRM Data
How to build a SQL Server Analysis Service Tabular Model from Sugar CRM using CData drivers.
-
Import Phoenix Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache Phoenix. In this article, you will use the OData format to import Apache Phoenix into Microsoft Power Query.
-
Migrating data from Clockify to Databricks using CData SSIS Components.
Easily push Clockify to Databricks using the CData SSIS Tasks for Clockify and Databricks.
-
How to Connect to & Open Redshift Data in Microsoft Excel
This article uses the CData ODBC driver for Redshift to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Establish a Live Connection with FHIR Data using Tableau Bridge
The CData ODBC Driver for FHIR enables you to integrate live FHIR into Tableau Cloud dashboards using the Tableau Bridge.
-
DataBind Avalara AvaTax Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Avalara with the DevExpress Windows Forms and Web controls to provide Avalara AvaTax to a chart.
-
Getting Started with the CData Power BI Connector for Stack Exchange
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Query Live Azure Data Lake Storage 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 Azure Data Lake Storage directly from the development environment.
-
Moving Data from Teradata to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Teradata data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous BambooHR Replication to IBM DB2
Use CData Sync for automated, continuous, customizable BambooHR replication to IBM DB2.
-
Build Dashboards with Toggl Data in Dundas BI
Create dynamic dashboards and perform analytics based on Toggl in Dundas BI.
-
Connect to Nuclia Data from a Connection Pool in Jetty
The Nuclia JDBC Driver supports connection pooling: This article shows how to connect faster to Nuclia from Web apps in Jetty.
-
Create NetSuite SuiteAnalytics-Connected Applications in Appsmith
Connect to NetSuite SuiteAnalytics Data via CData Connect AI in Appsmith and create custom business applications with real-time access to NetSuite SuiteAnalytics.
-
Build Procore-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Procore Data from Zoho Analytics and import live Procore.
-
Publish Unbounce-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Unbounce.
-
Getting Started with the CData Tableau Connector for SingleStore
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SingleStore.
-
Build a Simple VCL Application for Access Data
How to build a simple VCL Application to view Microsoft Access in RAD Studio using the CData ODBC Driver for Access.
-
Bind Live Exa Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Exa data
-
Automated Continuous Exact Online Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Exact Online replication to IBM DB2.
-
Access HubDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access HubDB from your Oracle system.
-
Deploy the ADO.NET Provider for Clari on an SSRS Report Server
Connect to Clari 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 LionDesk Data from MySQL in PHP
Connect to LionDesk through the standard MySQL libraries in PHP.
-
Prepare, Blend, and Analyze NetSuite Data in Alteryx Designer (Connect AI)
Build workflows to access live NetSuite CRM & ERP for self-service data analytics.
-
Build Automated Workflows with Live Klaviyo Data in Workato
Use CData Connect AI to connect to live Klaviyo and build automated workflows in Workato.
-
Access Live CSV 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 CSV/TSV Files through MCP integration.
-
Build Facebook-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Facebook to explore live Facebook Data in Cursor to assist with building Facebook-powered applications.
-
Edit and Search Stripe External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Stripe to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Stripe objects that you can access from apps and the dashboard.
-
Connect to Live Exact Online Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Exact Online in CData Connect AI and connect to your Exact Online from PostgreSQL.
-
DataBind Controls to Oracle Service Cloud Data in Delphi
DataBind to Oracle Service Cloud in Delphi with standard data access components and controls.
-
Operational Reporting on Bitly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Bitly.
-
Connect to SAP Business One Data in RapidMiner
Integrate SAP Business One with standard components and data source configuration wizards in RapidMiner Studio.
-
Build MarkLogic-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for MarkLogic to explore live MarkLogic Data in GitHub Copilot to assist with building MarkLogic-powered applications.
-
Create Data Visualizations in Cognos BI with Zoho Projects Data
Access Zoho Projects as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze SurveyMonkey Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SurveyMonkey with the CData JDBC Driver for SurveyMonkey.
-
Integrate Live Google Calendar Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Calendar from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Calendar.
-
Integrate Real-Time Access to Hugging Face in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Hugging Face in real time.
-
Integrating Claude Code CLI with EnterpriseDB 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 Elasticsearch-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Elasticsearch and build Elasticsearch-connected web apps with Axios.
-
Integrating Gumloop with Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Act CRM within automated workflows.
-
How to Work with Sage Cloud Accounting Data in AWS Glue Jobs Using JDBC
Connect to Sage Cloud Accounting from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Ontraport-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Ontraport Data in Gemini Code Assist to assist with building Ontraport-powered applications.
-
A PostgreSQL Interface for Apollo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Apollo JDBC Driver to create a PostgreSQL entry-point for data access.