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

Business Connectivity Services (BCS) in SharePoint 2010

Article:
Viewed:  989 
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:

1.png

Image 1.

My Data Base Table in Design mode:

2.png

Image 2.

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

Open SharePoint Designer -> Open your site like below:

3.png

Image 3.

Click Open.

4.png

Image 4.

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

5.png

Image 5.

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

6.png

Image 6.

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

7.png

Image 7.

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

8.png

Image 8.

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

9.png

Image 9.

Click Next .

10.png

Image 10.

Set your table column as identifier-> Click Finish.

11.png

Image 11.

Now save this from Left top Save button.

12.png

Image 12.

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

13.png

Image 13.

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

14.png

Image 14.

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

15.png

Image 15.

Now Click Create.

16.png

Image 16.

Your SQL Server Data.

Now Select Item -> Add

17.png

Image 17.

Check your SQL Server Data Table also.

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

18.png

Image 18.

Select Manage Service Applications.

19.png

Image 19.

Select Business Data Connectivity Service.

20.png

Image 20.

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

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