Identity Manager 8.0 - Configuration Guide

Configuring Column Properties

To edit column properties

1. Select the column on the Define column page and click the button.
2. Configure the column properties.
3. Click OK.

You can configure the following settings for a column.

Only value types that are already in the One Identity Manager data model are permitted.

Related Topics

• Creating a Simple Column
• Creating a Foreign Key Column
• Creating New Columns for Database Views
• Mapping Column Definitions
• Mapping Table Relations

Creating a Read-Only Database View

Views with the table type "read only" can be parts but also unions of the underlying tables. Views with type "read only" are predefined. Templates and formatting rules cannot be defined for columns in these views.

Database views of type "read only" are mainly used to edit the user interface and for creating reports.

To create a database view of type "read-only" 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 view table on the Extension method page and click Next.
5. Enter the properties for the database view on the Create view page and click Next.

   Table 314: Database View Properties

   Property	Description
   Table	Name of the table. 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.
   View definition	Enter the database query as a SELECT instruction. The first column in the database query is used as primary key column in the database view.

   NOTE: It is recommended you reference the primary key column for the queried table as the first column in view definition. If this is not possible, then at least select a unique characteristic.

6. Next step: Create foreign key relations on the page Create FK relations for view. For more information, see Creating Foreign Key Relations for Views.

Related Topics

• Database Views of Type "Read-only"
• Creating a Union View

Creating Foreign Key Relations for Views

If a database view contains a foreign key column, you specify which destinations tables should be referenced. The table and column relations are generated automatically.

To create a foreign key for a view in the Schema Extension

1. You create foreign key relations on the page Create FK relations for view.
   1. Double-click on in front of the column name to release the "Destination table" column.
   2. Select the destination table in the column "Destination table".
   3. Click Next.
2. Next step: You define the column properties on the Configure columns page. For more information, see Configuring Column Properties.

Related Topics

• Creating a Read-Only Database View
• Creating a Union View
• Creating a Foreign Key Column
• Database Views of Type "Read-only"
• Database Views of Type “Union“

Creating a Union View

Database views with the table type "Union" are views of the union of different tables and supply a grouping of different object types with the same context. Thus the union view QERAccProductUsage determined, which service items are used in which products, for example.

Views of type "Union" are predefined. Templates and formatting rules cannot be defined for columns in these views. The object key column (XObjectKey) must be referenced in the view definition. This makes it possible to create single object with its valid permissions.

"Union" views are mainly used for editing the user interface and for creating reports.

To create a database view of type "union" 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 union table on the Extension method page and click Next.
5. Enter the database view properties on the Create union view page and click Next.

   Table 315: Database View Properties

   Property	Description
   Table	Name of the table. 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.
   View definition	Enter the database query as a SELECT instruction. You must reference the object key (XObjectKey) as the first column in the database query. Using the object key makes faster access to individual objects with valid permissions possible.

6. Next step: Select the permissions groups to obtain permissions for the schema extensions on the page, Access permissions. For more information, see Permissions for Schema Extensions.

Related Topics

• Database Views of Type “Union“
• Creating a Read-Only Database View