Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

How does one crawl a SQL database? I want to be able to go to my SharePoint site, type in a keyword in my search bar, and have SharePoint crawl a SQL database and return desired search results.

Are various webparts going to have to be made? Like the profile page for a search results instance, is that going to require code to retrieve the information we want to see???

Thanks in advance.

share|improve this question

1 Answer 1

up vote 0 down vote accepted

This is super easy with SharePoint 2010. You need to define an External Content Type and then configure a content source, here is a nice article that will guide you: Configuring SharePoint Server 2010 Search for External Content Types (Part 1 of 2) and Configuring SharePoint Server 2010 Search for External Content Types (Part 2 of 2)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.