CData Software - Knowledge Base
Recent Articles
-
Excel Spreadsheet Automation on Calendly Data with the QUERY Formula
Pull data from Calendly, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Harvest Replication to MySQL
Use CData Sync for automated, continuous, customizable Harvest replication to MySQL.
-
Seamlessly Bring Guru Data into Retool Using CData Connect AI
Integrate Guru data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Moving Data from Dynamics NAV to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Dynamics NAV data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize Sage 200 Data in TIBCO Spotfire through OData
Integrate Sage 200 data into dashboards in TIBCO Spotfire.
-
Automated Continuous Beeminder Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Beeminder replication to IBM DB2.
-
Excel Spreadsheet Automation on ClickUp Data with the QUERY Formula
Pull data from ClickUp, automate spreadsheets, and more with the QUERY formula.
-
How to connect to Mailjet Data from Spring Boot
Connect to Mailjet in a Spring Boot Application using the CData API Driver for JDBC
-
Build Greenplum-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Greenplum data.
-
How to Easily Query BambooHR Data in OpenOffice Base
Connect to BambooHR data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate eBay Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live eBay data from Informatica Cloud.
-
Integrating Gumloop with SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SendGrid data within automated workflows.
-
Connect Testmonitor to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Testmonitor data using the CData Python MCP Server.
-
Connect to MailerSend Data in DBeaver
Use the CData ODBC Driver to connect to MailerSend data in DBeaver.
-
Getting Started with the CData Python Connector for Hubstaff
Learn to install and license the CData Python Connector and configure a connection to live Hubstaff data.
-
Establish a Live Connection with Microsoft Dataverse Data using Tableau Bridge
The CData ODBC Driver for Microsoft Dataverse enables you to integrate live Microsoft Dataverse data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Dataiku with SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SendGrid data.
-
How to Connect Flowise AI Agents to Live Epicor Kinetic Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Epicor Kinetic data without replication.
-
Connect to Azure DevOps Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Azure DevOps as an External Source in Dremio.
-
ETL MailerSend in Oracle Data Integrator
This article shows how to transfer MailerSend data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous SAP SuccessFactors Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Google Cloud SQL.
-
Automate Cloudflare Data Replication to Azure Synapse
Use CData Sync to customize and automate Cloudflare data replication to Azure Synapse.
-
Consume SAP Hybris C4C OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Hybris C4C feeds that reflect any changes in SAP Lumira.
-
Integrate Typeform Data in the Pentaho Report Designer
Publish reports based on Typeform data in the Pentaho BI tool.
-
Integrate Open WebUI with Live Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Square data from within the chat interface.
-
Import ActiveCampaign Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ActiveCampaign Data and provide access to live ActiveCampaign data for custom reports in the Power BI Service.
-
How to Easily Query Sage 300 Data in OpenOffice Base
Connect to Sage 300 data in OpenOffice Base using the CData ODBC Driver for Sage 300 and generate reports with live data insights.
-
Establish a Live Connection with Testmonitor Data using Tableau Bridge
The CData ODBC Driver for Testmonitor enables you to integrate live Testmonitor data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use Dash to Build Web Apps on Dynamics 365 Business Central Data via CData Connect AI
Build interactive Dash web apps on live Dynamics 365 Business Central data using pandas and the CData Connect AI Python SDK.
-
DataBind Controls to Bannerbear Data in C++Builder
DataBind to Bannerbear data in C++Builder with standard components and controls.
-
How to Keep Microsoft Access Working After the Salesforce Connector Discontinuation
A guide on using the CData Salesforce ODBC Driver to restore Microsoft Access connectivity after the native Salesforce connector retirement, enabling teams to run existing queries against live Salesforce data without rebuilding workflows.
-
Integrating LangChain with Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Impala data within automated workflows.
-
Integrating OpenCode with Hubstaff 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 Airtable Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Airtable data in Airbyte.
-
Connect to SuiteCRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SuiteCRM data in the Denodo Virtual DataPort Administrator.
-
Integrating Claude Code with Databricks Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Databricks data within assisted coding and automated development workflows.
-
Connect to Blackbaud FE NXT Data from HeidiSQL
Use CData Connect AI to connect to and query live Blackbaud FE NXT data from HeidiSQL.
-
Connect and Visualize Live Pinterest Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Pinterest data into the Databricks platform and create visualization dashboards with real-time Pinterest data.
-
Connect to Gumroad Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Gumroad data using standard SQL.
-
View Reports on Real-Time Elasticsearch Data in Power BI Report Server
Use the CData ODBC Driver for Elasticsearch to visualize Elasticsearch data in Power BI Desktop and then publish them to Power BI Report Server.
-
Import Real-Time Samanage Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Samanage data in ColdFusion.
-
Connect to Zoho Creator Data in NetBeans
Connect to Zoho Creator data in NetBeans with the data source configuration wizard.
-
How to Work with Exa Data in AWS Glue Jobs Using JDBC
Connect to Exa from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Work with Bullhorn CRM Data in ETL Validator JDBC
Connect to Bullhorn CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Billsby in MicroStrategy Desktop
Connect to Billsby data in MicroStrategy Desktop using the CData Software ODBC Driver for Billsby.
-
Extract, Transform, and Load ZohoMarketingHub Data in Informatica PowerCenter
Create a simple Workflow for ZohoMarketingHub data in Informatica PowerCenter.
-
Write a Simple Go Application to work with Front Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Front data.
-
Build a PostgreSQL Interface for Rootly Data using the CData JDBC Driver
Use the Remoting features of the Rootly JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Wistia Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Wistia data. Leverage the pyodbc module for ODBC in Python.
-
Easily Integrate Recurly Data in Lazarus Pascal IDE
Learn how to easily integrate live Recurly data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Dashboards with Foursquare Data in DBxtra
Create dynamic dashboards and perform analytics based on Foursquare data in DBxtra.
-
Integrating Kiro with Clio 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 Access Live BigCommerce Data in Power Automate Desktop via ODBC
The CData ODBC Driver for BigCommerce enables you to integrate BigCommerce data into workflows built using Microsoft Power Automate Desktop.
-
Create GitHub-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to GitHub Data from Klipfolio and build custom visualizations using live GitHub data.
-
Automated Continuous EnterpriseDB Replication to Databricks
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Databricks.
-
Build Apps with Live ServiceDesk Plus Data Using the Low-Code Development Platform of Mendix
Connect ServiceDesk Plus data with Mendix to build apps using the CData API Driver for JDBC.
-
Build Pipelines with Live Kintone Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Kintone from Google Cloud Data Fusion, enabling the integration of live Kintone data into the building and management of effective data pipelines.
-
Connect Deel to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Deel data using the CData Python MCP Server.
-
Connect to ClickUp Data from AWS Glue
Use CData Connect AI to gain access to live ClickUp data from your AWS Glue jobs.
-
Visualize WooCommerce Data in TIBCO Spotfire through ADO.NET
Integrate WooCommerce data into dashboards in TIBCO Spotfire.
-
Automated Continuous Oracle HCM Cloud Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to delimited files (CSV/TSV).
-
Automated ActiveCampaign Data Replication to Teradata
Use CData Sync to Customize and automate ActiveCampaign data replication to Teradata.
-
Interact with Live Google Analytics Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Google Analytics data.
-
Migrating data from SAP Business One to Snowflake using CData SSIS Components.
Easily push SAP Business One data to Snowflake using the CData SSIS Tasks for SAP Business One and Snowflake.
-
Connect to Epicor Kinetic from Asprova with CData Software ODBC Driver for Epicor Kinetic
This article shows how to connect faster to Epicor Kinetic data from Asprova.
-
Automated Continuous HBase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HBase replication to Amazon Redshift.
-
Object-Relational Mapping (ORM) with Trello 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 Trello data into a Java-based ORM framework, Hibernate.
-
Create Dynamic Salesforce Data 360 Grids Using the Infragistics XamDataGrid
Learn how you can connect Salesforce Data 360 to Infragistics XamDataGrid to build dynamic grids.
-
How to integrate Metabase with JSON Services
Use CData Connect AI to connect to live JSON services and create an interactive dashboard in Metabase from JSON services.
-
Bridge Acumatica Connectivity with Apache NiFi
Access and process Acumatica data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous QuickBooks Replication to Vertica
Use CData Sync for automated, continuous, customizable QuickBooks replication to Vertica.
-
Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy Web
Connect to Salesforce Pardot data in MicroStrategy Web using the CData Software JDBC Driver for Salesforce Pardot.
-
Replicate Clio Data to Multiple Databases
Replicate Clio data to disparate databases with a point-and-click configuration.
-
Configure the CData JDBC Driver for Act-On in a Connection Pool in Tomcat
Connect to Act-On data from a connection pool in Tomcat.
-
Connect to Square Data in Ruby
Connect to Square data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Hugging Face Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Hugging Face replication to delimited files (CSV/TSV).
-
Query Live SAP Business One Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live SAP Business One data through a conversational interface.
-
Connect AI Guide: SSO (Single Sign-On) and User Credentials
A basic guide to Connect AI features: Single Sign-On (SSO) and User Credentials
-
Integrate Live SAP Netweaver Gateway Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SAP Netweaver Gateway data from within the IDE.
-
Import Real-Time Instagram Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Instagram data in ColdFusion.
-
Integrate Box Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Box data from Informatica Cloud.
-
Use Dash to Build to Web Apps on Amazon S3 Data
Create Python applications that use pandas and Dash to build Amazon S3-connected web apps.
-
How to Create Power BI Visual Reports with Real-Time Webex Data
Use CData Power BI Connectors to visualize Webex data in Power BI.
-
Build Automated OneNote-Connected Workflows in Zapier
Use CData Connect AI to connect to live OneNote data and build automated workflows in Zapier.
-
How to create an RPA flow for Hubstaff Data in UiPath Studio
Use the Hubstaff ODBC Driver to create workflows that access real-time Hubstaff data without any coding.
-
Use Biml to Build SSIS Tasks to Replicate SendPulse Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SendPulse data to SQL Server.
-
How to Visualize YouTube Analytics Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live YouTube Analytics data in Python.
-
Connect to Copper Data from PowerBuilder via ADO.NET
This article demonstrates how to access Copper data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Power BI Reports on Real-Time SharePoint Data
Use the CData ODBC Driver for SharePoint to visualize SharePoint data in Power BI Desktop.
-
Connect to Zuora Data from AWS Glue
Use CData Connect AI to gain access to live Zuora data from your AWS Glue jobs.
-
Build Visualizations of Webex Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Webex data in Birst.
-
How to Connect the Power BI Service to SendGrid: Complete Guide
Connect to the CData Software Power BI Connector for SendGrid from PowerBI.com to provide real-time SendGrid data across the organization.
-
Integrate with Clari Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Clari data to a JSON file on disk.
-
Automated Continuous ADP Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ADP replication to Google Cloud SQL.
-
Connect to and Query SendGrid Data in QlikView over ODBC
Create data visualizations with SendGrid data in QlikView.
-
Replicate Avaza Data to Multiple Databases via the CData Sync CLI
Replicate Avaza data to disparate databases with a single configuration.
-
Analyze ZohoInvoice Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ZohoInvoice data and visualize live ZohoInvoice data in Infragistics Reveal.
-
Connect to WooCommerce Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for WooCommerce and the Script function in FileMaker Pro to connect to WooCommerce and work with WooCommerce data in your FileMaker application.
-
Search External Samanage Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Samanage data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Samanage Data objects that you can access from apps and the dashboard.
-
Connect to Adobe Commerce Data in HULFT Integrate
Connect to Adobe Commerce as a JDBC data source in HULFT Integrate