Identity Manager 8.1.4 - Configuration Guide

To extend an existing table in the Schema Extension

Start the Launchpad and log in to the One Identity Manager database.
Open the Launchpad and select the One Identity Manager Schema Extension entry. This starts the Schema Extension program.
Click Next on the start page.
On the Database connection page, check the connection data for the One Identity Manager database.
On the Select method page, select Extend table.
On the Extend table page, select the table that you want to extend from the Table menu.
On the Configure columns page, create your new columns. For more information, see Defining columns.

The technical identifier for the column is automatically formed according to the CCC_<column name> schema.

To create a simple column in the Schema Extension

On the Configure columns page, click .
Select the Simple column option and enter the name of the column under Column name.
Click OK.

On the Configure columns page, enter at least the following information.

Table 167: General column properties
Property	Description
Required field	Specifies whether a column must be filled.
Data type	Column data type Permitted .Net data types are listed in a pop-up menu. These are represented internally as SQL data types.
Length	Column length The column length is only specified for the .Net String data type.
Display name	Specifies how the column is labeled.

(Optional) Click to configure more column properties. For more information, see Advanced configuration of columns.

The technical identifier for the column is automatically formed according to the CCC_<column name> schema.
Foreign key columns are created with the String data type and a length of 38 characters.
The table relations and column relations are generated automatically.
- The relation IDs follow the naming convention:
  
  CCC-<database ID>-<4 digit sequential number>
- If a foreign key column is added to a database view, the relation IDs follow the naming convention:
  
  CCC-<database ID>-<4 digit sequential number> <Name of referenced table>
- If a column from a base table is referenced using the Base table table type, the table relations and column relations are also created for the base table.
- Validation of referential integrity is done by DLL or triggered.

To create a foreign key column in the Schema Extension

On the Configure columns page, click .
Select Foreign key column and enter the following data.
- Column name: Enter the name of the column. If possible, the name of the foreign key column should correspond to the name of the referenced table's primary key.
- From table: Select the referenced table.
Click OK.
On the Configure columns page, enter at least the following information.
- Required field: Specifies whether a column must be filled.
- Display name: Specifies how the column is labeled.

Click and enter the following information in the Key column values tab.

Table 168: Properties for foreign key columns
Property	Remarks
Foreign key	Indicates whether the column is a foreign key column. Enable the option.
From table	Referenced table for foreign key relations
Delete restrictions	Restriction for testing referential integrity when deleting an object
Insert restrictions	Restriction for testing referential integrity when inserting an object

(Optional) You can also configure more column properties. For more information, see Advanced configuration of columns.