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 database system's SQL Server in use 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 more information about checking data consistency, see the One Identity Manager Operational Guide.
Detailed information about this topic
- Creating new tables
- Creating new assignment tables
- Extending tables
- Creating database views with read-only type
- Creating database views with Union type
- Creating indexes
- Removing custom schema extensions
- Permissions for schema extensions
- Change labels for the schema extensions
- Adding schema extensions to the database