CData Software - Knowledge Base
Recent Articles
-
Create a Data Access Object for WooCommerce Data using JDBI
A brief overview of creating a SQL Object API for WooCommerce data in JDBI.
-
Query Shortcut Data as a SQL Server Database in Node.js
Execute SQL Server queries against Shortcut data from Node.js.
-
Build Dashboards with SageHR Data in Dundas BI
Create dynamic dashboards and perform analytics based on SageHR data in Dundas BI.
-
Connect to Helpscout Data from a Connection Pool in Jetty
The Helpscout JDBC Driver supports connection pooling: This article shows how to connect faster to Helpscout data from Web apps in Jetty.
-
Access Live OpenWeatherMap Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate OpenWeatherMap data into the statistical analysis tools available in SAS JMP. This article shows how to use OpenWeatherMap data in the Graph Builder and Query Builder.
-
Integrating OpenCode with QuickBooks Online 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.
-
Deploy the ADO.NET Provider for Aircall on an SSRS Report Server
Connect to Aircall data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to Active Directory Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Active Directory Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Google Campaign Manager 360-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 Google Campaign Manager 360 data without replication.
-
DataBind Controls to Klipfolio Data in C++Builder
DataBind to Klipfolio data in C++Builder with standard components and controls.
-
Build AI Agents with Bright Data 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 Bright Data data through CData Connect AI.
-
Automated Continuous Auth0 Replication to MongoDB
Use CData Sync for automated, continuous, customizable Auth0 replication to MongoDB.
-
Access Live SendGrid Data in Excel 365 Online (Excel for the web)
Connect to SendGrid data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData ODBC Driver for Microsoft Dataverse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft Dataverse to connect to Microsoft Dataverse data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Dataverse data in Excel.
-
Access Live Autopilot Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Autopilot data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Google Tasks Data in RapidMiner
Integrate Google Tasks data with standard components and data source configuration wizards in RapidMiner Studio.
-
Publish NetSuite-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live NetSuite data.
-
Automated Continuous Unbounce Replication to SQLite
Use CData Sync for automated, continuous, customizable Unbounce replication to SQLite.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Drive
Provide connectivity to Google Drive data through an SAP BusinessObjects universe.
-
CapsuleCRM Reporting in OBIEE with the CapsuleCRM JDBC Driver
Deploy the CapsuleCRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Create Power BI Visual Reports with Real-Time Square Data
Use CData Power BI Connectors to visualize Square data in Power BI.
-
Integrate LibreChat with Live FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live FreshBooks data from within the chat interface.
-
Integrating Drip Data in Talend Cloud Data Management Platform
Connect Drip Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Moving Data from SurveyMonkey to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SurveyMonkey data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Salesforce Marketing Replication to SingleStore
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to SingleStore.
-
Automated Continuous Miro Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Miro replication to Amazon S3.
-
Integrate LibreChat with Live Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Couchbase data from within the chat interface.
-
Integrate with live Oracle Eloqua Data in Jitterbit
Use CData Connect AI to connect to and integrate live Oracle Eloqua data in Jitterbit.
-
Connect and Visualize Live Apify Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Apify data into the Databricks platform and create visualization dashboards with real-time Apify data.
-
Query Float Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Float data from Node.js.
-
Query Mistral AI Data in DataGrip
Create a Data Source for Mistral AI in DataGrip and use SQL to query live Mistral AI data.
-
Automated Continuous Azure Blob Storage Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to AlloyDB.
-
Automated Continuous Workday Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Workday replication to delimited files (CSV/TSV).
-
Analyze Avro Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Avro data and visualize Avro data in SAP Analytics Cloud.
-
Integrating Kiro with Customer.io 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.
-
Stream NASA Data into Apache Kafka Topics
Access and stream NASA data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use ChatGPT to Talk to Your Samanage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Samanage data for you.
-
Viewing YouTube Analytics Data in RAD Studio Data Explorer
How to view YouTube Analytics data in RAD Studio Data Explorer using the CData ODBC Driver for YouTube Analytics.
-
Connect to HBase Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for HBase and the Script function in FileMaker Pro to connect to HBase and work with HBase data in your FileMaker application.
-
Access Live Google Directory Data in Excel 365 Online (Excel for the web)
Connect to Google Directory data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to load SQL Server data into Elasticsearch via Logstash
Introducing a simple method to load SQL Server data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Validate Nethunt Data with QuerySurge
Access and validate Nethunt data in QuerySurge using the CData JDBC Driver.
-
Query, Visualize, and Share live Avalara AvaTax Data in Redash
Use CData Connect AI to connect to live Avalara AvaTax data in Redash for querying, visualizing, and sharing.
-
Getting Started with the CData ODBC Driver for Missive
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Missive.
-
Use the CData Software ODBC Driver for WordPress in MicroStrategy Desktop
Connect to WordPress data in MicroStrategy Desktop using the CData Software ODBC Driver for WordPress.
-
Build Pipelines with Live HubSpot Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to HubSpot from Google Cloud Data Fusion, enabling the integration of live HubSpot data into the building and management of effective data pipelines.
-
Visualize Live Google Drive Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Drive data.
-
Connect to Tally Data from PowerBuilder via ADO.NET
This article demonstrates how to access Tally data from Appeon PowerBuilder using the CData ADO.NET Provider for Tally.
-
How to Connect to Live Reckon Accounts Hosted Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Reckon Accounts Hosted data for you.
-
Connect to Microsoft Teams Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft Teams data from Crystal Reports.
-
Connect to Blackbaud FE NXT from a Connection Pool in WebLogic
Use the CData JDBC Driver for Blackbaud FE NXT to connect to Blackbaud FE NXT data from Web applications running on WebLogic.
-
Query, Visualize, and Share live Salesforce CRM Analytics Data in Redash
Use CData Connect AI to connect to live Salesforce CRM Analytics data in Redash for querying, visualizing, and sharing.
-
Work with RabbitMQ Data in FoxPro
Load RabbitMQ data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Datasets from Printify in Domo Workbench and Build Visualizations of Printify Data in Domo
Use the CData Software ODBC Driver for Printify to create datasets from Printify data in Domo Workbench and then build visualizations in the Domo service.
-
Interact with Live Typeform Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Typeform data.
-
Integrating Claude Code with Klipfolio Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Klipfolio data within assisted coding and automated development workflows.
-
Connect to Acumatica Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Acumatica to connect to Acumatica data and execute queries in PowerBuilder.
-
How to integrate Marketo with Apache Airflow
Access and process Marketo data in Apache Airflow using the CData JDBC Driver.
-
Query Act CRM Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Act CRM entities in PHP by modeling them as objects.
-
Integrate Open WebUI with Live SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Ariba Procurement data from within the chat interface.
-
Link ZarMoney with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZarMoney data in Filemaker Pro for Mac or Windows.
-
Query Google Search Results as a MySQL Database in Node.js
Execute MySQL queries against Google Search results from Node.js.
-
Create AfterShip Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time AfterShip data access from reports, embedded analytics, and more.
-
How to connect and process Adobe Target data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Adobe Target data.
-
How to Connect to Live Workday Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Workday data for you.
-
Bind Live Act-On Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Act-On data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Access Live HDFS 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 HDFS data through MCP integration.
-
Connect to ZeroBounce from a Connection Pool in WebLogic
Use the CData JDBC Driver for ZeroBounce to connect to ZeroBounce data from Web applications running on WebLogic.
-
Getting Started with the CData JDBC Driver for Discord
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Discord.
-
Connect to Oracle Eloqua Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle Eloqua data from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Eloqua.
-
Use the CData Software JDBC Driver for JotForm in MicroStrategy Web
Connect to JotForm data in MicroStrategy Web using the CData Software JDBC Driver for JotForm.
-
How to connect to Google Drive Data from Spring Boot
Connect to Google Drive in a Spring Boot Application using the CData JDBC Driver for Google Drive
-
Moving Data from Confluence to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Confluence data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Validate Instantly Data with QuerySurge
Access and validate Instantly data in QuerySurge using the CData JDBC Driver.
-
Rapidly Develop VWO-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 VWO.
-
How to integrate Metabase with Presto Data
Use CData Connect AI to connect to live Presto data and create an interactive dashboard in Metabase from Presto data.
-
Integrating Codex with OnePageCrm 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 MVC Applications with Connectivity to Reply.io Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Reply.io from an ASP.NET MVC application.
-
Working with Avaza Data in LINQPad
Execute LINQ queries to Avaza data in LINQPad.
-
Connect to ZohoMarketingHub in SpagoBI
Create reports featuring live ZohoMarketingHub data in SpagoBI Studio. Host ZohoMarketingHub reports on SpagoBI Server.
-
Integrate Phoenix Data into Power Automate Desktop using CData Connect
CData Connect for Phoenix Data enables you to integrate Phoenix data into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Connect AI Python SDK for Bannerbear
Install the CData Connect AI Python SDK to read live Bannerbear data with standard DB-API 2.0 Python code.
-
How to Connect to & Open MongoDB Data in Microsoft Excel
This article uses the CData ODBC driver for MongoDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Using the CData Software ODBC Driver for Zuora in PyCharm
Connect to Zuora as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zuora.
-
Automated Continuous Microsoft Teams Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to AlloyDB.
-
How to connect to Accelo Data in DBVisualizer
Integrate Accelo data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate with Eventbrite Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Eventbrite data to a JSON file on disk.
-
Analyze Zuora Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zuora data in Microsoft R Open.
-
How to Easily Query Vercel Data in OpenOffice Base
Connect to Vercel data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Act CRM Data in CloverDX (formerly CloverETL)
Transfer Act CRM data using the visual workflow in the CloverDX data integration tool.
-
Object-Relational Mapping (ORM) with Databricks Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Databricks data into a Java-based ORM framework, Hibernate.
-
Analyze Twilio Data in Looker
Use CData Connect AI to connect to Twilio Data from Looker and build custom apps using live Twilio data.
-
Build Semantic Layer Views for Suadeo Data in APOS Live Data Gateway
Use the CData Connector for Suadeo in APOS Live Data Gateway to build Semantic Layer Views for Suadeo data.
-
Visualize Live Shopify Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Shopify data.
-
Visualize Live ZohoPeople Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ZohoPeople data into custom reports in Power BI.
-
How to update Impala from Excel
This article explains how to transfer data from Excel to Impala using the Excel Add-In for Impala.
-
How to Connect to Live Elasticsearch Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Elasticsearch data for you.
-
How to Connect to Live Stripe Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Stripe data for you.
-
Migrating data from Discord to Databricks using CData SSIS Components.
Easily push Discord data to Databricks using the CData SSIS Tasks for Discord and Databricks.
-
Connect to MYOB AccountRight Data in ACL Analytics
Connect to MYOB AccountRight data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MYOB AccountRight data.