Implementing Business Data Connectivity in SharePoint 2013

Click on the "Add Connection" button, we can create a new connection. Here we have the various options to select .NET Type, SQL Server, WCF Service.



Here we selected SQL Server, now we need to provide the Server credentials.



Now we can see all the tables and views from the database.



In this screen, we have the options to create various types of operations against the database.



Click on the "Next" button.



Parameters Configurations



Options for Filter parameters Configuration



Here we need to add a new External List, click on the "External List".



Select the site here and click the "Ok" button.



Enter the list name here and click the "Ok" button.



Then refresh the SharePoint site, we can see the external list here and click on the list.



Here we have the error message "Access denied by Business Connectivity".

Solution for this error

SharePoint Central Administration, click on "Manage service application".



Click on "Business Data Connectivity Service".

Set the permissions for this list.

Click "Ok" after setting the permissions.



Then refresh the site and hope it works; but again there are problems. An error message, like Login failed for user "NT AUTHORITY\ANONYMOUS LOGON".

Solution for this error

We need to edit the connection properties, the Authentication mode; select the value "BDC Identity".



Then use the following procedure:

Open PowerShell and type the following lines:
$bdc = Get-SPServiceApplication | where {$_ -match "Business Data Connectivity Service"}
$bdc.RevertToSelfAllowed = $true
$bdc.Update();

Now its working fine.



One more error

There is a chance for one more error as in the following:

Database Connector has throttled the response. The response from database contains more than '2000' rows. The maximum number of rows that can be read through Database Connector is '2000'. The limit can be changed via the 'Set-SPBusinessDataCatalogThrottleConfig' cmdlet

If that error exists then it is due to the number of recodes existing in the table.

Solution for this error

Use the following procedure:

Open PowerShell and type the following lines and execute

$bcs = Get-SPServiceApplicationProxy | where{$_.GetType().FullName -eq ('Microsoft.SharePoint.BusinessData.SharedService.' + 'BdcServiceApplicationProxy')}
$BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs
Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000

Now it will work fine.

Summary

In this article I tried to explain how to implement the Business Data Connectivity in SharePoint 2013.