Skip to Content

BI Platform - Alias mapping between SAP and LDAP help

dear all

I have LDAP authentication user e.g. john.smith, which i want to automatically alias to a SAP authenticated user e.g AB1~100/JOHN1S, when user is imported/update.

NOTE: the user objects are NOT the same. see my example above

can anyone point me in the right direction to do this.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 25, 2017 at 05:48 PM

    If the user ID's are the same between the systems, then they will automatically alias. If they're not the same, you have a couple of options.

    1. Manually map one to the other. Starting with the properties of one or the other user object, scroll down to the bottom of the page and click on "Assign Alias". Select the alias from the list on the left - you'll probably have to search for it - and move it to the right then click on OK. Save the user. If you're going to do this for many users, I would always start from the same type of user object - LDAP or SAP. NOTE: If you do this for user objects that have been in your system a while and where the user has saved stuff to their Favorites, I think they will lose the favorites from the object that you assign as the new alias unless they're moved/copied somewhere public and then moved into the Favorites for the user object the alias is assigned to.

    2. If you want this to happen automatically, you'll have to write code using the SDK that will read some sort of "mapping" file to get both of the user IDs, copy the favorites from one to the other, and then assign the alias. I have done this and it's not too difficult. I write the code in Java, descending from IProgram so that it can be run on a schedule inside BO. It gets scheduled to run about 5 minutes after the user update is scheduled to run from the various authentication types (means you can't set them to create the user when the user logs in - user has to be created through an authentication type user update.


    Add comment
    10|10000 characters needed characters exceeded

  • Aug 28, 2017 at 12:07 PM

    If your username are the same except for the SAP portion alias, you can remap all your SAP users without the system~client/ portion using this KBA . If not then as said you would need to look at a custom solution, they are out there and provided as a service by consultants as well.


    Add comment
    10|10000 characters needed characters exceeded

    • That will require a custom solution. SAP Consultants provide this service, it basically work sby them identifying some other attribute in common and use that to custom script a joining of the aliases, I don't think we have any simple way to accomplish this outside of custom code.

  • Oct 20, 2017 at 09:09 AM

    hi dell, do you think you could share your code a little for me, thanks

    Add comment
    10|10000 characters needed characters exceeded