User inbound interface is designed to load data into the following DB tables:
- PACE_MASTERDBO.PACE_USERS – User user fields
- PACE_MASTERDBO.PACE_USER_GROUPS – Business business group fields
- PACE_MASTERDBO.STARSEC_USER_GROUP – Application application group fields
- PACE_MASTERDBO.EGL_CENTER_ROLE – Center Role center role fields
- PACE_MASTERDBO.EGL_CENTER_ROLE_USER – Center Role center role for User user fields
- PACE_MASTERDBO.PACE_USERS_CONTACT_INFO or PACE_MASTERDBO.PACE_MAIL_USER_INFO (only 1 exists in a database) – Email email field
Stream name: eagle_ml-2-0_default_in_xml_user
Rule name: xml-user_user.xml
...
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