CData Software - Knowledge Base
Recent Articles
-
Connect to Box Data in CloverDX (formerly CloverETL)
Transfer Box using the visual workflow in the CloverDX data integration tool.
-
Query SpaceX Data in ColdFusion
Write standard ColdFusion data access code to connect to SpaceX.
-
How to Access Live PolarTeamPro Data in Power Automate Desktop via ODBC
The CData ODBC Driver for PolarTeamPro enables you to integrate PolarTeamPro into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Harvest Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Harvest replication to delimited files (CSV/TSV).
-
Integrate Live Zoho Inventory Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zoho Inventory to Blue Prism using the CData ODBC Driver for Zoho Inventory to create automated workflows for repetitive business tasks.
-
Integrating Cursor CLI with Oracle HCM Cloud 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 Neo4J Data from Crystal Reports
Use CData Connect AI to connect to and report on live Neo4J from Crystal Reports.
-
Integrating PingOne Data in Talend Cloud Data Management Platform
Connect PingOne Data with Talend Cloud Data Management Platform using the CData JDBC Driver for PingOne.
-
Analyze Workday Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Workday and visualize Workday in SAP Analytics Cloud.
-
Import Invoiced Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Invoiced. In this article, you will use the OData format to import Invoiced into Microsoft Power Query.
-
Build Semantic Layer Views for Yelp Data in APOS Live Data Gateway
Use the CData Connector for Yelp in APOS Live Data Gateway to build Semantic Layer Views for Yelp.
-
Automated Continuous Google Contacts Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Contacts replication to IBM DB2.
-
Connect to JobNimbus Data in HULFT Integrate
Connect to JobNimbus as a JDBC data source in HULFT Integrate
-
Stream Quaderno Data into Apache Kafka Topics
Access and stream Quaderno in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for BigCommerce
Provide connectivity to BigCommerce through an SAP BusinessObjects universe.
-
Connect to Google Tasks Data in NetBeans
Connect to Google Tasks in NetBeans with the data source configuration wizard.
-
Use the CData Software JDBC Driver for AfterShip in MicroStrategy Desktop
Connect to AfterShip in MicroStrategy Desktop using the CData Software JDBC Driver for AfterShip.
-
Integrate Certinia Data in Pentaho Data Integration
Build ETL pipelines based on Certinia in the Pentaho Data Integration tool.
-
Provide OData Services of MessageBird Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MessageBird by developing a WCF Service Application.
-
View Reports on Real-Time DB2 Data in Power BI Report Server
Use the CData ODBC Driver for DB2 to visualize IBM DB2 in Power BI Desktop and then publish them to Power BI Report Server.
-
Write a Simple Go Application to work with Splunk Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Splunk.
-
Natively Connect to PostgreSQL Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PostgreSQL. Leverage the native support for ODBC in PHP.
-
Analyze SAP SuccessFactors LMS Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP SuccessFactors LMS and visualize SAP SuccessFactors LMS in SAP Analytics Cloud.
-
Build Dashboards with Xero Data in DBxtra
Create dynamic dashboards and perform analytics based on Xero Accounting in DBxtra.
-
Integrating Claude Code CLI with Azure Synapse 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 TaxJar Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for TaxJar and the Script function in FileMaker Pro to connect to TaxJar and work with TaxJar in your FileMaker application.
-
Getting Started with the CData ADO.NET Provider for SAP Business One
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP Business One.
-
Build Pipelines with Live Vertica Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Vertica from Google Cloud Data Fusion, enabling the integration of live Vertica into the building and management of effective data pipelines.
-
How to Connect to Live SAP HANA 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 SAP HANA for you.
-
How to Query Live Yelp Data in Claude Desktop
Connect to and query live Yelp Data in Claude Desktop using CData MCP Server.
-
Extract, Transform, and Load Productboard Data in Informatica PowerCenter
Create a simple Workflow for Productboard in Informatica PowerCenter.
-
Getting Started with the CData SSIS Components for LDAP
Complete guide to installing, licensing, and connecting with the CData SSIS Components for LDAP.
-
Publish Freshsales-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Freshsales.
-
How to connect to Short.io Data from IntelliJ
Integrate connectivity to Short.io with wizards in IntelliJ.
-
Build MVC Applications with Connectivity to SAP Fieldglass Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Fieldglass from an ASP.NET MVC application.
-
How to update SFTP from Excel
This article explains how to transfer data from Excel to SFTP using the Excel Add-In for SFTP.
-
Integrate Live Confluence Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Integrate Landbot with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Landbot with External Services.
-
Migrating data from Drift to Databricks using CData SSIS Components.
Easily push Drift to Databricks using the CData SSIS Tasks for Drift and Databricks.
-
Query, Visualize, and Share live Freshdesk Data in Redash
Use CData Connect AI to connect to live Freshdesk in Redash for querying, visualizing, and sharing.
-
Import Real-Time Oracle Financials Cloud Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle Financials Cloud in ColdFusion.
-
Extract, Transform, and Load Shippo Data in Informatica PowerCenter
Create a simple Workflow for Shippo in Informatica PowerCenter.
-
Create Oracle Eloqua-Connected Dashboards in Grafana
Connect to Oracle Eloqua Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle Eloqua.
-
Use ChatGPT to Talk to Your Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Directory for you.
-
Import Reply.io Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Reply.io. In this article, you will use the OData format to import Reply.io into Microsoft Power Query.
-
Create Dynamic Landbot Grids Using the Infragistics XamDataGrid
Learn how you can connect Landbot to Infragistics XamDataGrid to build dynamic grids.
-
ETL Rebilly in Oracle Data Integrator
This article shows how to transfer Rebilly into a data warehouse using Oracle Data Integrator.
-
Feed Superchat Data into FineReport
How to set Superchat as a JDBC data source in FineReport.
-
Migrating data from GetResponse to Databricks using CData SSIS Components.
Easily push GetResponse to Databricks using the CData SSIS Tasks for GetResponse and Databricks.
-
Connect to Accelo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Accelo to connect to Accelo and execute queries in PowerBuilder.
-
Connect to SAP BusinessObjects BI from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP BusinessObjects BI to connect to SAP BusinessObjects BI from Web applications running on WebLogic.
-
Replicate Bitbucket Data to Multiple Databases
Replicate Bitbucket to disparate databases with a point-and-click configuration.
-
Connect to and Visualize Live Epicor Kinetic Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Epicor Kinetic.
-
Use Grok to Talk to Your JSON Services 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 JSON for you.
-
Connect to Microsoft Exchange Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Exchange from PowerBuilder using the Microsoft Exchange JDBC Driver.
-
How to create an RPA flow for Drip Data in UiPath Studio
Use the Drip ODBC Driver to create workflows that access real-time Drip without any coding.
-
Back Up ZarMoney to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ZarMoney data.
-
Access Live Salesforce Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce & Force.com into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce & Force.com in the Graph Builder and Query Builder.
-
Update Multiple Invoices using the CData Excel Add-In for QuickBooks
The CData Excel Add-In for QuickBooks makes it easy to modify your QuickBooks data right in Excel. This article will explain how to use the CData Excel Add-In for QuickBooks to mark multiple Invoices at once for printing and e-mailing.
-
Work with Sage 200 Data in FoxPro
Load Sage 200 into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to integrate Egnyte with Apache Airflow
Access and process Egnyte in Apache Airflow using the CData JDBC Driver.
-
Access Live Highrise Data in AWS Lambda
Connect to live Highrise CRM in AWS Lambda using the CData JDBC Driver.
-
Edit and Search Apollo External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Apollo to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Apollo objects that you can access from apps and the dashboard.
-
Getting Started with the CData Python Connector for FreshBooks
Learn to install and license the CData Python Connector
-
Build Charts with ElevenLabs Data in Clear Analytics
Create dynamic charts and perform analytics based on ElevenLabs in Clear Analytics.
-
Connect to Microsoft Entra ID Data in RapidMiner
Integrate Microsoft Entra ID with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData ODBC Driver for Sentry in Microsoft Power Query
You can use the CData Sentry ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sentry into Microsoft Power Query.
-
Connect to CampaignMonitor Data from PowerBuilder via ADO.NET
This article demonstrates how to access CampaignMonitor from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to update WordPress from Excel
This article explains how to transfer data from Excel to WordPress using the Excel Add-In for WordPress.
-
Access Live Clio Data in Coginiti Pro
Connect to and query live Clio from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Power BI XMLA Data in Excel 365 Online (Excel for the web)
Connect to Power BI XMLA from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Live OpenWeatherMap Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live OpenWeatherMap to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use JayDeBeApi to access xBase Data in Python
Use standard Python scripting and the development environment of your choice to access live xBase.
-
Automated Continuous Lakebase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Lakebase replication to Google BigQuery.
-
LINQ to MailerSend 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 MailerSend Data Provider.
-
Connecting Moonlit Workflow with OData Services 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 OData in real time.
-
ZendeskSell Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZendeskSell facts in real time.
-
Write a Simple Go Application to work with SurveyMonkey Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SurveyMonkey.
-
Connect to Greenhouse 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 Greenhouse.
-
Natively Connect to CapsuleCRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CapsuleCRM. Leverage the native support for ODBC in PHP.
-
Automated Continuous Retently Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Retently replication to Amazon Redshift.
-
Migrating data from ZohoExpense to Google BigQuery using CData SSIS Components.
Easily push ZohoExpense to Google BigQuery using the CData SSIS Tasks for ZohoExpense and Google BigQuery.
-
Connect to Avalara AvaTax Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Avalara AvaTax to connect to Avalara AvaTax and execute queries in PowerBuilder.
-
Import SAP Netweaver Gateway Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP Netweaver Gateway. In this article, you will use the OData format to import SAP Netweaver Gateway into Microsoft Power Query.
-
Visualize Eventbrite 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 Eventbrite into TIBCO Spotfire.
-
How to Query SAP Data in MySQL Workbench
Execute MySQL queries against live SAP ERP/NetWeaver from MySQL Workbench.
-
Choosing the Best Method to Connect SAP SuccessFactors to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP SuccessFactors from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Google Spanner Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Spanner replication to SingleStore.
-
Visualize WooCommerce Data in Sisense
Create an ElastiCube in Sisense app with access to WooCommerce.
-
Build Apps with Live Elasticsearch Data Using the Low-Code Development Platform of Mendix
Connect Elasticsearch with Mendix to build apps using the CData JDBC Driver for Elasticsearch.
-
Working with BigCommerce Data in LINQPad
Execute LINQ queries to BigCommerce in LINQPad.
-
Getting Started with the CData Python Connector for Front
Learn to install and license the CData Python Connector
-
Add SAP Business Warehouse Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Business Warehouse with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live PostgreSQL Data in Coginiti Pro
Connect to and query live PostgreSQL from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze CSV Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of CSV/TSV Files and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to SingleStore Data from HeidiSQL
Use CData Connect AI to connect to and query live SingleStore from HeidiSQL.
-
Analyze Active Directory Data in Cognos Analytics
Use CData Connect AI to connect to Active Directory Data from Cognos Analytics and analyze live Active Directory.
-
Work with Moosend Data in FoxPro
Load Moosend into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Hubstaff Data in NetBeans
Connect to Hubstaff in NetBeans with the data source configuration wizard.
-
Manage Act CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Act CRM.