About the OLE DB Provider for Commerce Server

  • Article

The OLE DB Provider for Commerce Server is a versatile tool that serves as the Commerce Server Data Warehouse Manager as well as an SQL data storage engine. As the Data Warehouse Manager, the OLE DB Provider for Commerce Server manages the logical schema, including the classes, data members, class relations, and the surrogate keys as well as the persistent physical storage of the Data Warehouse entities. And, as a typical SQL storage engine, the OLE DB Provider for Commerce Server optimizes the data updates and retrievals from the physical database.

The OLE DB Provider for Commerce Server is a COM component that accepts calls to a subset of the OLE DB API and processes each request against the data source. The OLE DB Provider for Commerce Server provides two distinct paths of functionality. The Fastload property passed in the connection string determines which of these functionalities is used. When the Fastload property is set to True, user class data can only be written to the OLE DB Provider for Commerce Server, and not read. When the Fastload property is set to False, data manipulation statements such as Select, Insert, Update, and Delete are supported.

Of the two programming models that OLE DB supports, the Commerce Server OLE DB provider only supports the binding programming model. Using the binding programming model, an application creates a binder object that can directly bind to any of the objects supported by OLE DB, namely the Data Source, Session, Command, Rowset, Stream, and Row objects. The Commerce Server OLE DB provider does not support the Rowset programming model, which creates objects in a hierarchy by using the CoCreateInstance method.

This section contains:

See Also

OLE DB Provider for Commerce Server

Copyright © 2005 Microsoft Corporation.
All rights reserved.