Configure Business Data Connectivity Service SharePoint 2013

SharePoint’s Business Connectivity Service (BCS) is intended to provide SharePoint access to a variety of data sources to include:

• SQL Server
• .NET
• WCF Service
• SOAP
• REST Service Connection
• XML file connection

Business Connectivity Services works.

1. BCS Definitions are based on ‘operations’, Create, Read Item, Read List, Update and Delete
2. BCS allows you to work directly with data stored in an external system or database
3. Authentication can be done directly using User authentication or the SharePoint Secured Store Service can be used to authenticate with a specific account
4. Information can be one-way (view only) or two-way (add, update & delete)
5. BCS data sources can be ‘associated’ to one another to create ‘relationships’ – One-to-Many, One-to-One, etc.
6. BCS Connections can be made using SharePoint Designer (easiest) or through Visual Studio
7. BCS ‘definitions’ can be exported and imported across sites
8. BCS is based on the “Business Data Catalog” and uses BDC definitions to access “line of business” (LOB) data.
9. WCF provides the most flexibility and control of data and is best when multiple data sources must be combined to create the desired view

Step 1: Configure the BCS on following link steps.

http://www.c-sharpcorner.com/UploadFile/Roji.Joy/how-to-configure-business-data-connectivity-service-sharepoi/

Step 2: Ctreate external list in following link step

http://www.codeproject.com/Articles/683749/Implementing-Business-Data-Connectivity-in-SharePo

Sometime following error occurred in the  BCS:

Error 1:

There are no addresses available for this application.

Solution:

Go to Central Administration --> Application Management --> Under Service ApplicationsClick Manage services on server. Start business data connectivity service.IIS Reset.

Error 2: 

An error has occurred in the providers configured from this site collection

Solution:

http://wscheema.com/blog/Lists/Posts/Post.aspx?ID=7

Error 3: 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.

Solution:Execute the following powershell commands:

Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000

 $BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs

$BCSThrottle

Reference:

http://akanoongo.blogspot.in/2011/02/how-to-resolve-2000-items-resolution-in.html