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
-
Excel Spreadsheet Automation on OneNote with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Import and Visualize Zoho Projects in Power View
Create data visualizations based on Zoho Projects in Excel.
-
Connect Exact Online to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Exact Online using the CData Python MCP Server.
-
Build a Singer.io Tap for Elasticsearch With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Elasticsearch data using
-
Connect to Harvest in HULFT Integrate
Connect to Harvest as a JDBC data source in HULFT Integrate
-
Connect to AlloyDB in SpagoBI
Create reports featuring live Google AlloyDB in SpagoBI Studio. Host AlloyDB reports on SpagoBI Server.
-
Query MySQL in DataGrip
Create a Data Source for MySQL in DataGrip and use SQL to query live MySQL.
-
Integrate Airtable into Automated Tasks with Power Automate
Use CData Connect Cloud to connect to Airtable and integrate live Airtable into your Power Automate tasks.
-
Replicate Multiple NetSuite SuiteAnalytics Accounts
Replicate multiple NetSuite SuiteAnalytics accounts to one or many databases.
-
How to Build an ETL App for Amazon Marketplace in Python with CData
Create ETL applications and real-time data pipelines for Amazon Marketplace in Python with petl.
-
Access Live Google Campaign Manager 360 in Excel 365 Online (Excel for the web)
Connect to Google Campaign Manager 360 from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Build Office 365-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for Office 365 and create custom apps in Bubble.
-
Create Square-Connected Applications in Appsmith
Connect to Square via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Square.
-
Visualize Sage Intacct from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sage Intacct.
-
Extend Google Sheets with Highrise
Make calls to the API Server from Google Apps Script.
-
Use the CData ODBC Driver for Google Ad Manager in Microsoft Power Query
You can use the CData Google Ad Manager ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Ad Manager into Microsoft Power Query.
-
How to Access Live MongoDB in Power Automate Desktop via ODBC
The CData ODBC Driver for MongoDB enables you to integrate MongoDB into workflows built using Microsoft Power Automate Desktop.
-
Replicate Multiple Oracle Sales Accounts
Replicate multiple Oracle Sales accounts to one or many databases.
-
Replicate Amazon Athena from PowerShell
Write a quick PowerShell script to query Amazon Athena. Use connectivity to the live data to replicate Amazon Athena to SQL Server.
-
Edit and Search External Asana Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of Asana to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Asana objects that you can access from apps and the dashboard.
-
Working with ClickUp in LINQPad
Execute LINQ queries to ClickUp in LINQPad.
-
Connect to Elasticsearch in ACL Analytics
Connect to Elasticsearch via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Elasticsearch.
-
Bidirectional Access to MYOB AccountRight from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate MYOB AccountRight in Filemaker Pro for Mac or Windows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Coinbase
Provide connectivity to Coinbase through an SAP BusinessObjects universe.
-
Build a Simple VCL Application for ActiveCampaign
How to build a simple VCL Application to view ActiveCampaign in RAD Studio using the CData ODBC Driver for ActiveCampaign.
-
Choosing the Best Method to Connect Redshift to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Amazon Redshift from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Load Tally to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Tally ERP to a database.
-
Access Live Oracle in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Database into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Database in the Graph Builder and Query Builder.
-
Replicate Multiple Microsoft Planner Accounts via the CData Sync CLI
Replicate multiple Microsoft Planner accounts to one or many databases.
-
How to Query Live Sybase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sybase data in natural language using Python.
-
Integrate Microsoft OneDrive in the Pentaho Report Designer
Publish reports based on Microsoft OneDrive in the Pentaho BI tool.
-
Visualize SAP Fieldglass in TIBCO Spotfire through ADO.NET
Integrate SAP Fieldglass into dashboards in TIBCO Spotfire.
-
Replicate Twitter Ads from PowerShell
Write a quick PowerShell script to query Twitter Ads. Use connectivity to the live data to replicate Twitter Ads to SQL Server.
-
Analyze Sugar CRM in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Sugar CRM in Microsoft R Open.
-
Build AI/ML Models with Live HDFS Data using Dataiku
-
