.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month

Home >> Articles >> SharePoint >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Searching LOB Data in SharePoint 2010

Posted By:Sunil Yadav       Posted Date: September 14, 2010    Points: 25    Category: SharePoint    URL: http://www.dotnetspark.com  

Searching LOB Data in SharePoint 2010. This article explains how we can search the LOB data in SharePoint 2010.

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 image.

Click on configure from ribbon and set up the site to allow profile page creation.


Click 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 profile.

Configure 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 Sources and click on Create New Content Source.

Enter the Name of Content source in this case Customers, select content to be crawled as Line of Business Data and select AdventureWorksLT2008 as external data source.

Finally check the Start full crawl of the content source. 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 under Queries and Results section which lists all the scopes created. Click on New Scope.

Fill in the details as shown in the below figures.

Now 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.

In the rule setting we need to choose the Scope Rule Type to Content Source and select content source as Customers.

To use search scope it should be added to the site either in search dropdown or advanced search.

Click on Site Settings -> Search Scope -> Display Group -> Search Dropdown

Check the Display for the scope Customers and position it to 1.

That's it your LOB data is ready to search.

Go to main site and perform a search as shown in the below figures.

User redirected to customer profile page.

Happy SharePointing.!!!!!!!!

 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend