UME - Export UME Groups from AS Java using IdM

[Matt_Marples]

Hi All,

I'm trying to understand if it's possible to read UME groups assigned to users in a SAP Netweaver Portal and then export the list to a csv file using SAP IdM?

Many thanks.

[terovirta · Accepted solution]

Hello,

it's possible and easy.. Just create a modified Initial Load job. Initial Load reads data from target system to IdM storing the data to temp tables..

Basically:

1) Create the AS Java repository if it doesn't already exist (plus create the technical user to UME for the IdM-connection)

2) Create the Initial Load job from NW AS Java template for that repository

3) Delete all the passes from the job that writes anything to Id Store (the data remains in temp-tables)

4) Add a pass that extracts the groups/users to CSV.

regards, Tero

[Matt_Marples]

Hi,

Thanks of this.

The ReadAsJavaGroups pass send it data to a temp table as you explained above (see below)

I've created a simple SQL statement that select all of the records from the temp (sapXXXXXgroup) table but it doesn't provide me with any details about who these groups are assigned to in the UME?

[terovirta]

Hello,

the memberships go to the groupAssignments table, note the line in your screen shot that has data type "TABLE".

regards, Tero

[Matt_Marples]

Thankyou very much Tero!!!