CData Software - Knowledge Base
Recent Articles
-
Automate Attio Data Replication to SAP HANA
Use CData Sync to customize and automate Attio data replication to SAP HANA.
-
Migrating data from Typeform to Databricks using CData SSIS Components.
Easily push Typeform data to Databricks using the CData SSIS Tasks for Typeform and Databricks.
-
Publish Salesforce-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesforce data.
-
Access Live Greenplum Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Greenplum data from your Google Sheets.
-
Integrating LlamaIndex with ZohoSubscriptions Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ZohoSubscriptions data in real time.
-
Integrating Dataiku with SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Hybris C4C data.
-
A PostgreSQL Interface for SAP Fieldglass Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Fieldglass JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to & Open Gumroad Data in Microsoft Excel
This article uses the CData ODBC driver for Gumroad to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate HCL Domino Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to HCL Domino data and integrate live HCL Domino data into your Power Automate tasks.
-
Create Apps from Vault CRM Data in Qlik Sense Cloud
Use CData Connect AI to connect to Vault CRM Data and build apps from live Vault CRM data in Qlik Sense Cloud.
-
Automated Continuous Exa Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Exa replication to Azure SQL Database.
-
Automated Continuous Paylocity Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Paylocity replication to PostgreSQL.
-
Integrate Google Directory Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Directory data and integrate live Google Directory data into your Power Automate tasks.
-
Connect to SFTP Data in Google Apps Script via Connect AI
Use CData Connect AI to access SFTP data in Google Apps Script.
-
Work with CampaignMonitor Data in FoxPro
Load CampaignMonitor data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Live Microsoft OneDrive Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft OneDrive data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Bridge Instantly Connectivity with Apache NiFi
Access and process Instantly data in Apache NiFi using the CData JDBC Driver.
-
Automate Bugsnag Data Replication to SAP HANA
Use CData Sync to customize and automate Bugsnag data replication to SAP HANA.
-
Link Clari with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Clari data in Filemaker Pro for Mac or Windows.
-
Integrate Live ZohoSubscriptions Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ZohoSubscriptions data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to connect to Act CRM Data from Spring Boot
Connect to Act CRM in a Spring Boot Application using the CData JDBC Driver for Act CRM
-
Connect to and Query SharePoint Excel Services Data in QlikView over ODBC
Create data visualizations with SharePoint Excel Services data in QlikView.
-
Automated Continuous Workday Replication to Vertica
Use CData Sync for automated, continuous, customizable Workday replication to Vertica.
-
Connect to HubSpot Data in Google Apps Script via Connect AI
Use CData Connect AI to access HubSpot data in Google Apps Script.
-
Build MVC Applications with Connectivity to MessageBird Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MessageBird from an ASP.NET MVC application.
-
Query PabblySubscriptions Data in DataGrip
Create a Data Source for PabblySubscriptions in DataGrip and use SQL to query live PabblySubscriptions data.
-
Connect to ZohoDesk Data in HULFT Integrate
Connect to ZohoDesk as a JDBC data source in HULFT Integrate
-
Visualize ZarMoney Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZarMoney data.
-
How to Connect to Live OneNote 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 OneNote data for you.
-
Build Automated Workflows with Live Cloudflare Data in Workato
Use CData Connect AI to connect to live Cloudflare data and build automated workflows in Workato.
-
How to Access LDAP Objects Using Entity Framework
This article shows how to access LDAP objects using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect to eBay Analytics Data in DBVisualizer
Integrate eBay Analytics data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to load Front data into Elasticsearch via Logstash
Introducing a simple method to load Front data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish Hacker News-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Hacker News data.
-
Integrate SageHR with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SageHR with External Services.
-
Integrating Claude Code CLI with Yelp 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 CouchDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live CouchDB data from Filemaker Pro on Mac.
-
Integrate Microsoft Entra ID Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Entra ID data in the Pentaho Data Integration tool.
-
Automated Continuous Azure DevOps Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Amazon Redshift.
-
How to connect to Splunk Data with Squirrel SQL client
Connect to Splunk data and execute queries in the Squirrel SQL Client.
-
Query Live Mode Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Mode data through a conversational interface.
-
Connecting Mastra with Google Directory 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 Google Directory data, no replication required.
-
Connecting Mastra with Databricks 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 Databricks data, no replication required.
-
Automated Continuous Hubstaff Replication to Oracle
Use CData Sync for automated, continuous, customizable Hubstaff replication to Oracle.
-
Connect to ConvertAPI Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ConvertAPI as an External Source in Dremio.
-
Natively Connect to Google Drive Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Drive data. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Certinia 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 Certinia data through natural language.
-
How to connect and process Notion data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Notion data.
-
Integrating LangChain with Printify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Printify data within automated workflows.
-
How to Connect to Live Google Directory 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 Google Directory data for you.
-
How to work with SAP Data in Apache Spark using SQL
Access and process SAP Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize Live GitLab Data in the Power BI Service
Use CData Connect AI to connect to live GitLab data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Live SQL Analysis Services Data in MicroStrategy through CData Connect AI
Create a live connection to SQL Analysis Services Data in CData Connect AI and connect to your SQL Analysis Services data from MicroStrategy.
-
Visualize Google Ad Manager Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Ad Manager data.
-
Integrate Redshift Data into Power Automate Desktop using CData Connect
CData Connect for Redshift Data enables you to integrate Redshift data into workflows built using Microsoft Power Automate Desktop.
-
How to connect to Neo4J Data with Squirrel SQL client
Connect to Neo4J data and execute queries in the Squirrel SQL Client.
-
Work with Trello Data in FoxPro
Load Trello data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live VWO Data in Coginiti Pro
Connect to and query live VWO data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Google's Antigravity Agent with Live MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live MYOB AccountRight data using the Model Context Protocol.
-
Connect to Bitly in SpagoBI
Create reports featuring live Bitly data in SpagoBI Studio. Host Bitly reports on SpagoBI Server.
-
Automated Continuous Moosend Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Moosend replication to delimited files (CSV/TSV).
-
Automated Continuous Workable Replication to SQLite
Use CData Sync for automated, continuous, customizable Workable replication to SQLite.
-
Integrate with Azure Data Lake Storage Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Data Lake Storage data to a JSON file on disk.
-
DataBind SAP Ariba Procurement Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP Ariba Procurement with the DevExpress Windows Forms and Web controls to provide SAP Ariba Procurement data to a chart.
-
Model, Search, and Visualize Live SuiteCRM Data in ThoughtSpot
Use CData Connect AI to connect to live SuiteCRM data for modeling, searching, and visualizing.
-
Replicate LinkedIn Ads Data to Multiple Databases via the CData Sync CLI
Replicate LinkedIn Ads data to disparate databases with a single configuration.
-
Connect to Stripe Data in Ruby
Connect to Stripe data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Dynamic Auth0 Grids Using the Infragistics XamDataGrid
Learn how you can connect Auth0 to Infragistics XamDataGrid to build dynamic grids.
-
Analyze Amazon Marketplace Data in Looker
Use CData Connect AI to connect to Amazon Marketplace Data from Looker and build custom apps using live Amazon Marketplace data.
-
How to connect to Quickbase Data with Squirrel SQL client
Connect to Quickbase data and execute queries in the Squirrel SQL Client.
-
Connect to OpenWeatherMap Data in Ruby
Connect to OpenWeatherMap data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to SparkPost Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SparkPost Data and connect to SparkPost data in Akorbi Digital RunMyProcess.
-
Create Data Visualizations in Cognos BI with Slack Data
Access Slack data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Shopify-Connected Applications in Appsmith
Connect to Shopify Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Shopify data.
-
Write a Simple Go Application to work with Paylocity Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Paylocity data.
-
Query, Visualize, and Share live Asana Data in Redash
Use CData Connect AI to connect to live Asana data in Redash for querying, visualizing, and sharing.
-
Import Real-Time Moosend Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Moosend data in ColdFusion.
-
Automated Continuous RSS Replication to IBM DB2
Use CData Sync for automated, continuous, customizable RSS replication to IBM DB2.
-
Integrate Live OData Services into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live OData services to Blue Prism using the CData ODBC Driver for OData to create automated workflows for repetitive business tasks.
-
How to Build an ETL App for Authorize.Net Data in Python with CData Connect AI
Extract and transform live Authorize.Net data in Python with petl and the CData Connect AI Python SDK.
-
LINQ to Close 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 Close Data Provider.
-
Integrating OpenCode with Oracle SCM 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 ChargeOver Data from a Connection Pool in Jetty
The ChargeOver JDBC Driver supports connection pooling: This article shows how to connect faster to ChargeOver data from Web apps in Jetty.
-
Visualize Demio 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 Demio data into TIBCO Spotfire.
-
Moving Data from JobNimbus to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live JobNimbus data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Perform Batch Operations with Exact Online Data in Apache NiFi
Connect to Exact Online data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Interact with Live Microsoft Dataverse Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Microsoft Dataverse data.
-
Connect to MariaDB Data in JRuby
Create a simple JRuby app with access to live MariaDB data.
-
Automated Continuous Avro Replication to SQL Server
Use CData Sync for automated, continuous, customizable Avro replication to SQL Server.
-
Integrate Google's Vertex AI Agent with Live DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live DB2 data within intelligent workflows.
-
Connect to HBase Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live HBase data from Filemaker Pro on Mac.
-
Automate Sendwithus Data Replication to Azure Synapse
Use CData Sync to customize and automate Sendwithus data replication to Azure Synapse.
-
Use Manus AI to Talk to Your SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on SingleStore data.
-
Enable the MailerSend JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MailerSend data.
-
Use the CData Software ODBC Driver for Quaderno in SAS for Real-Time Reporting and Analytics
Connect to real-time Quaderno data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Quaderno.
-
Connect to Real-Time MarkLogic Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for MarkLogic and Dataflow to import and use MarkLogic data in Power Apps.
-
Feed Access Data into FineReport
How to set Access data as a JDBC data source in FineReport.
-
Natively Connect to Workable Data in PHP
The CData ODBC driver for Workable enables you to create PHP applications with connectivity to Workable data. Leverage the native support for ODBC in PHP.
-
How to Visualize Amazon S3 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Amazon S3 data in Python.
-
Access Live Reckon Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Reckon data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.