The Business Connectivity Services is a fundamental application service of Microsoft SharePoint 2010. It provides capabilities to read and write data from external systems, such as Line of Business applications (LOB), web services, databases, or any other external source that offers a suitable connector
Architectural schema of the Business Connectivity Services in SharePoint 2010.
“Creating Custom Business Connectivity Services Connectors Using SharePoint Server 2010”
BDC Server Runtime will store configurations and shapes of data sources in a dedicated repository, which is called BDC Metadata Store and corresponds to a dedicated database file
The BDC Client Runtime, which is a client-side engine that can be automatically installed by SharePoint on any PC client hosting Office 2010
SharePoint Designer 2010 is the ideal solution for modeling SQL Server–based solutions and web/WCF service–based solutions.
Visual Studio 2010 works very well with custom .NET assemblies and custom connectors.
SharePoint Designer 2010 for a new ECT
ECT : External Content Type
Microsoft SharePoint Designer 2010, shown with External Content Types highlighted.
Click the Click Here To Discover External Data Sources And Define Operations link adjacent to External System
Click on Add connection, and provide connection details
SharePoint Designer 2010 gives you the following three options:
Using the SharePoint Designer 2010 interface, you can define the following operations:
Read Item Corresponds to the method for reading a single row/item.
Read List Corresponds to the method for reading a list of rows/items.
Create Creates a new row/item.
Update Updates an already existing row/item.
Delete Deletes an already existing row/item.
New Association command with which you can create a relationship between two ECTs in a master/detail fashion.
SharePoint Central Administration page for managing Business Data Connectivity Services
You can create the external list from SharePoint Designer 2010 or from the web browser.
Choose an External List template and create it.
In the standard properties select the target ECT, and you are done
User experience is exactly the same of browsing a native list of SharePoint.
You can export the ECT model by using SharePoint Designer 2010 or via the management page of the Business Data Connectivity Services service application.
If you try to export the Customer ECT definition, an XML file with extension .bdcm
(Business Data Connectivity Model)