Email: Password:       Forgot Password 
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.

Business Connectivity Services (BCS) in SharePoint 2010

Viewed:  2237 
Posted On:  24/10/2014 10:01:58 
What is BCS in SharePoint? How we can design BCS? How we can consume BCS in SharePoint? 


In this article I am going to explain BCS in SharePoint 2010. How we can make an external content type by using BCS. We will learn all of this step by step.

What is BCS ?

Microsoft Business Connectivity Services (BCS), formerly named the Business Data Catalog, enables users to read and write data from external systems—through Web services, databases, and Microsoft .NET Framework assemblies—from within Microsoft SharePoint 2010 and Microsoft Office 2010 applications

Business Connectivity Services are a set of services and features that provide a way to connect SharePoint solutions to sources of external data and to define external content types that are based on that external data. This article contains a step by step guide to design an External Content Type from SQL Server.

My SQL Server Data Base:


Image 1.

My Data Base Table in Design mode:


Image 2.

Now next task is to create an Creating an external content type

Open SharePoint Designer -> Open your site like below:


Image 3.

Click Open.


Image 4.

Select External Content types -> Click on External Content Type option.


Image 5.

Now Click (click here to discover external data source and define operation.)


Image 6.

Now Click on Add Connection -> Select SQL Server -> OK.


Image 7.

Enter your Data Base Server Name, Data Base name, Name(optional). And Click OK.


Image 8.

Here Expand your Data Table ->Right Click -> Select Create All Operations


Image 9.

Click Next .


Image 10.

Set your table column as identifier-> Click Finish.


Image 11.

Now save this from Left top Save button.


Image 12.

Now open your site -> Select Site Actions -> More options.


Image 13.

Select List -> External List -> Give name and click on Create.


Image 14.

Now click on search and external content type -> a pop up window will open -> search and select your External content type-> Ok.


Image 15.

Now Click Create.


Image 16.

Your SQL Server Data.

Now Select Item -> Add


Image 17.

Check your SQL Server Data Table also.

If there is an error message while displaying Data then Go to Central Admin .


Image 18.

Select Manage Service Applications.


Image 19.

Select Business Data Connectivity Service.


Image 20.

Make sure Set Object Permission and Set Metadata Store Permission should be like above.

         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us