Aggregation Across Multiple Data Sources
This topic describes the ability of the provider 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 7.0
Line-Of-Business (LOB) store with the following support:
- An OLE DB/Open Database Connectivity (ODBC) provider with support for a simple published subset of ANSI SQL,
or
- A Lightweight Directory Access Protocol version 3 (LDAPv3) compliant directory store.
The data aggregation layer is optimized for performance and scalability against Active Directory and SQL Server 7.0 stores.
The data aggregation layer is implemented as four components:
Aggregation layer. This layer is part of OLE DB Provider for Commerce Server itself.
Directory component.
Microsoft SQL Server 7.0 component.
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.