I am using BCS to pull Oracle data into a SharePoint external list via an .asmx web service so that it can be indexed and searched in Search Server 2010. I created a .NET connector assembly which implements ReadItem() and ReadList() methods to accomplish
this. Both methods call web service methods to either retrieve a record by id or the entire list of data, respectively. The data retrieved by the web service is done so using an Oracle stored procedure.
The data retrieved by the web service is refreshed in the Oracle database on a nightly basis by perl scripts. Because of this, search results muct also reflect any changes on a nightly b
View Complete Post