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
-
Automated Continuous Pinterest Replication to SQL Server
Use CData Sync for automated, continuous, customizable Pinterest replication to SQL Server.
-
Build an OLAP Cube in SSAS from SharePoint
Establish a connection to Microsoft SharePoint data from SQL Server Analysis Services, and use the SharePoint Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Amazon Athena from a Connection Pool in JBoss
Integrate Amazon Athena into Java servlets: Use the Management Console in JBoss to install the Amazon Athena JDBC Driver.
-
Connect to ShipStation from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ShipStation, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to connect to Sybase IQ with Squirrel SQL client
Connect to Sybase IQ and execute queries in the Squirrel SQL Client.
-
Access Live Salesforce Pardot in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce Pardot from your Google Sheets.
-
Automated Continuous Phoenix Replication to SQL Server
Use CData Sync for automated, continuous, customizable Phoenix replication to SQL Server.
-
Query Spark from Node.js
Use the OData endpoint of the CData API Server to connect to your Apache Spark SQL and perform CRUD operations on Spark from Node.js.
-
Build a PostgreSQL Interface for BigQuery using the CData JDBC Driver
Use the Remoting features of the BigQuery JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous EnterpriseDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Azure SQL Database.
-
Build a Singer.io Tap for Adobe Commerce With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Adobe Commerce data using
-
DataBind Controls to Amazon Marketplace in C++Builder
DataBind to Amazon Marketplace in C++Builder with standard components and controls.
-
Access Live eBay Analytics Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live eBay Analytics data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Rapidly Develop SAP-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.
-
Integrate Real-Time Access to Azure Active Directory in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure Active Directory in real time.
-
Visualize Dynamics CRM in Tableau
The CData ODBC driver for Dynamics CRM enables you integrate Microsoft Dynamics CRM into Tableau dashboards.
-
How to integrate Metabase with SAP Business One
Use CData Connect Cloud to connect to live SAP Business One and create an interactive dashboard in Metabase from SAP Business One.
-
Connect SAS Data Sets to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAS Data Sets using the CData Python MCP Server.
-
Seamlessly Bring Yahoo! Japan Data Solution into Retool Using CData Connect Cloud
Integrate Yahoo! Japan Data Solution data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
-
Process & Analyze Sage 300 in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sage 300 .
-
Query Marketo as a MySQL Database in Node.js
Execute MySQL queries against Marketo from Node.js.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Splunk
Provide connectivity to Splunk through an SAP BusinessObjects universe.
-
Trigger MYOB AccountRight IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Create Amazon DynamoDB-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Amazon DynamoDB from OutSystems and build custom enterprise apps using live Amazon DynamoDB.
-
Connect to Monday.com from PowerBuilder via JDBC
This article demonstrates how to access Monday.com from PowerBuilder using the Monday.com JDBC Driver.
-
DataBind Controls to TigerGraph in C++Builder
DataBind to TigerGraph in C++Builder with standard components and controls.
-
Automated Continuous QuickBooks Online Replication to Amazon S3
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Amazon S3.
-
Replicate Multiple Freshdesk Accounts via the CData Sync CLI
Replicate multiple Freshdesk accounts to one or many databases.
-
Access Live SAP Netweaver Gateway in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Netweaver Gateway in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect and process Adobe Analytics from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Adobe Analytics.
-
Query Jira Service Management from Node.js
Use the OData endpoint of the CData API Server to connect to your Atlassian Jira Service Management and perform CRUD operations on Jira Service Management from Node.js.
-
Create a Data Access Object for Office 365 using JDBI
A brief overview of creating a SQL Object API for Microsoft Office 365 in JDBI.
-
How to connect to Google Search Results from Spring Boot
Connect to Google Search in a Spring Boot Application using CData JDBC Google Search Driver
-
Build Dashboards with Greenplum in Dundas BI
Create dynamic dashboards and perform analytics based on Pivotal GreenPlum in Dundas BI.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Excel Online to Power BI dashboards. Simply drag and drop Microsoft Excel Online into data visuals on the Power BI canvas.
-
Integrate Redshift into Power Automate Desktop using CData Connect
CData Connect for Redshift enables you to integrate Amazon Redshift into workflows built using Microsoft Power Automate Desktop.
-
How to connect to Cosmos DB from Spring Boot
Connect to Cosmos DB in a Spring Boot Application using CData JDBC Cosmos DB Driver
-
Connect to Zoho Projects in Google Apps Script via Connect Cloud
Use CData Connect Cloud to access Zoho Projects in Google Apps Script.
-
Use the CData Software ODBC Driver for SAP HANA in MicroStrategy Web
Connect to SAP HANA in MicroStrategy Web using the CData Software ODBC Driver for SAP HANA.
-
Access Live Bullhorn CRM in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Bullhorn CRM from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Replicate Multiple TaxJar Accounts
Replicate multiple TaxJar accounts to one or many databases.
-
Build Pipelines with Live Couchbase in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to Couchbase from Google Cloud Data Fusion, enabling the integration of live Couchbase into the building and management of effective data pipelines.
-
Access Live Cassandra in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Cassandra from your Excel spreadsheets.
-
Analyze Smaregi in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Smaregi and visualize live Smaregi in Infragistics Reveal.
-
How to Connect DBeaver to Azure DevOps via a JDBC Driver
Manage Azure DevOps with visual tools in DBeaver like the query browser.
-
Work with Google Campaign Manager 360 in FoxPro
Load Google Campaign Manager 360 into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to Google Analytics from Spring Boot
Connect to Google Analytics in a Spring Boot Application using CData JDBC Google Analytics Driver
-
Provide OData Services of Facebook from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Facebook by developing a WCF Service Application.
-
How to Connect DBeaver to FTP via a JDBC Driver
Manage FTP Servers with visual tools in DBeaver like the query browser.
-
Automated Continuous Splunk Replication to SQL Server
Use CData Sync for automated, continuous, customizable Splunk replication to SQL Server.
-
Oracle SCM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Oracle SCM facts in real time.
-
Automate Quickbase Replication to SAP HANA
Use CData Sync to customize and automate Quickbase replication to SAP HANA.
-
Establish a Live Connection with Freshdesk using Tableau Bridge
The CData ODBC Driver for Freshdesk enables you to integrate live Freshdesk into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Raisers Edge NXT in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Raisers Edge NXT and visualize live Raisers Edge NXT in Infragistics Reveal.
-
Design BIRT Reports on Facebook
Provide current Facebook to your embedded analytics.
-
Connect to Workday in Aqua Data Studio
Access Workday from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Shopify in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to and Visualize Live Paylocity in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Paylocity.
-
Write a Simple Go Application to work with Monday.com on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Monday.com.
-
Establish a Live Connection with eBay using Tableau Bridge
The CData ODBC Driver for eBay enables you to integrate live eBay into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect the Power BI Service to SingleStore: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
SharePoint Excel Services Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SharePoint Excel Services facts in real time.
-
Connect Cvent to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Cvent using the CData Python MCP Server.
-
Working with Basecamp in LINQPad
Execute LINQ queries to Basecamp in LINQPad.
-
Connect to Unbounce from a Connection Pool in Jetty
The Unbounce JDBC Driver supports connection pooling: This article shows how to connect faster to Unbounce from Web apps in Jetty.
-
Connect to Monday.com from PowerBuilder via ADO.NET
This article demonstrates how to access Monday.com from Appeon PowerBuilder using the CData ADO.NET Provider for Monday.com.
-
Access HubSpot 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 HubSpot.
-
Automated Continuous CSV Replication to MySQL
Use CData Sync for automated, continuous, customizable CSV replication to MySQL.
-
Build Data Flows from Procore to SQL Server using SSIS
Easily back up Procore to SQL Server using the SSIS components for Procore.
-
Use the CData Software ODBC Driver for Greenhouse in MicroStrategy
Connect to Greenhouse in MicroStrategy Developer using the CData Software ODBC Driver for Greenhouse.
-
Trigger Cosmos DB IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Visualize Live Salesforce Marketing of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Salesforce Marketing Cloud using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Sage Cloud Accounting from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sage Cloud Accounting to connect to Sage Business Cloud Accounting and execute queries in PowerBuilder.
-
Use Dash to Build to Web Apps on Outreach.io
Create Python applications that use pandas and Dash to build Outreach.io-connected web apps.
-
Create REST Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate SQL Analysis Services in the Pentaho Report Designer
Publish reports based on SQL Analysis Services in the Pentaho BI tool.
-
Natively Connect to Reckon Accounts Hosted in PHP
The CData ODBC driver for Reckon Accounts Hosted enables you to create PHP applications with connectivity to Reckon Accounts Hosted. Leverage the native support for ODBC in PHP.
-
How to Access Gmail Using Entity Framework
This article shows how to access Gmail using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Cassandra-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Apache Cassandra.
-
Query Dynamics CRM in DataGrip
Create a Data Source for Dynamics CRM in DataGrip and use SQL to query live Microsoft Dynamics CRM.
-
Build an OLAP Cube in SSAS from Invoiced
Establish a connection to Invoiced data from SQL Server Analysis Services, and use the Invoiced Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Kintone from Node.js
Use the OData endpoint of the CData API Server to connect to your Kintone and perform CRUD operations on Kintone from Node.js.
-
Build Dashboards with SuiteCRM in DBxtra
Create dynamic dashboards and perform analytics based on SuiteCRM in DBxtra.
-
Automated Continuous Google Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Ads replication to SQLite.
-
Query Asana in DataGrip
Create a Data Source for Asana in DataGrip and use SQL to query live Asana.
-
Use the CData Software ODBC Driver for SAP in MicroStrategy Web
Connect to SAP ERP/NetWeaver in MicroStrategy Web using the CData Software ODBC Driver for SAP.
-
Automated Continuous SAP HANA XS Advanced Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to PostgreSQL.
-
Use the CData SSIS Components to Insert New or Update Existing Cloudant Records from SQL Server
Easily push SQL Server data to Cloudant using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Cloudant or update existing records with data from a SQL Server database.
-
Connect to and Visualize Live Zoho Projects in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho Projects.
-
Build Automated Workflows with Live Twitter Ads in Workato
Use CData Connect Cloud to connect to live Twitter Ads and build automated workflows in Workato.
-
Vault CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Vault CRM facts in real time.
-
How to update Zoho CRM from Excel
This article explains how to transfer data from Excel to Zoho CRM using the Excel Add-In for Zoho CRM.
-
View Reports on Real-Time HCL Domino in Power BI Report Server
Use the CData ODBC Driver for HCL Domino to visualize HCL Domino in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Oracle Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle replication to Google BigQuery.
-
Model, Search, and Visualize Live Google Directory in ThoughtSpot
Use CData Connect Cloud to connect to live Google Directory for modeling, searching, and visualizing.
-
Visualize Snapchat Ads in TIBCO Spotfire through ADO.NET
Integrate Snapchat Ads into dashboards in TIBCO Spotfire.
-
How to Create Power BI Visual Reports with Real-Time Blackbaud FE NXT
Use CData Power BI Connectors to visualize Blackbaud FE NXT in Power BI.
-
Use the CData ODBC Driver for SAP HANA in Microsoft Power Query
You can use the CData SAP HANA ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP HANA into Microsoft Power Query.
-
Connect to Snapchat Ads Using the Script Function in Claris FileMaker Pro
-