I am quite new to SharePoint. I am tasked to develop SharePoint solution for following requirements.
Basically it is Search and Display Results
BUT (There is always a BUT, Right!).
SharePoint Site Collection Owner will enable which fields end user can search from a long list of fields. Like a Check box against each fields.
End User can search only on those fields.
We have different data sources. There should be some way to enable or disable a data source(s); again SharePoint Site Collection Owner will enable data source(s) end user can search from list of data sources, like a check box against each data source.
These different datasoruces will not have same column names. E.g.: First Name, Last Name in DatasourceX can be Fore Name and Surname in DatasourceY. Column names will be different in different data sources.
All external data sources are different databases in Oracle Database.
When user enters the search term and clicks on Search button. System should present end user with few column names and if the end user is interested in the record, end user will click on the record and system should present with detail view.
Search should deliver results very fast any search taking more than 30 seconds to deliver will not be used.
User should be able to search results for future reference.
As i said i am very new to SharePoint. Can any one of you experts design a possible solution please?
Will it be web part, visual web part, fast search, etc?