Hi All,
We are trying to implement email generation for users where the email domain will be based upon the Brand user belongs to. Below different scenario's should be validated before we assign a new unique email address for the user or update existing email address.
Eg: There are 3 different email domains as mentioned below and prefix of email domain would be firstname.lastname@domain.com. If there are multiple users, then lastname will be appended within Incremental value (firstname.lastname1@domain.com, firstname.lastname2@domain.com so on..)
3 different email domains:
1. aaa.com
2. bbb.com
3. ccc.com
Scenario : While generating the new email address, the uniqueness should be checked against the prefix of the email domain instead of checking on the complete email.
Eg: User1 with firstname as "Test" and lastname as "user" is onboarded with domain as aaa.com. Then for this user, email would be "Test.user@aaa.com"
Now, User2 with same firstname and lastname as user1 but with different domain bbb.com is onboarded. Now, for this user, email should be Incremented to "Test.user1@bbb.com" since prefix is already taken by a different user belonging to different domain, but saviynt would consider Test.user@bbb.com also as Unique email since there is no existing user with that email and assign this email to 2nd user.
Note: We will be loading all the ProxyAddresses from AD into User_Attributes table for unique email generation against existing Proxy Addresses as well.
We thought of implementing custom jar for email generation, but couldn't find any API's which can be used for checking against the proxy address within the user_attributes table for uniqueness.
Implementing custom MYSQL function can be one of the option, but Saviynt doesn't seem to support deploying custom MYSQL functions into Saviynt DB now. Also, we would want to implement the solution as much possible with OOTB features instead of implementing via custom Jar/mysql function.
Any thoughts on how we can check the uniqueness with only the Prefix excluding the domain value within the email?
Thanks,
Nitish
