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
10/25/2024 06:18 AM
I want to copy Username and append with @domain.com in CP
10/25/2024 06:23 AM
10/25/2024 06:28 AM
im not importing Username, but Im creating Username in Saviynt using UserNameGeneration Rule.
How do I use #CONST#method to copy UserNamevalue to a CP in ImportUserJSON? will it work?
10/25/2024 06:30 AM
@vivekrajan1 try this
"ADDITIONALTABLES":
{
"USERS":"SELECT USERNAME,customproperty15,FIRSTNAME,LASTNAME,email from users"
},
"COMPUTEDCOLUMNS":
[
"EMPLOYEEID"
],
"PREPROCESSQUERIES":
[
"UPDATE NEWUSERDATA NW SET NW.EMPLOYEEID=NW.USERNAME"
]
}
10/25/2024 06:46 AM
As mentioned, If I do not use "USERNAME" in "COMPUTEDCOLUMNS" im getting error.
If I use USERNAME in COMPUTEDCOLUMNS, then Username becomes blank, because I am not creating UserName in Preprocessor
@rushikeshvartak @NM - is there a way to overcome this situation?
10/25/2024 06:56 AM
10/25/2024 07:21 AM
it means, i need to have CP15 mapping in ImportUserJson. And once user gets created, EIC will create a UpdateUser Task, then through WSRETRY job CP15 will be populated.
Am I correct?
10/25/2024 07:58 AM
Yes
10/25/2024 06:32 AM
No