Elczar Adame's Shared Points on SharePoint

Business Data Connectivity (BDC) service is one of the service applications of SharePoint 2010 as the innovated version of the Business Data Catalog in Microsoft Office SharePoint Server 2007. It is designed to associate business application data from various sources to SharePoint sites and lists.

This piece will show us on how to setup Business Data Connectivity with External Content Type through Microsoft SharePoint Designer 2010.

Yes, you have heard me right! Through SharePoint Designer. Below are the steps:

1. Let us start by preparing our database. For our purpose, let use the AdventureWorks 2008R2 SR1 sample database.

2. The next step is to assure that our Business Data Connectivity is properly configured and started.


3.  We will now open our SharePoint Designer and create an External Content Type.


We might encounter the error below if we have not properly configured our Business Data Connectivity Service.


4. Under the External Content Type Information section, click on the External System link to discover data sources.


5. On the next window, let us click the Add Connection button to define our Data Source.


6. Then, let us define our External Data Source Type and our SQL Server Connection. Since we have used the AdvantureWorks sample database in this piece, we will select SQL Server as our external data source type and AdventureWorksLT2008R2 for our database name.



7. Now in our Data Source Explorer, we will select the Customer table and click Create All Operations. This will provide us read item, read list, create, update, and delete operations.


8. At this point, in our Central Administration > Service Application > Business Data Connectivity Service, we will set the permission of our external content type.


9. Finally, let us open our SharePoint site, add an External Content Type list, and point it to the external content type we have just created. And we will have now a SharePoint list connected to our external data source.


Hope this would help!





Digg This

Comments on: "SharePoint 2010 Business Data Connectivity–External Content Type" (2)

  1. Is it possible to ask for user input when the page is loaded?
    For example, for read list operation i have given say contact by city and user is asked to enter city name and than page is displayed containing contacts of that particular city instead of all the contacts.

  2. Jen Trinanes said:

    Hi sir Elczar,

    I created an External Content Type in SharePoint Designer using data from AdventureWorks database. After setting permissions for my ECT I created an External List and configured my ECT as the datasource. When trying to access my External List in SharePoint I got an error message: “Cannot connect to the LobSystem (External System)”

    Does it have to do with user authentication?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Tag Cloud

%d bloggers like this: