CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Google Analytics Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Analytics data in ColdFusion.
-
Import Real-Time Strava Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Strava data in ColdFusion.
-
Connect to Dynamics NAV in SpagoBI
Create reports featuring live Dynamics NAV data in SpagoBI Studio. Host Dynamics NAV reports on SpagoBI Server.
-
Access Live Invoiced Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Invoiced data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Live Avro Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Avro data.
-
Visualize QuickBooks Data in Tableau
The CData ODBC driver for QuickBooks enables you integrate QuickBooks data into Tableau dashboards.
-
Create xBase-Connected Dashboards in Grafana
Connect to xBase Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to xBase data.
-
Visualize Live Jira Assets Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Jira Assets data into custom reports in Power BI.
-
Automated Continuous Aweber Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Aweber replication to Google BigQuery.
-
DataBind Controls to ZarMoney Data in C++Builder
DataBind to ZarMoney data in C++Builder with standard components and controls.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for AlloyDB
Provide connectivity to AlloyDB data through an SAP BusinessObjects universe.
-
Connect to FormSite 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 FormSite and work with FormSite data in your FileMaker application.
-
Integrate Open WebUI with Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Oracle Service Cloud data from within the chat interface.
-
Connect Zoho Inventory Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho Inventory data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Enable the Simplesat JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Simplesat data.
-
Visualize Aircall Data in Sisense
Create an ElastiCube in Sisense app with access to Aircall data.
-
Connect to Oracle Eloqua Reporting Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Eloqua Reporting and the Script function in FileMaker Pro to connect to Oracle Eloqua Reporting and work with Oracle Eloqua Reporting data in your FileMaker application.
-
Create Dashboards and Visualize Live Adobe Experience Manager Data in Geckoboard
Use CData Connect AI to connect to live Adobe Experience Manager data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Adobe Commerce Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Apache Kafka.
-
Build Dashboards with Google Directory Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Directory data in Dundas BI.
-
Create LinkedIn-Connected Dashboards in Grafana
Connect to LinkedIn Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to LinkedIn data.
-
Build Dashboards with Parallel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Parallel data in Dundas BI.
-
How to Connect to Live Perplexity 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 Perplexity data without replication.
-
Working with Harvest Data in LINQPad
Execute LINQ queries to Harvest data in LINQPad.
-
Connect to Clio Data from a Connection Pool in JBoss
Integrate Clio data into Java servlets: Use the Management Console in JBoss to install the Clio JDBC Driver.
-
Automated Continuous REST Replication to AlloyDB
Use CData Sync for automated, continuous, customizable REST replication to AlloyDB.
-
Automated Continuous QuickBooks Online Replication to Vertica
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Vertica.
-
Connect to and Visualize Live Nethunt Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Nethunt data.
-
Query Close Data in ColdFusion
Write standard ColdFusion data access code to connect to Close data.
-
Connect to Printify Data in Jaspersoft Studio
Execute SQL to remote Printify data in Jaspersoft Studio.
-
Automated Continuous Microsoft Teams Replication to MySQL
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to MySQL.
-
Visualize Live Coda Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Coda data into custom reports in Power BI.
-
How to Connect to Zoho Inventory Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoho Inventory data. Leverage the pyodbc module for ODBC in Python.
-
Connecting Moonlit Workflow with MailChimp 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 MailChimp data in real time.
-
How to Connect ZohoMarketingHub 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 ZohoMarketingHub data in real time using natural language.
-
Access Live SAP Ariba Procurement Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP Ariba Procurement data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Write a Simple Go Application to work with BenchmarkEmail Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to BenchmarkEmail data.
-
Use the CData Software ODBC Driver for Insightly in MicroStrategy Web
Connect to Insightly data in MicroStrategy Web using the CData Software ODBC Driver for Insightly.
-
Connecting Mastra with Neo4J Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Neo4J data, no replication required.
-
Build Azure Analysis Services-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Azure Analysis Services data.
-
Integrating Kiro with Pipeliner CRM 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 a Singer.io Tap for QuickBooks Online With the CData Python Connector
Learn how to easily build a Singer.io Tap for live QuickBooks Online data using the CData Python Connector.
-
Building Dynamic Web Pages with Cosmos DB Data Using AngularJS
Create single-page applications with live connectivity to Cosmos DB using the CData API Server.
-
Integrating Boomi Agentstudio with Adobe Target Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Adobe Target data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to create Mistral AI federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Mistral AI data in MySQL .
-
How to Connect to Elorus Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Elorus data. Leverage the pyodbc module for ODBC in Python.
-
ETL Pipeline CRM in Oracle Data Integrator
This article shows how to transfer Pipeline CRM data into a data warehouse using Oracle Data Integrator.
-
Moving Data from BambooHR to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live BambooHR data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to ZohoDesk Data in DBArtisan
Use wizards in DBArtisan to configure ZohoDesk data as a data source.
-
How to connect to ElevenLabs Data in DBVisualizer
Integrate ElevenLabs data with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish Crystal Reports on Short.io Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Short.io data.
-
Integrating Codex with CircleCI 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 Create Power BI Visual Reports with Real-Time Google Sheets Data
Use CData Power BI Connectors to visualize Google Sheets data in Power BI.
-
Use the CData ODBC Driver for WordPress in Microsoft Power Query
You can use the CData WordPress ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import WordPress data into Microsoft Power Query.
-
Provide OData Services of Google Ads Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Ads data by developing a WCF Service Application.
-
Access Live LightSpeedRetail Data in Coginiti Pro
Connect to and query live LightSpeedRetail data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect DBeaver to Exact Online via a JDBC Driver
Manage Exact Online data with visual tools in DBeaver like the query browser.
-
Import Real-Time Facebook Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Facebook data in ColdFusion.
-
Create Data Visualizations Based On FreshBooks Data in Mode
Use CData Connect AI to connect to FreshBooks Data from Mode and build visualizations using live FreshBooks data.
-
Query WordPress Data as a MySQL Database in Node.js
Execute MySQL queries against WordPress data from Node.js.
-
Connect to Slack Data in CloverDX (formerly CloverETL)
Transfer Slack data using the visual workflow in the CloverDX data integration tool.
-
Connecting GenSpark with Typeform Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Typeform data without any replication or custom integration required.
-
Connect to Avaza Data in DBArtisan
Use wizards in DBArtisan to configure Avaza data as a data source.
-
Build Grafana-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Grafana Data and create custom apps in Bubble.
-
Connect to FormSite Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for FormSite data.
-
How to connect SharePoint with Google Calendar Data through external lists
Provide Google Calendar data to SharePoint users as an external list.
-
How to Connect DBeaver to SpaceX via a JDBC Driver
Manage SpaceX data with visual tools in DBeaver like the query browser.
-
How to Query Missive Data in MySQL Workbench
Execute MySQL queries against live Missive data from MySQL Workbench.
-
Connect to Google Sheets Data in Aqua Data Studio
Access Google Sheets data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software JDBC Driver for Postmark in MicroStrategy Desktop
Connect to Postmark data in MicroStrategy Desktop using the CData Software JDBC Driver for Postmark.
-
Integrating Dataiku with Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Act-On data.
-
Automated Continuous Customer.io Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Customer.io replication to IBM DB2.
-
Automated Continuous Dynamics 365 Business Central Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Azure SQL Database.
-
Build Data Flows from Zendesk to SQL Server using SSIS
Easily back up Zendesk data to SQL Server using the SSIS components for Zendesk.
-
Access Live ServiceDesk Plus Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ServiceDesk Plus data from your Excel spreadsheets.
-
Build AfterShip-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for AfterShip Data and create custom apps in Bubble.
-
Build a Simple VCL Application for DocuSign Data
How to build a simple VCL Application to view DocuSign data in RAD Studio using the CData ODBC Driver for DocuSign.
-
How to connect PolyBase to VWO
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live VWO data.
-
How to Access Demio Data Using Entity Framework
This article shows how to access Demio data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData SSIS Components for Rebilly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Rebilly.
-
Provide OData Services of Procore Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Procore data by developing a WCF Service Application.
-
Integrate Dify with Live FTP 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 FTP data.
-
Connecting Agentforce with Guru 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 Guru data for you.
-
Connect to Jumpseller Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Jumpseller data using standard SQL.
-
Use the CData Software ODBC Driver for AgileCRM in MicroStrategy Web
Connect to AgileCRM data in MicroStrategy Web using the CData Software ODBC Driver for AgileCRM.
-
How to Visualize MongoDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live MongoDB data in Python.
-
Automated Continuous OpenWeatherMap Replication to MySQL
Use CData Sync for automated, continuous, customizable OpenWeatherMap replication to MySQL.
-
How to Connect to FTP Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to FTP data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Google Ads Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Ads data replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData SSIS Components for Snowflake
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Snowflake.
-
Rapidly Develop RabbitMQ-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by RabbitMQ.
-
How to Connect to Live GitHub 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 GitHub data for you.
-
Connect to Zoho Creator Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho Creator data using standard SQL.
-
Build Voice Agents in ElevenLabs with access to Live Azure Data Lake Storage Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Azure Data Lake Storage data.
-
Query Azure Synapse Data as a MySQL Database in Node.js
Execute MySQL queries against Azure Synapse data from Node.js.
-
Migrating data from FreshBooks to Snowflake using CData SSIS Components.
Easily push FreshBooks data to Snowflake using the CData SSIS Tasks for FreshBooks and Snowflake.
-
Prepare, Blend, and Analyze Gmail Data in Alteryx Designer (ODBC)
Build workflows to access live Gmail data for self-service data analytics.
-
How to Use a Microsoft Access Database to Update LinkedIn Data in Real Time
Update LinkedIn data by creating a linked table in Microsoft Access with the CData LinkedIn ODBC Driver.
-
How to create an RPA flow for ClickTime Data in UiPath Studio
Use the ClickTime ODBC Driver to create workflows that access real-time ClickTime data without any coding.
-
DataBind Controls to CircleCI Data in Delphi
DataBind to CircleCI data in Delphi with standard data access components and controls.