BCS External Content Type Configuration

 

In this article we can explore how to configure BCS External Content Type in SharePoint 2013.

BCS

BCS (Business Connectivity Services) allows Interfacing to Data that does not Live in SharePoint. For example, we can connect to External Databases, OData Sources etc.

When to use BCS?

The ideal scenarios to use BCS are:

· To leverage an existing SQL Server Table containing Data. BCS would free us from duplicating the Table in SharePoint. BCS also saves the cost involved in Synchronizing Data if there are users working on updating the source table.

· In Internal SharePoint application requiring data from External application. In this case we can create Custom .Net BCS Providers.

BCS Example

In our example we are creating a BCS List pointing to SQL Server Table. Please follow the steps below to create the BCS List in SharePoint. After the List creation, you will be able to Add/Edit/Delete items in the List & everything will reflect back in the SQL Server Table.

Step 1

Create a new SQL Server table named Customer.
image

Use the following structure:

1. Id Integer Identity

2. Name Nvarchar (max)

3. Address Nvarchar (max)

Fill the Table with some data as shown below.
image

Step 2

Open SharePoint Designer 2013 & Go to External Content Types pane as shown below.

image

Choose the External Content Type button from the left pane for creating a New External Content Type. (External Content Type is the keyword for referring BCS Content Types)

Enter the Name for the Content Type and click the highlighted area below to configure External Data Source.

image

You will get the following dialog. Choose Add Connection option.

image

In the appearing dialog choose SQL Server.

image

Enter the Credentials to SQL Server.
image

Choose our table. Right click and choose Create All Operations.
image

You will get the following wizard.

image

Click Next with default values.

Step 3

Now we need to create the List Instance. Go to Lists and Libraries in Designer and click the External List ribbon item.

image

Choose our Content Type from the appearing dialog box.

image

Click OK to continue. Enter the name as Customers for the list. Now you have successfully created the List Instance of our External Content Type.

Step 4

Now we can Test our new List. Open SharePoint & You should be able to see the Customers list in the Quick Launch. Click on it to see the items below.

image

Once you can see the data like above – You have successfully configured BCS External Content Type.

Errors

It is not surprising that you may get the following errors. You can refer the associated links to resolve them.

Access denied by business data connectivity.

http://www.jeanpaulva.com/index.php/2016/01/23/bcs-error-access-denied-by-business-data-connectivity/

Login failed for user

http://www.jeanpaulva.com/index.php/2015/12/27/bcs-error-login-failed-for-user/

AuthenticationMode RevertToSelf

http://www.jeanpaulva.com/index.php/2015/10/18/bcs-error-authenticationmode-reverttoself/

References

https://technet.microsoft.com/en-us/library/ee661740.aspx

Summary

In this article we have explored how to configure BCS External Content Type in SharePoint 2013.

Leave a Reply

Your email address will not be published. Required fields are marked *