i want to search with in oracle database.
can we do this with omnifind?
is anyone having any material regarding that??
thanks & regards,
Pinned topic how to crawl Oracle database in omnifind?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2005-11-22T15:29:00Z at 2005-11-22T15:29:00Z by SystemAdmin
SystemAdmin 110000D4XK2014 Posts
Re: how to crawl Oracle database in omnifind?2005-11-22T15:29:00ZThis is the accepted answer. This is the accepted answer.Hi Vishal,
I'm guessing you solved your installation problem!
OmniFind does support searching an Oracle database. For that, you need to install and setup WebSphere Information Integrator Standard Edition and federate your Oracle database with DB2. OmniFind crawls Oracle via WebSphere II Standard Edition's federation technology.
Here's what you need to do:
- Install the Oracle client and configure it to connect to your Oracle database. Test with SQLPLUS to make sure that you can connect to your database and issue basic select statements.
- Install WebSphere II Standard Edition on top of DB2. The installer should recognize the Oracle client and do the appropriate setup
- With the DB2 Control Center, create a "wrapper" for Oracle, then a server, a user mapping and then nicknames for all the tables/views that you want to search. Test with the DB2 command-line that you can issue select statements against those.
- In OmniFind, create a DB2 crawler and configure it to crawl the nicknames created in the previous step.
If you need help with the database federation setup, please refer to the WebSphere II Standard Edition documentation, or the following IBM redbook http://www.redbooks.ibm.com/abstracts/sg247052.html. There should also be tutorials on developerWorks