>

Part 1: SharePoint 2013 Business Connectivity Services, Search and Profile Page Demo

6 MIN READ

01/03/2014
Part 1: SharePoint 2013 Business Connectivity Services, Search and Profile Page Demo

This topic will be separated into 3 posts. It will cover a demo with step by step instructions for SharePoint 2013 Business Connectivity Services, Search and Profile Pages. The second post will go over creating the external content types and creating the Business Data Connectivity Service. The third post will cover customizing search and profile pages.

According to Microsoft, here is what you can do with BCS:

• Reveal external data from enterprise applications, web services, and OData services in SharePoint Server 2013 and in rich-client Office applications.

• Provide Office-type behaviors (such as Contacts, Tasks, and Appointments) and capabilities to external data and services.

• Provide complete interaction with the data, including write-back capabilities from Office applications and SharePoint Server to the underlying external system data and business objects.

• Enable offline use of external data and processes.

• Bridge the unstructured world of documents and people and the appropriate structured data that is locked in external systems.

What we will be focusing on is exposing a SQL database to SharePoint 2013 Search. There are a few blogs that go through this process, but I didn’t see one that covered everything from beginning to end with screenshots. This post will go through the following steps:

1. Set up SQL Databases

2. Set up the Service Applications

3. Create the External Content Type

4. Configure Business Data Connectivity Service

5. Configure Search Crawl

6. Configure Search Schema

7. Configure Search Page


Set up SQL Databases

For this example, we will be utilizing the AdventureWorks SQL 2012 database. It is a familiar database for a store that sells bikes that Microsoft likes to use. It has a relatively simple layout and some preconfigured SQL views that we can use for our external content types. We will perform the following steps:

1. Download the Database

2. Attach the Database

3. Configure Security

Download Adventure Works Database

http://msftdbprodsamples.codeplex.com/releases/view/93587

http://msftdbprodsamples.codeplex.com/downloads/get/478214

Extract the MDF and LDF files to your SQL server.

Attach the Database

Open SQL management Studio and connect to the Instance you want to store the AdventureWorks Database.

SharePoint-pt-1-1

Right Click on Databases and Select “Attach”

Add-MDF

Click Add and Navigate to the location of your extracted files.

Select-MDF

Select the AdventureWorks MDF file you extracted.

Once the database is attached you will need to grant permissions to the user you will be using to access the BDC Connection.

Configure Security

New-Login

We will first add the user to SQL. Right-click on Login under Security and select “New Login…”

New-User

Add the new user.

Database-Permissions

Select the AdventureWorks Database then db_datareader.


Set up the Service Applications in SharePoint

We are going to need 3 service applications to be configured to be able to display the AdventureWorks Data in our Search Results.
We will perform the following Steps:

1. Create the necessary Service Applications

2. Business Data Connectivity Service

3. Secure Store service

4. Search Service

5. Configure the Search service Application

6. Create the necessary Service Applications in SharePoint

Manage-Service-Applications

Go into Central Administration and Click on “Manage Service Applications”

Select-Services

Click on New then Select Business Data Connectivity Service and make any changes to the default you need.

Do the same for the Secure Store Service and Search Service Application.

Click-Secure-Store-Service

Configure the Secure Store Service

Now Click on the “Secure Store Service”

Generate-New-Key

Click on “Generate New Key” to get started

New-Target-Application

Now you can click on New to create a new target application

Target-Application-Type

Enter in any information you like but be sure that you select “Group” as the target application type.

This is because we want everyone to be able to see the information we are going to be crawling.

Target-Application-UsernamesRemember that we created a windows user account in SQL so we want to leave these set to windows username and windows password. If we had created a SQL user we would select the regular username and password in the drop-down and change the field names accordingly.

Secure-Store-Target-AdminsAdd any administrators to the administrator's box and “Everyone” to the member's box. This is the only location where you can set the Members of the Target Application and to change this you will need to edit the application and click through next until you get back to this screen.

You can, of course, do this from PowerShell as well.

 

Set-Credentials

Now that you have created the new Target Application you can set the credentials it will use. Check the Application you created and click on “Set Credentials”. These will be the ones you added into SQL.

 

Set-Credential-Owners

Enter in your credentials with the domain name and the password. Do not be alarmed that Everyone is shown as “Credential Owners”. Basically what this means is that the credentials for any logged in user will be mapped to this accounts permissions to access the data.

Part 2 will cover more on BDC.