We are trying to gauge whether Sharepoint 2010 search capabilities will work for a particular set of search requirements, which are these:
1. Data is scattered across a number of locations.
2. Some data is unstructured (text files, images, etc).
3. Some is stored in relational databases (oracle, sql server, sybase, mysql, etc)
What our customer would like to be able to do is to do keyword searches across all of these data sources, both the structured and unstructured, and return the results in an OpenSearch compatible format.
I think the unstructured data can be searched out of the box.
My understanding with respect to the structured data is that SP 2010 can search it, with the provision that we would need to write one or more federated search connectors for the structured data sources and then connect SP 2010 to these connectors to do
In other words, it is not possible right now to tell SP 2010 out-of-the-box to crawl databases a, b, and c, and more specifically certain tables and columns in each of those databases, and make them available directly for search.My understanding is that
those decisions and legwork would need to be done through the connector that we would write, and that SP 2010 could consolidate the results presented by each of the connectors. Is this correct?
View Complete Post