In this article we can explore how to configure BCS External Content Type in SharePoint 2013.
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.
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.
Create a new SQL Server table named Customer.
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.
Open SharePoint Designer 2013 & Go to External Content Types pane as shown below.
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.
You will get the following dialog. Choose Add Connection option.
In the appearing dialog choose SQL Server.
Enter the Credentials to SQL Server.
Choose our table. Right click and choose Create All Operations.
You will get the following wizard.
Click Next with default values.
Now we need to create the List Instance. Go to Lists and Libraries in Designer and click the External List ribbon item.
Choose our Content Type from the appearing dialog box.
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.
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.
Once you can see the data like above – You have successfully configured BCS External Content Type.
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.
Login failed for user
In this article we have explored how to configure BCS External Content Type in SharePoint 2013.