CData Software - Knowledge Base
Recent Articles
-
Automated Continuous AfterShip Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable AfterShip replication to PostgreSQL.
-
Create Informatica Mappings From/To an ODBC Data Source for Invoiced
Create an ODBC connection to Invoiced in Informatica and browse and transfer Invoiced data.
-
Automated Continuous Azure Data Catalog Replication to MySQL
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to MySQL.
-
Access Live Certinia Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Certinia data from your Excel spreadsheets.
-
Query Dynamics 365 Business Central Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Dynamics 365 Business Central data from Node.js.
-
Creating FreshBooks-Connected Applications in Unqork
You can use CData Connect AI to feed FreshBooks data to Unqork and build custom business apps.
-
Enable the Hubstaff JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Hubstaff data.
-
How to connect to Onfleet Data with Squirrel SQL client
Connect to Onfleet data and execute queries in the Squirrel SQL Client.
-
Create Kintone-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Kintone Data from OutSystems and build custom enterprise apps using live Kintone data.
-
Automated Continuous Microsoft Ads Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Google Cloud SQL.
-
Connect Sage Intacct to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sage Intacct data using the CData Python MCP Server.
-
Visualize SAP ByDesign 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 SAP ByDesign data into TIBCO Spotfire.
-
Minimum Requirements for CData API Server
This page lists the minimum system requirements for using CData API Server.
-
Visualize Live Supabase Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Supabase data.
-
Use Azure AI Foundry to Talk to Your GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your GraphQL data for you.
-
DataBind Charts to Instantly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Instantly 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.
-
Load SharePoint Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SharePoint data to a database.
-
Connect to and Visualize Live BigCommerce Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live BigCommerce data.
-
How to Build an ETL App for Azure Data Lake Storage Data in Python with CData Connect AI
Extract and transform live Azure Data Lake Storage data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Redis Data in RapidMiner
Integrate Redis data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous SpaceX Replication to Databricks
Use CData Sync for automated, continuous, customizable SpaceX replication to Databricks.
-
Work with AfterShip Data in FoxPro
Load AfterShip data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Publish Crystal Reports on FTP Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date FTP data.
-
Automated Continuous Grafana Replication to SingleStore
Use CData Sync for automated, continuous, customizable Grafana replication to SingleStore.
-
Connect to Omnisend Data in Ruby
Connect to Omnisend data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Build an ETL App for QuickBooks Data in Python with CData
Create ETL applications and real-time data pipelines for QuickBooks data in Python with petl.
-
Connect to TaxJar Data from PowerBuilder via ADO.NET
This article demonstrates how to access TaxJar data from Appeon PowerBuilder using the CData ADO.NET Provider for TaxJar.
-
Build Cloudant Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Cloudant data and build visualizations in Tableau Cloud.
-
Connect to QuickBooks Online from a Connection Pool in WebLogic
Use the CData JDBC Driver for QuickBooks Online to connect to QuickBooks Online data from Web applications running on WebLogic.
-
Automated Continuous Toggl Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Toggl data replication to OneLake in Microsoft Fabric.
-
Automate Access Data Replication to Couchbase
Use CData Sync to Customize and automate Access data replication to Couchbase.
-
Integrate with Live Xero Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Xero from the MuleSoft Anypoint Platform to integrate live Xero data into custom reports and dashboards.
-
How to Work with PingOne Data in ETL Validator JDBC
Connect to PingOne from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live Microsoft Teams 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 Microsoft Teams data through natural language.
-
Connect to CapsuleCRM Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live CapsuleCRM data.
-
Integrate LibreChat with Live AgileCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live AgileCRM data from within the chat interface.
-
Build Pipelines with Live Sage 300 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Sage 300 from Google Cloud Data Fusion, enabling the integration of live Sage 300 data into the building and management of effective data pipelines.
-
How to Connect to Live SAP HANA XS Advanced 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 SAP HANA XS Advanced data for you.
-
Access Live Azure Table Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Table data from your Excel spreadsheets.
-
Automated Continuous Slack Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Slack replication to IBM DB2.
-
LINQ to ChargeOver 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 ChargeOver Data Provider.
-
How to Use a Microsoft Access Database to Update WordPress Data in Real Time
Update WordPress data by creating a linked table in Microsoft Access with the CData WordPress ODBC Driver.
-
Connect to Testmonitor Data in Jaspersoft Studio
Execute SQL to remote Testmonitor data in Jaspersoft Studio.
-
Analyze CockroachDB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of CockroachDB data and visualize live CockroachDB data in Infragistics Reveal.
-
Working with Workday Data in LINQPad
Execute LINQ queries to Workday data in LINQPad.
-
Connect to ConstantContact Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ConstantContact to connect to ConstantContact data and execute queries in PowerBuilder.
-
Connect to Azure Table Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Table data using standard SQL.
-
Access Live XML Data in Excel 365 Online (Excel for the web)
Connect to XML data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate with Workable Data in JReport Designer
Create charts and reports based on Workable data in JReport Designer.
-
Build MVC Applications with Connectivity to Mouseflow Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Mouseflow from an ASP.NET MVC application.
-
Connect ClickUp to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ClickUp with IBM WebSphere for seamless data integration and connectivity.
-
Integrating Cursor with Stack Exchange 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.
-
Publish GitHub-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live GitHub data.
-
Automated Continuous Wistia Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Wistia replication to Amazon Redshift.
-
Build Pipelines with Live Guru Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Guru from Google Cloud Data Fusion, enabling the integration of live Guru data into the building and management of effective data pipelines.
-
Replicate xBase Data to Multiple Databases
Replicate xBase data to disparate databases with a point-and-click configuration.
-
Changelog: Driver Update 2024.2
Review the driver-specific changes from the 2024.2 CData Driver release.
-
Automated Continuous Couchbase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Couchbase replication to Apache Cassandra.
-
Integrate with Live Sugar CRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Sugar CRM from the MuleSoft Anypoint Platform to integrate live Sugar CRM data into custom reports and dashboards.
-
How to Connect to Live Oracle Financials Cloud 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 Oracle Financials Cloud data through natural language.
-
Build SharePoint-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SharePoint Data and create custom apps in Mendix.
-
Connect to Salesforce Data 360 Data in NetBeans
Connect to Salesforce Data 360 data in NetBeans with the data source configuration wizard.
-
Access Notion Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Notion data from HeidiSQL.
-
Access Live Microsoft Exchange Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Exchange data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating GitHub Copilot with ChargeOver 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 Azure Synapse Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Azure Synapse and the Script function in FileMaker Pro to connect to Azure Synapse and work with Azure Synapse data in your FileMaker application.
-
Create Data Visualizations in Cognos BI with Everhour Data
Access Everhour data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Feed SAP ByDesign Data into FineReport
How to set SAP ByDesign data as a JDBC data source in FineReport.
-
Choosing the Best Method to Connect ZohoSubscriptions to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoSubscriptions data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated FormSite Data Replication to Teradata
Use CData Sync to Customize and automate FormSite data replication to Teradata.
-
Automated Continuous Adobe Commerce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to PostgreSQL.
-
Query SQL Analysis Services Data as a SQL Server Database in Node.js
Execute SQL Server queries against SQL Analysis Services data from Node.js.
-
Use CData Connect AI to Access Greenhouse Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Greenhouse data in the Power Pivot business intelligence tool.
-
Connect to ZohoMarketingHub Data in Google Apps Script via Connect AI
Use CData Connect AI to access ZohoMarketingHub data in Google Apps Script.
-
LINQ to ZohoDesk 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 ZohoDesk Data Provider.
-
Connect to MariaDB in SpagoBI
Create reports featuring live MariaDB data in SpagoBI Studio. Host MariaDB reports on SpagoBI Server.
-
Connect to SAP Concur Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Concur data from PowerBuilder using the SAP Concur JDBC Driver.
-
How to load Salesforce data into Elasticsearch via Logstash
Introducing a simple method to load Salesforce data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Natively Connect to FreeAgent Data in PHP
The CData ODBC driver for FreeAgent enables you to create PHP applications with connectivity to FreeAgent data. Leverage the native support for ODBC in PHP.
-
Build a PostgreSQL Interface for RabbitMQ Data using the CData JDBC Driver
Use the Remoting features of the RabbitMQ JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Supabase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Supabase replication to AlloyDB.
-
Access Live Instagram Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Instagram data through MCP integration.
-
Connect to Paylocity Data from a Connection Pool in JBoss
Integrate Paylocity data into Java servlets: Use the Management Console in JBoss to install the Paylocity JDBC Driver.
-
Automated Continuous Freshsales Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Freshsales replication to Google Cloud SQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for RSS
Provide connectivity to RSS feeds through an SAP BusinessObjects universe.
-
Create Dynamics 365 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dynamics 365 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Zoho Inventory Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to SQL Server.
-
Integrate with Live Active Directory Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Active Directory from the MuleSoft Anypoint Platform to integrate live Active Directory data into custom reports and dashboards.
-
Automated Continuous Retently Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Retently replication to PostgreSQL.
-
Process & Analyze Neo4J Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Neo4J Data.
-
Create Dashboards and Visualize Live SAP Hybris C4C Data in Geckoboard
Use CData Connect AI to connect to live SAP Hybris C4C data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Getting Started with the CData ADO.NET Provider for Short.io
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Establish a Live Connection with Rootly Data using Tableau Bridge
The CData ODBC Driver for Rootly enables you to integrate live Rootly data into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Mailgun Data in Looker
Use CData Connect AI to connect to Mailgun Data from Looker and build custom apps using live Mailgun data.
-
Analyze SendPulse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SendPulse data in Microsoft R Open.
-
How to Connect to Live Attio 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 Attio data for you.
-
Getting Started with the CData Power BI Connector for Browserless
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData ADO.NET Provider for Google Ad Manager
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Ad Manager.
-
Connect to Teradata Data in Google Apps Script via Connect AI
Use CData Connect AI to access Teradata data in Google Apps Script.
-
Connect to Zoho Books Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zoho Books data in the Denodo Virtual DataPort Administrator.