CData Software - Knowledge Base
Recent Articles
-
Feed Amplitude Data into FineReport
How to set Amplitude as a JDBC data source in FineReport.
-
How to Query Wrike Data in MySQL Workbench
Execute MySQL queries against live Wrike from MySQL Workbench.
-
Write a Simple Go Application to work with Kintone Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Kintone.
-
Automated Continuous API Replication to Oracle
Use CData Sync for automated, continuous, customizable API replication to Oracle.
-
Connect to Microsoft Dataverse from Asprova with CData Software ODBC Driver for Microsoft Dataverse
This article shows how to connect faster to Microsoft Dataverse data from Asprova.
-
Getting Started with the CData Excel Add-In for MailerLite
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MailerLite.
-
DataBind Parquet Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Parquet with the DevExpress Windows Forms and Web controls to provide Apache Parquet to a chart.
-
Build Sybase-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Sybase to explore live Sybase Data in Claude Code to assist with building Sybase-powered applications.
-
Bind Live Google Spanner Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Spanner data
-
Connect to RabbitMQ Data from PowerBuilder via ADO.NET
This article demonstrates how to access RabbitMQ from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Grafana Data in JRuby
Create a simple JRuby app with access to live Grafana.
-
Connect to QuickBooks Online Data from AWS Glue
Use CData Connect AI to gain access to live QuickBooks Online from your AWS Glue jobs.
-
Connect to Gmail Data from PowerBuilder via ADO.NET
This article demonstrates how to access Gmail from Appeon PowerBuilder using the CData ADO.NET Provider for Gmail.
-
Access Email Data from MySQL in Amazon QuickSight
Connect to Email and build visualizations of Email using a MySQL Connection in Amazon QuickSight.
-
Connect and Query Live Vertica Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Vertica into Databricks
-
Integrating LlamaIndex with Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Zoom in real time.
-
Automated Continuous Dynamics NAV Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to delimited files (CSV/TSV).
-
Visualize SQL Analysis Services 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 SQL Analysis Services into TIBCO Spotfire.
-
Connect to Real-Time MySQL Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for MySQL and Dataflow to import and use MySQL in Power Apps.
-
How to publish and share NASA Data dashboards with Tableau Server
The CData ODBC driver for NASA enables you integrate NASA into Tableau dashboards.
-
Create SSAS Tabular Models from Google Cloud Storage Data
How to build a SQL Server Analysis Service Tabular Model from Google Cloud Storage using CData drivers.
-
Connect to Zuora Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zuora as an External Source in Dremio.
-
How to Query GitHub Data in MySQL Workbench
Execute MySQL queries against live GitHub from MySQL Workbench.
-
Migrating data from Codat to Google BigQuery using CData SSIS Components.
Easily push Codat to Google BigQuery using the CData SSIS Tasks for Codat and Google BigQuery.
-
Query Paylocity Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Paylocity and perform CRUD operations on Paylocity from Node.js.
-
How to connect to Missive Data with Squirrel SQL client
Connect to Missive and execute queries in the Squirrel SQL Client.
-
Integrating LlamaIndex with SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP Ariba Source in real time.
-
Import Cvent Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Cvent. In this article, you will use the OData format to import Cvent into Microsoft Power Query.
-
Analyze Oracle Eloqua Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Oracle Eloqua and visualize Oracle Eloqua in SAP Analytics Cloud.
-
Creating Sage Intacct-Connected Applications in Unqork
You can use CData Connect AI to feed Sage Intacct to Unqork and build custom business apps.
-
Extract, Transform, and Load SAP Ariba Procurement Data in Informatica PowerCenter
Create a simple Workflow for SAP Ariba Procurement in Informatica PowerCenter.
-
Use JayDeBeApi to access Redshift Data in Python
Use standard Python scripting and the development environment of your choice to access live Amazon Redshift.
-
Query Splunk Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Splunk from Node.js.
-
View Reports on Real-Time Access Data in Power BI Report Server
Use the CData ODBC Driver for Access to visualize Microsoft Access in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Mixpanel Data from a Connection Pool in Jetty
The Mixpanel JDBC Driver supports connection pooling: This article shows how to connect faster to Mixpanel from Web apps in Jetty.
-
Automated Continuous Salesforce CRM Analytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to IBM DB2.
-
Access Live Google Ad Manager Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Ad Manager from your Excel spreadsheets.
-
Load Slack Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Slack to a database.
-
Bridge Xero Connectivity with Apache NiFi
Access and process Xero Accounting in Apache NiFi using the CData JDBC Driver.
-
How to Access Live SAP Business One Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Business One enables you to integrate SAP Business One into workflows built using Microsoft Power Automate Desktop.
-
Prepare, Blend, and Analyze Pushbullet Data in Alteryx Designer (ODBC)
Build workflows to access live Pushbullet for self-service data analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Mistral AI
Provide connectivity to Mistral AI through an SAP BusinessObjects universe.
-
Consume JSON OData Feeds in SAP Lumira
Use the API Server to create data visualizations on JSON feeds that reflect any changes in SAP Lumira.
-
How to create an RPA flow for Salesloft Data in UiPath Studio
Use the Salesloft ODBC Driver to create workflows that access real-time Salesloft without any coding.
-
Automated Continuous Cosmos DB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Amazon S3.
-
Build AI Agents with Twitter Ads Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Twitter Ads through CData Connect AI.
-
Access Live Dynamics 365 Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Dynamics 365 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Analyze Microsoft Entra ID Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Entra ID and visualize live Microsoft Entra ID in Infragistics Reveal.
-
Connect to DocuSign Data in DBeaver
Use the CData ODBC Driver to connect to DocuSign in DBeaver.
-
Build Visualizations of Procore Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Procore in Birst.
-
Replicate Supabase Data from PowerShell
Write a quick PowerShell script to query Supabase. Use connectivity to the live data to replicate Supabase to SQL Server.
-
Create Power BI Reports on Real-Time PabblySubscriptions Data
Use the CData ODBC Driver for PabblySubscriptions to visualize PabblySubscriptions in Power BI Desktop.
-
Getting Started with the CData ODBC Driver for Bugsnag
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Bugsnag.
-
Publish Klipfolio-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Klipfolio.
-
Publish Crystal Reports on REST Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date REST.
-
Create Power BI Reports on Real-Time Figshare Data
Use the CData ODBC Driver for Figshare to visualize Figshare in Power BI Desktop.
-
Gong Reporting in OBIEE with the Gong JDBC Driver
Deploy the Gong JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize OneNote Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft OneNote.
-
Integrate Live SingleStore Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SingleStore to Blue Prism using the CData ODBC Driver for SingleStore to create automated workflows for repetitive business tasks.
-
Analyze Clockify Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Clockify from Power Pivot. You will use the Table Import Wizard to load Clockify. You can visually build the import query or use any SQL supported by the driver.
-
Connect Auth0 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Auth0 using the CData Python MCP Server.
-
Choosing the Best Method to Connect HubSpot to SQL Server: 5 Options Explained
Discover multiple ways to connect and use HubSpot from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating LangGraph with Pipedrive Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Pipedrive within automated workflows.
-
Build Apps with Live Browserless Data Using the Low-Code Development Platform of Mendix
Connect Browserless with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Productboard Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Productboard using standard SQL.
-
Visualize Outlook 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 Outlook into TIBCO Spotfire.
-
Connect to and Visualize Live Zoom Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoom.
-
How to Connect SendGrid Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SendGrid data in real time using natural language.
-
How to Visualize Anaplan Data in Python with pandas
Use pandas and other modules to analyze and visualize live Anaplan in Python.
-
Integrate Live Greenplum Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Pivotal GreenPlum and integrate live Pivotal GreenPlum into apps built in Microsoft Power Apps.
-
How to Connect to Live Zoho Books 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 Zoho Books for you.
-
Connect to Jira Assets Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Jira Assets in Airbyte.
-
How to Build an ETL App for Mode Data in Python with CData
Create ETL applications and real-time data pipelines for Mode in Python with petl.
-
Automated Continuous Box Replication to SingleStore
Use CData Sync for automated, continuous, customizable Box replication to SingleStore.
-
Use Microsoft Copilot Studio to talk to your QuickBooks Time 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 QuickBooks Time for you.
-
Automated Continuous SAP Ariba Procurement Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Amazon Redshift.
-
Build MarkLogic Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MarkLogic and build visualizations in Tableau.
-
Build Apps with Live Certinia Data Using the Low-Code Development Platform of Mendix
Connect Certinia with Mendix to build apps using the CData JDBC Driver for Certinia.
-
Automate SAP Data Replication to SAP HANA
Use CData Sync to customize and automate SAP ERP/NetWeaver replication to SAP HANA.
-
LINQ to QuickBooks Time 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 QuickBooks Time Data Provider.
-
How to Build an ETL App for Xero Data in Python with CData Connect AI
Build ETL pipelines that read and write live Xero Accounting in Python with petl and the CData Connect AI Python SDK.
-
How to Access Live Greenplum Data in Visual Studio Code via Cline
Run CData MCP Server for Greenplum on Windows Subsytem for Linux (WSL) and connect to live Pivotal GreenPlum from the Cline extension in Visual Studio Code.
-
Use the CData Software ODBC Driver for Power BI XMLA in MicroStrategy Desktop
Connect to Power BI XMLA in MicroStrategy Desktop using the CData Software ODBC Driver for Power BI XMLA.
-
DataBind Controls to Cvent Data in Delphi
DataBind to Cvent in Delphi with standard data access components and controls.
-
Integrate Live Cvent Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Cvent to Blue Prism using the CData ODBC Driver for Cvent to create automated workflows for repetitive business tasks.
-
Create Informatica Mappings From/To a JDBC Data Source for ClickUp
Create ClickUp data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData ADO.NET Provider for VWO
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
A PostgreSQL Interface for Zendesk Data using the CData ODBC Driver
Use the SQL Gateway and Zendesk ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for SAP Ariba Procurement in MicroStrategy
Connect to SAP Ariba Procurement in MicroStrategy Developer using the CData Software ODBC Driver for SAP Ariba Procurement.
-
Choosing the Best Method to Connect Front to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Front from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous ConstantContact Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ConstantContact replication to OneLake in Microsoft Fabric.
-
Integrating Kiro CLI with Kafka 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.
-
Import Real-Time Sage Cloud Accounting Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sage Business Cloud Accounting in ColdFusion.
-
How to connect to Testmonitor Data from Spring Boot
Connect to Testmonitor in a Spring Boot Application using the CData API Driver for JDBC
-
Replicate Multiple Excel Accounts via the CData Sync CLI
Replicate multiple Excel accounts to one or many databases.
-
Connect and Query Live Google Contacts Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Contacts into Databricks
-
Create Reports with AgileCRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date AgileCRM.
-
Connect to PingOne Data from PowerBuilder via JDBC
This article demonstrates how to access PingOne from PowerBuilder using the PingOne JDBC Driver.
-
How to Query Live Perigon Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Perigon data in natural language using Python.
-
Build Visualizations of PingOne Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PingOne in Birst.