CData Software - Knowledge Base
Recent Articles
-
Visualize Exact Online Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Exact Online data.
-
MailChimp Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to MailChimp data through CData Connect AI using different applications and tools.
-
Integrate with Confluence Data in JReport Designer
Create charts and reports based on Confluence data in JReport Designer.
-
Integrating OpenCode with Tavily 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 Jumpseller Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Jumpseller from PowerBI.com to create Power BI Dataflows with real-time data.
-
Work with PhantomBuster Data in FoxPro
Load PhantomBuster data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Codex with Invoiced 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.
-
Integrating Claude Code CLI with Discord 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.
-
Connecting Agentforce with Notion 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 Notion data for you.
-
Automated Continuous Bright Data Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Bright Data replication to Apache Kafka.
-
Use the CData ODBC Driver for REST from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for REST to connect to REST data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring REST data in Excel.
-
Connect to ClickUp Data in HULFT Integrate
Connect to ClickUp as a JDBC data source in HULFT Integrate
-
Connect Optimizely to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Optimizely data using the CData Python MCP Server.
-
Connect to Microsoft OneDrive Data in RazorSQL
Connect to Microsoft OneDrive from wizards and query Microsoft OneDrive data from the GUI in the RazorSQL database management tool.
-
Use ChatGPT to Talk to Your Zoho Projects 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 Zoho Projects data for you.
-
Access Beeminder 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 Beeminder data.
-
Integrate Grafana Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Grafana data from Informatica Cloud.
-
Create BigQuery-Connected Nintex Workflows
Use CData Connect AI to connect to BigQuery Data from Nintex Workflow Cloud and build custom workflows using live BigQuery data.
-
How to connect to Stack Exchange Data in DBVisualizer
Integrate Stack Exchange data with visual data analysis tools and data connection wizards in DBVisualizer
-
Work with MailerSend Data in FoxPro
Load MailerSend data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Devin with Live Dynamics 365 Business Central Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Dynamics 365 Business Central data.
-
Connect to and Query Paylocity Data in QlikView over ODBC
Create data visualizations with Paylocity data in QlikView.
-
Connect to DocuSign Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to DocuSign.
-
Visualize MailerLite Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MailerLite data.
-
Integrating Dataiku with SFTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SFTP data.
-
Build Charts with OpenWeatherMap Data in Clear Analytics
Create dynamic charts and perform analytics based on OpenWeatherMap data in Clear Analytics.
-
Connect to Azure Data Catalog Data from Crystal Reports
Use CData Connect AI to connect to and report on live Azure Data Catalog data from Crystal Reports.
-
How to update Snapchat Ads from Excel
This article explains how to transfer data from Excel to Snapchat Ads using the Excel Add-In for Snapchat Ads.
-
How to Connect to Live Pipedrive 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 Pipedrive data for you.
-
Analyze WooCommerce Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of WooCommerce data and visualize WooCommerce data in SAP Analytics Cloud.
-
Connect to SAP HANA Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP HANA data in Google Apps Script.
-
Perform Batch Operations with Salesloft Data in Apache NiFi
Connect to Salesloft data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to Work with Scrapfly Data in AWS Glue Jobs Using JDBC
Connect to Scrapfly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous FormSite Replication to MongoDB
Use CData Sync for automated, continuous, customizable FormSite replication to MongoDB.
-
Automated Jira Assets Data Replication to Teradata
Use CData Sync to Customize and automate Jira Assets data replication to Teradata.
-
Connecting Mastra with GetResponse 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 GetResponse data, no replication required.
-
Visualize Live Highrise Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Highrise data into custom reports in Power BI.
-
Natively Connect to YouTube Analytics Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to YouTube Analytics data. Leverage the native support for ODBC in PHP.
-
Import Real-Time Adobe Target Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Adobe Target data in ColdFusion.
-
Integrate Live Facebook Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Facebook data to Blue Prism using the CData ODBC Driver for Facebook to create automated workflows for repetitive business tasks.
-
Model Guru Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Guru, enabling the direct import of real-time Guru data.
-
Create Onfleet Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Onfleet from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData Excel Add-In for eBay Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for eBay Analytics.
-
How to create an RPA flow for Copper Data in UiPath Studio
Use the Copper ODBC Driver to create workflows that access real-time Copper data without any coding.
-
Establish a Live Connection with Sybase Data using Tableau Bridge
The CData ODBC Driver for Sybase enables you to integrate live Sybase data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Live Freshdesk Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Freshdesk in CData Connect AI and connect to your Freshdesk data from PostgreSQL.
-
Connect to Microsoft Entra ID Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Entra ID data as a data source.
-
Query Zendesk Data in ColdFusion
Write standard ColdFusion data access code to connect to Zendesk data.
-
Integrate Trae with Live Greenhouse Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Greenhouse data from within the AI-powered IDE.
-
Build MVC Applications with Connectivity to QuickBooks Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access QuickBooks from an ASP.NET MVC application.
-
How to Connect to Adobe Target Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Adobe Target data. Leverage the pyodbc module for ODBC in Python.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SparkPost
Provide connectivity to SparkPost data through an SAP BusinessObjects universe.
-
Access Live Productboard Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Productboard data into the statistical analysis tools available in SAS JMP. This article shows how to use Productboard data in the Graph Builder and Query Builder.
-
Manage Lakebase Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Lakebase.
-
Create Power BI Reports on Real-Time PingOne Data
Use the CData ODBC Driver for PingOne to visualize PingOne data in Power BI Desktop.
-
Automated Pipeliner CRM Data Replication to Teradata
Use CData Sync to Customize and automate Pipeliner CRM data replication to Teradata.
-
Create a Data Access Object for SAS xpt Data using JDBI
A brief overview of creating a SQL Object API for SAS xpt data in JDBI.
-
Build Visualizations of HDFS Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of HDFS data in Birst.
-
Automated Continuous Opsgenie Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Opsgenie data replication to OneLake in Microsoft Fabric.
-
Analyze Google Search Results in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Search results in Microsoft R Open.
-
Query Snowflake Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Snowflake data from Node.js.
-
Connecting Moonlit Workflow with Wistia 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 Wistia data in real time.
-
Automated Continuous Short.io Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Short.io replication to Google Cloud SQL.
-
Integrate Webflow with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Webflow with External Services.
-
How to Use a Microsoft Access Database to Update Xero Data in Real Time
Update Xero data by creating a linked table in Microsoft Access with the CData Xero ODBC Driver.
-
Use CData Connect AI to Access SendGrid Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SendGrid data in the Power Pivot business intelligence tool.
-
Access Live Demio Data in Coginiti Pro
Connect to and query live Demio data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Sage Cloud Accounting Data in ACL Analytics
Connect to Sage Cloud Accounting data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sage Cloud Accounting data.
-
Automated Continuous Close Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Close replication to Amazon S3.
-
Use the CData ODBC Driver for Amazon DynamoDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Amazon DynamoDB to connect to Amazon DynamoDB data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amazon DynamoDB data in Excel.
-
Integrating HubDB Data in Talend Cloud Data Management Platform
Connect HubDB Data with Talend Cloud Data Management Platform using the CData JDBC Driver for HubDB.
-
Connect Placid to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Placid data using the CData Python MCP Server.
-
Connect to Microsoft Dataverse Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Microsoft Dataverse.
-
Replicate FreshBooks Data to Multiple Databases
Replicate FreshBooks data to disparate databases with a point-and-click configuration.
-
Stream Typeform Data into Apache Kafka Topics
Access and stream Typeform data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access MarkLogic Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MarkLogic data from HeidiSQL.
-
Integrating Antigravity CLI with BigCommerce data via CData CLI
Connect BigCommerce data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect PolyBase to Google Campaign Manager 360
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Campaign Manager 360 data.
-
Connect to Monday.com from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Monday.com data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use Dash to Build to Web Apps on Zoho Inventory Data
Create Python applications that use pandas and Dash to build Zoho Inventory-connected web apps.
-
How to Connect to Live Wistia 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 Wistia data for you.
-
Integrate with SparkPost Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SparkPost data to a JSON file on disk.
-
How to Connect to Live Neo4J 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 Neo4J data for you.
-
Automated Continuous SAP Ariba Source Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Ariba Source data replication to OneLake in Microsoft Fabric.
-
How to Connect to Live AlloyDB Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your AlloyDB data for you.
-
How to integrate Metabase with WooCommerce Data
Use CData Connect AI to connect to live WooCommerce data and create an interactive dashboard in Metabase from WooCommerce data.
-
Use Dash to Build Web Apps on eBay Analytics Data via CData Connect AI
Build interactive Dash web apps on live eBay Analytics data using pandas and the CData Connect AI Python SDK.
-
Migrating data from QuickBooks Time to Databricks using CData SSIS Components.
Easily push QuickBooks Time data to Databricks using the CData SSIS Tasks for QuickBooks Time and Databricks.
-
Automate Reckon Accounts Hosted Data Replication to Azure Data Lake
Use CData Sync to customize and automate Reckon Accounts Hosted data replication to Azure Data Lake.
-
Integrate OpenCode with Live XML Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live XML data from within your AI coding agent.
-
Build a PostgreSQL Interface for Clio Data using the CData JDBC Driver
Use the Remoting features of the Clio JDBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for SAP SuccessFactors Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP SuccessFactors JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SAP Concur Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Concur data in Airbyte.
-
Enable the YouTube Analytics JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with YouTube Analytics data.
-
Connect to Bannerbear in SpagoBI
Create reports featuring live Bannerbear data in SpagoBI Studio. Host Bannerbear reports on SpagoBI Server.
-
Integrate Live Square Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Square data and integrate live Square data into apps built in Microsoft Power Apps.
-
Visualize JotForm Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to JotForm data.
-
How to Connect DBeaver to ClickTime via a JDBC Driver
Manage ClickTime data with visual tools in DBeaver like the query browser.
-
How to Connect the Power BI Service to Salesforce Marketing: Complete Guide
Connect to the CData Software Power BI Connector for Salesforce Marketing from PowerBI.com to provide real-time Salesforce Marketing data across the organization.
-
Replicate Paymo Data to Multiple Databases via the CData Sync CLI
Replicate Paymo data to disparate databases with a single configuration.