CData Software - Knowledge Base
Recent Articles
-
Replicate Box Data from PowerShell
Write a quick PowerShell script to query Box. Use connectivity to the live data to replicate Box to SQL Server.
-
How to Connect to Live MariaDB 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 MariaDB for you.
-
Getting Started with the CData ODBC Driver for BigCommerce
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for BigCommerce.
-
Replicate LaunchDarkly Data from PowerShell
Write a quick PowerShell script to query LaunchDarkly. Use connectivity to the live data to replicate LaunchDarkly to SQL Server.
-
How to Connect to Live Apollo 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 Apollo for you.
-
Viewing Testmonitor Data in RAD Studio Data Explorer
How to view Testmonitor in RAD Studio Data Explorer using the CData ODBC Driver for Testmonitor.
-
Getting Started with the CData Tableau Connector for CockroachDB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for CockroachDB.
-
Automate Front Data Replication to Couchbase
Use CData Sync to Customize and automate Front replication to Couchbase.
-
Access Live Elasticsearch Data in AWS Lambda
Connect to live Elasticsearch in AWS Lambda using the CData JDBC Driver.
-
Model, Search, and Visualize Live eBay Data in ThoughtSpot
Use CData Connect AI to connect to live eBay for modeling, searching, and visualizing.
-
Work with Elasticsearch Data in FoxPro
Load Elasticsearch into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to create an RPA flow for ScrapingBee Data in UiPath Studio
Use the ScrapingBee ODBC Driver to create workflows that access real-time ScrapingBee without any coding.
-
Import Oracle Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Oracle Data and provide access to live Oracle Database for custom reports in the Power BI Service.
-
Visualize Live Jodoo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Jodoo.
-
Connect to ZohoInvoice Data in DBArtisan
Use wizards in DBArtisan to configure ZohoInvoice as a data source.
-
Connect to Helpscout Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Helpscout in the Denodo Virtual DataPort Administrator.
-
Connect to and Visualize Live Teamwork Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Teamwork.
-
How to connect and process Email from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Email.
-
Connecting Moonlit Workflow with FHIR Data 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 FHIR in real time.
-
Access Webflow Data from MySQL in PHP
Connect to Webflow through the standard MySQL libraries in PHP.
-
How to connect PolyBase to GetResponse
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live GetResponse.
-
Automated Continuous Shopify Replication to SingleStore
Use CData Sync for automated, continuous, customizable Shopify replication to SingleStore.
-
Getting Started with the CData Python Connector for Instagram
Learn to install and license the CData Python Connector
-
Use the CData Software JDBC Driver for Google Forms in MicroStrategy Web
Connect to Google Forms in MicroStrategy Web using the CData Software JDBC Driver for Google Forms.
-
A PostgreSQL Interface for Outreach.io Data using the CData ODBC Driver
Use the SQL Gateway and Outreach.io ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Tableau Connector for GitHub
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for GitHub.
-
How to Create Power BI Visual Reports with Real-Time Apollo Data
Use CData Power BI Connectors to visualize Apollo in Power BI.
-
Access Live Oracle Eloqua Data in Excel 365 Online (Excel for the web)
Connect to Oracle Eloqua from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Unbounce 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 Unbounce.
-
Connect to SAS Data Sets Data in ACL Analytics
Connect to SAS Data Sets via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAS Data Sets.
-
Query Google Spanner Data as a MySQL Database in Node.js
Execute MySQL queries against Google Spanner from Node.js.
-
Migrating data from Sugar CRM to Snowflake using CData SSIS Components.
Easily push Sugar CRM to Snowflake using the CData SSIS Tasks for Sugar CRM and Snowflake.
-
Edit and Search HBase External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Apache HBase to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create HBase objects that you can access from apps and the dashboard.
-
Import Salesforce Pardot Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Salesforce Pardot. In this article, you will use the OData format to import Salesforce Pardot into Microsoft Power Query.
-
Integrating Float Data in Talend Cloud Data Management Platform
Connect Float Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automate OneNote Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft OneNote replication to Couchbase.
-
Bridge Azure Synapse Connectivity with Apache NiFi
Access and process Azure Synapse in Apache NiFi using the CData JDBC Driver.
-
How to Build an ETL App for Zoom Data in Python with CData
Create ETL applications and real-time data pipelines for Zoom in Python with petl.
-
Connect to Certinia Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Certinia using standard SQL.
-
How to publish and share Ontraport Data dashboards with Tableau Server
The CData ODBC driver for Ontraport enables you integrate Ontraport into Tableau dashboards.
-
Easily Integrate CampaignMonitor Data in Lazarus Pascal IDE
Learn how to easily integrate live CampaignMonitor in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Add Planio Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Planio with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Data Flows from Google Drive to SQL Server using SSIS
Easily back up Google Drive to SQL Server using the SSIS components for Google Drive.
-
Integrating Codex CLI with ZarMoney 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.
-
Migrating data from Simplesat to Google BigQuery using CData SSIS Components.
Easily push Simplesat to Google BigQuery using the CData SSIS Tasks for Simplesat and Google BigQuery.
-
Analyze Beeminder Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Beeminder with the CData JDBC Driver for Beeminder.
-
How to Work with ConstantContact Data in AWS Glue Jobs Using JDBC
Connect to ConstantContact from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Import Data from IBM Informix into Google Sheets
Import IBM Informix into a Google spreadsheet that is automatically refreshed.
-
Access Live LinkedIn 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 LinkedIn through MCP integration.
-
Publish Crystal Reports on Jumpseller Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Jumpseller.
-
Connect to Oracle Service Cloud Data in CloverDX (formerly CloverETL)
Transfer Oracle Service Cloud using the visual workflow in the CloverDX data integration tool.
-
Integrate PostgreSQL Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PostgreSQL from Informatica Cloud.
-
Integrating Claude Code CLI with Teamwork 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.
-
Create Data Visualizations in Cognos BI with Jira Data
Access Atlassian Jira as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
LINQ to BigQuery 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 BigQuery Data Provider.
-
Automated Continuous Autopilot Replication to SQL Server
Use CData Sync for automated, continuous, customizable Autopilot replication to SQL Server.
-
Seamlessly Bring Azure Table Data into Retool Using CData Connect AI
Integrate Azure Table data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connecting GenSpark with Google Drive Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Drive without any replication or custom integration required.
-
Getting Started with the CData ADO.NET Provider for Monday.com
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Monday.com.
-
Back Up MYOB AccountRight to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MYOB AccountRight. In this article, we will employ an SSIS workflow to populate a database with MYOB AccountRight data.
-
Integrate with Live Freshservice Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Freshservice from the MuleSoft Anypoint Platform to integrate live Freshservice into custom reports and dashboards.
-
Connect to Salesforce Data from AWS Glue
Use CData Connect AI to gain access to live Salesforce & Force.com from your AWS Glue jobs.
-
Access Live Authorize.Net Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Authorize.Net from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
A PostgreSQL Interface for Amazon Athena Data (MySQL Remoting via JDBC)
Use the Remoting features of the Amazon Athena JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Gumroad in MicroStrategy
Connect to Gumroad in MicroStrategy Developer using the CData Software JDBC Driver for Gumroad.
-
A PostgreSQL Interface for Clio Data using the CData ODBC Driver
Use the SQL Gateway and Clio ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Metabase with Greenhouse Data
Use CData Connect AI to connect to live Greenhouse and create an interactive dashboard in Metabase from Greenhouse.
-
Migrating data from Klaviyo to Snowflake using CData SSIS Components.
Easily push Klaviyo to Snowflake using the CData SSIS Tasks for Klaviyo and Snowflake.
-
Edit and Search External MongoDB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MongoDB to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MongoDB Data objects that you can access from apps and the dashboard.
-
Natively Connect to LaunchDarkly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to LaunchDarkly. Leverage the native support for ODBC in PHP.
-
Integrate with Live Microsoft Dataverse Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Dataverse from the MuleSoft Anypoint Platform to integrate live Microsoft Dataverse (CDS) into custom reports and dashboards.
-
Access CircleCI 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 CircleCI.
-
Getting Started with the CData ODBC Driver for RabbitMQ
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for RabbitMQ.
-
Integrating GitHub Copilot CLI with Gmail 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.
-
Create Data Visualizations in Cognos BI with Pinterest Data
Access Pinterest as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Pipedrive-Connected Apps in Choreo
Use CData Connect AI to connect to Pipedrive Data from Choreo and build custom apps using live Pipedrive.
-
Automated Continuous OneNote Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable OneNote replication to Apache Cassandra.
-
Building Dynamic Web Pages with Dropbox Data Using AngularJS
Create single-page applications with live connectivity to Dropbox using the CData API Server.
-
Connect to ClickTime Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ClickTime in the Denodo Virtual DataPort Administrator.
-
Replicate Oracle Sales Data from PowerShell
Write a quick PowerShell script to query Oracle Sales. Use connectivity to the live data to replicate Oracle Sales to SQL Server.
-
Automated Continuous Google Analytics Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Analytics replication to Snowflake.
-
Access Live Impala 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 Apache Impala through MCP integration.
-
Build a PostgreSQL Interface for Zoho CRM Data using the CData JDBC Driver
Use the Remoting features of the Zoho CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Odoo with Apache Airflow
Access and process Odoo ERP in Apache Airflow using the CData JDBC Driver.
-
Connect to Redshift in SpagoBI
Create reports featuring live Amazon Redshift in SpagoBI Studio. Host Redshift reports on SpagoBI Server.
-
Use Manus AI to Talk to Your MYOB AccountRight 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 MYOB AccountRight.
-
How to Build an ETL App for MariaDB Data in Python with CData
Create ETL applications and real-time data pipelines for MariaDB in Python with petl.
-
Replicate Zoho CRM Data to Multiple Databases
Replicate Zoho CRM to disparate databases with a point-and-click configuration.
-
Integrate Live Amazon S3 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Amazon S3 to Blue Prism using the CData ODBC Driver for Amazon S3 to create automated workflows for repetitive business tasks.
-
DataBind Controls to Pinecone Data in C++Builder
DataBind to Pinecone in C++Builder with standard components and controls.
-
Creating Dynamics 365 Business Central-Connected Applications in Unqork
You can use CData Connect AI to feed Dynamics 365 Business Central to Unqork and build custom business apps.
-
Automated EmailOctopus Data Replication to Teradata
Use CData Sync to Customize and automate EmailOctopus replication to Teradata.
-
Getting Started with the CData Python Connector for Placid
Learn to install and license the CData Python Connector
-
Build Rebilly-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Rebilly.
-
How to connect to Okta Data from Spring Boot
Connect to Okta in a Spring Boot Application using the CData JDBC Driver for Okta
-
Excel Spreadsheet Automation on Webflow Data with the QUERY Formula
Pull data from Webflow, automate spreadsheets, and more with the QUERY formula.
-
Replicate Multiple ClickTime Accounts
Replicate multiple ClickTime accounts to one or many databases.
-
Bridge PolarTeamPro Connectivity with Apache NiFi
Access and process PolarTeamPro in Apache NiFi using the CData JDBC Driver.
-
Build a Singer.io Tap for Epicor Kinetic With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Epicor Kinetic data using
-
Build WooCommerce Visualizations in Tableau Desktop
Use CData Connect AI to connect to live WooCommerce and build visualizations in Tableau.