1 Oct 2011

Business Connectivity Services SharePoint

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.

Architectural schema of the Business Connectivity Services in SharePoint 2010.

“Creating Custom Business Connectivity Services Connectors Using SharePoint Server 2010”
http://msdn.microsoft.com/en-us/library/ff953161.aspx

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

Step 1:

image

Microsoft SharePoint Designer 2010, shown with External Content Types highlighted.

Step2:

image

Step 3:

Click the Click Here To Discover External Data Sources And Define Operations link adjacent to External System

Step 4:

Click on Add connection, and provide connection details

SharePoint Designer 2010 gives you the following three options:
.NET Type
SQL Server
WCF Service

Operations Designer window for an ECT.
Operations Designer window for an ECT.

 

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.

 

image

SharePoint Central Administration page for managing Business Data Connectivity Services

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)

No comments:

Post a Comment