CData Software - Knowledge Base
Recent Articles
-
Working with ShipEngine Data in LINQPad
Execute LINQ queries to ShipEngine in LINQPad.
-
Import and Visualize Discourse Data in Power View
Create data visualizations based on Discourse in Excel.
-
Prepare, Blend, and Analyze SAS xpt Data in Alteryx Designer (ODBC)
Build workflows to access live SAS XPORT for self-service data analytics.
-
Access ShipEngine Data from MySQL in Amazon QuickSight
Connect to ShipEngine and build visualizations of ShipEngine using a MySQL Connection in Amazon QuickSight.
-
Integrate Live GitHub Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live GitHub to Blue Prism using the CData ODBC Driver for GitHub to create automated workflows for repetitive business tasks.
-
Integrate Webflow Data in the Pentaho Report Designer
Publish reports based on Webflow in the Pentaho BI tool.
-
Integrate Cursor with Live Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Slack from within the editor.
-
Connect to and Query ConvertKit Data in QlikView over ODBC
Create data visualizations with ConvertKit in QlikView.
-
Connect to MarkLogic from Asprova with CData Software ODBC Driver for MarkLogic
This article shows how to connect faster to MarkLogic data from Asprova.
-
Bridge ConvertKit Connectivity with Apache NiFi
Access and process ConvertKit in Apache NiFi using the CData JDBC Driver.
-
Automate Yelp Data Replication to SAP HANA
Use CData Sync to customize and automate Yelp replication to SAP HANA.
-
Automated Continuous TaxJar Replication to MySQL
Use CData Sync for automated, continuous, customizable TaxJar replication to MySQL.
-
Build ScrapingBee-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ScrapingBee.
-
Establish a Live Connection with ServiceDesk Plus Data using Tableau Bridge
The CData ODBC Driver for ServiceDesk Plus enables you to integrate live ServiceDesk Plus into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to Live Certinia 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 Certinia for you.
-
How to import ZohoPeople Data into Apache Solr
Use the CData Software JDBC Driver for ZohoPeople in Data Import Handler and create an automated import of ZohoPeople to Apache Solr Enterprise Search platform.
-
How to Import Data from FTP into Google Sheets
Import FTP Servers into a Google spreadsheet that is automatically refreshed.
-
Connect to Email Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use Microsoft Copilot Studio to talk to your DocuSign 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 DocuSign for you.
-
Automated Continuous Pipeliner CRM Replication to Databricks
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Databricks.
-
How to Work with Optimizely Data in ETL Validator JDBC
Connect to Optimizely from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Landbot Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Landbot and work with Landbot in your FileMaker applications.
-
Connect to MongoDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live MongoDB from Filemaker Pro on Mac.
-
Automated Continuous DocuSign Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable DocuSign replication to Apache Kafka.
-
Query WordPress Data through ODBC in Node.js
Use node-odbc to execute SQL queries against WordPress from Node.js.
-
Integrate LibreChat with Live Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Gmail from within the chat interface.
-
Use the CData ODBC Driver for IBM Informix in Microsoft Power Query
You can use the CData IBM Informix ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import IBM Informix into Microsoft Power Query.
-
Automated Continuous Power BI XMLA Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Amazon Redshift.
-
Publish Short.io-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Short.io.
-
Connect to Tavily Data in Aqua Data Studio
Access Tavily from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automate Coinbase Data Replication to Azure Synapse
Use CData Sync to customize and automate Coinbase replication to Azure Synapse.
-
How to Connect the Power BI Service to AfterShip: Complete Guide
Connect to the CData Software Power BI Connector for AfterShip from PowerBI.com to provide real-time AfterShip across the organization.
-
Visualize Live ClickTime Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ClickTime.
-
Create Dynamic Hacker News Grids Using the Infragistics XamDataGrid
Learn how you can connect Hacker News to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Customer.io with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Customer.io with External Services.
-
Viewing Adobe Commerce Data in RAD Studio Data Explorer
How to view Adobe Commerce in RAD Studio Data Explorer using the CData ODBC Driver for Adobe Commerce.
-
Connect to Certinia Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Certinia.
-
Replicate MarkLogic Data to Multiple Databases via the CData Sync CLI
Replicate MarkLogic to disparate databases with a single configuration.
-
Use the CData Software JDBC Driver for Clari in MicroStrategy Desktop
Connect to Clari in MicroStrategy Desktop using the CData Software JDBC Driver for Clari.
-
Access Cohere Data from MySQL in PHP
Connect to Cohere through the standard MySQL libraries in PHP.
-
Automate ServiceNow Data Replication to Couchbase
Use CData Sync to Customize and automate ServiceNow replication to Couchbase.
-
Visualize Microsoft Entra ID Data in TIBCO Spotfire through OData
Integrate Microsoft Entra ID into dashboards in TIBCO Spotfire.
-
Integrating Blackbaud FE NXT Data in Talend Cloud Data Management Platform
Connect Blackbaud FE NXT Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Blackbaud FE NXT.
-
Getting Started with the CData Python Connector for MailChimp
Learn to install and license the CData Python Connector
-
Connect to YouTube Analytics 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 YouTube Analytics.
-
Integrate with Oracle Data in JReport Designer
Create charts and reports based on Oracle Database in JReport Designer.
-
Replicate Multiple Asana Accounts via the CData Sync CLI
Replicate multiple Asana accounts to one or many databases.
-
How to Query Live Slack Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Slack data in natural language using Python.
-
Visualize HubSpot Data in TIBCO Spotfire through OData
Integrate HubSpot into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Python Connector for Access
Learn to install and license the CData Python Connector
-
Moving Data from ConvertKit to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ConvertKit data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize Salesforce Marketing Data in TIBCO Spotfire through ADO.NET
Integrate Salesforce Marketing Cloud into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Tableau Connector for Nethunt
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate Multiple ChargeOver Accounts
Replicate multiple ChargeOver accounts to one or many databases.
-
Build a PostgreSQL Interface for Sugar CRM Data using the CData JDBC Driver
Use the Remoting features of the Sugar CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Metabase with Dynamics 365 Business Central Data
Use CData Connect AI to connect to live Dynamics 365 Business Central and create an interactive dashboard in Metabase from Dynamics 365 Business Central.
-
Use the CData Software JDBC Driver for Printify in MicroStrategy Desktop
Connect to Printify in MicroStrategy Desktop using the CData Software JDBC Driver for Printify.
-
Migrating data from Keap to Snowflake using CData SSIS Components.
Easily push Keap to Snowflake using the CData SSIS Tasks for Keap and Snowflake.
-
Prepare, Blend, and Analyze Facebook Ads Data in Alteryx Designer (ODBC)
Build workflows to access live Facebook Ads for self-service data analytics.
-
Use Databricks Agent Bricks to Talk to Your Box Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Box for you.
-
Use the CData ODBC Driver for Egnyte in Microsoft Power Query
You can use the CData Egnyte ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Egnyte into Microsoft Power Query.
-
Build Act-On-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Act-On to explore live Act-On Data in Claude Code to assist with building Act-On-powered applications.
-
Create Informatica Mappings From/To a JDBC Data Source for ServiceNow
Create ServiceNow data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Feed Raisers Edge NXT Data into FineReport
How to set Raisers Edge NXT as a JDBC data source in FineReport.
-
Integrating Cursor CLI with Mouseflow 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.
-
Automated Continuous Oracle Eloqua Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Google BigQuery.
-
Create Datasets from Greenplum in Domo Workbench and Build Visualizations of Greenplum Data in Domo
Use the CData Software ODBC Driver for Greenplum to create datasets from Pivotal GreenPlum in Domo Workbench and then build visualizations in the Domo service.
-
Create Reports from Quickbase Data in Looker Studio
Use CData Connect AI to gain access to live Quickbase and create custom reports in Looker Studio.
-
Visualize SFTP Data in Tableau
The CData ODBC driver for SFTP enables you integrate SFTP into Tableau dashboards.
-
Access Live Square 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 Square through MCP integration.
-
Rapidly Develop Scrapfly-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 Scrapfly.
-
Build a Singer.io Tap for Greenhouse With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Greenhouse data using
-
Publish Crystal Reports on Shortcut Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Shortcut.
-
How to import ZohoMarketingHub Data into Apache Solr
Use the CData Software JDBC Driver for ZohoMarketingHub in Data Import Handler and create an automated import of ZohoMarketingHub to Apache Solr Enterprise Search platform.
-
Build AI/ML Models with Live WordPress Data using Dataiku
Connect WordPress Data with Dataiku using the CData JDBC Driver for WordPress.
-
Connect to Azure Analysis Services Data from a Connection Pool in Jetty
The Azure Analysis Services JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Analysis Services from Web apps in Jetty.
-
Load Printify Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Printify to a database.
-
Automate Cloudant Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live IBM Cloudant and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Work with SAP Fieldglass Data in FoxPro
Load SAP Fieldglass into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connecting Mastra with Sage Cloud Accounting 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 Sage Business Cloud Accounting, no replication required.
-
Build Visualizations of SAP Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP ERP/NetWeaver in Birst.
-
Connect to Quaderno Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Quaderno in the Denodo Virtual DataPort Administrator.
-
Query Outreach.io Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Outreach.io entities in PHP by modeling them as objects.
-
Use the CData Software JDBC Driver for Microsoft OneDrive in MicroStrategy
Connect to Microsoft OneDrive in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft OneDrive.
-
Import and Visualize Email Data in Power View
Create data visualizations based on Email in Excel.
-
Bridge Bright Data Connectivity with Apache NiFi
Access and process Bright Data in Apache NiFi using the CData JDBC Driver.
-
Analyze SharePoint Data in Looker
Use CData Connect AI to connect to SharePoint Data from Looker and build custom apps using live Microsoft SharePoint.
-
Work with ChargeOver Data in FoxPro
Load ChargeOver into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automate RSS Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live RSS Feeds and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Load Bitly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Bitly to a database.
-
Use the CData ODBC Driver for Elasticsearch in Microsoft Power Query
You can use the CData Elasticsearch ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Elasticsearch into Microsoft Power Query.
-
Integrate Contentful with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Contentful with External Services.
-
Use Dash to Build to Web Apps on Acumatica Data
Create Python applications that use pandas and Dash to build Acumatica-connected web apps.
-
Access ZohoPeople 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 ZohoPeople.
-
Mailjet Reporting in OBIEE with the Mailjet JDBC Driver
Deploy the Mailjet JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Explore Geographical Relationships in LightSpeedRetail Data with Power Map
Create data visualizations with LightSpeedRetail in Power Map.
-
Replicate Multiple Greenplum Accounts via the CData Sync CLI
Replicate multiple Greenplum accounts to one or many databases.
-
Connect to EnterpriseDB Data in Ruby
Connect to EnterpriseDB in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Live PostgreSQL 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 PostgreSQL directly from the development environment.
-
Use the CData ODBC Driver for NASA from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for NASA to connect to NASA from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring NASA in Excel.