Create a New Search Profile that Uses an Oracle Database
The procedures here describe how to create a new search profile that uses an Oracle Database.
Note: Because of how Oracle works, the computer where the Search profile is located must be on the same local network as the Oracle server.
Pre-Requisites for Oracle database connectivity:
- An Oracle driver must be installed on the system.
- The currently logged on user must have access to the Oracle database through the network.
- A database must be created on the Oracle server. It is suggested to call the database
Search
. - A username and password must be defined in the user options and this username must have access to the Oracle server and its Search database (see Set User Options).
To create a search profile connected to an Oracle database
- Open OL Connect Search.
- Go to File, New, Oracle Profile...
- Enter the name of the Oracle database, provided by the database administrator then click OK.
- Browse to the location you want to save the search profile (prf file).
- Enter a name for the profile then click Save.
Once your profile is created, additional actions may be done on the profile:
- To share a profile on the network between multiple users, see Sharing A Profile On The Network.
- To edit the profile manually to change additional options, see Search Profile Contents Line by Line.