SharePoint How to Add business Data Connectivity Services

In our last post we learned about adding a service. In this post we will learn about creating a business data connectivity services.

SP 2013 Enterprise: Business Data Connectivity Services
Install of SharePoint 2013 working
SharePoint Designer 2013 installed
Created Active Directory user accounts needed for the setup of the Secure Store

Load up SharePoint Designer.
It may ask you to configure updates, select ask me later and then Select Accept.

open sp site

You will have a prompt for Office, select Next, Next, (I picked background circuits but you can pick anything) select Next, select no thanks, and then all done.


Set the default site location, by selecting open site, and set it to site: http://spent:8080/

selecting site

selecting site

Select Open.

Now Select the site. In another window open the Central Administration at site: http://spent:22932/default.aspx

Under Application Management, click Manage Service Applications.

app mgmt selector

On the Service Application ribbon, click Create, and then New,  Select Business Data Connectivity Service.

selecting service apps

Give the Service Application a name, for example: Business Data Service

The database server entry should autopopulate. Remove the guid attached to the Database Name for simpilicity:

BDC_Service_DB_c6fb3fd3-68ab-4015-abe8-847cc8bff527 should be BDC_Service_DB

Give the Application pool name a name, for example: BDCAppPool.

Fill out the following details:

Business Data Connectivity app details

This application pool will be managed by the CLD\SPDB account, so no changes are needed. Select OK to create the Business Data Connectivity Service Application.

create biz app

Success, click OK to close.

After the service application has successfully created, hover over the service application name until it turns into a hyperlink. Click the link to manage the service application.


On the Edit ribbon, click Permissions, and then Set Metadata Store Permissions.

Ribbon set metadata store permissions

Grant the necessary service accounts access permissions.

set permissions detailed

Click OK to finish.

Start the Services


  1. In Central Administration, under Application Management, click Manage Services on Server.
  1. Find the Business Data Connectivity Service and Start it.



Create a Site Collection for the Business Data Connectivity Services


  1. In Central Administration, under Application Management, click Create Site Collection.
  1. In the Title box of the Create Site Collection page, enter BCS Sample Site.

3.   In the URL section, select the /sites/ option in the drop-down box, and enter BCS in the text box.

4.  In the Template Selection section, choose Team Site.

5.  Enter one or two login accounts to serve as the site collection administrators, as shown in the Figure . In this example, the SharePoint Administrator (SPAdmin) account was set as the primary administrator. Click OK.

template selection details 1

Click OK to create the site collection.

creating top site

Click OK again.

Ensure BCS Services are running on the farm


  1. Navigate to the site, located at: http://spent:8080/sites/BCS/_layouts/15/start.aspx#/SitePages/Home.aspx


  1. Click on the gear icon in the upper right corner , and select Site Settings.


  1. On the Site Settings page for the site collection, under Site Collection Administration, click Site Collection Features.


  1. Locate PerformancePoint Site Collection Features and click Activate.

performance point

5. Use the browsers back button to go to Site Settings, and under the Site Actions heading, click Manage Site Features.

6. Locate the BICenter Data Connections Feature and click Activate.

bicenter connections feature


That’s it. Business Data connectivity services are now running on the SharePoint server farm. In the next post we will discover how to add a database.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s