Direct database queries cannot be carried out from front-ends and web application when an application server is implemented due to security issues. Database queries, which are required on forms for example, must be formulated in One Identity Manager as predefined database queries. Database queries are always executed with the permissions of the current user. Prefined database queries must be assigned to a permissions group.
A wizard in the Web Designer helps you to create database queries for the Web Portal and to link it with at least one permissions group. You can enter more predefined database queries in the Designer.
To create predefined database queries
Object processing status.
|Description||Spare text box for additional explanation.|
|Identifier for SQL code||A unique identifier that is used to identify the query|
|Code||Full database query SQL syntax. You can also use SQL parameters in the query.|
The One Identity Manager requires country information at different stages, for example, employee country and state assignments are accessed when email notifications are created or IT Shop workflows are being determined. Language, 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.
The 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 languages English - United States [en-US] and German - Germany [de-DE]. You can use other languages if required. To do this it is advisable to translate the required text before starting to use the One Identity Manager. There is a Language Editor in the Designer to help you do this. A special control element is provided in the One Identity Manager tools which aids multi-language input.
Other languages are made available with the One Identity Manager Language Pack translating the Web Portal.
NOTE: You will find the One Identity Manager Language Pack in the Support Portal under https://support.oneidentity.com/.
Time stamps, for example, insert dates or modification dates, are stored in the 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 Web Portal are in use.
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 calls in the Helpdesk Module. Weekends and public holidays are taken into account when calculating working hours.
To determine the working hours