MDM repository users backup

[Former Member]

Hi All,

Can anyone share how to save users to file in MDM repositories for us to be able to reload them after repository refresh? We regularly perform refresh of repositories from our MDM prod to non-prod, and we always have to recreate users, which appears to be time consuming since there is no mass user creation in MDM that we know of.

Appreciate any response. Thanks.

Regards,

Philip

[former_member226173]

Hi Rumar,

The below link explains the process on how to upload the data back into the User table in the DB . To copy the data from the DB you can use the below Query

Kindly use the below link .

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0224edf-bf37-2c10-228f-c16415815...

Regards,

Vag Vignesh Shenoy

[cweissheimer]

Hello Phillip,

The only way I can imagine this being achieved is by using a custom MDM Java API application that uses the com.sap.mdm.security.commands.CreateUserCommand to create the users.

You can use the Export Repository Users functionality (implemented in SP11) to make this easier and read all users from the exported csv file.

Best Regards,

Carlos