Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

User account correlation rule

shivmano
Regular Contributor III
Regular Contributor III

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

2 REPLIES 2

RMG
New Contributor II
New Contributor II

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.

PremMahadikar
Valued Contributor
Valued Contributor

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