Model Context Protocol (MCP) finally gives AI models a way to access the business data needed to make them really useful at work. CData MCP Servers have the depth and performance to make sure AI has access to all of the answers.
Try them now for free →CData Software - Knowledge Base
Recent Articles
-
Connect to Azure DevOps as an External Data Source using PolyBase
Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Azure DevOps.
-
Stream Shippo into Apache Kafka Topics
Access and stream Shippo in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Publish Reports with MailChimp in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailChimp.
-
Bind Live Azure Active Directory Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Active Directory data
-
Integrate with HubSpot in SnapLogic
Use CData Connect Cloud to connect to and integrate with live HubSpot in SnapLogic.
-
Manage LinkedIn in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for LinkedIn.
-
Feed FTP into FineReport
How to set FTP Servers as a JDBC data source in FineReport.
-
Rapidly Develop Sugar CRM-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Migrating data from Jira to Google BigQuery using CData SSIS Components.
Easily push Atlassian Jira to Google BigQuery using the CData SSIS Tasks for Jira and Google BigQuery.
-
Provide OData Services of Redis from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Redis by developing a WCF Service Application.
-
Automated Continuous Cosmos DB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Apache Kafka.
-
Consume Pipedrive OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Pipedrive feeds that reflect any changes in SAP Lumira.
-
Integrate Real-Time Access to Phoenix in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Phoenix in real time.
-
Consume Sybase IQ OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sybase IQ feeds that reflect any changes in SAP Lumira.
-
Use Biml to Build SSIS Tasks to Replicate Presto to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Presto to SQL Server.
-
Import Real-Time Freshdesk via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Freshdesk in ColdFusion.
-
Import Real-Time JSON Services via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use JSON in ColdFusion.
-
Import Real-Time DocuSign via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use DocuSign in ColdFusion.
-
Connect to Facebook Ads in Jaspersoft Studio
Execute SQL to remote Facebook Ads in Jaspersoft Studio.
-
How to Query Live Exact Online in Claude Desktop
Connect to and query live Exact Online in Claude Desktop using the CData MCP Server.
-
How to Visualize CockroachDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live CockroachDB in Python.
-
Build Sansan-Connected Apps in Choreo
Use CData Connect Cloud to connect to Sansan from Choreo and build custom apps using live Sansan.
-
Explore Geographical Relationships in Phoenix with Power Map
Create data visualizations with Apache Phoenix in Power Map.
-
Easily Integrate SuiteCRM in Lazarus Pascal IDE
Learn how to easily integrate live SuiteCRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Enable the Salesforce Marketing JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesforce Marketing Cloud.
-
Build Facebook Ads-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Facebook Ads.
-
How to Access Live Paylocity in Power Automate Desktop via ODBC
The CData ODBC Driver for Paylocity enables you to integrate Paylocity into workflows built using Microsoft Power Automate Desktop.
-
Create Reports from Smartsheet in Looker Studio
Use CData Connect Cloud to gain access to live Smartsheet and create custom reports in Looker Studio.
-
How to connect to SAP Fieldglass in DBVisualizer
Integrate SAP Fieldglass with visual data analysis tools and data connection wizards in DBVisualizer
-
How to integrate FHIR with Apache Airflow
Access and process FHIR in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Sage Cloud Accounting Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Microsoft Access.
-
How to Connect to Live Elasticsearch in n8n Workflows and Agents (via CData Connect Cloud)
Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Elasticsearch for you.
-
Query Workday using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Workday entities in PHP by modeling them as objects.
-
Work with Live FHIR in Power Query
Use CData Connect Cloud to connect to FHIR and work with live FHIR in Microsoft Power Query.
-
Visualize Live SAP BusinessObjects BI in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live SAP BusinessObjects BI into custom reports in Power BI.
-
Viewing MySQL in RAD Studio Data Explorer
How to view MySQL in RAD Studio Data Explorer using the CData ODBC Driver for MySQL.
-
Automated Continuous Monday.com Replication to MySQL
Use CData Sync for automated, continuous, customizable Monday.com replication to MySQL.
-
How to Work with Bitbucket in ETL Validator JDBC
Connect to Bitbucket from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live MongoDB in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MongoDB from your Excel spreadsheets.
-
Create Informatica Mappings From/To an ODBC Data Source for Zuora
Create an ODBC connection to Zuora in Informatica and browse and transfer Zuora.
-
Connect to Teradata from a Connection Pool in WebLogic
Use the CData JDBC Driver for Teradata to connect to Teradata from Web applications running on WebLogic.
-
Create SSAS Tabular Models from Sage 300
How to build a SQL Server Analysis Service Tabular Model from Sage 300 using CData drivers.
-
Import Real-Time MYOB AccountRight via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MYOB AccountRight in ColdFusion.
-
Back Up Blackbaud FE NXT to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Blackbaud FE NXT. In this article, we will employ an SSIS workflow to populate a database with Blackbaud FE NXT data.
-
How to Connect DBeaver to Paylocity via a JDBC Driver
Manage Paylocity with visual tools in DBeaver like the query browser.
-
Access Invoiced 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 Invoiced.
-
How to create Visio diagrams from Amazon Athena
Automatically update Amazon Athena with the changes you make to Visio master shapes.
-
Automated Continuous Drift Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Drift replication to Amazon S3.
-
Connect to Excel Online as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Microsoft Excel Online.
-
Publish FTP-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live FTP Servers.
-
Build Impala-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to Impala from Zoho Analytics and import live Apache Impala.
-
Automated Continuous PostgreSQL Replication to IBM DB2
Use CData Sync for automated, continuous, customizable PostgreSQL replication to IBM DB2.
-
Visualize Shippo in Sisense
Create an ElastiCube in Sisense app with access to Shippo.
-
Connect to Oracle SCM in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Oracle SCM and connect to Oracle SCM in Akorbi Digital RunMyProcess.
-
Query Monday.com using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Monday.com entities in PHP by modeling them as objects.
-
Automated Continuous Exact Online Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Exact Online replication to Azure SQL Database.
-
Access Facebook Ads from MySQL in Amazon QuickSight
Connect to Facebook Ads and build visualizations of Facebook Ads using a MySQL Connection in Amazon QuickSight.
-
Connect to Trello in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Trello and connect to Trello in Akorbi Digital RunMyProcess.
-
How to connect and process Apache Hive from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Apache Hive.
-
Build a Simple VCL Application for Cloudant
How to build a simple VCL Application to view IBM Cloudant in RAD Studio using the CData ODBC Driver for Cloudant.
-
Create Datasets from Shippo in Domo Workbench and Build Visualizations of Shippo in Domo
Use the CData Software ODBC Driver for Shippo to create datasets from Shippo in Domo Workbench and then build visualizations in the Domo service.
-
Replicate Zoho Projects from PowerShell
Write a quick PowerShell script to query Zoho Projects. Use connectivity to the live data to replicate Zoho Projects to SQL Server.
-
Stream Klipfolio into Apache Kafka Topics
Access and stream Klipfolio in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Replicate BambooHR to Multiple Databases via the CData Sync CLI
Replicate BambooHR to disparate databases with a single configuration.
-
Edit and Search External eBay Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of eBay to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create eBay objects that you can access from apps and the dashboard.
-
Connect to Jira from Asprova with CData Software ODBC Driver for Jira
This article shows how to connect faster to Jira data from Asprova.
-
Configure the CData JDBC Driver for Wave Financial in a Connection Pool in Tomcat
Connect to Wave Financial from a connection pool in Tomcat.
-
Access MongoDB 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 MongoDB.
-
A PostgreSQL Interface for Paylocity (MySQL Remoting via JDBC)
Use the Remoting features of the Paylocity JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Google Directory in the Pentaho Report Designer
Publish reports based on Google Directory in the Pentaho BI tool.
-
A PostgreSQL Interface for Kafka (MySQL Remoting via JDBC)
Use the Remoting features of the Kafka JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate RSS Feeds Replication to Couchbase
Use CData Sync to Customize and automate RSS Feeds replication to Couchbase.
-
How to connect to Cloudant from IntelliJ
Integrate connectivity to IBM Cloudant with wizards in IntelliJ.
-
Connect to and Visualize Live HarperDB in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live HarperDB.
-
Access Live Acumatica in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Acumatica ERP from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData Software JDBC Driver for Amazon Athena in MicroStrategy Web
Connect to Amazon Athena in MicroStrategy Web using the CData Software JDBC Driver for Amazon Athena.
-
Connect to Shopify in SpagoBI
Create reports featuring live Shopify in SpagoBI Studio. Host Shopify reports on SpagoBI Server.
-
Connect Stripe to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Stripe using the CData Python MCP Server.
-
How to Query Live SAP HANA XS Advanced in Claude Desktop
Connect to and query live SAP HANA XS Advanced in Claude Desktop using the CData MCP Server.
-
Use the CData Software ODBC Driver for SendGrid in SAS for Real-Time Reporting and Analytics
Connect to real-time SendGrid in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SendGrid.
-
Connect to BigCommerce as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live BigCommerce.
-
Integrate Jira Assets in Pentaho Data Integration
Build ETL pipelines based on Jira Assets in the Pentaho Data Integration tool.
-
Visualize Live BCart in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live BCart into custom reports in Power BI.
-
How to Connect DBeaver to Jira Assets via a JDBC Driver
Manage Jira Assets with visual tools in DBeaver like the query browser.
-
Create Data Visualizations Based On Odoo in Mode
Use CData Connect Cloud to connect to Odoo from Mode and build visualizations using live
-
How to Access Live PingOne in Power Automate Desktop via ODBC
The CData ODBC Driver for PingOne enables you to integrate PingOne into workflows built using Microsoft Power Automate Desktop.
-
Import SuiteCRM into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SuiteCRM. In this article, you will use the OData format to import SuiteCRM into Microsoft Power Query.
-
Connect and Query Live Dynamics CRM Data in Databricks with CData Connect Cloud
Use CData Connect Cloud to integrate live Microsoft Dynamics CRM into Databricks
-
Automated Continuous Microsoft Planner Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to IBM DB2.
-
Bidirectional Access to AlloyDB from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google AlloyDB in Filemaker Pro for Mac or Windows.
-
Connect to Zoho Inventory in Jaspersoft Studio
Execute SQL to remote Zoho Inventory in Jaspersoft Studio.
-
Connect and Query Live SAP ByDesign Data in Databricks with CData Connect Cloud
Use CData Connect Cloud to integrate live SAP Business ByDesign into Databricks
-
DataBind Controls to Sage 200 in C++Builder
DataBind to Sage 200 in C++Builder with standard components and controls.
-
Connect to Sage Intacct as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Sage Intacct.
-
Twilio Reporting in OBIEE with the Twilio JDBC Driver
Deploy the Twilio JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Load Parquet to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache Parquet to a database.
-
Query Google Data Catalog as a MySQL Database in Node.js
Execute MySQL queries against Google Data Catalog from Node.js.
-
Connect to Phoenix in NetBeans
Connect to Apache Phoenix in NetBeans with the data source configuration wizard.
-
Automated Continuous NetSuite Replication to MySQL
Use CData Sync for automated, continuous, customizable NetSuite replication to MySQL.
-
Connect to Greenplum in CloverDX (formerly CloverETL)
Transfer Pivotal GreenPlum using the visual workflow in the CloverDX data integration tool.