CData Software - Knowledge Base
Recent Articles
-
Connect to Bannerbear Data in Jaspersoft Studio
Execute SQL to remote Bannerbear data in Jaspersoft Studio.
-
Analyze ConvertAPI Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ConvertAPI data in Microsoft R Open.
-
Automated Continuous Teamgate Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Teamgate replication to Azure SQL Database.
-
Enable the ZohoPeople JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZohoPeople data.
-
Use Dash to Build Web Apps on OneNote Data via CData Connect AI
Build interactive Dash web apps on live OneNote data using pandas and the CData Connect AI Python SDK.
-
Create Dynamic Hive Grids Using the Infragistics XamDataGrid
Learn how you can connect Hive to Infragistics XamDataGrid to build dynamic grids.
-
Connect to GetResponse from Asprova with CData Software ODBC Driver for GetResponse
This article shows how to connect faster to GetResponse data from Asprova.
-
Build Avro-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Avro data without replication.
-
Use the CData Software JDBC Driver for ZarMoney in MicroStrategy Web
Connect to ZarMoney data in MicroStrategy Web using the CData Software JDBC Driver for ZarMoney.
-
Visualize QuickBooks Time 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 QuickBooks Time data into TIBCO Spotfire.
-
Build Data Flows from Attio to SQL Server using SSIS
Easily back up Attio data to SQL Server using the SSIS components for Attio.
-
Build Apps with Live Discord Data Using the Low-Code Development Platform of Mendix
Connect Discord data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Amplitude Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Amplitude replication to Amazon Redshift.
-
Replicate Google Search Results to Multiple Databases
Replicate Google Search results to disparate databases with a point-and-click configuration.
-
Create Microsoft Entra ID Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft Entra ID from PowerBI.com to create Power BI Dataflows with real-time data.
-
A PostgreSQL Interface for Excel Online Data (MySQL Remoting via JDBC)
Use the Remoting features of the Excel Online JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Oracle HCM Cloud Data in HULFT Integrate
Connect to Oracle HCM Cloud as a JDBC data source in HULFT Integrate
-
Connect and Query Live Campaigner Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Campaigner data into Databricks and enable direct, live querying and analysis without replication.
-
Migrating data from Testmonitor to Google BigQuery using CData SSIS Components.
Easily push Testmonitor data to Google BigQuery using the CData SSIS Tasks for Testmonitor and Google BigQuery.
-
Automate Timely Data Replication to Couchbase
Use CData Sync to Customize and automate Timely data replication to Couchbase.
-
Natively Connect to AgileCRM Data in PHP
The CData ODBC driver for AgileCRM enables you to create PHP applications with connectivity to AgileCRM data. Leverage the native support for ODBC in PHP.
-
Create LeadDesk Dataflows on PowerBI.com
Connect to the CData Power BI Connector for LeadDesk from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect to Foursquare Data from IntelliJ
Integrate connectivity to Foursquare data with wizards in IntelliJ.
-
Integrate with SAP Concur Data in JReport Designer
Create charts and reports based on SAP Concur data in JReport Designer.
-
Connect FHIR to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live FHIR data using the CData Python MCP Server.
-
Use Dash to Build Web Apps on SAP Hybris C4C Data via CData Connect AI
Build interactive Dash web apps on live SAP Hybris C4C data using pandas and the CData Connect AI Python SDK.
-
Build Automated Workflows with Live SAP Netweaver Gateway Data in Workato
Use CData Connect AI to connect to live SAP Netweaver Gateway data and build automated workflows in Workato.
-
Connect to MYOB AccountRight from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from MYOB AccountRight data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData ODBC Driver for Exa
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Exa.
-
Validate Landbot Data with QuerySurge
Access and validate Landbot data in QuerySurge using the CData JDBC Driver.
-
Query ADP Data as a MySQL Database in Node.js
Execute MySQL queries against ADP data from Node.js.
-
Integrating Claude Code CLI with Airtable 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.
-
Build AI/ML Models with Live OneNote Data using Dataiku
Connect OneNote Data with Dataiku using the CData JDBC Driver for OneNote.
-
Natively Connect to Auth0 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Auth0 data. Leverage the native support for ODBC in PHP.
-
Automate SageHR Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SageHR data from PowerShell? This article demonstrates how to utilize the SageHR Cmdlets for tasks like connecting to SageHR data, automating operations, downloading data, and more.
-
Connect to Notion Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Notion data.
-
Viewing ZohoMarketingHub Data in RAD Studio Data Explorer
How to view ZohoMarketingHub data in RAD Studio Data Explorer using the CData ODBC Driver for ZohoMarketingHub.
-
Automated Continuous Webflow Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Webflow replication to Amazon S3.
-
How to Connect to Live Salesloft 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 Salesloft data for you.
-
Excel Spreadsheet Automation on Figshare Data with the QUERY Formula
Pull data from Figshare, automate spreadsheets, and more with the QUERY formula.
-
How to connect to CSV Data with Squirrel SQL client
Connect to CSV data and execute queries in the Squirrel SQL Client.
-
Connect to Amazon DynamoDB Data from HeidiSQL
Use CData Connect AI to connect to and query live Amazon DynamoDB data from HeidiSQL.
-
How to Connect to Live Google Search Results 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 Google Search results for you.
-
Use the CData Software JDBC Driver for Sentry in MicroStrategy Desktop
Connect to Sentry data in MicroStrategy Desktop using the CData Software JDBC Driver for Sentry.
-
Prepare, Blend, and Analyze Box Data in Alteryx Designer (ODBC)
Build workflows to access live Box data for self-service data analytics.
-
Replicate Multiple Hugging Face Accounts via the CData Sync CLI
Replicate multiple Hugging Face accounts to one or many databases.
-
Automated Continuous Accelo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Accelo replication to IBM DB2.
-
Getting Started with the CData Python Connector for Notion
Learn to install and license the CData Python Connector and configure a connection to live Notion data.
-
Natively Connect to Browserless Data in PHP
The CData ODBC driver for Browserless enables you to create PHP applications with connectivity to Browserless data. Leverage the native support for ODBC in PHP.
-
How to connect PolyBase to Outlook
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Outlook data.
-
Add ZohoPeople Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZohoPeople with the Informatica Enterprise Data Catalog to classify and organize data.
-
Stream JotForm Data into Apache Kafka Topics
Access and stream JotForm data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to create an RPA flow for Freshservice Data in UiPath Studio
Use the Freshservice ODBC Driver to create workflows that access real-time Freshservice data without any coding.
-
How to Connect to Live SQL Server 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 SQL Server data for you.
-
Connect to Jodoo Data in RazorSQL
Connect to Jodoo from wizards and query Jodoo data from the GUI in the RazorSQL database management tool.
-
Replicate Zoom Data to Multiple Databases
Replicate Zoom data to disparate databases with a point-and-click configuration.
-
Build MVC Applications with Connectivity to OnePageCrm Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access OnePageCrm from an ASP.NET MVC application.
-
How to connect and process Microsoft Entra ID data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Entra ID data.
-
How to create an RPA flow for WooCommerce Data in UiPath Studio
Use the WooCommerce ODBC Driver to create workflows that access real-time WooCommerce data without any coding.
-
Integrating GitHub Copilot with GetResponse 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 Data Visualizations in Cognos BI with Dynamics 365 Business Central Data
Access Dynamics 365 Business Central data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Back Up Anaplan data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Anaplan. In this article, we will employ an SSIS workflow to populate a database with Anaplan data data.
-
Integrate Google's Vertex AI Agent with Live XML 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 XML data within intelligent workflows.
-
Build Dashboards with SAP ByDesign Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP ByDesign data in DBxtra.
-
Integrating LlamaIndex with PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on PayPal data in real time.
-
Connect to Asana Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Asana data in the Denodo Virtual DataPort Administrator.
-
Stream Amplitude Data into Apache Kafka Topics
Access and stream Amplitude data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Figshare Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Figshare facts in real time.
-
How to Connect to Live SAP Hybris C4C Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Hybris C4C data securely in real time.
-
Load Reckon Accounts Hosted Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Reckon Accounts Hosted data to a database.
-
Build Automated Workflows with Live Adobe Commerce Data in Workato
Use CData Connect AI to connect to live Adobe Commerce data and build automated workflows in Workato.
-
Integrate Dify with Live Apollo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Apollo data.
-
Access Live Anaplan Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Anaplan data through MCP integration.
-
How to Connect to Live SAP Business One 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 SAP Business One data for you.
-
Use CData Connect AI to Access Printify Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Printify data in the Power Pivot business intelligence tool.
-
How to Connect to Live QuickBooks Online Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live QuickBooks Online data without replication.
-
How to publish and share Campaigner Data dashboards with Tableau Server
The CData ODBC driver for Campaigner enables you integrate Campaigner data into Tableau dashboards.
-
Manage Sybase Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sybase.
-
Build a Singer.io Tap for Superchat With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Superchat data using the CData Python Connector.
-
Build Semantic Layer Views for Float Data in APOS Live Data Gateway
Use the CData Connector for Float in APOS Live Data Gateway to build Semantic Layer Views for Float data.
-
Connect to and Visualize Live CircleCI Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live CircleCI data.
-
Integrating LangChain with Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zuora data within automated workflows.
-
Automated Continuous Telegram Replication to SQLite
Use CData Sync for automated, continuous, customizable Telegram replication to SQLite.
-
Query Live Amazon S3 Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Amazon S3 data directly from the development environment.
-
How to connect PolyBase to ShipEngine
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ShipEngine data.
-
Connect to SAP Fieldglass Data in DBArtisan
Use wizards in DBArtisan to configure SAP Fieldglass data as a data source.
-
Query Access Data in ColdFusion
Write standard ColdFusion data access code to connect to Access data.
-
Integrating LlamaIndex with Pinterest Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Pinterest data in real time.
-
Integrating Antigravity CLI with Pingdom data via CData CLI
Connect Pingdom data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Power BI Connector for Pinterest
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Pinterest.
-
Getting Started with the CData Tableau Connector for Aircall
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Design BIRT Reports on Vercel Data
Provide current Vercel data to your embedded analytics.
-
Create Oracle Financials Cloud-Connected Business Apps in AppSheet
Connect to Oracle Financials Cloud Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle Financials Cloud data.
-
Publish Reports with WordPress Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date WordPress data.
-
Access Live Procore Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Procore data from your Excel spreadsheets.
-
Connect to Microsoft Ads from Asprova with CData Software ODBC Driver for Microsoft Ads
This article shows how to connect faster to Microsoft Ads data from Asprova.
-
Build Apps with Live Paylocity data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Paylocity data into the Adalo platform and build custom mobile and web applications with real-time Paylocity data.
-
Use the CData Software JDBC Driver for SAS Data Sets in MicroStrategy
Connect to SAS Data Sets data in MicroStrategy Developer using the CData Software JDBC Driver for SAS Data Sets.
-
Consume Okta OData Feeds in PowerBuilder
This article demonstrates how to consume Okta data as OData feeds from PowerBuilder using the API Server.
-
BigCommerce Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on BigCommerce facts in real time.