Chat now with support
Chat with Support

Identity Manager 8.1.4 - 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 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
Setting up Job servers Configuring the One Identity Manager Service Handling processes in One Identity Manager
Tracking changes with process monitoring Conditional compilation using preprocessor conditions Scripts in One Identity Manager
Using scripts Notes on message output Notes on using date values 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 of scripts in 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 executing scripts Editing and testing script code with the System Debugger Extended debugging in the Object Browser
Reports in One Identity Manager Adding custom tables or columns to the One Identity Manager schema Web service integration SOAP Web Service One Identity Manager as SPML provisioning service provider Processing DBQueue tasks One Identity Manager Service configuration files

Embedding reports in the user interface

In order to display a report in a One Identity Manager administration tool, such as Manager, you need to link in the report as a custom interface form.

In the Manager's info system, you can display reports that you create in the Report Editor as statistics. To do this, you must alter the Manager's user interface. The report opens when you double-click on the statistic's header.

To create a user interface form

  1. In the Designer, select the User interface | Forms | User interface forms category.

  2. Select the Edit form task.

  3. Select Form | Insert.

  4. Edit the interface form's master data.

    Take the following cases into account:

    • Use the VI_Report form definition.

      This form definition is configured for displaying in the graphical user interface and in web applications. You only need to set up one interface form for this. Which form template will be used to display the interface form is decided dynamically, depending on usage.

    • In the form’s configuration data, enter the name of the report to be run and the report parameters in the SpecialSheetData section.

      Syntax:

      <DialogSheetDefinition FormatVersion="1.0">

      <SpecialSheetData>report name&#7;parameter1=value1&#7;parameter2=value2 ...

      ...

      </SpecialSheetData>

      </DialogSheetDefinition>

      Example:

      <DialogSheetDefinition FormatVersion="1.0">

      <SpecialSheetData>CCC_Employee_by_Department&#7;UIDDepartment=%UID_Department%</SpecialSheetData>

      </DialogSheetDefinition>

  5. Assign the user interface form to the applications and permissions groups.

  6. (Optional) Assign the user interface form to the object definitions.

  7. (Optional) Assign the user interface form to the menu items.

Related topics

Creating and exporting reports on a cyclical basis

You can create customer-specific processes to control the creation of reports and perform the export on a cyclical or event-controlled basis.

You can use the ReportComponent process component to create reports and export them to different file formats. The following formats are supported: HTML, PDF, RTF, TEXT, XLS, TIFF, XML, CSV, XPS, DOCX,and XLSX.

To exports reports in CSV format, you can also use the ScriptComponent process component with the CSVExport or CSVExportSingle process tasks.

NOTE: Use the default report server as executing server in the processes.

Related topics

Adding custom tables or columns to the One Identity Manager schema

The object technology implemented in One Identity Manager makes it possible to add customer-specific columns and tables to the existing application data model at the database level. These are, therefore, available at the object level with all corresponding tasks. A custom extension to the system data model is not recommended.

Basic knowledge of the SQL Server is a prerequisite for making schema extensions. It is assumed that you understand the concept and the architecture of One Identity Manager.

To implement a custom extension of the One Identity Manager schema, use the Schema Extension program. You can make the following extensions using the Schema Extension:

  • Create new tables

  • Create new assignment tables

  • Create new columns

  • Create new views

  • Create new indexes

  • Removing custom schema extensions

    NOTE: You can delete custom schema extensions only on databases with the Test environment or Development system staging level. It is not possible to transport the changes.

The Schema Extension program creates the schema extensions in the database and ensures that the necessary extensions are made in the One Identity Manager schema. The basic table definitions and column definitions of the custom tables are entered in the DialogTable, DialogColumn, QBMRelation and DialogValidDynamicRef tables. You must then adjust the properties in the Designer to the desired requirements.

The Designer contains a variety of consistency checks. Run these consistency checks and apply the repair methods after carrying out a schema extension and after making changes to table and column definitions. For detailed information on checking data consistency, see the One Identity Manager Operational Guide.

You cannot create custom functions, triggers, or database procedures with the Schema Extension program. If you need custom functions, triggers, or database procedures, add these to the database in a suitable program for executing SQL queries. Keep to the following conventions for name database components.

  • Name begin with the CCC_ string.
  • All names are a maximum of 30 characters long.
  • One Identity recommends using UpperCamelCase as notation for the names.
Detailed information about this topic
Related topics

Creating new tables

Use this task to create a simple table in the One Identity Manager schema.

Technical details
  • The technical identifier for the table is automatically formed according to the CCC<Table name> schema.

  • The following columns are generated automatically:

    • Primary key column

      The primary key column is automatically transferred as the UID. The name of the primary key column is formed according to the UID_CCC<table name>.

    • X columns (XUserInserted, XUserUpdated, XDateInserted, XDateUpdated, XTouched, XObjectKey, XMarkedForDeletion)

To create a simple table in the Schema Extension

  1. Start the Launchpad and log in to the One Identity Manager database.

  2. Open the Launchpad and select the One Identity Manager Schema Extension entry. This starts the Schema Extension program.

  3. Click Next on the start page.

  4. On the Database connection page, check the connection data for the One Identity Manager database.

  5. On the Select method page, select New table.

  6. On the Create new table page, enter the following information.

    Table 166: Table properties
    Property Description

    Table

    A technical name for the table.

    Display name

    Displays table name The display name is used, for example, to identify the table in a database search or for error output.

    Description

    Comments on using the table.

  7. On the Configure columns page, create the new columns. For more information, see Defining columns.

Related topics
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating