Thursday, April 18, 2013

Linked Data Sources in SharePoint 2010

In this post we will discuss what is linked data sources in SharePoint 2010. Also you can check my previous posts on Hide Ribbon from Read Access users in SharePoint 2010, Backup of Site collection in SharePoint 2010 and SPWeb.GetSubwebsForCurrentUser Method SharePoint 2010.

- A linked data source allows the designer to combine the data from multiple data sources into a single set of data. The data sources being linked need not be of the same type.
- Data from a SharePoint list could be linked with relational data or web service data.

- A linked data source can combine the information from a pair of data sources in one of two ways: merging or joining.

- The records of the two data sources are simply combined into a single list. The combined list can be sorted and filtered as though all of the data came from a single source.

- Also you can link data sources using a join operation. Joining data involves creating new records by combining the fields of related records in the two data sources. Instead of having a list containing all of the entries of both lists, as in merging data, a joined data set will contain one entry for each combination of related records. This allows you to combine different types of information from different locations to produce new insights into the data.