Posted by webuneek on April 9, 2009 at 4:43pm
I am needing assistance creating a form that will allow a visitor to enter in only one field ... a 'part' number. The form will then search 5 different databases for this exact number and return a result of manufacturer name (5 possible choices for now) and phone number for that manufacturer. Each manufacturer may be using SQL, mySQL, or Oracle for their database. I will have access to these.
http://www.lassosoft.com/Products/Lasso9/index.lasso may work, however would like to implement using a Drupal module or by modifying one that executes the multiple database search feature.
Comments
Custom module for searching DB
You could write a custom module that takes the DB URLs to the multiple databases and the corresponding tables you want to search. Then in the query process, you could open connectionss and query the tables and return the result to the user. This is where you do not want to import the data into drupal or a centralized search repository.
Another way to do this for faster results would be to crawl the DB and create a search index apriori in something like Lucene and then serve the data via Apache Solr.
An alternate approach to lucene
A custom implementation of hook_search that includes index creation and flushing could work as well.