CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SpaceX Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SpaceX data replication to OneLake in Microsoft Fabric.
-
Connect to Datadog in SpagoBI
Create reports featuring live Datadog data in SpagoBI Studio. Host Datadog reports on SpagoBI Server.
-
Salesforce Pardot Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Salesforce Pardot data through CData Connect AI using different applications and tools.
-
Automated Continuous Apollo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Apollo replication to Amazon S3.
-
Automated Continuous AlloyDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable AlloyDB replication to Azure SQL Database.
-
Integrate Zuora with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zuora with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zuora data.
-
Integrate with live ActiveCampaign Data in Jitterbit
Use CData Connect AI to connect to and integrate live ActiveCampaign data in Jitterbit.
-
DataBind Charts to Nuclia Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Nuclia data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Prepare, Blend, and Analyze Zoho Books Data in Alteryx Designer (Connect AI)
Build workflows to access live Zoho Books data for self-service data analytics.
-
Integrate Open WebUI with Live Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Freshteam data from within the chat interface.
-
Build Data Flows from ConvertAPI to SQL Server using SSIS
Easily back up ConvertAPI data to SQL Server using the SSIS components for ConvertAPI.
-
Getting Started with the CData Python Connector for Salesforce CRM Analytics
Learn to install and license the CData Python Connector and configure a connection to live Salesforce CRM Analytics data.
-
Use the CData Software JDBC Driver for Rootly in MicroStrategy Web
Connect to Rootly data in MicroStrategy Web using the CData Software JDBC Driver for Rootly.
-
Write a Simple Go Application to work with Facebook Ads Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Facebook Ads data.
-
Connect to and Query Shopify Data in QlikView over ODBC
Create data visualizations with Shopify data in QlikView.
-
How to Connect to Live Asana Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Asana data for you.
-
Query Zuora Data as a MySQL Database in Node.js
Execute MySQL queries against Zuora data from Node.js.
-
Integrate Theia IDE with Live Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Neo4J data from within the development environment.
-
Use the CData Software ODBC Driver for FreeAgent in MicroStrategy Web
Connect to FreeAgent data in MicroStrategy Web using the CData Software ODBC Driver for FreeAgent.
-
Build Semantic Layer Views for Google Ads Data in APOS Live Data Gateway
Use the CData Connector for Google Ads in APOS Live Data Gateway to build Semantic Layer Views for Google Ads data.
-
Integrate Zuora with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zuora with External Services.
-
Integrate Google's Vertex AI Agent with Live Microsoft Planner 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 Microsoft Planner data within intelligent workflows.
-
How to Work with Mode Data in AWS Glue Jobs Using JDBC
Connect to Mode from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Dash to Build Web Apps on HCL Domino Data via CData Connect AI
Build interactive Dash web apps on live HCL Domino data using pandas and the CData Connect AI Python SDK.
-
Connect to Real-Time Flowlu Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Flowlu data in Power Apps.
-
Seamlessly Bring Workday Data into Retool Using CData Connect AI
Integrate Workday data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Query Short.io Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Short.io data from Node.js.
-
Build Automated Testmonitor-Connected Workflows in Zapier
Use CData Connect AI to connect to live Testmonitor data and build automated workflows in Zapier.
-
Create Microsoft Dataverse-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft Dataverse Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Dataverse data.
-
Connect to Lakebase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Lakebase Data and connect to Lakebase data in Akorbi Digital RunMyProcess.
-
Analyze Jumpseller Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Jumpseller data and visualize Jumpseller data in SAP Analytics Cloud.
-
Analyze Oracle Eloqua Reporting Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle Eloqua Reporting data in Microsoft R Open.
-
How to connect to Gorgias Data in DBVisualizer
Integrate Gorgias data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Bitly Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Bitly replication to PostgreSQL.
-
Integrating Claude Code with FreshBooks Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on FreshBooks data within assisted coding and automated development workflows.
-
How to update SingleStore from Excel
This article explains how to transfer data from Excel to SingleStore using the Excel Add-In for SingleStore.
-
Build Data Flows from ZendeskSell to SQL Server using SSIS
Easily back up ZendeskSell data to SQL Server using the SSIS components for ZendeskSell.
-
Connect to Live MySQL Data in PostGresSQL Interface through CData Connect AI
Create a live connection to MySQL in CData Connect AI and connect to your MySQL data from PostgreSQL.
-
Access Live Certinia 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 Certinia data through MCP integration.
-
Replicate QuickBooks Time Data to Multiple Databases
Replicate QuickBooks Time data to disparate databases with a point-and-click configuration.
-
Automated Continuous PostgreSQL Replication to SingleStore
Use CData Sync for automated, continuous, customizable PostgreSQL replication to SingleStore.
-
Visualize Live MariaDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MariaDB data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Controls to RabbitMQ Data in C++Builder
DataBind to RabbitMQ data in C++Builder with standard components and controls.
-
Integrating OpenCode with Deel 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.
-
HBase Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to HBase data through CData Connect AI using different applications and tools.
-
Connect to SingleStore Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SingleStore data in the Denodo Virtual DataPort Administrator.
-
Integrate HubSpot Data in the Pentaho Report Designer
Publish reports based on HubSpot data in the Pentaho BI tool.
-
Query, Visualize, and Share live Dynamics CRM Data in Redash
Use CData Connect AI to connect to live Dynamics CRM data in Redash for querying, visualizing, and sharing.
-
Access Live Smartsheet Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Smartsheet data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access SAP Ariba Source Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Ariba Source data from your Oracle system.
-
Integrate Live Printify Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Printify data and integrate live Printify data into apps built in Microsoft Power Apps.
-
Connect to Oracle Service Cloud Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Service Cloud and the Script function in FileMaker Pro to connect to Oracle Service Cloud and work with Oracle Service Cloud data in your FileMaker application.
-
Getting Started with the CData JDBC Driver for Timely
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Timely.
-
Excel Spreadsheet Automation on Google Cloud Storage Data with the QUERY Formula
Pull data from Google Cloud Storage, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Auth0 Replication to Snowflake
Use CData Sync for automated, continuous, customizable Auth0 replication to Snowflake.
-
Connect to Live ZohoExpense Data in MicroStrategy through CData Connect AI
Create a live connection to ZohoExpense Data in CData Connect AI and connect to your ZohoExpense data from MicroStrategy.
-
Access Short.io Data from MySQL in Amazon QuickSight
Connect to Short.io and build visualizations of Short.io data using a MySQL Connection in Amazon QuickSight.
-
Integrate Live Microsoft OneDrive Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft OneDrive data to Blue Prism using the CData ODBC Driver for Microsoft OneDrive to create automated workflows for repetitive business tasks.
-
Connect to Stack Exchange Data in NetBeans
Connect to Stack Exchange data in NetBeans with the data source configuration wizard.
-
Build Visualizations of OnePageCrm Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of OnePageCrm data in Birst.
-
Integrate OpenCode with Live NetSuite Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live NetSuite data from within your AI coding agent.
-
Query, Visualize, and Share live Microsoft Teams Data in Redash
Use CData Connect AI to connect to live Microsoft Teams data in Redash for querying, visualizing, and sharing.
-
Build Dashboards with Google Cloud Storage Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Cloud Storage data in Dundas BI.
-
Create SSAS Tabular Models from Marketo Data
How to build a SQL Server Analysis Service Tabular Model from Marketo data using CData drivers.
-
How to Connect to Live ShipStation 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 ShipStation data for you.
-
Build Oracle-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle data.
-
Integrating LangChain with Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Workday data within automated workflows.
-
Connect to Vimeo Data in CloverDX (formerly CloverETL)
Transfer Vimeo data using the visual workflow in the CloverDX data integration tool.
-
Analyze Microsoft Teams Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Teams data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Paylocity Data in the Pentaho Report Designer
Publish reports based on Paylocity data in the Pentaho BI tool.
-
Build a Singer.io Tap for SuiteCRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SuiteCRM data using the CData Python Connector.
-
Use Biml to Build SSIS Tasks to Replicate Salesforce Pardot Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Salesforce Pardot data to SQL Server.
-
Integrate Real-Time Access to Azure Table in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure Table data in real time.
-
How to Connect to Live Guru 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 Guru data for you.
-
View Reports on Real-Time SAP HANA XS Advanced Data in Power BI Report Server
Use the CData ODBC Driver for SAP HANA XS Advanced to visualize SAP HANA XS Advanced data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect and process QuickBooks Time data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live QuickBooks Time data.
-
Integrate Redshift Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Redshift data from Informatica Cloud.
-
Working with Typeform Data in LINQPad
Execute LINQ queries to Typeform data in LINQPad.
-
Extract, Transform, and Load Anaplan Data in Informatica PowerCenter
Create a simple Workflow for Anaplan data in Informatica PowerCenter.
-
Integrating Claude Code CLI with CouchDB 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.
-
Migrating data from Access to Snowflake using CData SSIS Components.
Easily push Access data to Snowflake using the CData SSIS Tasks for Access and Snowflake.
-
Integrate Quickbase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Quickbase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Quickbase data.
-
Query SparkPost Data as a MySQL Database in Node.js
Execute MySQL queries against SparkPost data from Node.js.
-
Build a PostgreSQL Interface for Slack Data using the CData JDBC Driver
Use the Remoting features of the Slack JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Scrapfly Data as a MySQL Database in Node.js
Execute MySQL queries against Scrapfly data from Node.js.
-
Build MVC Applications with Connectivity to Clio Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Clio from an ASP.NET MVC application.
-
Use ChatGPT to Talk to Your Paymo 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 Paymo data for you.
-
Enable the SparkPost JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SparkPost data.
-
Work with Chargebee Data in FoxPro
Load Chargebee data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Write a Simple Go Application to work with Procore Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Procore data.
-
Automated Continuous DB2 Replication to Snowflake
Use CData Sync for automated, continuous, customizable DB2 replication to Snowflake.
-
Integrate Google's Antigravity Agent with Live WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live WordPress data using the Model Context Protocol.
-
How to connect and process Basecamp data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Basecamp data.
-
Connecting Agentforce with PingOne Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your PingOne data for you.
-
Build Pipelines with Live SAP Hybris C4C Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP Hybris C4C from Google Cloud Data Fusion, enabling the integration of live SAP Hybris C4C data into the building and management of effective data pipelines.
-
Visualize Live IBM Cloud Object Storage Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live IBM Cloud Object Storage data into custom reports in Power BI.
-
Configure the CData JDBC Driver for ZohoExpense in a Connection Pool in Tomcat
Connect to ZohoExpense data from a connection pool in Tomcat.
-
Migrating data from Vault CRM to Snowflake using CData SSIS Components.
Easily push Vault CRM data to Snowflake using the CData SSIS Tasks for Vault CRM and Snowflake.
-
Connect to Suadeo Data in DBArtisan
Use wizards in DBArtisan to configure Suadeo data as a data source.
-
Getting Started with the CData Connect AI Python SDK for iContact
Install the CData Connect AI Python SDK to read live iContact data with standard DB-API 2.0 Python code.