Newbie Sharepoint Search Questions

[HARLEY12]

My company has two SQL Server databases which have data we would like to be searched via Sharepoint. It was my understanding that Sharepoint needs physical documents in a directory to index and then a search can be performed which returns the location of these documents. I have written some code to extract the information out of the two databases and create physical files for each bit of data, but I would rather insert this data into some text fields in a SQL database and have Sharepoint search those fields instead. Is this possible?

 

[dlongnecker]

Harley12-

To my knowledge, the only way to search other SQL databases is to add that information as content databases; however, you would need to develop a front-end to display that information to your users.

SharePoint's advanced searching and indexing can index SQL databases linked as "content databases" or existing on your existing content, Exchange public folders, Lotus Notes databases, file shares, and SharePoint lists (non-Portal).

A good document for setting these up can be found at:

http://www.microsoft.com/technet/prodtechnol/sppt/reskit/c2261881x.mspx

Hope this helps!

-David

---
David R. Longnecker
Web Developer
CCNA, MCSA, Network+, A+
Management Information Services
Wichita Public Schools, USD 259

 

[HARLEY12]

Thanks David...this article looks like it is going to be really helpful!