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

One Identity Manager schema basics

The One Identity Manager‘s data model differentiates between user data and meta data.

The payload contains all the information required to maintaining data, such as information about employees, user accounts, groups, memberships and operating data, approval workflows, attestation, recertification and compliance rules. The user data is described by the application data model.

The meta data contains the description of the application data model and scripts for formatting roles and templates or conditional interactions. One Identity Manager’s entire system configuration, all the front-end control settings and the queues for asynchronous processing of data and processes are also part of the metadata. The meta data is described by the system data model.

The application and system data model table definitions are stored in the table DialogTable. Column definitions for application and system data model tables are kept in the table DialogColumn. The tables relations and column relations are stored in the QBMRelation table.

Related Topics

Overview of the One Identity Manager schema

The data model is mapped and edited in Designer under the category One Identity Manager Schema. This category displays the One Identity Manager default tables and the custom tables including their properties. It gives you an overview of customizations to the default configuration, the value templates and formatting rules of the database columns.

To display the schema overview

  1. In the One Identity Manager, select Designer Schema.
  2. Open the schema overview with One Identity Manager Schema.

TIP: When you select a table or column in Designer, you can open the schema overview using the tasks Show table <table name> in schema and Show column <column name> in schema.

Figure 6: Schema overview

The schema overview has two modes for displaying the One Identity Manager schema.

  • Displaying the data model

    This mode gives you an overview of all tables including their columns and the table relations.

  • Displaying the dependencies

    This mode only displays those tables that have columns with dependencies due to value templates. Tables and columns without dependencies are not shown.

Tables and their columns are displayed using a special control element. The name of the database table is shown in the header of the control element.All other entries represent columns in the table. Each control element entry has a tooltip. The tooltip content depends on the display mode selected. The column entries are labeled with icons that mark particular properties of the columns depending on the display mode.

Figure 7: Control Elements for Displaying Database Tables and their Columns

You can control the display of column entries with the menu items Options | Show all columns and Options | Hide all columns or the icons in the control element header. Use Options | Hide small tables to only show the name of the table for tables with less than 20 columns.

To display tables and columns that are disabled by preprocessor conditions, use the menu Options | Show disabled columns.

You can change the layout of the control elements in the schema overview with the mouse. Using the menu item Options | Save table layout the changes made to the schema layout are saved in the internal database and in the Designer's change log.

Relations between tables or columns are represented by connecting lines. You can control how these are displayed using the menu item Options | Hide table relations. If the menu item is disabled all the connectors are shown. If the menu item is enabled then none of the connectors are shown. If a control element is selected the connectors are highlighted anyway without regard to the menu setting.

Figure 8: Using Connectors to Illustrate Relations

A connector points to column entries that are related to it. You can navigate between the connection points using the connector. When you select a connector the cursor changes to an arrow icon.Double click on the connector to move the view to other end of the connector. The direction is indicated by the arrow icon. Movement is controlled through Options | Animate movements. When the cursor passes over a connector a tool tip, whose contents depends on the display mode, is shown.

You can use the quick overview to navigate faster around the schema view. On the lower right edge of the schema overview there is a button which you use to open the quick overview. The area of the schema overview that is currently shown in the window is marked with a frame in the quick overview. Using the mouse you can move this frame around in the view. The corresponding area of the schema overview is then shown in the window.

Figure 9: Open Quick Overview

Related Topics

Displaying the data model

This mode gives you an overview of all tables including their columns and the table relations.

To display the data model

  1. In the One Identity Manager, select Designer Schema.
  2. Open the schema overview with One Identity Manager Schema.
  3. Select the menu item Options | Data model.

A table entry's tooltip contains the name of the table and the table's preprocessor conditions. A column entry's tooltip contains the name of the column, description, data type and the minimum and maximum length of the column.

A connector's tooltip shows the table relations. This tooltip contains the name of the tables that are related to it and the table relation properties. A single mouse click on the connector opens the table relation properties in the edit view.

Column entries are marked in the control with icons representing special properties.

Table 12: Meaning of the Icons
Icon Meaning
The column is a foreign key column (FK).
The column is a primary key column (PK).
The column has the data type string or text.
The column has the data type binary.
The column has the data type bool.
The column has the data type int, byte or short.
The column has the data type double or decimal.
The column has the data type date.
Related Topics

Displaying the column dependencies due to templates

This mode only displays those tables that have columns with dependencies due to value templates. Tables and columns without dependencies are not shown.

To display the column dependencies

  1. In the One Identity Manager, select Designer Schema.
  2. Open the schema overview with One Identity Manager Schema.
  3. Select the menu item Options | Dependencies.

The tooltip for a table entry contains the name of the table. The tooltip for the column entries contains the name of the column. If a column has a value template it is shown in the tooltip. If the column does not have a value template itself but is referenced by value templates belong to other columns then those columns are named in the tooltip.

When you select a column, the connections to other columns are highlighted in color. A tooltip shows the sender and subscriber relationship of the column dependencies. The tooltip contains the names of tables that refer to each other. The sender, subscriber and the part of the value template that gives the reason for the dependency are also shown.

Table 13: Meaning of Colors for Sender Subscriber Relations
Color Meaning
Green Column is sender.
Red Column is subscriber.
Related Topics
Related Documents