Learn more
 

Latest News

Stay informed about our newest developments, awards, and releases.


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.

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.