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

  1. Open OL Connect Search.
  2. Go to File, New, Oracle Profile...
  3. Enter the name of the Oracle database, provided by the database administrator then click OK.
  4. Browse to the location you want to save the search profile (prf file).
  5. Enter a name for the profile then click Save.

Once your profile is created, additional actions may be done on the profile: