4. Install 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. Select open site, and set it to site: http://spent:8080/
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.
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 auto-populate. Remove the guid attached to the Database Name for simplicity:
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.