Bulk Import Business Roles with Dynamic Query

Question

I have several hundred business roles that need to be created in One Identity Manager. Is there a way to bulk load them with the query included (maybe using Data Import)? If so, what table/view would I use? Thanks!

Markus Weiss-Ehlers · Accepted Answer

You are right, after you have added the business roles to the Org table, you need to created an associated entry in the table DynamicGroup. 
 You need to provide all of the mandatory properties including the where clause. 
 
 The memberships for a role a stored in a M:N table called PersonInOrg. 
 For more information please take a look at the Identity Manager 7.1.1 - Business Roles Administration Guide 
 If you need to know some more table names in the future, one of the easiest way to find out the table name of an object is, to load an object in the Manager and open the object properties. In the primary key, you will find the table name in the <T> tag. See sample for the dynamic roles. 
 
 Hth

Barry Jackson · Answer

Hi Victoria, 
 
Business roles go into the 'Org' table. Dataimporter will work .... if you're on version 7.0 or above you have the option of a CSV Sync Project as well. 
 
If you use Dataimporter and you want a regular import you'll have to build a process, process plan, schedule etc. to make this happen. 
 
The CSV Sync Project has all those constructs built-in. 
 
HTH, Barry.

Markus Weiss-Ehlers · Answer

Yes it is possible. 
 You need to use a virtual property of type Key resolution to do the resolution of your display name and return the XObjectKey of the org. 
 A sample is in the screenshot. Please adapt to your needs.

Bulk Import Business Roles with Dynamic Query

Top Replies