Integration (BCS)

The Business Connectivity Services (BCS) included with Microsoft SharePoint, allows exposing of data residing in other data sources through the SharePoint interface as an external list.  BCS allows a two way synchronization with your data source, so you can edit data from within SharePoint and it will be available in your data source as well.

BCS can retrieve data through a SQL Server database, web services or a custom .NET type.

 

sp_bcs