i want to search with in oracle database.
can we do this with omnifind?
is anyone having any material regarding that??
thanks & regards,
This topic has been locked.
2 replies Latest Post - 2013-11-06T09:01:22Z by dikkini
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 PostsACCEPTED ANSWER
Re: how to crawl Oracle database in omnifind?2005-11-22T15:29:00Z in response to SystemAdminHi 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