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

Limiting column lengths

You can use the column definition to control the length of the values to be entered. For example, the login name of an Active Directory user account is limited to a maximum of 20 characters. You can also use the column definition to define which columns are required.

To define the length of a column

  1. In the Designer, select the One Identity Manager Schema category.

  2. Select the table and start the Schema Editor with the Show table definition task.

  3. Select the column and then the Column properties view.

  4. Select the Value calculation tab and edit the following properties.

    • Max. length: Enter the maximum length of the column. If the value is equal to 0, the length is taken from the database schema.

    • Min. length: Enter the minimum length of the column. Columns with a minimum length of 1 or greater are flagged as required fields in the front-ends.

  5. Select the Database > Commit to database and click Save.

Related topics

Defining decimal places for displaying values

In the user interface, you can define the number of decimal places for displaying values of columns with the .Net data types Double, Decimal, Int, Long or Short.

In columns with the .Net data types Int, Long or Short, the decimal point is shifted in the value display when the decimal places are specified. In columns with the .Net data types Double or Decimal, the value is displayed with the corresponding number of places after the decimal point. Take this behavior into account when calculating with different data types.

Example:
  • Prices with the .Net data type Int are given with cent after the decimal point. In the front-end a price of $3.50 is displayed as 3.50 and saved in the database as 350.

  • Quantities with the .Net data type double are, for example, specified with three places after the decimal point. In the front-end, a quantity of 100 pieces is displayed with the value 100,000, while the value 100 is saved in the database.

To define the number of decimal places

  1. In the Designer, select the One Identity Manager Schema category.

  2. Select the table and start the Schema Editor with the Show table definition task.

  3. Select the column and then the Column properties view.

  4. Select the Column tab and enter the number of decimal places to be used in the Number of decimal places input field.

  5. Select the Database > Commit to database and click Save.

Related topics

Using predefined formatting types

You can specify column formats based on predefined formatting types. By combining formatting types with each other, you can obtain the formatting you required.

NOTE: If there is a column or column combination for a table that needs to be unique, define multi-column uniqueness in the Designer. For more information, see Defining unique columns for tables.

To specify formatting types

  1. In the Designer, select the One Identity Manager schema category.

  2. Select the table and start the Schema Editor with the Show table definition task.

  3. Select the column and then the Column properties view.

  4. Select the Value calculation tab and define the formatting types in the Column format input field.

    Table 26: Permitted formatting types
    Value Formatting type Permitted values

    0

    None

    No special formatting = default

    1

    IP address

    IP address [0-9]³.[0-9]³. [0-9]³.[0-9]³

    2

    MAC ID

    MACID [0-9,A-F]12

    4

    Drive letter

    Drive letter [A-Z]1:

    8

    Number

    [0-9]+

    16

    Uppercase

    Uppercase

    32

    Uppercase server dependent

    (only maintained for compatibility reasons)

    64

    NT name

    All characters are permitted except for „!@/\:,“[];|=+*?<>“

    128

    Phone

    Phone [0123456789#/-+*]n

    256

    Exchange name

    All characters are permitted except for „ÄÖÜäöüß“!§$%&\|/<>#*{}[] ²³~^,“

    512

    ASCII characters and numbers

    All characters of the ASCII character set

    2048

    URI

    Uniform Resource Identifier

    4096

    Email address

    Valid email address

    8192

    Prevent XSS characters

    Certain characters that can be used for cross-site scripting (XSS) are invalid. The < and > characters are tested.

    Testing only takes place if the QBM | XssCheck configuration parameter is set. If the QBM | XssCheck | Sync configuration parameter is set, testing is also done during synchronization.

  5. Select the Database > Commit to database and click Save.

IMPORTANT: Compile the database to implement the formatting type.

Related topics

Creating formatting scripts

You can use a formatting script to verify column values. Formatting scripts, as opposed to value templates, are only run when a value is assigned to the column.

To create a formatting script

  1. In the Designer, select the One Identity Manager Schema category.

  2. Select the table and start the Schema Editor with the Show table definition task.

  3. Select the column and then the Column properties view.

  4. Select the Value calculation tab and enter the formatting script for the column in the Formatting script input field.

    Write the script in VB.Net syntax which allows all VB.Net script functions to be used.

  5. Select the Database > Commit to database and click Save.

IMPORTANT: Compile the database to bring the formatting script into effect.

TIP: Test compile using the Schema > Test compile menu item.

Example of a formatting script

The value in the column Mail in the ADSAccount table should correspond to SMPT format. If this is not the case, an error message is sent. The formatting script for the ADSAccount.Mail column can be formulated as follows:

Dim str as String = Convert.ToString(Value)

If str.Length > 0 Then

If Not VID_IsSMTPAddress(str) Then

Throw New Exception("""" & str & """ is not a valid SMTP address.")

End If

End If

Related topics
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating