CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code CLI with PingOne 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.
-
Analyze Live CockroachDB Data in SAS Viya
Use CData Connect AI to connect to CockroachDB from SAS Viya and deploy self-service analytics using live CockroachDB.
-
How to Import Data from Pinecone into Google Sheets
Import Pinecone into a Google spreadsheet that is automatically refreshed.
-
How to Connect to Live Azure Table 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 Azure Table Storage for you.
-
Validate SendPulse Data with QuerySurge
Access and validate SendPulse in QuerySurge using the CData JDBC Driver.
-
How to create an RPA flow for Supabase Data in UiPath Studio
Use the Supabase ODBC Driver to create workflows that access real-time Supabase without any coding.
-
Replicate CSV Data from PowerShell
Write a quick PowerShell script to query CSV/TSV Files. Use connectivity to the live data to replicate CSV/TSV Files to SQL Server.
-
Integrating Dataiku with Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Facebook Ads.
-
Automated Continuous Oracle Service Cloud Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Apache Kafka.
-
Build AI/ML Models with Live MessageBird Data using Dataiku
Connect MessageBird Data with Dataiku using the CData API Driver for JDBC.
-
Analyze Rebilly Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Rebilly and visualize live Rebilly in Infragistics Reveal.
-
Bidirectional Access to Azure Synapse Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Azure Synapse in Filemaker Pro for Mac or Windows.
-
Connect to Redis Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Redis in the Denodo Virtual DataPort Administrator.
-
Visualize Live HubSpot Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live HubSpot using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Microsoft OneDrive Data in RapidMiner
Integrate Microsoft OneDrive with standard components and data source configuration wizards in RapidMiner Studio.
-
Enable the FreshBooks JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with FreshBooks.
-
A PostgreSQL Interface for Couchbase Data using the CData ODBC Driver
Use the SQL Gateway and Couchbase ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Azure Synapse within intelligent workflows.
-
Excel Spreadsheet Automation on LinkedIn Ads Data with the QUERY Formula
Pull data from LinkedIn Ads, automate spreadsheets, and more with the QUERY formula.
-
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.
-
How to connect PolyBase to Telegram
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Telegram.
-
Replicate Databricks Data to Multiple Databases via the CData Sync CLI
Replicate Databricks to disparate databases with a single configuration.
-
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.
-
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.
-
How to Seamlessly Import Microsoft Ads Data into IBM SPSS Modeler
Integrate Microsoft Ads data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect the Power BI Service to Delighted: Complete Guide
Connect to the CData Software Power BI Connector for Delighted from PowerBI.com to provide real-time Delighted across the organization.
-
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.
-
Integrate SAP HANA Data in the Pentaho Report Designer
Publish reports based on SAP HANA in the Pentaho BI tool.
-
BigCommerce Reporting in OBIEE with the BigCommerce JDBC Driver
Deploy the BigCommerce JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
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.
-
Use ChatGPT to Talk to Your Instagram 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 Instagram for you.
-
Build Charts with Wistia Data in Clear Analytics
Create dynamic charts and perform analytics based on Wistia in Clear Analytics.
-
Prepare, Blend, and Analyze Beeminder Data in Alteryx Designer (ODBC)
Build workflows to access live Beeminder for self-service data analytics.
-
Create a Data Access Object for Gumroad Data using JDBI
A brief overview of creating a SQL Object API for Gumroad in JDBI.
-
Prepare, Blend, and Analyze ZarMoney Data in Alteryx Designer (ODBC)
Build workflows to access live ZarMoney for self-service data analytics.
-
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.
-
Automated Continuous Sage 300 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Sage 300 replication to Amazon S3.
-
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.
-
How to Easily Query Salesforce CRM Analytics Data in OpenOffice Base
Connect to Salesforce CRM Analytics data in OpenOffice Base using the CData ODBC Driver for Salesforce CRM Analytics and generate reports with live data insights.
-
Enable the Freshservice JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Freshservice.
-
Build Reckon Accounts Hosted-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Reckon Accounts Hosted to explore live Reckon Accounts Hosted Data in Gemini Code Assist to assist with building Reckon Accounts Hosted-powered applications.
-
Connect to Highrise Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Highrise CRM in Airbyte.
-
Integrate Live Spark Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
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.
-
How to Connect the Power BI Service to Sugar CRM: Complete Guide
Connect to the CData Software Power BI Connector for Sugar CRM from PowerBI.com to provide real-time Sugar CRM across the organization.
-
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.
-
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.
-
How to Query Twilio Data in MySQL Workbench
Execute MySQL queries against live Twilio from MySQL Workbench.
-
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.
-
Extend Google Sheets with SingleStore Data
Make calls to SingleStore from Google Apps Script via the API Server.
-
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.
-
Query Salesforce Data 360 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Salesforce Data 360 entities in PHP by modeling them as objects.
-
Build SAP ByDesign Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Business ByDesign and build visualizations in Tableau Cloud.
-
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.
-
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.
-
Access Google Drive Data from MySQL in Amazon QuickSight
Connect to Google Drive and build visualizations of Google Drive using a MySQL Connection in Amazon QuickSight.
-
Query, Visualize, and Share live FreshBooks Data in Redash
Use CData Connect AI to connect to live FreshBooks in Redash for querying, visualizing, and sharing.
-
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.
-
Integrating Claude Code CLI with eBay Analytics 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.
-
LINQ to Spotify 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 Spotify Data Provider.
-
MailChimp Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MailChimp facts in real time.
-
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.
-
Connect to Snowflake Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Snowflake from Filemaker Pro on Mac.
-
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.
-
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.
-
Integrate Live DB2 Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
DataBind Controls to Acumatica Data in Delphi
DataBind to Acumatica ERP in Delphi with standard data access components and controls.
-
Use the CData API Server to Access ChartMogul Data in Microsoft PowerPivot
Use the CData API Server to connect to live ChartMogul in the Power Pivot business intelligence tool.
-
Publish ZarMoney-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZarMoney.
-
Process & Analyze Recurly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Recurly Data.
-
Creating SAP Ariba Procurement-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Ariba Procurement to Unqork and build custom business apps.
-
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.
-
Connect to Teamgate Data in DBArtisan
Use wizards in DBArtisan to configure Teamgate as a data source.
-
Replicate ShipEngine Data to Multiple Databases via the CData Sync CLI
Replicate ShipEngine to disparate databases with a single configuration.
-
How to connect to NASA Data with Squirrel SQL client
Connect to NASA and execute queries in the Squirrel SQL Client.
-
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 Opsgenie Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Opsgenie replication to Amazon Redshift.
-
Automated Continuous Drift Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Drift replication to Amazon Redshift.
-
Integrating Antigravity CLI with Microsoft Entra ID via CData CLI
Connect Microsoft Entra ID to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Query Pinecone Data in DataGrip
Create a Data Source for Pinecone in DataGrip and use SQL to query live Pinecone.
-
Automated Continuous HubSpot Replication to MySQL
Use CData Sync for automated, continuous, customizable HubSpot replication to MySQL.
-
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.
-
Automate Suadeo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Suadeo from PowerShell? This article demonstrates how to utilize the Suadeo Cmdlets for tasks like connecting to Suadeo, automating operations, downloading data, and more.
-
Create Data Visualizations in Cognos BI with PDFMonkey Data
Access PDFMonkey as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate DocuSign Data into Power Automate Desktop using CData Connect
CData Connect for DocuSign Data enables you to integrate DocuSign into workflows built using Microsoft Power Automate Desktop.
-
Extract, Transform, and Load Testmonitor Data in Informatica PowerCenter
Create a simple Workflow for Testmonitor in Informatica PowerCenter.