Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/25/2024 11:53 PM
Hi team,
We want to insert only rank 1 owners into entitlement using data set by utlizing the enhanced query execution. Is it it possible to do so? If yes then how can we put joins and so on in enhanced query.
Data set format
Entitlement , Owner
RoleA, 123451
Solved! Go to Solution.
06/26/2024 10:12 PM
Hi @SSinha_ Is there any reason you're not using csv file based option to add owners to entitlements?
06/26/2024 10:19 PM
Hi @SSinha_
This is achievable by csv import using Upload Entitlement Associations From CSV option.
Please find attached sample file where I have added owner with Rank1 to the entitlement.
Regards,
Dhruv Sharma
06/27/2024 01:32 AM - edited 06/27/2024 01:32 AM
Thank you for all the responses , but the csv file is not being used since post entitlement recon all the owners are deleted and we need to upload the CSVs again after each entitlement import(file based) and I tried the SAV file approach but the issue is that the role owner csv file always moves to the sucess folder so again we need to upload it. An alternative solution would be a way to stop the owner file from moving into the success folder after the schema based job has been completed? is there a way
06/27/2024 03:34 AM
Hi @SSinha_ , is it a db connector?
06/27/2024 05:35 AM
No @NM , we are importing files based on schema job
06/27/2024 07:04 AM
1 sav file and other csv file? and entitlement owners are also present in the same file?
can you share to check the config?
06/28/2024 08:43 AM
Yes we are mapping entitlement entitlment using SAV File approach mentioned here
06/28/2024 10:59 AM - edited 06/28/2024 10:59 AM
Great You can mark suggested solution as accept solution
06/27/2024 07:08 AM
Workaround
06/28/2024 08:39 AM
Thank you , will try it out and get back to you
06/26/2024 10:23 PM