About this guide
One Identity Manager software architecture
Working with objects in One Identity Manager
Inserting, modifying and deleting an object in One Identity Manager
Customizing the One Identity Manager default configuration
Reloading changes dynamically
Locking and unlocking individual properties for editing
System configuration reports
Adjusting the One Identity Manager base configuration
Overview of the settings of a database
Changing the connection data for the database
Database configuration for a test, development or productive environment
Language settings for displaying and maintaining the data
Configuration parameters for system 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
Editing table definitions and column definitions
Table types in One Identity Manager
Editing the user interface
Database views of the view type
Database views of the proxy type
Database views of the Union type
Database views of the read-only type
Using table scripts
Editing table relations
Working with a Globally Unique Identifier module
Templates for generating values
Editing value templates
Preventing a change to a column
Restricting the execution of value templates
Example of local value templates within an object
Example of cross-object value templates
Formatting of values
Defining unique columns
Limiting the column length
Defining decimal places for displaying values
Predefined formatting types
Creating formatting scripts
Column dependencies for setting values
Permitted values for a column
Configuring columns for full-text search
Mapping dynamic foreign keys
Supporting file groups
Table properties
Column properties
Object definitions for the user interface
Localization in One Identity Manager
Selection criteria for object definitions
Using the captions for object definitions
Editing the object definitions
Object definition properties
User interface navigation
Navigation elements
Recommendations for editing menu navigation
Notes on working with the User Interface Editor
Selecting the user interface navigation view for editing
Forms for the user interface
Loading the entire user interface navigation
Loading the user interface navigation using an application
Directly loading menu items
Loading menu items using permissions groups
Loading the user interface navigation using a WHERE clause
Simulating the user interface navigation during editing
Copying an existing user interface navigation for a new permissions group
Creating a new user interface navigation
Copying a menu item
Creating a new menu item
Creating a menu category
Assigning a menu item to an application
Assigning a menu item to a permissions group
General menu item properties
Creating database queries for data-dependent menu items
Editing lists
Using links
Using variables
Recommendations for editing forms
Editing user interface forms
Statistics in One Identity Manager
Notes on working with the Form Editor
Disabling user interface forms
Copying a user interface form
Creating a new user interface form
Assigning a user interface form to an application
Assigning a user interface form to a permissions group
Assigning a user interface form to an object definition
Assigning a user interface form to a menu item
Displaying custom columns and tables on master data forms
Forms for custom extensions
User interface form properties
Working with overview forms
Editing statistic definitions
Including statistics in the user interface
Diagram types for visualizing statistics
Examples of statistic definitions
Extending the Launchpad
Recommendations for extending the Launchpad
Actions for the Launchpad
Creating new menu items and actions for 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
Working in different time zones
Determining working hours
Editing country information
Process orchestration in One Identity Manager
Enabling other countries and states
Specifying the standard hours for countries and states/provinces/counties
Displaying public holidays for countries and states
Editing countries
Editing states
Country properties
State properties
Public holiday properties
Language-dependent data representation
Basic rules for using language-dependent data
Labeling columns for translation
Using the text memory for translation
Displaying the translations in the Language Editor
Showing usage of a translation
Editing the translations from a single table
Editing all translations
Changing the key text of a translation
Importing translations
Setting up Job servers in Designer
Tracking changes with process monitoring
Editing a Job server
Machine roles and server functions
Job server statistic information
Connection data for process generation
Installing the One Identity Manager Service on the Job server
Configuring the One Identity Manager Service
One Identity Manager Service configuration files
Customizing the One Identity Manager Service configuration for a Job server
Handling processes in One Identity Manager
Template for the configuration file
Selecting the module types and editing the parameters
Validity check on configuration file
Process collection module
Job destination module
Selecting a method
Logwriter module
Dispatcher module
Connection module
HTTP authentication module
Module plug-ins
HTTPLogPlugin
ScheduleCommandPlugin
RequestWatchDogPlugin
PerformanceCounterPlugin
DebugMailPlugin
ShareInfoPlugin
RemoteConnectPlugin
File module with private key
Editing processes with the Process Editor
Defining processes
Creating and editing processes
Copying processes
Creating and editing process steps
Copying individual process steps
Importing a process step into a process
Searching for an entry within a process
Comparing processes
Exporting and importing processes
Properties of a process
Process step properties
Process step parameters
Events for processes
Simulating process generation
Checking the validity of a process
Compiling a process
Using process-specific and global variables for the process definition
Thresholds for handling processes
Specifying the executing server
Notifications about process step handling
Executing processes automatically
Displaying the status of process plans
Starting a process plan immediately
Creating and editing a process plan
Process plan properties
Overview of process components
Basic rules for process monitoring
Logging data changes
Logging process information during process handling
Conditional compilation using preprocessor conditions
Editing the process information for processes
Editing the process information for process steps
Editing the process information for events
Recording messages in the process history
Process tracking for DBQueue Processor operations
Archiving and deleting records
Preprocessor-relevant configuration parameters
Preprocessor conditions in objects
Preprocessor conditions in VB.Net expressions
Evaluation of preprocessor conditions during compilation
Scripts in One Identity Manager
Using scripts
Notes on message output
Notes on using date values
Using dollar ($) notation
Reports in One Identity Manager
Accessing local object columns
Accessing columns of an object connected by a relation
Accessing the old column value
Accessing the display value of a column
Accessing references in comments
Accessing meta values of the local object
Using base. Object
Calling functions
Pre-scripts for use in processes and process steps
Using session services
Querying configuration parameters
Testing for the existence of certain database entries
Querying session object global variables
Using #LD-Notation
Scripts in the script library
Support for processing of scripts in Script Editor
Creating and editing scripts with the Script Editor
Copying scripts in the Script Editor
Testing a script in the Script Editor
Testing script compilation in the Script Editor
Overriding scripts
Editing and testing script code with the System Debugger
Loading the system library
Editing script code in the System Debugger
Logging database queries and object actions
Testing script code in the System Debugger
Testing scripts in the System Debugger
Testing templates and formatting scripts in the System Debugger
Testing methods in the System Debugger
Testing table scripts in the System Debugger
Saving changes to the database
Working with the Report Editor
Adding custom tables or columns to the One Identity Manager schema
Menu items in Report Editor
Views in the Report Editor
Program settings for the Report Editor
Logging database queries
Creating and editing reports in the Report Editor
Editing the general report properties
Creating and editing a data source
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
Report parameters
Editing report parameters
General parameter settings
Defining the parameter values
Settings for calculating values
Using virtual data sources
Editing the report form
Example of a simple report with data grouping
Translating reports
Embedding reports in the user interface
Creating and exporting reports on a cyclical basis
Creating a new table
Extending a table
Defining columns
Web service integration
Creating a simple column
Creating a foreign key column
Creating a dynamic foreign key column
Creating a new column for database views of View type
Advanced configuration of columns
Creating database views with read-only type
Creating database views of Union type
Creating a new assignment table
Creating indexes
Removing custom schema extensions
Permissions for schema extensions
Change labels for the schema extensions
Applying the schema extensions
Recommendations for advanced configuration of custom schema extensions
Managing custom database objects within the database
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
Modifying 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 SOAP Web Service
Configuring the SOAP Web Service
Display the status of a SOAP Web Service
Uninstalling the SOAP Web Service
Examples of calls
SPML web service
Installing and configuring the SPML web service
Configuring the One Identity Manager schema
Testing SPML web service functionality
Processing DBQueue tasks
Configuring the DBQueue Processor for test and development environments
Initializing the DBQueue Processor
Reinitialization of 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
Appendix: Configuration files of the One Identity Manager Service
Creating and editing a data source
For each report you need to create a data source from which to read the report data to be displayed. Normally one data source is sufficient for one report. However, you can define several data sources for each report.
To edit a data source
- Open the report in the Report Editor.
- Select the Data source tab in the properties dialog box.
- Select the data source from Defined queries.
- OR -
Click Add.
This creates a new data source.
- Edit the data source properties.
To delete a data source
- Open the report in the Report Editor.
- Select the Data source tab in the properties dialog box.
- Select the data source from Defined queries.
- Click Delete.
You can test the results while processing a data source.
To test a data query
- Open the report in the Report Editor.
- Select the Data source tab in the properties dialog box.
- Select the data source from Defined queries.
- Click the
button next to Query module.
The result of a data source is shown in a separate dialog.
|
|
NOTE: When a data query is copied to the clipboard, a database query is generated in SQL syntax, which you can run on the database with an appropriate SQL query tool. To copy the data query, use the |
button next to Query module.Detailed information about this topic
- 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
Related Topics
Data retrieval using an SQL query
Reports in One Identity Manager > Creating and editing a data source > Data retrieval using an SQL query
Data queries with the SQL query module are executed directly on the database without checking user access permissions. This means that a column to be used in the report is displayed even though the user may not have access permission to it.
| Property | Meaning |
|---|---|
| Name | Name of the data source. |
| Description | Description of data source. |
|
Max. lines |
Maximum number of result lines for this query. If this number is exceeded, report creation is terminated. |
|
Parent query |
Not used. |
| Query module | Select the SQL query module. |
| Query |
Full database query SQL syntax. The query must contain all the columns used in the report. You can also use SQL parameters in the query. Add these parameters subsequently to the report by entering them on the Parameters tab. Syntax for parameters: @<Parametername> |
Example:
The query should return the employees (table Person) assigned to an department. The department (UID_Department) is found with (XObjectKey). This is passed as a parameter to the report. The employee‘s first name (firstname), last name (lastname) and department name (departmentname) are queried.
Select Firstname, Lastname, Departmentname
from person join Department
on person.uid_Department = department.uid_Department
where Department.XObjectKey = @ObjectKeyBase
Related Topics
Data retrieval using a database view
Reports in One Identity Manager > Creating and editing a data source > Data retrieval using a database view
You can use the View query module to create data queries using predefined database views and thus control user access rights.
| Property | Meaning |
|---|---|
| Name | Name of the data source. |
| Description | Description of data source. |
|
Max. lines |
Maximum number of result lines for this query. If this number is exceeded, report creation is terminated. |
|
Parent query |
Not used. |
| Query module | Select the View query module. |
| View name | Name of the database view. |
| Condition |
Condition for limiting the data set returned from the database table. You formulate the condition as a valid WHERE clause for database queries. You may use SQL parameters in the condition. Add these parameters subsequently to the report by entering them on the Parameters tab. Syntax for parameters: @<Parametername> |
| Sort order | The data queries are sorted by these database view columns. |
Related Topics
Data retrieval using an object
Reports in One Identity Manager > Creating and editing a data source > Data retrieval using an object
Data queries with the Object query module are created using the object layer and therefore take user access permissions fully into account.
| Property | Meaning |
|---|---|
| Name | Name of the data source. |
| Description | Description of data source. |
|
Max. lines |
Maximum number of result lines for this query. If this number is exceeded, report creation is terminated. |
| Parent query |
In a parent query, restrictions are applied to the data record that are passed on to subsequent queries, all members of a department, for example. Parameters that are defined in the parent query are also available in subsequent queries. |
| Query module | Select the Object query module. |
| Table | Select the table to find the object in. |
| Columns |
Columns to use in the report. Some columns are always added to the report definition and must not be explicitly entered here. These include:
|
| Resolve foreign key | Set this option if the display value of the referenced object should be returned in <column>_Display rather than the UID. |
| Condition |
Condition for limiting the data set returned from the table. You formulate the condition as a valid WHERE clause for database queries. You may use SQL parameters in the condition. Add these parameters subsequently to the report by entering them on the Parameters tab. Syntax for parameters: @<Parametername> Syntax for columns of a parent query: @<name of parent query>.<column of the parent query> |
| Sort order | The data queries are sorted by these table columns. |