Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/24/2024 11:19 PM
Hi Team,
We are importing User details(FN,LN,Email etc) from HR systems, and Saviynt creates Username using UserNameGeneration Rule. At the same time I need to copy the generated UserName into user's CP15.
Is it possible to copy the username to CP15 field during user onboarding?
I was checking Enhanced Query Job, but it will not check USERS table.
Is this scenario possible using Preprocessor Query in ModifyUserDataJson? If yes, Could you please give me a example.
10/24/2024 11:44 PM
@vivekrajan1 yes preprocessor should work .
Sample
SET NEWUSERUSERDATA.CUSTOMPROPERTY15=NEWUSEDATA.username
10/25/2024 03:07 AM
Thank you I will test this out,
1 last question, UserName Generation Rule will trigger only for the New Users and I could use preprocessor query to Copy the value to CP15.
If I use Preprocessor query to create UserName, is it possible to copy Username to CP15?
Thanks,
Vivek
10/25/2024 03:11 AM
@vivekrajan1 yes just have cp15 set afterwards.
10/25/2024 06:00 AM
* If I donot use USERNAME in COMPUTEDCOLUMNS, then UserImportJob fails with this message,
Error in Users Import - Error while processing data: Unknown column 'NW.USERNAME' in 'field list'
* If I use USERNAME in COMPUTEDCOLUMNS, then UserName field becomes blank and UserID is not creating. Because Username is generated via UserNameGeneration Rule and not by Preprocessor. How do I overcome this?
{
"ADDITIONALTABLES":
{
"USERS":"SELECT USERNAME,customproperty15,FIRSTNAME,LASTNAME,email from users"
},
"COMPUTEDCOLUMNS":
[
"EMPLOYEEID","USERNAME"
],
"PREPROCESSQUERIES":
[
"UPDATE NEWUSERDATA NW SET NW.EMPLOYEEID=NW.USERNAME"
]
}
10/25/2024 06:02 AM
10/25/2024 06:07 AM
Users created through UserImport Job(REST Connector).
We create Username through UserNameGeneration Rule
10/25/2024 06:13 AM