The Schema Editor has different views for displaying and editing the One Identity Manager schema:
|Simple schema view||Tables and column definitions are displayed in tabular form in the simple schema view. You can use this view to quickly edit properties. This view is opened from the Designer's task view when a table or a column is selected.|
|Properties||In the edit view you can edit a database table, a database column or a table relation. The properties of a table, a column or a table relation are displayed depending on what you select. There is a default context menu available for the input fields.|
|Schema overview||You can get a overview of the entire One Identity Manager data model in the schema overview.|
It is possible to edit several column definitions or table relations at the same time in the simple schema view.
Entries in the list that have different input are labeled with the icon in the edit view. When one field is edited and saved, all the other entries are given the same value.
You can get a overview of the entire One Identity Manager data model in the schema overview.
NOTE: Tables and columns that are deactivated through preprocessor conditions are not shown in the view.
To display the schema overview
NOTE: When you select a table or column in the Designer, open the schema overview by using the tasks Show table ‘XY’ in schema and Show column ‘XY’ in schema.
Figure 13: Schema overview
Tables and their columns are displayed using a special control element. The name of the database table is shown in the header of the control element.All other entries represent columns in the table. Each control element entry has a tooltip. The contents of the tooltip depends on which display mode (data model or dependencies) has been selected. The column entries are labeled with icons that mark particular properties of the columns depending on the display mode.
Figure 14: Control Elements for Displaying Database Tables and their Columns
Use the menu items Options | Show all columns or Options | Hide all columns or the icons in the control element header to control how columns are displayed. Use Options | Hide small tables to only show the name of the table for tables with less than 20 columns.
You can change the layout of the control elements in the schema overview with the mouse. Using the menu item Options | Save table layout the changes made to the schema layout are saved in the internal database and in the Designer's change log.
Relations between tables or columns are represented by connecting lines. You can control how these are displayed using the menu item Options | Hide table relations. If the menu item is disabled all the connectors are shown. If the menu item is enabled then none of the connectors are shown. If a control element is selected the connectors are highlighted anyway without regard to the menu setting.
Figure 15: Using Connectors to Illustrate Relations
A connector points to column entries that are related to it. You can navigate between the connection points using the connector. When you select a connector the cursor changes to an arrow icon.Double click on the connector to move the view to other end of the connector. The direction is indicated by the arrow icon. Movement is controlled through the menu item Options | Animate movements. When the cursor passes over a connector a tool tip, whose contents depends on the display mode, is shown.
You can use the quick overview to navigate faster around the schema view. On the lower right edge of the schema overview there is a button which you use to open the quick overview. The area of the schema overview that is currently shown in the window is marked with a frame in the quick overview. Using the mouse you can move this frame around in the view. The corresponding area of the schema overview is then shown in the window.
Figure 16: Open Quick Overview