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
Result List Configuration
To display object properties
- Select Select columns....
- You specify which object properties should be additionally shown in which order in the result list. You can also enter the column width and alignment of the column description.
- Click OK.
| Icon | Meaning |
|---|---|
 |
Inserts column in view. |
 |
Removes column from view. |
 |
Moves column up. |
 |
Moves column down. |
 |
Specifies how columns are labeled. If selected the column names are displayed. If this option is not active, the identifiers from the data model are shown. |
Multiple Editing of List entries
It is possible to edit more than one object of the same object type at the same time in the List Editor.
- Select entries in the result list with SHIFT + CLICK or CTRL + CLICK.
Entries in the list that have different input are specially labeled in the edit view. When one field is edited and saved, all the other objects are given the same value.
Displaying Object Relations
To display object relations
- Select View | Select table relations... in the menu.
- You can specify which object relations are displayed in the List Editor.
Table 19: Items in the Dialog Window Context Menu Context Menu Item Meaning Show relation Shows the object relation edit window in the edit view.. Hide relation Hides the object relation edit window in the edit view. - Click OK.
Each relation is shown in its own edit window. You can change the assignment with the mouse (double click on icon) or the context menu
| Icon | Meaning |
|---|---|
 |
Object is assigned to the selected base object. |
 |
Object is not assigned to all selected base objects (multiple entry editing). |
 |
Object is not assigned to an object. |
| Context Menu Item | Meaning |
|---|---|
| Assign | Assign object to the selected base object. |
| Remove | Remove assignment of object to base object. |
| Properties | Displays the object properties of the selected entry. |
| Navigation | Shows all other editors that can be used with the selected object. |
Working with the SQL Editor
Working with the SQL Editor
You can use the SQL Editor to run database queries against the internal Designer’s SQLite database. This internal database contains the schema and the files from the system components of the connected One Identity Manager database.
|
|
NOTE: The SQL Editor is only available if the current user is authorized to use the program function "Option to call the SQL editor in to run SQL statements in the SQL database. (Designer_SQLEditor)". |
To execute a database query
- Start the SQL Editor from the Database | Run SQL Editor... menu.
This opens in the SQL Editor in the Designer's document view.
- Enter your database query in SQLite notation in the query window. The editor supports highlighting.
- Run the database query using F5.
The result are displayed in the results window.
TIP: Click with the mouse in a column header to sort by the selected column.
TIP: Use the shortcut CTRL + C to copy lines or single entries into the clipboard. Use SHIFT+ SELECT or CTRL + SELECT to select more than one line in the table.