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.
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/
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.
On the Service Application ribbon, click Create, and then New, Select Business Data Connectivity Service.
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:
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.
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.
Grant the necessary service accounts access permissions.
Click OK to finish.
Start the Services
- In Central Administration, under Application Management, click Manage Services on Server.
- Find the Business Data Connectivity Service and Start it.
Create a Site Collection for the Business Data Connectivity Services
- In Central Administration, under Application Management, click Create Site Collection.
- 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.
Click OK to create the site collection.
Click OK again.
Ensure BCS Services are running on the farm
- Navigate to the site, located at: http://spent:8080/sites/BCS/_layouts/15/start.aspx#/SitePages/Home.aspx
- Click on the gear icon in the upper right corner , and select Site Settings.
- On the Site Settings page for the site collection, under Site Collection Administration, click Site Collection Features.
- Locate PerformancePoint Site Collection Features and click Activate.
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.
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.