CData Software - Knowledge Base
Recent Articles
-
Connecting Mastra with SAP SuccessFactors 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 SAP SuccessFactors data, no replication required.
-
Connect Sugar CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sugar CRM data using the CData Python MCP Server.
-
Load HubDB Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HubDB data to a database.
-
Use ChatGPT to Talk to Your Wistia 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 Wistia data for you.
-
Visualize Live AdRoll Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live AdRoll data.
-
Getting Started with the CData SSIS Components for Everhour
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Everhour.
-
Publish Reports with OnePageCrm Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OnePageCrm data.
-
Extract, Transform, and Load Greenplum Data in Informatica PowerCenter
Create a simple Workflow for Greenplum data in Informatica PowerCenter.
-
Integrate Trae with Live DocuSign Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live DocuSign data from within the AI-powered IDE.
-
How to Seamlessly Import MongoDB Data into IBM SPSS Modeler
Integrate MongoDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Unbounce Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Unbounce and the SQL Gateway to access Unbounce data from Google Apps Script.
-
Build Visualizations of Avro Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Avro data in Birst.
-
Access Onfleet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Onfleet data from your Oracle system.
-
Migrating data from OData to Google BigQuery using CData SSIS Components.
Easily push OData services to Google BigQuery using the CData SSIS Tasks for OData and Google BigQuery.
-
Getting Started with the CData Tableau Connector for AfterShip
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Access Klaviyo Data from MySQL in PHP
Connect to Klaviyo through the standard MySQL libraries in PHP.
-
Work with Live Printify Data in Power Query
Use CData Connect AI to connect to Printify data and work with live Printify data in Microsoft Power Query.
-
Connect to Sage 200 Data in DBArtisan
Use wizards in DBArtisan to configure Sage 200 data as a data source.
-
Replicate Multiple CapsuleCRM Accounts via the CData Sync CLI
Replicate multiple CapsuleCRM accounts to one or many databases.
-
Automated Continuous Zendesk Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zendesk replication to Snowflake.
-
Build Bright Data-Connected Apps in Choreo
Use CData Connect AI to connect to Bright Data Data from Choreo and build custom apps using live Bright Data data.
-
Build Suadeo-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 Suadeo data without replication.
-
Access GitHub Data from MySQL in Amazon QuickSight
Connect to GitHub and build visualizations of GitHub data using a MySQL Connection in Amazon QuickSight.
-
Use Databricks Agent Bricks to Talk to Your Google Spanner Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Spanner data for you.
-
How to Visualize LaunchDarkly Data in Python with pandas
Use pandas and other modules to analyze and visualize live LaunchDarkly data in Python.
-
Connect to Google Search Results in JRuby
Create a simple JRuby app with access to live Google Search results.
-
Integrate with Live Freshteam Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Freshteam from the MuleSoft Anypoint Platform to integrate live Freshteam data into custom reports and dashboards.
-
Create Oracle Service Cloud-Connected Dashboards in Grafana
Connect to Oracle Service Cloud Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle Service Cloud data.
-
Use the CData Software JDBC Driver for PDFMonkey in MicroStrategy Web
Connect to PDFMonkey data in MicroStrategy Web using the CData Software JDBC Driver for PDFMonkey.
-
DataBind Controls to Zoho Inventory Data in Delphi
DataBind to Zoho Inventory data in Delphi with standard data access components and controls.
-
Connect to Live SendGrid Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SendGrid in CData Connect AI and connect to your SendGrid data from PostgreSQL.
-
Process & Analyze Brex Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Brex Data.
-
Access Live Azure Synapse Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Synapse data from your Excel spreadsheets.
-
How to Connect to Live Yelp 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 Yelp data for you.
-
Connect to Salesforce Data 360 Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Salesforce Data 360 data.
-
Connect to PostgreSQL Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live PostgreSQL data.
-
Integrate Live Freshteam 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 Freshteam data from within the IDE.
-
Getting Started with the CData ADO.NET Provider for Mode
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Extract, Transform, and Load Google Search Results in Informatica PowerCenter
Create a simple Workflow for Google Search results in Informatica PowerCenter.
-
Visualize SageHR 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 SageHR data into TIBCO Spotfire.
-
Build Zoho CRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Zoho CRM data.
-
Integrating GitHub Copilot with Act-On 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.
-
Integrating Gumloop with Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho Books data within automated workflows.
-
How to Connect to Live Typeform 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 Typeform data for you.
-
Create Sybase-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sybase Data from OutSystems and build custom enterprise apps using live Sybase data.
-
Visualize EmailOctopus Data in Tableau
The CData ODBC driver for EmailOctopus enables you integrate EmailOctopus data into Tableau dashboards.
-
Automated Continuous Basecamp Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Basecamp replication to IBM DB2.
-
Automate Microsoft Exchange Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Exchange data replication to Azure Data Lake.
-
Build Apps with Live Moosend Data Using the Low-Code Development Platform of Mendix
Connect Moosend data with Mendix to build apps using the CData API Driver for JDBC.
-
Write a Simple Go Application to work with SQL Server Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SQL Server data.
-
Integrating Antigravity CLI with Mouseflow data via CData CLI
Connect Mouseflow data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Dynamic REST Grids Using the Infragistics XamDataGrid
Learn how you can connect REST to Infragistics XamDataGrid to build dynamic grids.
-
How to Use a Microsoft Access Database to Update Stripe Data in Real Time
Update Stripe data by creating a linked table in Microsoft Access with the CData Stripe ODBC Driver.
-
Operational Reporting on Zoho Projects Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zoho Projects data.
-
Replicate Customer.io Data to Multiple Databases via the CData Sync CLI
Replicate Customer.io data to disparate databases with a single configuration.
-
How to connect PolyBase to Highrise
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Highrise data.
-
Build Agents in Relevance AI with Access to Live QuickBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on QuickBooks data within intelligent agent workflows.
-
Write a Simple Go Application to work with MailerLite Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MailerLite data.
-
Integrate Live Marketo Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Marketo from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Marketo data.
-
Query Blackbaud FE NXT Data in ColdFusion
Write standard ColdFusion data access code to connect to Blackbaud FE NXT data.
-
Connect to Demio Data in RazorSQL
Connect to Demio from wizards and query Demio data from the GUI in the RazorSQL database management tool.
-
Integrate Real-Time Access to Okta in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Okta data in real time.
-
Connect to Spark Data in CloverDX (formerly CloverETL)
Transfer Spark data using the visual workflow in the CloverDX data integration tool.
-
Use the CData ODBC Driver for Foursquare in Microsoft Power Query
You can use the CData Foursquare ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Foursquare data into Microsoft Power Query.
-
Replicate Float Data from PowerShell
Write a quick PowerShell script to query Float data. Use connectivity to the live data to replicate Float data to SQL Server.
-
Connect to SAP Concur Data in Aqua Data Studio
Access SAP Concur data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Theia IDE with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Basecamp data from within the development environment.
-
Connect to Wave Financial Data from PowerBuilder via ADO.NET
This article demonstrates how to access Wave Financial data from Appeon PowerBuilder using the CData ADO.NET Provider for Wave Financial.
-
Build Box-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Box Data and create custom apps in Bubble.
-
Create a Data Access Object for Mocean Data using JDBI
A brief overview of creating a SQL Object API for Mocean data in JDBI.
-
DataBind Controls to Jira Data in Delphi
DataBind to Jira data in Delphi with standard data access components and controls.
-
Connect to Suadeo Data in Ruby
Connect to Suadeo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Live Bullhorn CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Bullhorn CRM data.
-
Use the CData Software ODBC Driver for ElevenLabs in MicroStrategy Desktop
Connect to ElevenLabs data in MicroStrategy Desktop using the CData Software ODBC Driver for ElevenLabs.
-
Access Live QuickBooks Online Data in AWS Lambda (with IntelliJ IDEA)
Connect to live QuickBooks Online data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Billsby Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Billsby data from HeidiSQL.
-
Build Agents in Relevance AI with Access to Live GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on GitLab data within intelligent agent workflows.
-
How to create OneNote federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for OneNote data in MySQL .
-
Integrating Cursor with Microsoft Teams 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.
-
Visualize Live ServiceDesk Plus Data in the Power BI Service
Use CData Connect AI to connect to live ServiceDesk Plus data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Factorial Data in Pentaho Data Integration
Build ETL pipelines based on Factorial data in the Pentaho Data Integration tool.
-
Connect to HubSpot Data in HULFT Integrate
Connect to HubSpot as a JDBC data source in HULFT Integrate
-
Integrating Claude Code with Egnyte Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Egnyte data within assisted coding and automated development workflows.
-
Automated Continuous Datadog Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Datadog data replication to OneLake in Microsoft Fabric.
-
Integrate Live OData Services into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to OData from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live OData services.
-
Automated Continuous Helpscout Replication to MySQL
Use CData Sync for automated, continuous, customizable Helpscout replication to MySQL.
-
Connect to Google Spanner Data in ACL Analytics
Connect to Google Spanner data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Spanner data.
-
Connect to Cvent Data in DBeaver
Use the CData ODBC Driver to connect to Cvent data in DBeaver.
-
Access Live Sage 300 Data in Coginiti Pro
Connect to and query live Sage 300 data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData SSIS Components for BigCommerce
Complete guide to installing, licensing, and connecting with the CData SSIS Components for BigCommerce.
-
Use the CData Software ODBC Driver for CSV in MicroStrategy Web
Connect to CSV data in MicroStrategy Web using the CData Software ODBC Driver for CSV.
-
Import Real-Time xBase Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use xBase data in ColdFusion.
-
Access Foursquare Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Foursquare data from HeidiSQL.
-
Integrating GitHub Copilot with Google Ad Manager 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.
-
Integrating Dataiku with Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Dynamics 365 data.
-
Build Dashboards with Aha! Data in DBxtra
Create dynamic dashboards and perform analytics based on Aha! data in DBxtra.
-
Query SAP HANA XS Advanced Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP HANA XS Advanced data from Node.js.
-
Visualize Lakebase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Lakebase data.
-
View Reports on Real-Time Keap Data in Power BI Report Server
Use the CData ODBC Driver for Keap to visualize Keap data in Power BI Desktop and then publish them to Power BI Report Server.
-
Explore Geographical Relationships in iContact Data with Power Map
Create data visualizations with iContact data in Power Map.