One Identity Manager Software Architecture
Working with Objects in One Identity Manager
Inserting, Modifying and Deleting Objects in One Identity Manager
Working with the Designer
General Information about the Program
Menu Items
Views in the Designer
Customizing Program Settings
Using Help
Limiting List Sizes
Searching for List Entries
Using the Designer's Own Full-Text Search
Using User Defined Filters for Searching
Making and Committing Changes to Objects
The Designer Editors
Working with the Object Editor
Working with the List Editor
Customizing the One Identity Manager Default Configuration
Checking Data Consistency
Menu Items
Functions in the Result List
Result List Configuration
Multiple Editing of List entries
Displaying Object Relations
Working with the SQL Editor
Support for Scripting
Working with the Consistency Editor
Starting the Consistency Check
Recording Test Results
Repairing Errors
Compiling a One Identity Manager Database
Working with Change Labels
Creating Change Labels
Displaying Contents of a Change Label
Booking Changes to a Change Label Retrospectively
Basic System Configuration Data
One Identity Manager Authentication Module
Database Connection Data
The One Identity Manager Data Model
Database Connection Properties
Configuring a One Identity Manager Database for Testing, Development or Production
Configuration Parameters for System Configuration
Setting up the Mail Notification System
Enabling More Languages for Displaying and Maintaining Data
Displaying Country Information
Working in Different Time Zones
Determining Working Hours
Editing Countries
Editing States
Modifying Public Holidays
Setting Up and Configuring Schedules
Password Policies in One Identity Manager
Predefined Password Policies
Editing Password Policies
Custom Scripts for Password Requirements
Restricted Passwords
Testing a Password
Testing Generating a Password
Assigning a Password Policy
Reloading Changes Dynamically
TimeTrace Databases
Machine Roles and Server Functions
Files for Software Update
Importing New Files into a One Identity Manager Database
Exporting Files from a One Identity Manager Database
Configuring Files
Operating Systems in Use
System Configuration Reports
Using Predefined Database Queries
Managing Custom Database Objects within a Database
Basics of the Data Model
General Advice for Editing Table and Column Definitions
Working with the Schema Editor
Mapping Table Definitions
Granting One Identity Manager Schema Permissions
Table Properties
Working with Module Globally Unique Modifiers
Table scripts
Database Views of Type "View"
Database Views of Type "Union"
Database Views of Type "Proxy"
Database Views of Type "Read-only"
Mapping Column Definitions
Column Properties
Templates
Mapping Table Relations
Supporting File Groups
Editing Value Templates
Example of Local Value Templates within an Object
Example of Value Templates across Objects
Formats for Checking Values
Permitted Column Values
Mapping Dynamic Foreign Keys
Column Dependencies for Setting Values
Configuring Columns for Full-Text Search
Predefined Permissions Groups and System Users
Editing Permissions Groups and System Users
Working with the User Interface
Working with the User & Permissions Group Editor
Permissions Group Dependencies
Copying Permissions Groups
Manually Creating Permissions Groups
Permissions Groups Properties
Editing System Users
Adding a System User to Permissions Groups
Dynamic system user
Which Employees Use System Users?
Editing Permissions for One Identity Manager Schema Tables and Columns
Rules for Finding Valid Permissions for Tables and Columns
Working with the Permissions Editor
Availability of Certain Functionality
Displaying Permissions for an Object
Displaying the Current User's Permissions
Menu Items
Views in the Permissions Editor
Functions in the Permissions Edit View
Filtering Entries in the Permissions Editor
Granting Permissions for Tables
Granting Column Permissions
Object definitions for the User Interface
Process Orchestration in One Identity Manager
Selection Criteria for Object Definitions
Using Display Text for Object Definitions
Working with Object Definitions
User Interface Navigation
Navigation View Elements
Recommendations for Editing Menu Navigation
Working with the User Interface Editor
Editing Menu Items
General Menu Item Properties
Creating Database Queries for Data Dependent Menu Items
Editing Lists
Using Links
Using Variables
Forms for the User Interface
Recommendations for Editing Forms
Working with the Form Editor
Editing Interface Forms
Statistics in the One Identity Manager
User Interface Form Properties
Form Definitions and Form Templates
Effects of Object Definitions when Displaying Interface Forms
Features of the Assignment Form
Forms for Custom Extensions
Custom Master Data Forms
Configuration Data for Displaying Many-to-Many and Object Relations on Forms
Replacing Default Forms with Custom Forms
Working with Overview Forms
Working with Statistic Definitions
Linking Statistics into the User Interface
Diagram Types for Visualizing Statistics
Examples of Statistic Definitions
Extending the Launchpad
Task Definitions for the User Interface
Applications for Configuring the User Interface
Icons and Images for Configuring the User Interface
Language Dependent Data Representation
Declaring the Job Server
Tracking Changes with Process Monitoring
Working with the Job Server Editor
Editing a Job Server
One Identity Manager Service Configuration
Job Server Properties
Server Functions of a Job Server
Job Server Machine Roles
Job Server Statistic Information
Installing the One Identity Manager Service on the Job Server
Customizing the One Identity Manager Service Configuration for a Job Server
One Identity Manager Service Configuration Files
Process Collection Module
Handling Processes in the One Identity Manager
MSSQLJobProvider
OracleJobProvider
FileJobProvider
FTPJobProvider
HTTPJobProvider
AppServerJobProvider
The Jobdestination Module
The Configuration Module
The Logwriter Module
The Dispatcher Module
The Connection Module
The HTTP Authentication Module
The Plug-ins Module
HTTPLogPlugin
ScheduleCommandPlugin
DBSchedulerWatchDogPlugin
RequestWatchDogPlugin
PerformanceCounterPlugin
DebugMailPlugin
ShareInfoPlugin
RemoteConnectPlugin
Module File with Private Key
Working with the Process Editor
Defining Processes
Creating and Editing Processes
Executing Processes Automatically
Process Components
Properties for a Process
Using Process Specific and Global Variables for the Process Definition
Thresholds for Handling Processes
Creating and Editing Events
Creating and Editing Process Steps
Process Step Parameters
Searching for a Process Step within a Process
Comparing Processes
Exporting and Importing Processes
Simulating Process Generation
Checking the Validity of a Process
Compiling a Process
Basics for Process Monitoring
Logging Data Changes
Logging Process Information during Process Handling
Recording Messages in the Process History
Process Tracking for DBQueue Processor Operations
Archiving and Deleting Recordings
Conditional Compilation using Preprocessor Conditions
Preprocessor Relevant Configuration Parameters
Preprocessor Conditions in Objects
Preprocessor Conditions in VB.Net Expressions
Evaluation of Preprocessor Conditions during Compilation
One Identity Manager Scripts
Using Scripts
Message Output
Implementing Dates
Using Dollar ($) Notation
Maintaining Mail Templates
Reports in the One Identity Manager
Accessing Local Object Columns
Accessing Object Columns Connected by a Relation
Accessing the Old Column Value
Accessing Column Display Values
Accessing References in Comments
Accessing Local Object Meta Values
Using base. Object
Calling Functions
Pre-scripts for using in Processes and Process Steps
Using Session Services
Querying Configuration Parameters
Testing the Existence of Certain Database Entries
Querying Session Object Global Variables
Using #LD Notation
Scripts in the Script Library
Working with the Script Editor
Editing Scripts
Overriding Scripts
Testing Script Compilation
Testing a Script with the Script Editor
Testing Scripts with the System Debugger
Working with the Report Editor
Creating and Editing Reports
Custom schema extensions
General Report Properties
Creating a Data Source
Example of a Simple Report with Data Grouping
Translating Reports
Linking Reports into the User Interfaces
Data Retrieval using an SQL Query
Data Retrieval using a Database View
Data Retrieval using an Object
Data Retrieval using Single Object History
Data Retrieval using Multiple Object History
Data Retrieval using Historical Assignments
Data Query for Simulation Data
Editing Report Parameters
Using Virtual Data Sources
Editing the Report Form
Creating a New Table
Extending a Table
Defining Columns
Transporting One Identity Manager Schema Customizations
Creating a Simple Column
Creating a Foreign Key Column
Creating New Columns for Database Views
Configuring Column Properties
Creating a Read-Only Database View
Creating a Union View
Creating New Assignments Tables
Creating Indexes
Permissions for Schema Extensions
Specifying Change Labels for Schema Extensions
Adding Schema Extensions
Adding in Custom Extensions to the User Interface
Basics for Transport of One Identity Manager Schema Modifications
Creating a Transport Package with the Database Transporter
Importing Data
Transporting SQL Statements
Transporting Favorite Objects
Transport by Change Label
Transport by Change Information
Transporting Schema Extensions
Transporting Selected Objects and their Dependencies
Transporting System Configuration
Transporting System Files
Displaying Contents of a Transport Package
Importing a Transport Package with the Database Transporter
Displaying Transport History
Importing Data from CSV Files
Importing Data from a Database
Import Configuration
Web Service Integration
Assigning Target Tables and Columns
Assigning Target Columns with the Assignment Wizard
Specifying the Hierarchy
Options for Handling Records
Specifying Connection Variables
Importing Data
Using Import Definition Files
Binding a Web Service
SOAP Web Service
Generic Web Service Call
Direct Web Service Call
Self-Defined Web Service Call
Creating a Web Service Solution with the Web Service Integration Wizard
Changing a Web Service Solution
Deleting a Web Service Solution
Installing and Configuring the SOAP Web Service
One Identity Manager as SPML Provisioning Service Provider
Installing the SOAP Web Service
Configuring the SOAP Web Service
Displaying the Status of a SOAP Web Service
Uninstalling the SOAP Web Service
Examples of Calls
SPML Web Service
Installing and Configuring SPML Web Services
Configuring the One Identity Manager Schema
Testing SPML Web Service Functionality
Searching for Errors in the One Identity Manager
Monitoring Process Handling with Job Queue Info
Processing DBQueue Tasks
Working with Job Queue Info
Job Queue Info Views
Monitoring Process Execution
Error Messaging in the Error Message Window
Displaying Messages in the Error Log View
Logging Messages in the Database Journal
Writing the One Identity Manager Log
One Identity Manager Service Logging
Displaying Details of Process Handling
Displaying Details of Process Step Handling
Displaying Details of a Process Step Parameter
Reinstating Process Steps and Processes
Enabling Extended Logging of Process Steps
Determining the State of the Server
Displaying Entries in the DBQueue
Displaying Messages in the Database Journal
Displaying the Job Queue Sequence
Stopping the System (Emergency Stop)
Configuring the One Identity Manager Service Log File
Advanced Logging in the One Identity Manager Service
Displaying the One Identity Manager Service Log File
Extended Debugging in the One Identity Manager Service
Output of Extended Return Values from Individual Process Components
Outputting Custom Messages in the One Identity Manager Service Log File
Logging Messages in the Event View
HTTPLogPlugins Log File
Displaying One Identity Manager Application Server Status
Configuring the DBQueue Processor for Test and Development
Initializing the DBQueue Processor
Controlling Processing of DBQueue Processor Tasks
Processing DBQueue Processor Tasks
Reactivating DBQueue Processor Tasks
Bulk Processing in DBQueue Processor
How the Central Dispatcher Communicates with Individual Slots
Scheduled Maintenance Tasks
One Identity Manager Configuration Files
System Configuration Reports
The category Documentation contains different reports about system configuration and customizations. When you select an entry in this category the corresponding report is generated. Generating the report may take some time depending on its size.
| Report | Contents |
|---|---|
| System configuration | This report contains the description and settings of enabled configuration parameters. |
| Processes | This report contains the description of all enabled default processes. The process steps and their parameters as well as the scripts used and configuration parameters for a process are listed. |
| Process Components | The report contains the description of all process components with their tasks and parameters. |
| Templates | This report contains the descriptions of all default templates including affected columns, scripts used and configuration parameters. |
| Formatting rules | This report contains the description of all default formatting rules including scripts used and configuration parameters. |
| Scripts | This report contains the description of all default scripts including configuration parameters used. Process usage, process steps, templates, formatting rules and scripts are listed for each script. |
| Full report | Full report about system configuration. This groups together all the information in the separate reports. |
| Report | Contents |
|---|---|
| System configuration | This report contains the description and settings of enabled configuration parameters. |
| Processes | This report contains the description of all enabled default processes. The process steps and their parameters as well as the scripts used and configuration parameters for a process are listed. |
| Templates | This report contains the descriptions of all default templates including affected columns, scripts used and configuration parameters. |
| Formatting rules | This report contains the description of all default formatting rules including scripts used and configuration parameters. |
| Scripts | This report contains the description of all default scripts including the configuration parameters used. Process usage, process steps, templates, formatting rules and scripts are listed for each script. |
| One Identity Manager schema | This report contains the description of custom One Identity Manager schema extensions (tables and columns). |
| Full report | Full report about system configuration. This groups together all the information in the separate reports. In addition, information about customized database objects is also listed, such as database procedures, functions, triggers or view definitions. |
Using Predefined Database Queries
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, those required on forms, for example, must be formulated as "predefined database queries" in One Identity Manager. 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
- Select the category Base Data | Advanced | Predefined SQL in the Designer.
- Select the menu item Object | New.
- Edit the master data.
Table 80: Properties of Predefined Database Queries Property Description Processing status Object processing status.
Description Spare text box for additional explanation. Identifier for SQL code Unique identifier used to identify the query Code Full database query SQL syntax. You can also use SQL parameters in the query. - Assign permissions groups.
- Select View | Select table relations... in the menu and enable the table QBMGroupHasLimitedSQL.
- Select one or more permissions groups on the Permissions group tab.
Managing Custom Database Objects within a Database
Database object information such as custom database tables, columns, database procedures, functions, triggers or view definitions need to be stored in the database for creating transport packets with the program "Database Transporter" or for creating reports using the system configuration. The DBQueue Processor checks and updates this data.
|
|
NOTE: It is not usually necessary to edit the data manually although you might edit the comment for use in reports. |
To customize database objects
- Select the category Base Data | Advanced | Modified SQL in the Designer.
- Select the database object.
- Modify Remarks.
| Property | Description |
|---|---|
| Processing status |
The process state is used for creating custom configuration packages. |
| Remarks | Additional comments, for example, for using in system configuration reports. |
| Name | Database object name |
| Modified | Specifies whether the database object has been changed |
| Sort order |
Order in which the data is presented. |
| Type | Type of database object, for example, procedure, function, trigger, index, view, custom table, custom column. |
Related Topics
The One Identity Manager Data Model
The One Identity Manager Data Model
The One Identity Manager Data Model
The One Identity Manager database distinguishes between user data and meta data. Reference data is specified by the application data model and meta data by the system data model. Meta Data includes data for specifying the application data model, for regulating access rights and to influence and control system behavior such as modifying the One Identity Manager interface to meet customer requirements.
The data model is mapped and edited in Designer under the category One Identity Manager Schema. This category displays default tables delivered by us and the customer specific tables together with their properties. You also get an overview of the value templates and formatting rules for the database columns and preprocessor dependencies.
|
|
IMPORTANT: Use the program, "Schema Extension" to extend the One Identity Manager data model. Schema extensions are added to the database using "Schema Extension" and the necessary extensions are made in the One Identity Manager data model. |
|
|
NOTE: Reports about system configuration and customization of tables and column properties can be found in the category Documentation. |
Detailed information about this topic
- Basics of the Data Model
- General Advice for Editing Table and Column Definitions
- Mapping Table Definitions
- Mapping Column Definitions
- Mapping Table Relations