By Using BCS In SharePoint 2010 you can Create External Content Type for External Data Source and which allows you interaction in SharePoint list and Other out of the box Features. Collaboration External data with Microsoft Office Business Application like Microsoft excel, outlook, Word, Workspace Clients. Take a great advantage of Office user experience in your external business data Like Sap and other System. BCS is a Solution for business data to give standard interface for users and single development Platform for Developer to Manage Multiple Data Source and Collaboration ADO.net,Web Service,Wcf to Create New rich SharePoint Application with integrated existing external Data .
If we see BCS Arch web have two type of BCS Runtime.
1 BCS Server Side Runtime
Which Deal list by using External Content Type with SSS.
2 BCS Client Runtime
Microsoft Office with Custom Plugin and out of the box functionality for List. cache for external data source which allow offline customization.
Major Component for BCS Solutions
contain external data upon external content type
External Content Type
basic Matadata and scheme for to Manage CURD operation with external data-source. and Provide Object Model and map data Type with external system(Web Service,Db,LOB,Rest) and SharePoint.
Data Types Supported by External List InfoPath Forms
(Data form source like contacts from dynamic in outlook )
Use Secure Store Service.
To connect BCS with deferent external Systems. you need to different credentials for current user with Multiple accounts. To store all credentials for use of BCS we use SSS.
Customize External List Forms Using Microsoft InfoPath
BCS Support for Visual Studio 2010 and SharePoint 2010 designer
Visual Studio 2010
Example : http://msdn.microsoft.com/en-us/gg621216(how to Create External Content type)
Visual Studio BDC Model
Model is the major Component of BCS. Model is entity(ECT) which contain data structures. abstract Methods .
Modelling with Web Service
model will depend on the behaviours of Wcf & web service Methods with programmed on web service Side.
Every ECT should have uniquely identify an instance of that type. because without unique identifier bcs can not fine instance of entity.
External System Connectivity
You can use . Web Service and ADO as well but bcs provides out of the box connectors with biztalk and Custom Connectors API.
SharePoint 2010 Designer
ECT Designer in SPD 2010 allow you to create ECTs by connecting Web Servies and and Xml, Dd with xml and code
Example : http://msdn.microsoft.com/en-us/library/ee556431.aspx
Business Connectivities Service with XML
Types of Solution