Share via


Aggregation Across Multiple Data Sources

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

This topic describes the ability of the OLE DB Provider for Commerce Server to aggregate profile object data from multiple disparate data sources into a single homogeneous OLE DB Row object.

The data aggregation layer handles requests for fetching specified properties of profile object data, inserting new profile objects, deleting profile objects, updating specified properties of profile object data, and combining the results of running search queries simultaneously across multiple data stores.

The data aggregation layer provides support for the following data source types:

  • Microsoft Active Directory

  • Microsoft SQL Server

  • ADAM (Active Directory Application Mode)

The data aggregation layer is optimized for performance and scalability against Active Directory and SQL Server stores.

The data aggregation layer is implemented as four components:

  • Aggregation layer, which is part of the OLE DB Provider for Commerce Server itself

  • Directory component

  • Microsoft SQL Server

  • LOB stores component

The aggregation layer processes requests by splitting them into sub-requests appropriate to each aggregated data store and passing them to components responsible for those stores.

See Also

Other Resources

Profiles Concepts and Tasks