Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/15/2024 10:44 PM - edited 04/15/2024 11:17 PM
Hi Team
I am trying to perform user account correlation rule for SAP account import and below are the conditions that I need to address
1) username=account name
2) lastname + first 2 characters of firstname = account name
3) lastname + first 1 character of firstname = account name
4) customproperty3 = account name
Below is the code I am using but the correlation is not working. Can someone please advise.
LOWER(users.username)=LOWER(accounts.name) # LOWER(concat(users.lastname,left(users.firstname,2)))=LOWER(accounts.name) # LOWER(users.customproperty3)=LOWER(accounts.name) # LOWER(concat(users.lastname,left(users.firstname,1)))=LOWER(accounts.name)
Also, I currently have wrong usernames mapped with accounts. I have tried using basic config and re-ran the import but the correlation is not changing. How can I remove the existing correlations?
Thank you
Solved! Go to Solution.
04/16/2024 12:53 AM
To remove the correlation, please remove the correlation config and set it to blank. This will set all accounts as Orphan, once this is completed try using basic config.
04/16/2024 06:23 AM
Hi @shivmano ,
1. Correlation rule is non-case sensitive, don't use 'LOWER'. Try below, its working for me:
users.username=accounts.name # concat(users.lastname,left(users.firstname,2))=accounts.name # users.customproperty3=accounts.name # concat(users.lastname,left(users.firstname,1))=accounts.name
2. Once the account is correlated to the user, configured new correlation wouldn't change existing account - user mapping.
Check this resolved article which would help you to un-map and re-map the user with new correlation rule - Solved: Disconnected Application - Incorrect User Account ... - Saviynt Forums - 30172
If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos