BCS in SharePoint 2010

Introduction

Today, in this article let's play around with one of the interesting and most useful concepts in SharePoint 2010.

Question: What is BCS (Business Connectivity Service)?
 

In simple terms "It is used to create, manage and consume any external data source".

Step 1: Open SharePoint 2010 Central Administration and navigate to a specific site.

Step 2: Open SharePoint designer 2010 and choose an "External Content Type" option as in:

 

Output1.png
 

 Step 3: The external new content type looks like this:


 Output2.png

 

Step 4: Adding data source type:

 

Output3.png
 

 

Step 5: Providing server details output of application looks like this:

 

Output4.png
 

 

Step 6: Connection established and choose a create all operations:

 

Output5.png
 

 

Output6.jpg
 

 

Output7.jpg
 

 

Step 7: Operations are now configured:

 

Output8.png
 

 

Step 8: Create a new external list and use up the created content type:

 

Output9.png
 

Step 9: The list published on the server looks like this:

 

Output10.jpg
 

 

I hope this article is useful for you.