Configuring Business Data Connectivity Service in SharePoint 2013

Configuring Business Data Connectivity Service in SharePoint 2013:

BCS enables SharePoint 2013 to work with data that is hosted externally. Potential sources can include Sql-databases, web services, Windows Communication Foundation (WCF) services, Open Data Protocol (OData) sources.

Steps to configure BCS:

1. Open the SharePoint Central Administration from the server that contains your BCS solution.
2. On the Quick Launch, click application Settings --> Service Application --> Manage Services on Server.

1   3.   If the Business Data Connectivity Service is stopped, then start the service.

  

      4.   Open the SharePoint Central Administration website for your farm with a Farm administrator account. This must be the farm in which you started the Business Data Connectivity Service.

      5.   On the Quick start, click "Application Management".

    6. On the Application Management page under Service Applications, click "Manage service applications".

       7.       On the "SERVICE APPLICATIONS" tab, click "New" and click "Business Data Connectivity Service".

     8. Configure the setting in the Create New Business Data Connectivity Service Application configuration page.

    9. Configurable account should be the one which is used to create the BCS.

  10. Click "OK" to create the new Business Data Connectivity Service Application.

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

          

          12.    Click "Administrators" in the Operations area and add any accounts that you want to be able to administer the Business Data Connectivity service application granting them full control. When these individuals open Central Administration they will only be able to administer the Business Data Connectivity service application.