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 …

Hi @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 R…

[image] sai krishna: SELECT GHID , GHDES FROM RMTFIL.SAGRHP WHERE GHID in (‘USRDR’,‘SUPUPD’) 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 …

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

JDBC connector Account to Entitlement Mapping Issue

Identity Security Cloud (ISC) ISC Discussion and Questions

sai_krishna_L (sai krishna) May 5, 2025, 4:50am 3

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

Topic		Replies	Views
JDBC connector Entitlement and Account Aggregatiom ISC Discussion and Questions aggregation , identity-security-cloud , provisioning , entitlements , jdbc-connector	5	352	December 6, 2024
Aggregate Entitlement and Accounts from JDBC Source ISC Discussion and Questions aggregation , identity-security-cloud , provisioning , entitlements , jdbc-connector	17	2544	October 6, 2023
Account Aggregation Issue ISC Discussion and Questions aggregation , identity-security-cloud	13	151	December 29, 2024
JDBC Connector (Entitlement Aggregation failure) ISC Discussion and Questions aggregation , identity-security-cloud , entitlements	6	331	July 27, 2024
SQLLoader Aggregation Issue — Entitlements Not Becoming Assignments in IDN ISC Discussion and Questions aggregation , identity-security-cloud , entitlements	6	49	January 31, 2026

JDBC connector Account to Entitlement Mapping Issue

Related topics