Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Administration of Excel Services
As shown in Figure 7-19, the Provider section of the page contains the following settings for the trusted
data provider properties:
Provider ID — The unique provider identification for this data provider. For example, the
MSOLAP.3 provider ID is associated with Microsoft Object Linking and Embedding (OLE) DB
Provider for OLAP Services 9.0.
Provider Type — Identifies the data provider type for this data provider, and determines the
driver that the ECS uses when accessing the source. The default selection is OLE DB. You have
three options for this setting:
OLE DB — The data provider accesses an OLE DB data source using a driver installed
on the ECS.
ODBC — The data provider accesses an ODBC data source using a driver installed on
ODBC DSN — The data provider accesses an ODBC data source using a system DSN
defined on the ECS.
Description — An optional field that you can use for documentation of the trusted data provider.