This section describes the procedure to create multi-valued custom fields in One Identity Manager.
To create multi-valued custom fields in One Identity Manager
-
Create a custom column in the respective User tables in the database.
- Create a custom column in CSMUser table.
To create a custom column in CSMUser table
- Open SchemaExtension. exe.
- In the Select Method window, select Extend table and click Next.
- In the Extend table window, select CSMUser table and click Next.
- In the Configure columns window, click Create New column (+).
- In the Create new column window, enter a name for the column. For example: RolesID.
- Enter a display name for the column to be displayed in Manager.exe.
- In the Configure columns window, select the data type as string from the Data type list and click Next.
- In the Access permissions window, add appropriate permissions and click Next.
- Click Finish after the compilation is done.
-
Repeat the steps for all custom columns that you have to create. For example: RolesName, WorkspaceID, and WorkspaceName.
-
Create a custom column in UCIUser table.
To create a custom column in UCIUser table
-
Repeat the steps that you performed for creating a custom column in CSMUser table.
-
Ensure that you use the same column name and other details used when you created a custom column in CSMUser table.
-
- Create a custom column in CSMUser table.
- Change the created custom column to multi-value in both the tables.
-
Change the created column in CSMUser table to multi-value.
To change the created column in CSMUser table to multi-value
-
Open Designer.exe.
-
Select One Identity Manager Schema in the left pane.
-
Click Show Table Definition.
-
Select CSMUser.
- Select the created custom column.
-
Select the More tab.
-
Select multi-value column and click Finish.
- Select Commit to database.
-
Select Compile Database.
-
-
Change the created column in UCIUser table to multi-value.
To change the created column in UCIUser table to multi-value, repeat the steps that you performed for CSMUser table.
-
-
Create custom mappings and add directions accordingly.
-
Add mappings for each custom field created.
-
Add the mapping directions accordingly.
-