CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Workday 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 Workday for you.
-
Integrate with Live WordPress Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to WordPress from the MuleSoft Anypoint Platform to integrate live WordPress into custom reports and dashboards.
-
Automated Amazon S3 Data Replication to Teradata
Use CData Sync to Customize and automate Amazon S3 replication to Teradata.
-
How to create an RPA flow for Optimizely Data in UiPath Studio
Use the Optimizely ODBC Driver to create workflows that access real-time Optimizely without any coding.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ADP
Provide connectivity to ADP through an SAP BusinessObjects universe.
-
Automated SharePoint Excel Services Data Replication to Teradata
Use CData Sync to Customize and automate SharePoint Excel Services replication to Teradata.
-
Integrating Kiro CLI with Copper 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.
-
Access WooCommerce 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 WooCommerce.
-
Visualize Salesforce Marketing Data in Sisense
Create an ElastiCube in Sisense app with access to Salesforce Marketing Cloud.
-
Access Live Jodoo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Jodoo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Automated SAP Business One-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Business One and build automated workflows in Zapier.
-
Build a PostgreSQL Interface for BigCommerce Data using the CData JDBC Driver
Use the Remoting features of the BigCommerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Apps with Live Strava Data Using the Low-Code Development Platform of Mendix
Connect Strava with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize HCL Domino Data in Tableau
The CData ODBC driver for HCL Domino enables you integrate HCL Domino into Tableau dashboards.
-
Integrate SAP HANA Data in the Pentaho Report Designer
Publish reports based on SAP HANA in the Pentaho BI tool.
-
Analyze Toggl Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Toggl with the CData JDBC Driver for Toggl.
-
Use Biml to Build SSIS Tasks to Replicate QuickBooks Time Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate QuickBooks Time to SQL Server.
-
Query MYOB AccountRight Data in DataGrip
Create a Data Source for MYOB AccountRight in DataGrip and use SQL to query live MYOB AccountRight.
-
How to Access Live Microsoft Dataverse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Microsoft Dataverse enables you to integrate Microsoft Dataverse (CDS) into workflows built using Microsoft Power Automate Desktop.
-
Integrate Dropbox Data in the Pentaho Report Designer
Publish reports based on Dropbox in the Pentaho BI tool.
-
Connect to and Visualize Live Pinterest Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pinterest.
-
Build Charts with Wistia Data in Clear Analytics
Create dynamic charts and perform analytics based on Wistia in Clear Analytics.
-
Build Trello Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Trello and build visualizations in Tableau.
-
Connect GetResponse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect GetResponse with IBM WebSphere for seamless data integration and connectivity.
-
Create a Data Access Object for Gumroad Data using JDBI
A brief overview of creating a SQL Object API for Gumroad in JDBI.
-
Replicate BenchmarkEmail Data in Heroku for Use in Salesforce Connect
Replicate BenchmarkEmail to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query Mistral AI Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Mistral AI from Node.js.
-
Integrate Open WebUI with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Atlassian Confluence from within the chat interface.
-
Integrate Live Redshift Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Amazon Redshift to Blue Prism using the CData ODBC Driver for Redshift to create automated workflows for repetitive business tasks.
-
Integrating Antigravity CLI with SAP SuccessFactors LMS via CData CLI
Connect SAP SuccessFactors LMS to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use ChatGPT to Talk to Your Google Campaign Manager 360 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 Google Campaign Manager 360 for you.
-
Connecting Moonlit Workflow with SAP Business One 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 SAP Business One in real time.
-
Build an OLAP Cube in SSAS from Qualaroo Data
Establish a connection to Qualaroo data from SQL Server Analysis Services, and use the Qualaroo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Facebook Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Facebook replication to Google Cloud SQL.
-
How to Visualize Datadog Data in Python with pandas
Use pandas and other modules to analyze and visualize live Datadog in Python.
-
Integrate LibreChat with Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Xero Accounting from within the chat interface.
-
Choosing the Best Method to Connect Sybase IQ to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sybase IQ from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build AI/ML Models with Live Auth0 Data using Dataiku
Connect Auth0 Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Samanage Replication to Snowflake
Use CData Sync for automated, continuous, customizable Samanage replication to Snowflake.
-
Choosing the Best Method to Connect Helpscout to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Helpscout from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate SurveyMonkey Data into Power Automate Desktop using CData Connect
CData Connect for SurveyMonkey Data enables you to integrate SurveyMonkey into workflows built using Microsoft Power Automate Desktop.
-
Import and Visualize QuickBooks Data in Power View
Create data visualizations based on QuickBooks Desktop in Excel.
-
How to Easily Query Freshservice Data in OpenOffice Base
Connect to Freshservice data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Manage Active Directory Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Active Directory.
-
Create Avalara AvaTax-Connected Applications in Appsmith
Connect to Avalara AvaTax Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Avalara AvaTax.
-
Connect to Marketo Data in NetBeans
Connect to Marketo in NetBeans with the data source configuration wizard.
-
How to Access Live Bitbucket Data in Visual Studio Code via Cline
Run CData MCP Server for Bitbucket on Windows Subsytem for Linux (WSL) and connect to live Bitbucket from the Cline extension in Visual Studio Code.
-
Build Azure Analysis Services-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Azure Analysis Services to explore live Azure Analysis Services Data in GitHub Copilot to assist with building Azure Analysis Services-powered applications.
-
Getting Started with the CData ADO.NET Provider for Tickspot
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
DataBind Charts to Azure Analysis Services Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Analysis Services 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.
-
Automated ServiceNow Data Replication to Teradata
Use CData Sync to Customize and automate ServiceNow replication to Teradata.
-
Connect to Snowflake Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Snowflake from Filemaker Pro on Mac.
-
Analyze Freshdesk Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Freshdesk from Power Pivot. You will use the Table Import Wizard to load Freshdesk. You can visually build the import query or use any SQL supported by the driver.
-
Build a PostgreSQL Interface for Azure Data Lake Storage Data using the CData JDBC Driver
Use the Remoting features of the Azure Data Lake Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Apps with Live Microsoft Entra ID Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Entra ID with Mendix to build apps using the CData JDBC Driver for Microsoft Entra ID.
-
Analyze Stripe Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Stripe from Power Pivot. You will use the Table Import Wizard to load Stripe. You can visually build the import query or use any SQL supported by the driver.
-
A PostgreSQL Interface for Everhour Data using the CData ODBC Driver
Use the SQL Gateway and Everhour ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Microsoft Teams Data from PowerShell
Write a quick PowerShell script to query Microsoft Teams. Use connectivity to the live data to replicate Microsoft Teams to SQL Server.
-
Back Up Teradata to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Teradata. In this article, we will employ an SSIS workflow to populate a database with Teradata data.
-
Easily Integrate NASA Data in Lazarus Pascal IDE
Learn how to easily integrate live NASA in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Apps from YouTube Analytics Data in Qlik Sense Cloud
Use CData Connect AI to connect to YouTube Analytics Data and build apps from live YouTube Analytics in Qlik Sense Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Redis
Provide connectivity to Redis through an SAP BusinessObjects universe.
-
Integrate Live DB2 Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Visualize SAP Business Warehouse Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Business Warehouse.
-
Integrate Theia IDE with Live Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Explore Geographical Relationships in Discord Data with Power Map
Create data visualizations with Discord in Power Map.
-
Process & Analyze Recurly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Recurly Data.
-
How to Query Live HelloSign Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live HelloSign data in natural language using Python.
-
Use the CData Software ODBC Driver for Postmark in MicroStrategy Web
Connect to Postmark in MicroStrategy Web using the CData Software ODBC Driver for Postmark.
-
Build Agents in Relevance AI with Access to Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ADP within intelligent agent workflows.
-
How to Access Live Notion Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Notion enables you to integrate Notion into workflows built using Microsoft Power Automate Desktop.
-
Use the CData API Server to Access Databricks Data in Microsoft PowerPivot
Use the CData API Server to connect to live Databricks in the Power Pivot business intelligence tool.
-
Automated Continuous Drift Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Drift replication to Amazon Redshift.
-
Use the CData ODBC Driver for ElevenLabs from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ElevenLabs to connect to ElevenLabs from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ElevenLabs in Excel.
-
Getting Started with the CData Tableau Connector for SAP HANA
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP HANA.
-
Access Excel Online Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Excel Online from your Oracle system.
-
Getting Started with the CData Connect AI Python SDK for Google Contacts
Install the CData Connect AI Python SDK to read and write live Google Contacts with standard DB-API 2.0 Python code.
-
Access SharePoint Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft SharePoint from HeidiSQL.
-
How to Connect to Zoho Projects Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoho Projects. Leverage the pyodbc module for ODBC in Python.
-
Building Dynamic D3.js Apps with Database Data
Use the API Server and D3.js to Build Dynamic Web Apps with Live Database Data.
-
Connect to Microsoft Planner Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Planner and the Script function in FileMaker Pro to connect to Microsoft Planner and work with Microsoft Planner in your FileMaker application.
-
Connect to Oracle Financials Cloud Data from AWS Glue
Use CData Connect AI to gain access to live Oracle Financials Cloud from your AWS Glue jobs.
-
Establish a Live Connection with Bright Data Data using Tableau Bridge
The CData ODBC Driver for Bright Data enables you to integrate live Bright Data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize SharePoint Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft SharePoint.
-
Build a PostgreSQL Interface for Certinia Data using the CData JDBC Driver
Use the Remoting features of the Certinia JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to create an RPA flow for Jira Assets Data in UiPath Studio
Use the Jira Assets ODBC Driver to create workflows that access real-time Jira Assets without any coding.
-
How to Work with Mouseflow Data in ETL Validator JDBC
Connect to Mouseflow from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Box Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Box in the Denodo Virtual DataPort Administrator.
-
Access Dynamics 365 Business Central Data from MySQL in Amazon QuickSight
Connect to Dynamics 365 Business Central and build visualizations of Dynamics 365 Business Central using a MySQL Connection in Amazon QuickSight.
-
Replicate EmailOctopus Data to Multiple Databases via the CData Sync CLI
Replicate EmailOctopus to disparate databases with a single configuration.
-
Natively Connect to Drip Data in PHP
The CData ODBC driver for Drip enables you to create PHP applications with connectivity to Drip. Leverage the native support for ODBC in PHP.
-
Bidirectional Access to Apify Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apify in Filemaker Pro for Mac or Windows.
-
How to Work with Timely Data in ETL Validator JDBC
Connect to Timely from ETL Validator jobs using the CData Software JDBC Driver.
-
Process & Analyze Perplexity Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Perplexity Data.
-
How to Build an ETL App for Confluence Data in Python with CData Connect AI
Build ETL pipelines that read and write live Atlassian Confluence in Python with petl and the CData Connect AI Python SDK.
-
Connect to Gorgias Data from PowerBuilder via ADO.NET
This article demonstrates how to access Gorgias from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous MessageBird Replication to SQLite
Use CData Sync for automated, continuous, customizable MessageBird replication to SQLite.
-
How to Connect to Live API 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 API for you.
-
Access Live HubSpot Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live HubSpot from your Google Sheets.
-
Connect to Amazon DynamoDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Amazon DynamoDB.