Entitlement Owner mapping using enhanced query

[SSinha_]

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

[naveenss]

Hi @SSinha_ Is there any reason you're not using csv file based option to add owners to entitlements?

[Dhruv_S]

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

[SSinha_]

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

[NM]

Hi @SSinha_ , is it a db connector?

[SSinha_]

No @NM , we are importing files based on schema job

[NM]

1 sav file and other csv file? and entitlement owners are also present in the same file?

can you share to check the config?

[SSinha_]

Yes we are mapping entitlement entitlment using SAV File approach mentioned here

https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter02-Identity-Repository/Uploa...

[rushikeshvartak]

Great You can mark suggested solution as accept solution

[rushikeshvartak · Accepted solution]

Workaround

• upload data in dataset
• read data using analytics 
• use sav4sav rest connector 
• call entitlement update api and map owners
• https://forums.saviynt.com/t5/identity-governance/unable-to-populate-usercustomproperty-based-on-sav...

[SSinha_]

Thank you , will try it out and get back to you

[rushikeshvartak]

• You can't insert into entitlement_owners using enhanced query as table contains composite keys 
• Please use CSV format as suggested by Dhruv