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.
Transfer data from Excel to QuickBooks using the CData Excel Add-In
This article explains how to transfer data from Excel to QuickBooks using the CData Excel Add-In for QuickBooks. For this example, we will use the Customers table;however, the same process will work for any table that can be retrieved by the Excel Add-In.
How to Execute Stored Procedures with the CData BizTalk Adapter for Salesforce
You can use stored procedures provided by the CData BizTalk Adapter for Salesforce to automate working with Salesforce data in BizTalk. Stored procedures implement actions available in the underlying API.
Configure a One-Way Send Port for the CData BizTalk Adapter for Salesforce
Use the CData BizTalk Adapter for Salesforce with a one-way send port to execute updategrams and data manipulation SQL in BizTalk.
Configure a Solicit-Response Send Port for the CData BizTalk Adapter for Salesforce
Use the CData BizTalk Adapter for Salesforce with a solicit-response send port to execute updategrams and data manipulation SQL in BizTalk.
Configuring a Receive Location for the CData BizTalk Adapters
This article will show how to configure a Receive Location using the CData BizTalk Adapters to pull data from a data source. The steps included discuss creating the receive location, setting up the connection string, configuring the location to pull data daily, and writing it to an XML file.
Using the CData JDBC drivers with the Pentaho Report Designer
The CData Data Providers (JDBC, ODBC, and ADO.NET) implement standards based access to various data source which enables third party tools to interoperate. In this article we use the CData JDBC Driver for Salesforce in Pentaho (a BI tool) to publish reports based on Salesforce data. A similar approach can be used with any other CData JDBC Driver.
Use Crystal Reports to create reports with Salesforce data
The CData Data Providers (JDBC, ODBC, and ADO.NET) implement standards based access to various data source which enables third party tools to interoperate. In this article we use the CData JDBC Driver for Salesforce from Crystal Reports to publish reports based on Salesforce data.
Bill an Invoice with the CData Excel Add-In for QuickBooks
The CData Excel Add-In for QuickBooks makes it easy to transfer data in and out of QuickBooks Desktop and QuickBooks Online. In this article, you will create an Invoice spreadsheet that can be sent to customers. Customers can then insert the Invoice data as Bills to their company files or their company on QuickBooks Online.
Using Mail Merge with Salesforce, SharePoint, or Google Contacts
The CData ODBC Drivers can be used from tools like Mail Merge in Microsoft Word to access live data from various sources (QuickBooks, Salesforce, SharePoint etc.). This article uses the CData ODBC Driver for Salesforce with Mail Merge, but this procedure can be follwoed for other CData ODBC drivers.
Generating an Entity Data Model in Visual Studio Express
The Entity Data Model Wizard can be used to easily generate an Entity Data Model in Visual Studio. However this feature is not available in Visual Studio Express. In this article you will use the edmgen utility available with .NET Framework 4.0 to generate the Entity Data Model.
