Defining an executor lookup data source

Use the Optim™ preferences to define a lookup data source for the executor platform.

A database connection that includes a schema named EXTENDED_LOOKUP is required.

To use the identity privacy lookup policies, the database must include the tables from the EXTENDED_LOOKUP schema provided with the sample data.

The default connection for the executor lookup data source is the Optim Replacement Data connection profile, which is based on the EXTENDED_LOOKUP schema in a local management server installation.

You can add the connection in the Data Source Explorer view or create a connection when you define the lookup data source.

To define a lookup data source for the executor platform:

  1. Click Window > Preferences. The Preferences window opens.
  2. In the navigation tree, expand the Optim node and then click Executor Lookup Data Source. The Executor Lookup Data Source page opens.
  3. Click Edit. The Executor Lookup Data Source Selection window opens.
  4. Select a connection to the lookup data source that contains a schema named EXTENDED_LOOKUP. You can also create or edit a connection.
  5. Click OK.