Chat now with support
Chat with Support

Identity Manager 9.2.1 - Configuration Guide

About this guide One Identity Manager software architecture Customizing the One Identity Manager default configuration Customizing the One Identity Manager base configuration One Identity Manager schema basics
Overview of the One Identity Manager schema Table types and default columns in the One Identity Manager data model Notes on editing table definitions and column definitions Table definitions Column definitions Table relations Dynamic foreign key Supporting file groups
Editing the user interface
Object definitions for the user interface User interface navigation Forms for the user interface Statistics in One Identity Manager Extending the Launchpad Task definitions for the user interface Applications for configuring the user interface Icons and images for configuring the user interface Using predefined database queries
Localization in One Identity Manager Process orchestration in One Identity Manager
Mapping processes in One Identity Manager Setting up Job servers
The One Identity Manager Service functionality Tracking changes with process monitoring Conditional compilation using preprocessor conditions Scripts in One Identity Manager
Visual Basic .NET scripts usage Notes on message output Notes on using date values Tips for using PowerShell scripts Using dollar ($) notation Using base objects Calling functions Pre-scripts for use in processes and process steps Using session services Using #LD notation Script library Support for processing scripts in the Script Editor Creating and editing scripts in the Script Editor Copying scripts in the Script Editor Testing scripts in the Script Editor Testing script compilation in the Script Editor Overriding scripts Permissions for running scripts Editing and testing script code with the System Debugger Extended debugging in the Object Browser
One Identity Manager query language Reports in One Identity Manager Adding custom tables or columns to the One Identity Manager schema Web service integration One Identity Manager as SCIM 2.0 service provider Processing DBQueue tasks One Identity Manager Service configuration files

Creating simple columns

Technical details

  • 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

  1. On the Configure columns of table page, click .

  2. Select the Simple column option and enter the name of the column under Column name.

  3. Click OK.

  4. On the Configure columns of table 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.

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

Related topics

Creating foreign key columns

Restrictions

  • The referenced table has a one-column primary key.

Technical details

  • 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 program

  1. On the Configure columns of table page, click .

  2. 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.

  3. Click OK.

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

    • Required field: Specifies whether a column must be filled.

    • Display name: Specifies how the column is labeled.

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

    Table 168: Properties for foreign key columns
    Property Remarks

    Foreign key

    Specifies 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

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

Related topics

Creating dynamic foreign keys

Technical details

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

  • Dynamic foreign key columns are created with the String data type and a length of 138 characters.

To create a dynamic foreign key column in the Schema Extension

  1. On the Configure columns of table page, click .

  2. Select Dynamic foreign key columns and enter the name of the column under Column name.

  3. Click OK.

  4. 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.

  5. Click and enter the following information in the Dynamic foreign key tab.

    Table 169: Properties for foreign key columns
    Property Remarks

    Referenced table

    Select the tables to be referenced. All tables are permitted, if there are no restrictions.

    Delete restrictions

    Restriction for testing referential integrity when deleting an object

    Insert restrictions

    Restriction for testing referential integrity when inserting an object

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

Related topics

Creating new columns for database views with type view

If the table to be expanded is a database view with the View table type, the selection of new columns is restricted to custom columns of the underlying base table. You can only select custom columns from the base table that are not yet used in the view.

  • First extend the base table by a new column (simple column or foreign key column).

  • Then you extend the database view with the new columns.

To create a new column for database views with the View type in the Schema Extension

  1. On the Configure columns of table page, click .

  2. Enter the following information.

    • Column name: Enter the name of the column.

    • Base column: Select the base table column that you want to add to the database view.

  3. Click OK.

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

Related topics
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating