CData Software - Knowledge Base
Recent Articles
-
Integrating LangChain with Supabase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Supabase data within automated workflows.
-
How to Query Live Sybase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sybase data data in natural language using Python.
-
Connect to HDFS Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time HDFS data using standard SQL.
-
Automate PagerDuty Data Replication to Azure Synapse
Use CData Sync to customize and automate PagerDuty data replication to Azure Synapse.
-
Build Zoho Creator-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Zoho Creator Data and create custom apps in Mendix.
-
Build MVC Applications with Connectivity to Facebook Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Facebook from an ASP.NET MVC application.
-
Connect to QuickBooks Online Data in RazorSQL
Connect to QuickBooks Online from wizards and query QuickBooks Online data from the GUI in the RazorSQL database management tool.
-
Integrating Cursor with BambooHR 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 Exa Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Exa from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData ODBC Driver for Oracle Financials Cloud
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Oracle Financials Cloud.
-
Integrating Gumloop with SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Ariba Procurement data within automated workflows.
-
YouTube Analytics Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to YouTube Analytics data through CData Connect AI using different applications and tools.
-
Import and Visualize Perigon Data in Power View
Create data visualizations based on Perigon data in Excel.
-
Access Live SingleStore Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SingleStore data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Live Recurly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Recurly data.
-
Integrating OpenCode with Bannerbear 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.
-
How to Connect to Live Google Calendar 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 Google Calendar data for you.
-
Automated Continuous ZarMoney Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZarMoney replication to AlloyDB.
-
Use Biml to Build SSIS Tasks to Replicate BenchmarkEmail Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate BenchmarkEmail data to SQL Server.
-
Use Grok to Talk to Your eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your eBay data for you.
-
Automated Continuous PostgreSQL Replication to SQLite
Use CData Sync for automated, continuous, customizable PostgreSQL replication to SQLite.
-
Use Claude to Talk to Your QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your QuickBooks Online data for you.
-
How to Work with Bitly Data in ETL Validator JDBC
Connect to Bitly from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Data Visualizations Based On PingOne Data in Mode
Use CData Connect AI to connect to PingOne Data from Mode and build visualizations using live PingOne data.
-
Create Apps from Amazon Athena Data in Qlik Sense Cloud
Use CData Connect AI to connect to Amazon Athena Data and build apps from live Amazon Athena data in Qlik Sense Cloud.
-
Analyze Nethunt Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Nethunt data with the CData JDBC Driver for Nethunt.
-
Query Cloudant Data in DataGrip
Create a Data Source for Cloudant in DataGrip and use SQL to query live Cloudant data.
-
Integrate Monday.com Data in the Pentaho Report Designer
Publish reports based on Monday.com data in the Pentaho BI tool.
-
Automated Continuous Timely Replication to Snowflake
Use CData Sync for automated, continuous, customizable Timely replication to Snowflake.
-
Connecting GenSpark with Google Calendar 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 Calendar data without any replication or custom integration required.
-
Access Salesforce CRM Analytics 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 Salesforce CRM Analytics data.
-
Access Live Cosmos DB Data in Excel 365 Online (Excel for the web)
Connect to Cosmos DB data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Analyze Power BI XMLA Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Power BI XMLA data and visualize live Power BI XMLA data in Infragistics Reveal.
-
How to use SQLAlchemy ORM to access Intercom Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Intercom data.
-
Automate Azure DevOps Data Replication to Couchbase
Use CData Sync to Customize and automate Azure DevOps data replication to Couchbase.
-
Working with Freshservice Data in LINQPad
Execute LINQ queries to Freshservice data in LINQPad.
-
Replicate ChargeOver Data in Heroku for Use in Salesforce Connect
Replicate ChargeOver data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use Biml to Build SSIS Tasks to Replicate Quaderno Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Quaderno data to SQL Server.
-
Using the CData Software ODBC Driver for ActiveCampaign in PyCharm
Connect to ActiveCampaign as an ODBC data source in PyCharm using the CData Software ODBC Driver for ActiveCampaign.
-
Build Timely-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Timely Data from Zoho Analytics and import live Timely data.
-
How to connect to Adobe Analytics Data from Spring Boot
Connect to Adobe Analytics in a Spring Boot Application using the CData JDBC Driver for Adobe Analytics
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP Hybris C4C
Provide connectivity to SAP Hybris C4C data through an SAP BusinessObjects universe.
-
Create Reports with Grafana Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Grafana data.
-
Visualize Bitly Data in Tableau
The CData ODBC driver for Bitly enables you integrate Bitly data into Tableau dashboards.
-
Use the CData Software JDBC Driver for Wistia in MicroStrategy Desktop
Connect to Wistia data in MicroStrategy Desktop using the CData Software JDBC Driver for Wistia.
-
How to connect to ZohoInvoice Data in DBVisualizer
Integrate ZohoInvoice data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Mistral AI from Asprova with CData Software ODBC Driver for Mistral AI
This article shows how to connect faster to Mistral AI data from Asprova.
-
Connect Bitbucket Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Bitbucket data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build a Singer.io Tap for Salesforce Marketing With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Salesforce Marketing data using the CData Python Connector.
-
How to Work with Simplesat Data in ETL Validator JDBC
Connect to Simplesat from ETL Validator jobs using the CData Software JDBC Driver.
-
Choosing the Best Method to Connect Excel to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Excel data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous SAP BusinessObjects BI Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Oracle.
-
Build Visualizations of Dotmailer Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Dotmailer data in Birst.
-
Link Egnyte with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Egnyte data in Filemaker Pro for Mac or Windows.
-
Integrate Live Microsoft Ads Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Ads data to Blue Prism using the CData ODBC Driver for Microsoft Ads to create automated workflows for repetitive business tasks.
-
Integrate with Okta Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Okta data to a JSON file on disk.
-
Query Live Sage 300 Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Sage 300 data through a conversational interface.
-
Excel Spreadsheet Automation with the CDATAQUERY Formula
The CData Excel Add-In provides formulas that can pull data from different data sources into your spreadsheet. For example, the Google provider can create a spreadsheet of directions. In this article we show how to use the CDATAQUERY formula to automate spreadsheets.
-
Automated Continuous PolarTeamPro Replication to MongoDB
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to MongoDB.
-
How to Work with Spotify Data in AWS Glue Jobs Using JDBC
Connect to Spotify from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Deel Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Deel data.
-
Build Semantic Layer Views for Mode Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Mode data.
-
Connect to Discord Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Discord data.
-
Integrate Cline with Live FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live FreshBooks data from within your IDE.
-
Connect to SQL Analysis Services Data in NetBeans
Connect to SQL Analysis Services data in NetBeans with the data source configuration wizard.
-
Connect to Highrise Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Highrise and the Script function in FileMaker Pro to connect to Highrise and work with Highrise data in your FileMaker application.
-
A PostgreSQL Interface for Superchat Data (MySQL Remoting via JDBC)
Use the Remoting features of the Superchat JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Perigon Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Perigon data from Informatica Cloud.
-
Analyze Live CSV Data in SAS Viya
Use CData Connect AI to connect to CSV data from SAS Viya and deploy self-service analytics using live CSV data.
-
Integrating Claude Code with xBase Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on xBase data within assisted coding and automated development workflows.
-
How to Build an ETL App for Supabase Data in Python with CData
Create ETL applications and real-time data pipelines for Supabase data in Python with petl.
-
Integrating Antigravity CLI with eBay Analytics data via CData CLI
Connect eBay Analytics data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Create Power BI Visual Reports with Real-Time Phoenix Data
Use CData Power BI Connectors to visualize Phoenix data in Power BI.
-
Visualize Accelo Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Accelo data into TIBCO Spotfire.
-
Access Live Microsoft Exchange Data in TIBCO Data Virtualization
Use the Microsoft Exchange Tibco DV Adapter to create a Microsoft Exchange data data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Exchange data from your TDV Server.
-
Import Real-Time Parallel Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Parallel data in ColdFusion.
-
Access Live AdRoll Data in Coginiti Pro
Connect to and query live AdRoll data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Microsoft Copilot Studio to talk to your Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Guru data for you.
-
Connect to Anaplan Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Anaplan data using standard SQL.
-
Integrate with live Google Analytics Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Analytics data in Jitterbit.
-
How to connect Amazon QuickSight to Power BI XMLA Data
Create a connection to Power BI XMLA data in CData Connect AI and insert Power BI XMLA data into Amazon QuickSight SPICE to build interactive dashboards.
-
Prepare, Blend, and Analyze MailerLite Data in Alteryx Designer (ODBC)
Build workflows to access live MailerLite data for self-service data analytics.
-
Extract, Transform, and Load Kintone Data in Informatica PowerCenter
Create a simple Workflow for Kintone data in Informatica PowerCenter.
-
Getting Started with the CData Excel Add-In for BigQuery
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for BigQuery.
-
Connect to Suadeo Data from AWS Glue
Use CData Connect AI to gain access to live Suadeo data from your AWS Glue jobs.
-
Automated Continuous Yelp Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Yelp replication to Apache Kafka.
-
Use the CData ODBC Driver for Snowflake from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Snowflake to connect to Snowflake data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Snowflake data in Excel.
-
Automated Continuous Cohere Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Cohere replication to AlloyDB.
-
How to connect Amazon QuickSight to Monday.com Data
Create a connection to Monday.com data in CData Connect AI and insert Monday.com data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Klaviyo Replication to Vertica
Use CData Sync for automated, continuous, customizable Klaviyo replication to Vertica.
-
Automated Continuous ElevenLabs Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ElevenLabs replication to delimited files (CSV/TSV).
-
Integrate with Live Greenhouse Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Greenhouse from the MuleSoft Anypoint Platform to integrate live Greenhouse data into custom reports and dashboards.
-
Create Informatica Mappings From/To an ODBC Data Source for SurveyMonkey
Create an ODBC connection to SurveyMonkey in Informatica and browse and transfer SurveyMonkey data.
-
Create Jira Assets-Connected Business Apps in AppSheet
Connect to Jira Assets Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Jira Assets data.
-
Create Moosend-Connected Dashboards in Grafana
Connect to Moosend Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Moosend data.
-
Connecting Agentforce with Yelp 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 Yelp data for you.
-
Automated Continuous iContact Replication to SingleStore
Use CData Sync for automated, continuous, customizable iContact replication to SingleStore.
-
Automated Continuous JSON Replication to Snowflake
Use CData Sync for automated, continuous, customizable JSON replication to Snowflake.
-
Visualize ElevenLabs Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ElevenLabs data into TIBCO Spotfire.
-
Build Data Flows from Vercel to SQL Server using SSIS
Easily back up Vercel data to SQL Server using the SSIS components for Vercel.