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


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

Back to Part 2

Configure Search Crawl

This section is relatively quick. The only caveat is that by default BDC only returns 2000 results. For our example this is fine. But often times you will need to increase this limit significantly. Once you have the limit set to what you want you can create a new content source and run a full crawl on it.

Actions in this step:

1. Configure BDC Throttle Limit
2. Create a New Content Source and Run a Full Crawl

Configure BDC Throttle Limit


highlighting SharePoint Management Shell

Right click on “SharePoint 2013 Management Shell” and select Run as Administrator


Select Run as Administrator

$bdcProxy = Get-SPServiceApplicationProxy | where {$_.GetType().FullName -eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}

$dbRule = Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy


This will display the currently set throttle limit.

If you want to change that number use the following:

Set-SPBusinessDataCatalogThrottleConfig -Identity $dbRule -Maximum 1000000 -Default 10000


Create a New Content Source and Run a Full Crawl


selecting Manage service applications

Back in Central Administration return to “Manage service Applications”


Select Search Service Application

Click “Search Service Application”


select Content Sources

Click “Content Sources”


Select New Content Source

We are going to add our new content source so click on “New Content Source”


Name AdventureWorks then click Line of Business Data

Select a new name, Select “Line of Business Data”, Select the service application we created earlier “Business Data Connectivity Service”, Select “Crawl selected external data source” and select “AdventureWorks”

select start full crawl

Click on “Start Full Crawl”


select Crawl Log

While the crawl is running you can view its progress via the “Crawl Log”


Select AdventureWorks

Click on the “AdventureWorks” Content Source you created.


Log Details Refresh

Now keep hitting refresh and will the crawl to go faster.


Configure Search Schema

In this step, we are going to be mapping Managed Properties. SharePoint 2013 decided to rename the link to this area “Search Schema”. When the Full Crawl Ran it created several Crawled Properties based on the fields that we mapped in our External Content Type. In order to use these in our Search Results and Refinement Panel, we need to map them to Managed Properties and configure their properties. SharePoint can also be configured to automatically generate Managed Properties, but you will often need to rename/reconfigure these.

We will:

1. Review the Crawled Properties
2. Create and Configure New Managed Properties

Review the Crawled Properties


Select Search Schema

Once the crawl completes successfully Click “Search Schema”


Select Business Data

Click on “Crawled Properties”, Select “Business Data” from the drop-down and note all the new properties available.


Create and Configure New Managed Properties


Select New Managed Property

Now click on “Managed Properties” and click “New Managed Property”.  We will be creating 3 properties for use in search.


Add AdventureWorksProductName then select Text and click Searchable and Queryable, retrievable

The first Property we will be adding is AdventureWorksProductName.  It is just a plain text and we just want it to be Searchable and Queryable.


Add a mapping

Click “Add Mapping”


Select Business Data, name,

Select the “Business Data” Category and type in “name” to retrieve a list of properties

Add a mapping to “vProductModelCatalogDescriptionRead ListElement.Name”

Modified Data Propoerties

Do the same for the Modified Date field we added, except be sure to select “Date and Time” as the data type.

Refining and Sorting

We are also going to be refining and Sorting on this field.  NOTE: You will need to perform a FULL crawl in order to see these changes.


Add the mapping just as we did for the first property.

Finally, do the same for the Add a mapping to “vProductModelCatalogDescriptionRead ListElement.Color” but make sure to select Text instead of Date.

Configure Search Page

In this section, we are going to create a search results page to display our search results, so that we can use some of our refinement fields as well. This can be done on a site you create, or you can just create a new page in your search center, or edit an existing one.

In this section we will:

1. Add Search Web Parts to a Page
2. Configuring the Refinement Web part

Add Search Web Parts to a Page


Search Site Homepage

Navigate to the site you created and edit the homepage and delete all the default web parts on the page.

Add Webparts

Click on the top area, then “INSERT”, “Web Part”, “Search”, “Search Box” then Click “Add”


Edit Refinement Webpart

Edit the “Refinement” Web Part.

Configure the Refinement Web Part

Choose Refiners

Click “Choose Refiners…”


Refinement Properties

Here we will select the two fields that we added and marked as refinable: “AdventureWorksColor” and “AdventureWorksModifiedDate”


BDC Search

Note that the item template is not necessarily displaying the information we want.  So in another blog post, we will change this.


Item Profile Page

Clicking on an item results in the profile page.

So that covers the basics on using BDC with Search. Combining this with other content sources and customizing the search results can produce a robust application revolving around SharePoint search capabilities. I have worked on several of these solutions across a variety of DoD, DoJ, and civilian agencies as well as commercial entities with the MetroStar Systems team, and we have had excellent results thus far.