SharePoint Business Connectivity Services - Part 2

1. Click Next.

2. Click Add Filter Parameters button.  In the Properties pane, select Country in the Data Source Element drop down. Click Click to Add link in the Filter field.


3. Keep all default options and click Ok. The Filter Type is Comparison. The Operator is Equals and the Filter Field is Country. In the external list, the filter will default to Country field. User will select a country in the filter column to see records for that country.

4. In Properties pane, in Default Value, type US.

5. Click Finish.

6. Click Save button in the menu.

7. Click Create List & Forms button in the ribbon to create an external list based on the external content type you just created.

8. Type NewECT in the List Name. If you want to create an InfoPath form for your list, check Create InfoPath Form checkbox. I left it unchecked because I wanted the default form to be used. Click OK to save the settings.

Figure 4: Create new external list

9. Select Lists and Libraries from the left side under Site Objects. In the right pane, under External Lists, you will see newly created list. Click it to open.

10. Click Preview in Browser button in the ribbon to open the list in the browser.

11. You will see Access denied by Business Data Connectivity error. There are a few things that you need to be aware of before the list can be previewed in the browser. You have to set permissions in the Central Admin site. Steps below will take you through the whole process for setting up the pre-requisite permissions. Common errors that you get when viewing external list in the browser are as following:

• BCS Access Denied. 
• BCS login failed for user NT Authority

BCS Access Denied

In SharePoint 2013, If you have set up Business Connectivity Services, or BCS for short, and now you are trying to access an external content type in a list but you get “Access denied by Business Data Connectivity”, here is you will solve it.

Figure 5: Access denied by Business Data Connectivity

This error occurs because the logged in user does not have permissions on the external content type that you had created. To resolve the issue go to central administration site and give permissions to specific users on the external content type.

1. Open SharePoint Central Admin site.

2. Click Application Management.

3. In Service Applications section, click Manage service applications.

4. Click Business Data Connectivity Service. 

5. You will see your external content type listed on this page. Select it (by checking the box) and click Set Object Permissions button in the ribbon.

Figure 6: Set Object Permissions

6. This will open a dialog box. Enter username that you want to give permission to in the box and click Add. Select the added user in the box below and select permissions for that user by checking the boxes against the listed permissions. Depending on the type of user, you can select which permissions to give. For example, giving them Execute permission will let them see the results. If the user is admin type, then give them all the permissions. Lastly, check the box at the bottom to “propagate” permissions to all methods of the external content type. Click OK to save the settings.

Figure 7: Add an account

Also, if you want to give access to all users in the organization, add NT Authority\Authenticated Users in the box at the top and click Add and then assign desired permissions as described above. When you add authenticated users, you see All Users (windows) listed as one of the users.

Figure 8: Add All Users (windows)