CData Software - Knowledge Base
Recent Articles
-
Connecting Moonlit Workflow with CapsuleCRM 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 CapsuleCRM data in real time.
-
Access Live Paymo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Paymo data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Microsoft Copilot Studio to talk to your BigCommerce 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 BigCommerce data for you.
-
Build Vertica-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Vertica Data from Zoho Analytics and import live Vertica data.
-
Gmail Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Gmail data through CData Connect AI using different applications and tools.
-
Create Reports from Azure Analysis Services Data in Looker Studio
Use CData Connect AI to gain access to live Azure Analysis Services data and create custom reports in Looker Studio.
-
How to Query Live OpenWeatherMap Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live OpenWeatherMap data data in natural language using Python.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Simplesat
Provide connectivity to Simplesat data through an SAP BusinessObjects universe.
-
Integrating Cursor with LightSpeedRetail 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Auth0
Create an ODBC connection to Auth0 in Informatica and browse and transfer Auth0 data.
-
Connecting Agentforce with Mailgun 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 Mailgun data for you.
-
Connect to Oracle Sales Data in Ruby
Connect to Oracle Sales data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Natively Connect to Bannerbear Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Bannerbear data. Leverage the native support for ODBC in PHP.
-
Connect to Neo4J Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Neo4J and the SQL Gateway to access Neo4J data from Google Apps Script.
-
How to create Visio diagrams from Adobe Commerce Data
Automatically update Adobe Commerce data with the changes you make to Visio master shapes.
-
Create a Data Access Object for Phoenix Data using JDBI
A brief overview of creating a SQL Object API for Phoenix data in JDBI.
-
ETL Dropbox in Oracle Data Integrator
This article shows how to transfer Dropbox data into a data warehouse using Oracle Data Integrator.
-
A PostgreSQL Interface for CSV Data (MySQL Remoting via JDBC)
Use the Remoting features of the CSV JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Epicor Kinetic Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Google BigQuery.
-
Connect to ZohoDesk from a Connection Pool in WebLogic
Use the CData JDBC Driver for ZohoDesk to connect to ZohoDesk data from Web applications running on WebLogic.
-
Visualize Live Float Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Float data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to MariaDB Data in Google Apps Script via Connect AI
Use CData Connect AI to access MariaDB data in Google Apps Script.
-
Automated Continuous Quickbase Replication to Databricks
Use CData Sync for automated, continuous, customizable Quickbase replication to Databricks.
-
Extract, Transform, and Load Jira Assets Data in Informatica PowerCenter
Create a simple Workflow for Jira Assets data in Informatica PowerCenter.
-
How to connect to AlloyDB Data from IntelliJ
Integrate connectivity to AlloyDB data with wizards in IntelliJ.
-
Automated Continuous Mailjet Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Mailjet replication to Google BigQuery.
-
Bridge Bugsnag Connectivity with Apache NiFi
Access and process Bugsnag data in Apache NiFi using the CData JDBC Driver.
-
Publish Reports with Retently Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Retently data.
-
How to integrate Metabase with API Data
Use CData Connect AI to connect to live API data and create an interactive dashboard in Metabase from API data.
-
Viewing BigQuery Data in RAD Studio Data Explorer
How to view BigQuery data in RAD Studio Data Explorer using the CData ODBC Driver for BigQuery.
-
Build eBay-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 eBay data without replication.
-
Build AI Agents with Box 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 Box data through CData Connect AI.
-
Query Helpscout Data as a MySQL Database in Node.js
Execute MySQL queries against Helpscout data from Node.js.
-
How to connect to Ontraport Data from Spring Boot
Connect to Ontraport in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze Parallel Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Parallel from Power Pivot. You will use the Table Import Wizard to load Parallel data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Hubstaff Data from PowerBuilder via JDBC
This article demonstrates how to access Hubstaff data from PowerBuilder using the Hubstaff JDBC Driver.
-
How to Connect to Databricks Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Databricks data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Jodoo Data in Pentaho Data Integration
Build ETL pipelines based on Jodoo data in the Pentaho Data Integration tool.
-
Build MVC Applications with Connectivity to Pipedrive Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Pipedrive from an ASP.NET MVC application.
-
Connecting Agentforce with Dynamics 365 Business Central 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 Dynamics 365 Business Central data for you.
-
Integrating Cursor with Invoiced 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 Query Live LaunchDarkly Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LaunchDarkly data data in natural language using Python.
-
Replicate Multiple Cvent Accounts via the CData Sync CLI
Replicate multiple Cvent accounts to one or many databases.
-
Connect to Clockify Data from PowerBuilder via JDBC
This article demonstrates how to access Clockify data from PowerBuilder using the Clockify JDBC Driver.
-
Query Live ZohoDesk Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live ZohoDesk data directly from the development environment.
-
Connect to SAS Data Sets Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAS Data Sets to connect to SAS Data Sets data and execute queries in PowerBuilder.
-
How to Easily Query Oracle Eloqua Data in OpenOffice Base
Connect to Oracle Eloqua data in OpenOffice Base using the CData ODBC Driver for Oracle Eloqua and generate reports with live data insights.
-
How to connect Amazon QuickSight to SAP ByDesign Data
Create a connection to SAP ByDesign data in CData Connect AI and insert SAP ByDesign data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Webflow Data from PowerBuilder via ADO.NET
This article demonstrates how to access Webflow data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Live Active Directory Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Active Directory in CData Connect AI and connect to your Active Directory data from PostgreSQL.
-
View Reports on Real-Time Sage 300 Data in Power BI Report Server
Use the CData ODBC Driver for Sage 300 to visualize Sage 300 data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create MYOB AccountRight-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to MYOB AccountRight Data from OutSystems and build custom enterprise apps using live MYOB AccountRight data.
-
Build CockroachDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live CockroachDB data.
-
How to import ConstantContact Data into Apache Solr
Use the CData Software JDBC Driver for ConstantContact in Data Import Handler and create an automated import of ConstantContact data to Apache Solr Enterprise Search platform.
-
How to Connect to Live HubSpot Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your HubSpot data for you.
-
Getting Started with the CData Excel Add-In for Act CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Act CRM.
-
Publish Crystal Reports on Microsoft OneDrive Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft OneDrive data.
-
Build a Simple VCL Application for Zendesk Data
How to build a simple VCL Application to view Zendesk data in RAD Studio using the CData ODBC Driver for Zendesk.
-
Publish Reports with Gong Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Gong data.
-
Integrate with live Snowflake Data in Jitterbit
Use CData Connect AI to connect to and integrate live Snowflake data in Jitterbit.
-
How to Visualize PagerDuty Data in Python with pandas
Use pandas and other modules to analyze and visualize live PagerDuty data in Python.
-
Automated Continuous RSS Replication to SQL Server
Use CData Sync for automated, continuous, customizable RSS replication to SQL Server.
-
Build Apps with Live Google Drive data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Drive data into the Adalo platform and build custom mobile and web applications with real-time Google Drive data.
-
Create Stripe-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Stripe Data from Klipfolio and build custom visualizations using live Stripe data.
-
Build AI Agents with Blackbaud FE NXT 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 Blackbaud FE NXT data through CData Connect AI.
-
Replicate Phoenix Data from PowerShell
Write a quick PowerShell script to query Phoenix data. Use connectivity to the live data to replicate Phoenix data to SQL Server.
-
Integrate with Snowflake Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Snowflake data to a JSON file on disk.
-
Working with Oracle Financials Cloud Data in LINQPad
Execute LINQ queries to Oracle Financials Cloud data in LINQPad.
-
ETL FreeAgent in Oracle Data Integrator
This article shows how to transfer FreeAgent data into a data warehouse using Oracle Data Integrator.
-
Build Data Flows from Freshsales to SQL Server using SSIS
Easily back up Freshsales data to SQL Server using the SSIS components for Freshsales.
-
Natively Connect to Azure Synapse Data in PHP
The CData ODBC driver for Azure Synapse enables you to create PHP applications with connectivity to Azure Synapse data. Leverage the native support for ODBC in PHP.
-
How to Connect DBeaver to RabbitMQ via a JDBC Driver
Manage RabbitMQ data with visual tools in DBeaver like the query browser.
-
Use the CData Software ODBC Driver for SFTP in SAS for Real-Time Reporting and Analytics
Connect to real-time SFTP data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SFTP.
-
Replicate Strava Data to Multiple Databases
Replicate Strava data to disparate databases with a point-and-click configuration.
-
Use the CData Software JDBC Driver for Tavily in MicroStrategy
Connect to Tavily data in MicroStrategy Developer using the CData Software JDBC Driver for Tavily.
-
How to Connect to Live Apollo 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 Apollo data for you.
-
DataBind Gumroad Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Gumroad data to a chart.
-
Query Live FreshBooks 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 FreshBooks data through a conversational interface.
-
Integrating Boomi Agentstudio with Perplexity Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Perplexity data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Getting Started with the CData ODBC Driver for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP SuccessFactors LMS.
-
Integrating Kiro with ADP 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.
-
A PostgreSQL Interface for Anaplan Data (MySQL Remoting via JDBC)
Use the Remoting features of the Anaplan JDBC Driver to create a PostgreSQL entry-point for data access.
-
Validate Confluence Data with QuerySurge
Access and validate Confluence data in QuerySurge using the CData JDBC Driver.
-
Create Reports from Zoho Books Data in Looker Studio
Use CData Connect AI to gain access to live Zoho Books data and create custom reports in Looker Studio.
-
How to Connect the Power BI Service to Parallel: Complete Guide
Connect to the CData Software Power BI Connector for Parallel from PowerBI.com to provide real-time Parallel data across the organization.
-
Integrating Brex Data in Talend Cloud Data Management Platform
Connect Brex Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Google Contacts 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 Google Contacts data.
-
Integrate Google's Antigravity Agent with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft OneDrive data using the Model Context Protocol.
-
Connect to Invoiced Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Invoiced data.
-
Integrating Codex with Oracle Eloqua Reporting 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 Omnisend from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Omnisend data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Reply.io Data in CloverDX (formerly CloverETL)
Transfer Reply.io data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous BenchmarkEmail Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to delimited files (CSV/TSV).
-
Replicate ZohoSubscriptions Data from PowerShell
Write a quick PowerShell script to query ZohoSubscriptions data. Use connectivity to the live data to replicate ZohoSubscriptions data to SQL Server.
-
Automated Continuous Jira Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Jira replication to Azure SQL Database.
-
Create Dynamics CRM-Connected Applications in Appsmith
Connect to Dynamics CRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Dynamics CRM data.
-
How to Connect the Power BI Service to Salesforce Pardot: Complete Guide
Connect to the CData Software Power BI Connector for Salesforce Pardot from PowerBI.com to provide real-time Salesforce Pardot data across the organization.
-
Automated Continuous Guru Replication to Oracle
Use CData Sync for automated, continuous, customizable Guru replication to Oracle.
-
Natively Connect to Greenhouse Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Greenhouse data. Leverage the native support for ODBC in PHP.
-
Object-Relational Mapping (ORM) with Brex 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 Brex data into a Java-based ORM framework, Hibernate.