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 →
Latest News
Stay informed about our newest developments, awards, and releases.
Access Salesforce Data in QlikView Using the CData ODBC Driver for Salesforce
The CData ODBC drivers expand your ability to work with data from a wide variety of data sources. For example, you can use the ODBC drivers to create visualizations that organize and present your Salesforce data in QlikView. In this article we outline simple steps to use CData ODBC Drivers from QlikView.
Using CData ODBC drivers from SharePoint Excel Services
This article demonstrates how to use the CData ODBC drivers to connect to an external data source from Excel spreadsheets in SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards in their Excel spreadsheets using data from sources like Salesforce, QuickBooks, Dynamics CRM and many more.
Access SAP Tables and SAP Queries using CData SAP Providers
In this article we explain how our SAP products obtain table information and provide a free helper utility to add additional table schemas to our SAP Providers.
Connect to Dynamics NAV with the CData OData Provider
This article uses the CData ADO.NET OData provider to retrieve data from Dynamics NAV. The process described will also work for other CData OData providers (JDBC, ODBC, SSIS, etc.).
Using Microsoft Query in Excel to Connect to Salesforce
This article uses the CData ODBC driver for Salesforce to execute SQL with Microsoft Query in Excel. It will also demonstrate using parameters.
Install a Microsoft Excel Add-In Manually
Some Microsoft Excel users may need to follow these steps to manually add the CData Excel Add-In formulas, enabling you to execute your own database queries.
Import Salesforce Data into Microsoft Power Query
The CData API Server offers standards-based web service endpoints that allow a variety of applications to get data from Salesforce. These endpoints expose data as OData, RSS, HTML, CSV, ATOM, SOAP, JSON, JSONP, and TSV. In this article, we will use the CSV format to import Salesforce data into Microsoft Power Query.
Import Salesforce Data into Google Spreadsheets
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to get data from Salesforce (plus 80+ other sources). These endpoints expose data as OData, RSS, HTML, CSV, ATOM, SOAP, JSON, JSONP, and TSV. In this article, we will use the CSV format to import Salesforce data into a Google Spreadsheet.
Update a Google Calendar with a Microsoft Access Linked Table
This article explains how to update Google Calendar events by creating a linked table in Microsoft Access with the CData ODBC Driver for Google Apps.
Excel Spreadsheet Automation with the CDATAQUERY Formula
The CData Excel Add-In provides formulas that can pull data from different data sources into your spreadsheet. For example, the Google provider can create a spreadsheet of directions. In this article we show how to use the CDATAQUERY formula to automate spreadsheets.
