This article explains how we can search the LOB data in SharePoint 2010
My last article talked about how we can Access LOB data using business connectivity
. Now we will see how
to configure search for LOB data.
Since in earlier post we have created
External Content Type i.e. Customer
, we will be configuring search for
the same ECT.
Firstly create ECT profile page as shown in the below
Click on configure from ribbon and set up the site to allow
profile page creation.
ok to create a profile page. On successful creation of profile page you will see
the default action URL. This URL is used to display the customer
search on Customer ECT. To achieve this, create Content Source and search scope
on the same Entity.
Go to Central AdminaManage Service Applicationa
Search Service Application. Create Content Sources.
To create content
sources edit Search Service Application
and navigate to Content
and click on Create New Content Source
the Name of Content source in this case Customers, select content to be crawled
as Line of Business Data
and select AdventureWorksLT2008
external data source.
Finally check the Start full crawl of the
On successfully creating content sources allow it crawl the
content sources.Create Search Scope.
Now it's time to
create a search scope. To create search scope, click on Scopes
Queries and Results
section which lists all the scopes created. Click on
in the details as shown in the below figures.
we have created a search scope. The created search scope does not contains any
rule so we need to add rule.
Click on Add Rules.
the rule setting we need to choose the Scope Rule Type
and select content source as Customers.
use search scope it should be added to the site either in search dropdown or
Click on Site Settings -> Search
Scope -> Display Group -> Search Dropdown
the Display for the scope Customers
and position it to 1.
it your LOB data is ready to search.
Go to main site and perform a search
as shown in the below figures.
redirected to customer profile page.