Chat now with support
Chat with Support

Identity Manager 8.1 - Configuration Guide

About this guide One Identity Manager software architecture Customizing the One Identity Manager default configuration Adjusting the One Identity Manager base configuration One Identity Manager schema basics 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
Setting up Job servers in Designer Configuring the One Identity Manager Service Handling processes in One Identity Manager
Tracking changes with process monitoring Conditional compilation using preprocessor conditions Scripts in One Identity Manager Reports in One Identity Manager Adding custom tables or columns to the One Identity Manager schema Web service integration SOAP Web Service One Identity Manager as SPML provisioning service provider Processing DBQueue tasks Appendix: Configuration files of the One Identity Manager Service

Advanced configuration of columns

To edit column properties

  1. Select the column on the Define column page and click the button.
  2. Configure the column properties.
  3. Enter the following information on the Advanced tab.

    Table 186: Advanced configuration of columns
    Property Remarks
    Name Technical identifier for the column The column name is formed from CCC_<column name.
    Data type Column data type Permitted .Net data types are listed in a pop-up menu. These are represented internally as SQL data types. The only permitted data types are those already used in the One Identity Manager data model.
    Length Column length The column length is only specified for the .Net data type String. For columns containing UIDs, enter the value 38.
    Column contains UIDs Specifies whether this is UID column. This option is only permissible for columns with the String .Net data type and a length of 38 characters.
    Column contains unicode Specifies whether the column contains Unicode. This option is only permissible for the String and Text .Net data types.
  4. Enter the following information on the Base values tab.

    Table 187: Column base values
    Property Remarks
    Primary key Specifies whether the column is used as a primary key.
    Required field Specifies whether a column must be filled.
    Display name Specifies how the column is labeled.
    Show in wizards Indicates if the column can be displayed in Rule Editor for compliance rules for creating queries and in tabular overviews in Web Portal.
    Do not auto extend permissions For custom columns in a predefined table, permissions are not automatically assigned to predefined permissions groups, even though the Common | AutoExtendPermissions configuration parameter is set.
    Comment Additional information about the column.
    Initial value

    Initial value for the column This value is transferred to the existing data records of the extended table. The initial value for numerical data types is 0. The initial value for the Bool data type is False.

    Sort order The sort order specifies the position for displaying the column on the generic form and the custom tabs of the default form. Columns with a value less than 1 are not displayed on the forms.
  5. Enter the following information for foreign key columns on the Key column values tab.

    Table 188: Properties for foreign key columns
    Property Remarks
    Foreign key Indicates whether the column is a foreign key column.
    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. Enter the following information for dynamic foreign key columns on the Dynamic foreign key tab.

    Table 189: 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
  7. Click OK.
Related Topics

Creating database views with read-only type

Technical details
  • The technical identifier for the database view is automatically formed according to the schema CCC<Table name>.
  • The first column of the database query (view definition) is used as the primary key column of the database view.

    NOTE: It is recommended that you reference the primary key column of the queried table in the view definition as the first column. If this is not possible, then at least select a unique characteristic.

  • If a database view contains a foreign key column, you specify which destinations tables should be referenced. The table and column relations are generated automatically.

  • If you want to index the database view for the full text search, the XDateInserted, XDateUpdated and XObjectKey columns must be available.

To create a database view of read-only type in theSchema Extension

  1. Open Launchpad and select One Identity Manager Schema Extension. This starts the Schema Extension program.
  2. Click Next on the start page.
  3. On the Database connection page, enter the connection credentials for the One Identity Manager database.
  4. On the Select method page, select Create view.
  5. On the Create view page, enter the following information.
    Table 190: Database view properties
    Property Description
    Table Technical identifier for the database view.
    Display name Name displayed for the database view. The display name is used, for example, to identify the database view in a database search or error output.
    Description

    Comments on using the database view.

    View definition Enter the database query as a select statement.
  6. (Optional) Create the foreign key relations on the Create FK relations for views page.
    • Double-click the icon in front of the column name and select the target table in the Target table column.
  7. On the Configure columns page, enter the display name of the columns.

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

Creating database views of Union type

Technical details
  • The technical identifier for the database view is automatically formed according to the schema CCC<Table name>.

  • As the first column of the database query (view definition), the object key (XObjectKey) must be referenced. The object key allows faster access to a single object with its valid permissions.

  • If you want to index the database view for the full text search, the XDateInserted, XDateUpdated and XObjectKey columns must be available.

To create a database view of Union type in theSchema Extension

  1. Open Launchpad and select One Identity Manager Schema Extension. This starts the Schema Extension program.
  2. Click Next on the start page.
  3. On the Database connection page, enter the connection credentials for the One Identity Manager database.
  4. On the Select method page, select Create union view.
  5. On the Create union view page, enter the following information.
    Table 191: Database view properties
    Property Description
    Table Technical identifier for the database view.
    Display name

    Name displayed for the database view. The display name is used, for example, to identify the database view in a database search or error output.

    Description

    Comments on using the database view.

    View definition Enter the database query as a select statement.
Related Topics

Creating a new assignment table

Technical details
  • The technical identifier for the table is automatically formed according to the schema CCC<Table name>.
  • The XObjectKey and XMarkedForDeletion columns are automatically generated.
  • The table relations and column relations are generated automatically.

To create a new assignment (many-to-many) table in the Schema Extension.

  1. Open Launchpad and select One Identity Manager Schema Extension. This starts the Schema Extension program.
  2. Click Next on the start page.
  3. On the Database connection page, enter the connection credentials for the One Identity Manager database.
  4. On the Select method page, select New relation table.
  5. On the Create a relation table page, enter the following information.
    Table 192: Assignment table properties
    Property Description
    Table Technical identifier for the table
    Display name

    Displays table name The display name is used, for example, to identify the table in a database search or for error output.

    Description

    Comments on using the table

    Create XOrigin column (for assignment requests) You can create the origin column (XOrigin) optionally. The origin of an assignment is stored in this column as a bit field. Each time an entry is made in the assignment table the bit position is changed according to the assignment type.
    Related tables Use the Left table and Right table menus to specify which tables are included in the relation table.
    Column names Enter the relevant columns in Column name for each table side. Select the table’s primary key column.
  6. On the Configure columns page, enter the display name of the columns.

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