CData Software - Knowledge Base
Recent Articles
-
Visualize Discord 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 Discord data into TIBCO Spotfire.
-
Build a Singer.io Tap for Deel With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Deel data using the CData Python Connector.
-
Build Apps with Live Apify Data Using the Low-Code Development Platform of Mendix
Connect Apify data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Optimizely Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Optimizely replication to Amazon Redshift.
-
Automate Chargebee Data Replication to Azure Synapse
Use CData Sync to customize and automate Chargebee data replication to Azure Synapse.
-
Analyze Google Cloud Storage Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Cloud Storage data with the CData JDBC Driver for Google Cloud Storage.
-
Automated Continuous ServiceDesk Plus Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to Google Cloud SQL.
-
Build Visualizations of Guru Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Guru data in Birst.
-
Connect to Keap Data from PowerBuilder via JDBC
This article demonstrates how to access Keap data from PowerBuilder using the Keap JDBC Driver.
-
How to Connect to Live Zendesk 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 Zendesk data for you.
-
Perform Batch Operations with Dynamics 365 Business Central Data in Apache NiFi
Connect to Dynamics 365 Business Central data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Replicate MySQL Data from PowerShell
Write a quick PowerShell script to query MySQL data. Use connectivity to the live data to replicate MySQL data to SQL Server.
-
Automated Continuous QuickBooks Time Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Amazon Redshift.
-
Create Snowflake-Connected Business Apps in AppSheet
Connect to Snowflake Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Snowflake data.
-
Integrating Cursor with Outlook 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.
-
Connect to GraphQL Data in NetBeans
Connect to GraphQL data in NetBeans with the data source configuration wizard.
-
Import Real-Time FHIR Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use FHIR data in ColdFusion.
-
Build Snapchat Ads Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Snapchat Ads data and build visualizations in Tableau.
-
Automated Continuous Typeform Replication to MongoDB
Use CData Sync for automated, continuous, customizable Typeform replication to MongoDB.
-
Analyze Live IBM Cloud Object Storage Data in SAS Viya
Use CData Connect AI to connect to IBM Cloud Object Storage data from SAS Viya and deploy self-service analytics using live IBM Cloud Object Storage data.
-
Natively Connect to Adobe Experience Manager Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Adobe Experience Manager data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Zoom Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoom replication to SQL Server.
-
How to Connect the Power BI Service to Reckon: Complete Guide
Connect to the CData Software Power BI Connector for Reckon from PowerBI.com to provide real-time Reckon data across the organization.
-
How to connect PolyBase to HDFS
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HDFS data.
-
How to Query QuickBooks Time Data in MySQL Workbench
Execute MySQL queries against live QuickBooks Time data from MySQL Workbench.
-
Use Grok to Talk to Your Hive 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 Hive data for you.
-
How to Seamlessly Import Impala Data into IBM SPSS Modeler
Integrate Impala data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Seamlessly Import Campaigner Data into IBM SPSS Modeler
Integrate Campaigner data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Factorial 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 Factorial data.
-
Getting Started with the CData SSIS Components for Bitly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bitly.
-
Create Power BI Reports on Real-Time Confluence Data
Use the CData ODBC Driver for Confluence to visualize Confluence data in Power BI Desktop.
-
Use the CData Software ODBC Driver for Brex in MicroStrategy Web
Connect to Brex data in MicroStrategy Web using the CData Software ODBC Driver for Brex.
-
How to Build an ETL App for SurveyMonkey Data in Python with CData Connect AI
Extract and transform live SurveyMonkey data in Python with petl and the CData Connect AI Python SDK.
-
How to publish and share Amazon S3 Data dashboards with Tableau Server
The CData ODBC driver for Amazon S3 enables you integrate Amazon S3 data into Tableau dashboards.
-
Connect to Google Contacts Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Contacts and the Script function in FileMaker Pro to connect to Google Contacts and work with Google Contacts data in your FileMaker application.
-
Create Apify-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Apify Data from OutSystems and build custom enterprise apps using live Apify data.
-
Publish Reports with Oracle Financials Cloud Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Financials Cloud data.
-
Integrate Devin with Live IBM Informix 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 IBM Informix data.
-
Connect to Bannerbear from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Bannerbear data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Stream Printful Data into Apache Kafka Topics
Access and stream Printful data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to ClickUp Data with Squirrel SQL client
Connect to ClickUp data and execute queries in the Squirrel SQL Client.
-
Feed Epicor Kinetic Data into FineReport
How to set Epicor Kinetic data as a JDBC data source in FineReport.
-
Build Access-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Access data and build web apps with connectivity to live Access data.
-
Build SurveyMonkey Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SurveyMonkey data and build visualizations in Tableau Cloud.
-
Automated Continuous Excel Online Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Excel Online replication to Amazon S3.
-
DataBind Keap Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Keap data to a chart.
-
Replicate ConvertKit Data to Multiple Databases
Replicate ConvertKit data to disparate databases with a point-and-click configuration.
-
How to Query Live Microsoft Entra ID Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Entra ID data data in natural language using Python.
-
Access Live Amazon DynamoDB Data in AWS Lambda
Connect to live Amazon DynamoDB data in AWS Lambda using the CData JDBC Driver.
-
How to Build an ETL App for Gmail Data in Python with CData
Create ETL applications and real-time data pipelines for Gmail data in Python with petl.
-
Use the CData ODBC Driver for Salesforce Marketing in Microsoft Power Query
You can use the CData Salesforce Marketing ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Salesforce Marketing data into Microsoft Power Query.
-
Integrating LlamaIndex with GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on GitLab data in real time.
-
Integrate Live Twitter Ads Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Twitter Ads data to Blue Prism using the CData ODBC Driver for Twitter Ads to create automated workflows for repetitive business tasks.
-
How to Connect to Live Mailgun 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 Mailgun data for you.
-
Create Reports from Cvent Data in Looker Studio
Use CData Connect AI to gain access to live Cvent data and create custom reports in Looker Studio.
-
Analyze Salesforce Marketing Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesforce Marketing from Power Pivot. You will use the Table Import Wizard to load Salesforce Marketing data. You can visually build the import query or use any SQL supported by the driver.
-
Access PabblySubscriptions Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PabblySubscriptions data from HeidiSQL.
-
Replicate BigQuery Data from PowerShell
Write a quick PowerShell script to query BigQuery data. Use connectivity to the live data to replicate BigQuery data to SQL Server.
-
Build Data Flows from SQL Server to QuickBooks Online through SSIS
Easily push SQL Server data to QuickBooks Online using the CData SSIS Tasks for QuickBooks Online.
-
Connect to Dynamics 365 Business Central Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Dynamics 365 Business Central as an External Source in Dremio.
-
Easily Integrate Zoho Books Data in Lazarus Pascal IDE
Learn how to easily integrate live Zoho Books data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Azure Synapse Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Azure Synapse data from Filemaker Pro on Mac.
-
Viewing Perigon Data in RAD Studio Data Explorer
How to view Perigon data in RAD Studio Data Explorer using the CData ODBC Driver for Perigon.
-
Automated Continuous CouchDB Replication to MySQL
Use CData Sync for automated, continuous, customizable CouchDB replication to MySQL.
-
Use the CData ODBC Driver for Dynamics 365 Business Central in Microsoft Power Query
You can use the CData Dynamics 365 Business Central ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Dynamics 365 Business Central data into Microsoft Power Query.
-
Create Highrise-Connected Applications in Appsmith
Connect to Highrise Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Highrise data.
-
Bind Live Smartsheet Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Smartsheet data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Access Live Guru Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Guru data from your Excel spreadsheets.
-
Getting Started with the CData Tableau Connector for Cohere
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Avaza from Asprova with CData Software ODBC Driver for Avaza
This article shows how to connect faster to Avaza data from Asprova.
-
Access Live Apify Data in AWS Lambda
Connect to live Apify data in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData JDBC Driver for ZarMoney
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZarMoney.
-
Connect to Zoho Inventory Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zoho Inventory Data and connect to Zoho Inventory data in Akorbi Digital RunMyProcess.
-
How to Query Hacker News Data in MySQL Workbench
Execute MySQL queries against live Hacker News data from MySQL Workbench.
-
Connect to PDFMonkey Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PDFMonkey data.
-
Build Agents in Relevance AI with Access to Live Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Salesforce Pardot data within intelligent agent workflows.
-
Use the CData ODBC Driver for SpaceX in Microsoft Power Query
You can use the CData SpaceX ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SpaceX data into Microsoft Power Query.
-
Automated Continuous Placid Replication to Oracle
Use CData Sync for automated, continuous, customizable Placid replication to Oracle.
-
Automated Continuous Nuclia Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Nuclia replication to delimited files (CSV/TSV).
-
DataBind Paddle Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Paddle data to a chart.
-
Query AfterShip Data as a MySQL Database in Node.js
Execute MySQL queries against AfterShip data from Node.js.
-
Use Dash to Build Web Apps on Guru Data via CData Connect AI
Build interactive Dash web apps on live Guru data using pandas and the CData Connect AI Python SDK.
-
Connect to ADP from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ADP data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Query Onfleet Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Onfleet data from Node.js.
-
Replicate Short.io Data from PowerShell
Write a quick PowerShell script to query Short.io data. Use connectivity to the live data to replicate Short.io data to SQL Server.
-
Connect to Landbot Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Landbot and work with Landbot data in your FileMaker application.
-
Natively Connect to EmailOctopus Data in PHP
The CData ODBC driver for EmailOctopus enables you to create PHP applications with connectivity to EmailOctopus data. Leverage the native support for ODBC in PHP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ZohoDesk
Provide connectivity to ZohoDesk data through an SAP BusinessObjects universe.
-
A PostgreSQL Interface for Bugsnag Data using the CData ODBC Driver
Use the SQL Gateway and Bugsnag ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Real-Time Access to IBM Informix in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to IBM Informix data in real time.
-
Connect to Onfleet Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Onfleet as an External Source in Dremio.
-
Getting Started with the CData Connect AI Python SDK for Aweber
Install the CData Connect AI Python SDK to read live Aweber data with standard DB-API 2.0 Python code.
-
Build Pipelines with Live BigQuery Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to BigQuery from Google Cloud Data Fusion, enabling the integration of live BigQuery data into the building and management of effective data pipelines.
-
Close Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Close facts in real time.
-
Integrate Cursor with Live IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live IBM Cloud Object Storage data from within the editor.
-
Connect to Moosend Data from PowerBuilder via ADO.NET
This article demonstrates how to access Moosend data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to import SharePoint Data into Apache Solr
Use the CData Software JDBC Driver for SharePoint in Data Import Handler and create an automated import of SharePoint data to Apache Solr Enterprise Search platform.
-
Integrate OpenCode with Live Jumpseller Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Jumpseller data from within your AI coding agent.
-
Integrate Splunk with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Splunk with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Splunk data.
-
DataBind Charts to MarkLogic Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MarkLogic data 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.