CData Software - Knowledge Base
Recent Articles
-
Replicate Airtable Data in Heroku for Use in Salesforce Connect
Replicate Airtable to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Parquet Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache Parquet.
-
Use Microsoft Copilot Studio to talk to your Office 365 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 Microsoft Office 365 for you.
-
Access Live Presto Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Presto data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect Flowise AI Agents to Live IBM Cloud Object Storage 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 IBM Cloud Object Storage without replication.
-
Access LeadDesk Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access LeadDesk from your Oracle system.
-
Use the CData Software JDBC Driver for SAP SuccessFactors LMS in MicroStrategy Web
Connect to SAP SuccessFactors LMS in MicroStrategy Web using the CData Software JDBC Driver for SAP SuccessFactors LMS.
-
Connect to SAP Ariba Procurement Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP Ariba Procurement Data and connect to SAP Ariba Procurement in Akorbi Digital RunMyProcess.
-
How to connect and process Campaigner from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Campaigner.
-
Use Azure AI Foundry to Talk to Your Bullhorn CRM 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 Bullhorn CRM for you.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Databricks to Power BI dashboards. Simply drag and drop Databricks into data visuals on the Power BI canvas.
-
Build Cassandra-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Apache Cassandra and build Cassandra-connected web apps with Axios.
-
How to Connect to Live Square 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 Square for you.
-
Connecting Mastra with Salesforce CRM Analytics 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 Salesforce CRM Analytics, no replication required.
-
Visualize ServiceDesk Plus Data in TIBCO Spotfire through ADO.NET
Integrate ServiceDesk Plus into dashboards in TIBCO Spotfire.
-
Operational Reporting on Xero Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Xero Accounting.
-
Connect Simplesat to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Simplesat using the CData Python MCP Server.
-
Create Dynamics 365 Business Central-Connected Nintex Workflows
Use CData Connect AI to connect to Dynamics 365 Business Central Data from Nintex Workflow Cloud and build custom workflows using live Dynamics 365 Business Central.
-
Analyze ChargeOver Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ChargeOver with the CData JDBC Driver for ChargeOver.
-
Import Real-Time Redshift Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Amazon Redshift in ColdFusion.
-
Integrate SpaceX with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SpaceX with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SpaceX.
-
Integrate Cursor with Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Exact Online from within the editor.
-
Access HelloSign Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for HelloSign.
-
Integrating IBM Cloud Object Storage Data in Talend Cloud Data Management Platform
Connect IBM Cloud Object Storage Data with Talend Cloud Data Management Platform using the CData JDBC Driver for IBM Cloud Object Storage.
-
Getting Started with the CData Power BI Connector for Shippo
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
ETL Vault CRM in Oracle Data Integrator
This article shows how to transfer Veeva Vault & Vault CRM into a data warehouse using Oracle Data Integrator.
-
Build Apps with Live Drip Data Using the Low-Code Development Platform of Mendix
Connect Drip with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Cline with Live Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live IBM Cloudant from within your IDE.
-
Use the CData Software ODBC Driver for Printify in MicroStrategy Web
Connect to Printify in MicroStrategy Web using the CData Software ODBC Driver for Printify.
-
Build an OLAP Cube in SSAS from SharePoint Data
Establish a connection to Microsoft SharePoint data from SQL Server Analysis Services, and use the SharePoint Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate Avro Data from PowerShell
Write a quick PowerShell script to query Apache Avro. Use connectivity to the live data to replicate Apache Avro to SQL Server.
-
Connect to Timely Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Timely to connect to Timely and execute queries in PowerBuilder.
-
Build Semantic Layer Views for Lakebase Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Lakebase.
-
Migrating data from Customer.io to Google BigQuery using CData SSIS Components.
Easily push Customer.io to Google BigQuery using the CData SSIS Tasks for Customer.io and Google BigQuery.
-
Use Biml to Build SSIS Tasks to Replicate Google Calendar Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Calendar to SQL Server.
-
Stream FTP Data into Apache Kafka Topics
Access and stream FTP Servers in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to publish and share Nethunt Data dashboards with Tableau Server
The CData ODBC driver for Nethunt enables you integrate Nethunt into Tableau dashboards.
-
Import Asana Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Asana Data and provide access to live Asana for custom reports in the Power BI Service.
-
Query DB2 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume DB2 entities in PHP by modeling them as objects.
-
Getting Started with the CData SSIS Components for Freshservice
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Freshservice.
-
Build a Singer.io Tap for BigCommerce With the CData Python Connector
Learn how to easily build a Singer.io Tap for live BigCommerce data using
-
Build Suadeo-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Suadeo to explore live Suadeo Data in Claude Code to assist with building Suadeo-powered applications.
-
Automated Continuous Amazon Athena Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Apache Cassandra.
-
Prepare, Blend, and Analyze Basecamp Data in Alteryx Designer (ODBC)
Build workflows to access live Basecamp for self-service data analytics.
-
DataBind Controls to Adobe Commerce Data in C++Builder
DataBind to Adobe Commerce in C++Builder with standard components and controls.
-
Integrating LangGraph with Oracle HCM Cloud Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle HCM Cloud within automated workflows.
-
How to connect PolyBase to Kintone
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Kintone.
-
Connect and Visualize Live Facebook Ads Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Facebook Ads into the Databricks platform and create visualization dashboards with real-time Facebook Ads.
-
Integrate with SAP Data in JReport Designer
Create charts and reports based on SAP ERP/NetWeaver in JReport Designer.
-
Connect to GitHub Data in DBArtisan
Use wizards in DBArtisan to configure GitHub as a data source.
-
Integrate Real-Time Access to Act-On in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Act-On in real time.
-
Viewing Smartsheet Data in RAD Studio Data Explorer
How to view Smartsheet in RAD Studio Data Explorer using the CData ODBC Driver for Smartsheet.
-
Connect to Paylocity Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Paylocity.
-
Migrating data from Drift to Google BigQuery using CData SSIS Components.
Easily push Drift to Google BigQuery using the CData SSIS Tasks for Drift and Google BigQuery.
-
Analyze ServiceNow Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ServiceNow from Power Pivot. You will use the Table Import Wizard to load ServiceNow. You can visually build the import query or use any SQL supported by the driver.
-
Build a PostgreSQL Interface for Tavily Data using the CData JDBC Driver
Use the Remoting features of the Tavily JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Azure Data Lake Storage Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Data Lake Storage.
-
Automate NetSuite Data Replication to SAP HANA
Use CData Sync to customize and automate NetSuite CRM & ERP replication to SAP HANA.
-
Connect to Aha! Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Aha!.
-
Getting Started with the CData Python Connector for Square
Learn to install and license the CData Python Connector
-
Write a Simple Go Application to work with ZohoDesk Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZohoDesk.
-
Replicate CouchDB Data to Multiple Databases
Replicate Apache CouchDB to disparate databases with a point-and-click configuration.
-
Bridge HubDB Connectivity with Apache NiFi
Access and process HubDB in Apache NiFi using the CData JDBC Driver.
-
Access MYOB AccountRight Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MYOB AccountRight from HeidiSQL.
-
Connect to Gong Data in NetBeans
Connect to Gong in NetBeans with the data source configuration wizard.
-
Access Live Bitbucket Data in Coginiti Pro
Connect to and query live Bitbucket from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Natively Connect to Acumatica Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Acumatica ERP. Leverage the native support for ODBC in PHP.
-
Analyze Google Directory Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Directory from Power Pivot. You will use the Table Import Wizard to load Google Directory. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Live Twilio Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Twilio in CData Connect AI and connect to your Twilio from PostgreSQL.
-
Connect to Harvest Data in DBeaver
Use the CData ODBC Driver to connect to Harvest in DBeaver.
-
How to Connect the Power BI Service to FreshBooks: Complete Guide
Connect to the CData Software Power BI Connector for FreshBooks from PowerBI.com to provide real-time FreshBooks across the organization.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for PingOne
Provide connectivity to PingOne through an SAP BusinessObjects universe.
-
Build AI/ML Models with Live Authorize.Net Data using Dataiku
Connect Authorize.Net Data with Dataiku using the CData JDBC Driver for Authorize.Net.
-
Query YouTube Analytics Data from Node.js
Use the OData endpoint of the CData API Server to connect to your YouTube Analytics and perform CRUD operations on YouTube Analytics from Node.js.
-
How to Seamlessly Import Act-On Data into IBM SPSS Modeler
Integrate Act-On data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate HBase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HBase with External Services.
-
Jumpseller Reporting in OBIEE with the Jumpseller JDBC Driver
Deploy the Jumpseller JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Build an ETL App for Optimizely Data in Python with CData
Create ETL applications and real-time data pipelines for Optimizely in Python with petl.
-
Build Semantic Layer Views for QuickBooks Online Data in APOS Live Data Gateway
Use the CData Connector for QuickBooks Online in APOS Live Data Gateway to build Semantic Layer Views for QuickBooks Online.
-
How to import Avro Data into Apache Solr
Use the CData Software JDBC Driver for Avro in Data Import Handler and create an automated import of Apache Avro to Apache Solr Enterprise Search platform.
-
Query Email Data as a MySQL Database in Node.js
Execute MySQL queries against Email from Node.js.
-
Establish a Live Connection with Adobe Commerce Data using Tableau Bridge
The CData ODBC Driver for Adobe Commerce enables you to integrate live Adobe Commerce into Tableau Cloud dashboards using the Tableau Bridge.
-
Load Salesforce Data 360 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesforce Data 360 to a database.
-
Visualize AgileCRM Data in Sisense
Create an ElastiCube in Sisense app with access to AgileCRM.
-
Access Live ScrapingBee Data in Coginiti Pro
Connect to and query live ScrapingBee from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Microsoft Copilot Studio to talk to your Acumatica 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 Acumatica ERP for you.
-
Getting Started with the CData JDBC Driver for Smartsheet
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Smartsheet.
-
LINQ to Zoho Inventory 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 Zoho Inventory Data Provider.
-
Visualize AdRoll Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to AdRoll.
-
Using the CData Software ODBC Driver for Rebilly in PyCharm
Connect to Rebilly as an ODBC data source in PyCharm using the CData Software ODBC Driver for Rebilly.
-
Analyze Live Highrise Data in SAS Viya
Use CData Connect AI to connect to Highrise CRM from SAS Viya and deploy self-service analytics using live Highrise CRM.
-
Access PhantomBuster Data from MySQL in PHP
Connect to PhantomBuster through the standard MySQL libraries in PHP.
-
Analyze Live Trello Data in SAS Viya
Use CData Connect AI to connect to Trello from SAS Viya and deploy self-service analytics using live Trello.
-
Rapidly Develop SQL Server-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 SQL Server.
-
Integrating Cursor CLI with SAP Business Warehouse 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 OpenCode Terminal with Dotmailer 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.
-
How to import GitLab Data into Apache Solr
Use the CData Software JDBC Driver for GitLab in Data Import Handler and create an automated import of GitLab to Apache Solr Enterprise Search platform.
-
Connect to HubSpot Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for HubSpot in the Denodo Virtual DataPort Administrator.
-
Access Live SQL Analysis Services Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SQL Analysis Services from your Excel spreadsheets.
-
Access AgileCRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live AgileCRM from HeidiSQL.