Linking Reports into the User Interfaces

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

To create a user interface form

1. Select User Interface | Forms | User interface forms in the Designer.

2. Select Form | Insert from the menu.

3. Edit the user interface form master data.

   Take the following cases into account:

   • Use the form definition "VI_Report".

     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 configuration data the name of the report to run and the special report parameters are passed to the interface form in "SpecialSheetData".

     Syntax:

     <DialogSheetDefinition FormatVersion="1.0">

     <SpecialSheetData>report name|parameter1=value1|parameter2=value2 .

     ...

     </SpecialSheetData>

     </DialogSheetDefinition>

     Example:

     <DialogSheetDefinition FormatVersion="1.0">

     <SpecialSheetData>CCC_Employee_by_Department|UIDDepartment=%UID_Department%</SpecialSheetData>

     </DialogSheetDefinition>

4. Assign the form to the application. Use the Program view to do this.

5. The form also needs to be linked to a permissions group. Use the Object relations view to do this.

6. Then you must assign the form to a permissions group. Use the Permissions groups view to do this. Read Effects of Object Definitions when Displaying Interface Forms about controlling the display of forms through object definitions.

7. Assign the menu item to the user interface form, if it is to be displayed in the user interface depending on this menu item. Use the Menu assignments view to do this. Use the to assign a menu item to the interface form.

Reports can be created and exported on a cyclical basis or event controlled. This functionality is provided in the form of a process component. You can create a report with the process component "ReportComponent" and export it in various file formats. The following formats are supported: HTML, PDF, RTF, TEXT, XLS, TIFF, XML, CSV, XPS, DOCX and XLSX . To use this functionality, create a custom process.

Related Topics

• Editing Interface Forms
• Editing Menu Items
• Defining Processes

Custom schema extensions

Custom Schema Extensions

The One Identity Manager database distinguishes between reference 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 One Identity Manager administration tools to meet user defined requirements. 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 database level. These are therefore available at object level with all the corresponding tasks. Custom extensions to the system data model are not permitted.

You can make the following extensions in the Schema Extension:

• Create new tables
• Create new assignment tables
• Create new columns
• Create new views
• Create new indexes

Additional steps for extending the schema are:

• Issuing permissions for schema extensions
• Specifying change labels
• Add schema extensions to the database

You cannot create custom functions, triggers or database procedures with the program Schema Extension. If you require custom functions, triggers or database procedures, add them with a suitable query tool into the database. Keep to the following conventions for name database components.

• Name begin with the string CCC_.
• All names are a maximum of 30 characters long.
• It is recommended to use UpperCamelCase for as notation for the names.

Detailed information about this topic

• Creating a New Table
• Creating New Assignments Tables
• Extending a Table
• Creating a Read-Only Database View
• Creating a Union View
• Creating Indexes
• Permissions for Schema Extensions
• Specifying Change Labels for Schema Extensions
• Adding Schema Extensions

Related Topics

• The One Identity Manager Data Model
• Basics of the Data Model
• General Advice for Editing Table and Column Definitions
• Adding in Custom Extensions to the User Interface

Creating a New Table

To create a simple table in the Schema Extension

1. Open Launchpad and select One Identity Manager Schema Extension. This starts the program "Schema Extension".
2. Click Next on the start page.
3. Enter connection credential for the One Identity Manager database on the Database connection page and click Next.
4. Select the extension method New table table on the Extension method page and click Next.

   This creates a table with table type "T".

5. Enter the table properties on the page Create new table and click Next.

   Table 309: Table Properties

   Property	Description
   Table	Table name. The name of the new table must begin with the prefix "CCC". The table name is formatted as CCC<table name>.
   Display name	The display name is used, for example, to identify the table in a database search or for error output.
   Description:	You can enter a comment on a table about using it in the data model.

6. Next step: You create a new columns on the Configure columns page. For more information, see Defining Columns.

   NOTE:The following columns are automatically created: Primary key column The primary key column is automatically taken to be the UID. The name of the primary key column is formatted as UID_CCC<table name>. X Columns (XUserInserted, XUserUpdated, XDateInserted, XDateUpdated, XTouched, XObjectKey, XMarkedForDeletion)

Detailed information about this topic

• Defining Columns
• Creating a Simple Column
• Creating a Foreign Key Column
• Creating New Columns for Database Views
• Configuring Column Properties

Related Topics

• Extending a Table
• Creating New Assignments Tables
• Creating a Read-Only Database View
• Creating a Union View
• Mapping Table Definitions

Extending a Table

To extend an existing table in the Schema Extension

1. Open Launchpad and select One Identity Manager Schema Extension. This starts the program "Schema Extension".
2. Click Next on the start page.
3. Enter connection credential for the One Identity Manager database on the Database connection page and click Next.
4. Select the extension method Extend table on the Extension method page and click Next.
5. On the Extend table page, select the table for you want to extend and click Next.
6. Next step: You create a new columns on the Configure columns page. For more information, see Defining Columns.

Detailed information about this topic

• Defining Columns
• Creating a Simple Column
• Creating a Foreign Key Column
• Creating New Columns for Database Views
• Configuring Column Properties

Related Topics

• Creating a New Table
• Creating New Assignments Tables
• Creating a Read-Only Database View
• Creating a Union View
• Mapping Table Definitions