Configure Business Data Connectivity Service in SharePoint 2013

 SharePoint Business Connectivity Service (BCS) is used 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 used for.

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

With BCS, you can bring information into SharePoint from a variety sources. For example, you can bring data from an external SQL Server database, a traditional web service, a WCF service, proprietary systems, and OData services.

Follows the steps to start the Business Data Connectivity service:

1.      Open the SharePoint Central Administration that you want to start BCS service.

2.      Click System Settings.

3.    Under Service Application category clicks "Manage services on server". 

 

 

4.      Make sure the server name as Business Data Connectivity Service server name, if not name the change the server name

5.  Look for Business Data Connectivity Service and if stop then start.

 

Follows the steps to create a new Business Data Connectivity Services service application

Open the SharePoint Central Administration using Farm administrator account.

The farm must have started the Business Data Connectivity Service.

2.      Click on "Application Management".

3.    Under Service Application category clicks "Manage services applications ". 

 

 

 

4.      If Business Data Connectivity Service Applicationinstance already running then skip the rest of this steps. Otherwise follow the rest of steps to create one.

5.    Click "New" on SERVICE APPLICATIONS and then click on "Business Data Connectivity Service"

 

6.      Now configure the setting in the Create New Business Data Connectivity Service Application.

7. Provide the Name of Service to create new service application.

This BCS service application can be used by multiple BCS solutions.

8.      Database automatically fills only you will provide database name and authentication as recommended windows authentication.

 

 

9.      If you have SQL Server database mirroring configured and want to add in Data Connectivity Service database in mirroring, then enter the name of failover database server name in Failover Database Server.

 

 

10.  Provide the Application pool name for service if you do not have created pool then create new click on Create new application pool and enter the name "SharePointServiceApps" This application pool use be use all service applications. More on planning, creating and configuring service applications, see Manage service applications in SharePoint 2013.
 

11.  Select the Service account that configured for deploying a Business Connectivity Services on-premises solution in the SharePoint 2013.
 

12. After confirm, Click on “OK” button to create new Business Data Connectivity Service Application and click "OK" again.
 

13.  Select the row that the Business Data Connectivity Service Application is in, not the proxy row.

14.  Add an account for Administrators of the Business Data Connectivity service and select Full Control permission.

 

   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: 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

 

Thank you very much

          Fahadullah Karimi

         SharePoint Specialist

http://sharepoint-solution-tricks.blogspot.com/

• Previous Post
• Next Post

JavaScript Object Model(JSOM) in SharePoint 2013

Create External list using Business Data Connectivity in SharePoint 2013