Identity Manager 8.1 - Configuration Guide

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 database level. These are therefore available at object level with all the 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 to the One Identity Manager schema, use the Schema Extension program. You can carry out the following extension in the Schema Extension:

• Create new tables

• Create new assignment tables

• Create new columns

• Create new views

• Create new indexes

• Removing custom schema extensions

  You can only delete custom schema extensions on databases with the staging level Test environment or Development system.

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 and QBMRelation tables. You must then adjust the properties in 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 program Schema Extension. 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 string CCC_.
• All names are a maximum of 30 characters long.
• One Identity recommends using UpperCamelCase as notation for the names.

Detailed information about this topic

• Creating a new table
• Creating a new assignment table
• Extending a table
• Creating database views with read-only type
• Creating database views of Union type
• Creating indexes
• Removing custom schema extensions
• Permissions for schema extensions
• Change labels for the schema extensions
• Applying the schema extensions

Related Topics

• One Identity Manager schema basics
• Table types and default columns in the One Identity Manager data model
• Recommendations for advanced configuration of custom schema extensions
• Managing custom database objects within the database

Creating a new table

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 schema CCC<Table name>.
• 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. Open Launchpad and select One Identity Manager Schema Extension. This starts the Schema Extension program.
2. Click Next on the start page.
3. On the Database connection page, enter the connection credentials for the One Identity Manager database.
4. On the Select method page, choose New table.
5. On the Create new table page, enter the following information.

   Table 182: Table properties

   Property	Description
   Table	Technical identifier 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

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

Related Topics

• Table types and default columns in the One Identity Manager data model
• Extending a table
• Creating a new assignment table
• Creating database views with read-only type
• Creating database views of Union type

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 Schema Extension program.
2. Click Next on the start page.
3. On the Database connection page, enter the connection credentials for the One Identity Manager database.
4. On the Select method page, select Extend table.
5. On the Extend table page, select the table that you want to extend from the Table menu.
6. On the Configure columns page, create the new columns. For more information, see Defining columns.

Related Topics

• Table types and default columns in the One Identity Manager data model
• Creating a new table
• Creating a new assignment table
• Creating database views with read-only type
• Creating database views of Union type

Defining columns

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

Detailed information about this topic

• 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

Related Topics

• Table types and default columns in the One Identity Manager data model