5.3 Configuring the Global Setup

The Identity Tracking Solution Pack requires some global configuration that must be completed. This configuration needs to be completed before any additional configuration. The configuration information is contained in the Identity Tracking Solution Pack.

If you have completed these global configuration task for another use case, you can skip the following sections:

5.3.1 Accessing the Global Setup Configuration

To access the Global Setup configuration information:

  1. In the Sentinel Control Center toolbar, click Tools > Solution Packs.

  2. Double-click the Identity Tracking Solution Pack entry in the Solution Packs Manager.

  3. In the left pane, select Identity Tracking Solution Pack > Solution Pack Controls > Global Setup, then click the Implementation tab in the right pane.

    Global Setup Documentation

5.3.2 Configuring the Sentinel Data Field

The Sentinel data field must be able to hold Identity Manager attribute data.

  1. Start the Sentinel Control Center, then click the Admin tab.

    Admin tab in Sentinel

  2. Select Admin > Event Configuration from the toolbar.

  3. In the left pane, browse to and select ReservedVar43.

    The tag is rv43.

  4. In the Label field in the right pane, change the display label to Data, then click Apply.

  5. Click Save, then close the Event Configuration window and reopen it to see the changes take place.

5.3.3 Adding SQL Indexes to Speed Up Queries

The performance of queries for certain reports in the Identity Tracking Solution Pack is increased if you add indexes to the database. These indexes increase the speed of queries against the large database.

To add the indexes for the Oracle database:

  1. Copy the oracle_index.sql file under the Description tab to a system that contains a database client capable of connecting to the Sentinel database server.

  2. Connect to the Sentinel database via SQL*Plus as the ESECDBA user.

    For example, if your database name is ESEC, the user name is esecdba@ESEC.

  3. Execute the SQL script by running the following command at the SQL> prompt:

    @/file_location/oracle_index.sql

    After the script is successfully executed, the required indexes are created in the Sentinel database.

To add the indexes for MS SQL 2006:

  1. Copy the msqsql_index.sql file under the Description tab to a to a system that contains a database client capable of connecting to the Sentinel database server.

  2. Connect to the Sentinel database via MS SQL Server Management Studio as the ESECDBA user.

  3. From the toolbar, select File > Open > File, then browse to and select the mssql_index.sql file.

  4. (Conditional) If the database is not set to the default of ESEC, then in the Microsoft SQL 2006 server, click View > Toolbars > SQL Editor > Access Database, then select Sentinel Database from the drop-down list.

  5. In the toolbar, click Query > Execute to execute the SQL script.

    After the script is successfully executed, the required indexes are created in the Sentinel database.