Hi Team,
Problem statement : Entitlement is not getting mapped to the account. Attached all the required queries and snippet of schemas.
Account query :
SELECT sausr,ghid FROM RMTFIL.SAUSRP left join RMTFIL.SAGRHP on saacnt = ghid WHERE SALEVL = ‘GR’ AND SAACNT in (‘USRDR’,‘SUPUPD’)
Entitlement query :
SELECT GHID , GHDES FROM RMTFIL.SAGRHP
WHERE GHID in (‘USRDR’,‘SUPUPD’)
Account Schema:
Entitlement Schema:
Kind Regards,
Sai Krishna L
Why the GHID is marked as entitlement in the entitlement schema ?
Hi Safae,
I was just trying different ways to map the entitlement to account. Even without GHID is marked as entitlement in the entitlement schema it’s not working.
Regards,
Sai Krishna L
After those changes, did you try running an unoptimized aggregation?
Hi Gopi,
I did try an unoptimized aggregation, but the expected output is not there. Can you let me know if the column names are different but with same value will that entitlement still map to the account?
Example:
Entitlement Columns:
GHID: USRDR
SAACNT: USRDR
Account Column:
SAUSR: 12345
Regards,
Sai Krishna L
Hi @sai_krishna_L ,
I have a quick question, do you wish to have different attributes in the entitlement schema to manage the entitlement or you just need to promote one of the account attribtue as a entitlement?
Regards,
Karthi
Hi @Karthikeyan_U,
I just need to promote one of the account attribute as an entitlement. So that entitlement to account mapping will happen.
Regards,
Sai Krishna L
No need to define the ent schema if you are not pulling any of ent attributes except GHID. Also, are you able to see the entitlements in Entitlements tab after running aggregation? Make sure Multivalued option has been chosen for GHID in account schema.
Hi Theja,
If we don’t define the Ent schema then the master Ent list won’t be present. Hence, it’s a mandate I should read the Ent with master table itself.
Hi,
Have you run the query seperately by connecting to MySQL workbench and is it getting the entitlement values? This way we will know whether query issue or connector issue.
Hi @sai_krishna_L,
Like @JackSparrow mentioned, you don’t have to mandatorily define entitlement unless you wish to manage the Entitlements (create, modify/update, or delete). The account schema alone is fine for promoting the entitlements in SailPoint ISC.
Regards,
Karthi
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
