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

Using predefined database queries

Due to security issues, you cannot run any direct database queries from the user interface or from web applications. Direct database queries, such as those required on forms, must take the form of predefined database queries in One Identity Manager. Database queries are always run with the permissions of the current user. Predefined database queries must be assigned to a permissions group.

A wizard in the Web Designer helps you to create database queries for the Web Designer Web Portal and to link them with at least one permissions group. You can add more predefined database queries with the Designer.

You will find examples on the installation medium in the QBM\dvd\AddOn\ApiSamples directory.

To create predefined database queries

  1. In the Designer, select the Base data > Advanced > Predefined SQL category.

  2. Select the Object > New menu item.

  3. Edit the main data.

    Table 63: Properties of predefined database queries
    Property Description

    Processing status

    Object processing status. The processing status is used for creating custom configuration packages.

    Description

    Text field for additional explanation.

    Identifier for SQL code

    A unique identifier that is used to identify the query

    SQL type

    Type of SQL query. Permitted values are:

    • Statement: This is a complete SQL query.

    • WHERE clause: This is where clause part of the SQL query.

    Code

    Full database query SQL syntax. You can also use SQL parameters in the query.

  4. Assign permissions groups.

    1. Select View > Select table relations and enable the QBMGroupHasLimitedSQL table.

    2. In the edit view, select the Permissions group view and select the permissions groups.

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

Localization in One Identity Manager

One Identity Manager requires country information at different stages, for example, identity country and state assignments are accessed when email notifications are created or IT Shop workflows are being determined. Languages, time zones, public holidays, and working hours are mapped as well as countries and states. The basis data is loaded into the database during schema installation.

One Identity Manager supports language-dependent representation of data. You can use this feature to edit display text in different languages for the One Identity Manager tool user interfaces. You can also create multi-language text for process information output, script processing as well as processing messages.

The default One Identity Manager installation is supplied in the English - United States [en-US] and German - Germany [de-DE] language. You can add other languages to the user interface and display text if required. In this instance, you must translate the text before One Identity Manager goes live. There is a Language Editor in the Designer to help you do this. A special control is provided in the One Identity Manager tools that aids multi-language input.

To help you translate One Identity Manager, other languages are made available with the Web Portal Language Pack.

NOTE: You will find the One Identity Manager Language Pack in the Support Portal under https://support.oneidentity.com/.

Detailed information about this topic

Working in different time zones

Time stamps, for example, insert dates or modification dates, are stored in One Identity Manager with the respective UTC. The object layer transforms this time data into the currently valid time zone data when an object is loaded. The user, therefore, sees all the values in local time. When an object is saved the current time zone data is transformed into UTC data.

Countries and time zones are linked to another in the One Identity Manager schema. This makes it easier to find out the time zones when web fronts such as the Web Portal are in use.

Related topics

Determining working hours

Working hours are calculated for various function in One Identity Manager. For example, to determine working hours in the IT Shop or for determining reaction and solution times for tickets in the Helpdesk Module. Weekends and public holidays are taken into account when calculating working hours.

To determine the working hours

  • Ensure that a state and/or county is entered into the identity’s main data.

  • Public holiday are entered by state (county) in One Identity Manager. You can add separate public holidays for states.

  • To exclude public holidays from the working hours calculation, in the Designer set the QBM | WorkingHours | IgnoreHoliday configuration parameter.

  • To exclude weekends from the working hours calculation, in the Designer, set the QBM | WorkingHours | IgnoreWeekend configuration parameter.

Related topics
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating