Chat now with support
Chat with Support

Identity Manager 9.2 - 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
Mapping processes in One Identity Manager Setting up Job servers
The One Identity Manager Service functionality Tracking changes with process monitoring Conditional compilation using preprocessor conditions Scripts in One Identity Manager
Visual Basic .NET scripts usage Notes on message output Notes on using date values Tips for using Windows PowerShell scripts 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 scripts in the 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 running scripts Editing and testing script code with the System Debugger Extended debugging in the Object Browser
One Identity Manager query language Reports in One Identity Manager Adding custom tables or columns to the One Identity Manager schema Web service integration One Identity Manager as SCIM 2.0 service provider Processing DBQueue tasks One Identity Manager Service configuration files

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 167: 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 of table page, create the new columns. For more information, see Defining columns.

Related topics

Extending tables

To extend an existing 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 Extend table.

  6. On the Extend table page, select the table that you want to extend from the Table menu.

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

Related topics

Defining columns

On the Configure columns of table page in the Schema Extension, you can see which columns already exit for the selected table and how many resources are free for new columns.

NOTE: Take the maximum size allowed for a table into account when extending.

Detailed information about this topic
Related topics

Creating simple columns

Technical details

  • The technical identifier for the column is automatically formed according to the CCC_<column name> schema.

To create a simple column in the Schema Extension

  1. On the Configure columns of table page, click .

  2. Select the Simple column option and enter the name of the column under Column name.

  3. Click OK.

  4. On the Configure columns of table page, enter at least the following information.

    Table 168: General column properties

    Property

    Description

    Required field

    Specifies whether a column must be filled.

    Data type

    Column data type Permitted .Net data types are listed in a pop-up menu. These are represented internally as SQL data types.

    Length

    Column length The column length is only specified for the .Net String data type.

    Display name

    Specifies how the column is labeled.

  5. (Optional) Click to configure more column properties. For more information, see Advanced configuration of columns.

Related topics
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating