User inbound interface is designed to load data into the following DB tables:
...
Microstrategy Model Processing Details
microstrategyRole can get the following valid values (MSTR_ROLE code category):
- 1 - Consumer;
- 2 - Writer;
- 3 - Administrator.
microstrategyUserStatus can get the following valid values (MSTR_USR_STATUS code category):
- 1 - ACTIVE;
- 2 - INACTIVE;
- 3 - DELETED.
Deleting User
To delete a user, make sure you have set header/action = ‘DELETE’, the User will be deleted, and the followings elements:
- userId
- updateSource
Switch Off Password Encryption
If you load data thru the panel, user password is encrypted by default. To switch off encryption, you should add a header/processingOptions element with "APPLY_NO_RULE_password" value:
Code Block | ||
---|---|---|
| ||
<EagleML xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" eaglemlVersion="2-0" eaglemlType="UserAdministrationTransactionMessage" xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd" xsi:type="UserAdministrationTransactionMessage"> <userAdministrationTransaction> <header> <objectType>User</objectType> <processingOptions>APPLY_NO_RULE_password<processingOptions>password</processingOptions> </header> <user> <objectType>User</objectType> <objectId>User</objectId> <objectDescription>User</objectDescription> ... |
...