CData ODBC Driver for SharePoint 2015

Overview

The CData ODBC Driver for SharePoint 2015 allows you to access data from SharePoint using the standard ODBC interfaces. The driver abstracts the underlying data source into tables, views, and stored procedures that can be used to both retrieve and update data.

The Getting Started section explains how to connect and create an ODBC DSN. The Using the ODBC Driver section describes how to use the ODBC driver in some of the popular applications that connect via ODBC.

The Supported SQL section shows the SQL syntax supported by the driver and points out any limitations.

An important feature of the driver is the ability to easily cache data locally. This allows the driver to be used in an offline mode when access to the data source is not possible. It also enables complex SQL queries that are otherwise not supported by the underlying data source itself. See the section Caching Data for more details on this feature.

The Data Model section lists the tables, views, and stored procedures available for the driver.