SSP provided with MOSS, which enables us to integrate back-end-line-of-business (LOB) systems with SharePoint. For example, data from a SQL Server table can be pulled and displayed in lists, web parts, search results, user profiles etc, with no coding absolutely. One time external system data source is registered with Shared Service Administration site via an XML file and BDC performs all of the operations necessary to use the data in SharePoint. This XML file is the metadata database which describes the target data source.
To improve the performance, BDC infrastructure uses a data cache to hold metadata to minimize trips to the metadata database.
MOSS ships with two basic parts along with several others for BDC.
- Business Data List
- Business Data Item