Aggregation Across Multiple Data Sources
This topic describes the ability of the OLE DB Provider for Commerce Server Core Systems 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 Core Systems 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.