JDBC - Not loading all entitlements

After configuring a JBDC to Sybase, we managed to retrieve all identities, yet struggle to load the corresponding entitlements. We downloading the account CSV, we see all data, but SailPoint only shows 3 entitlements in IdentityNow.

Before we had issues with data ordering, hence had to include ‘disableOrderCheck’.

image

Hi @JacobMareenGT

Do you have a query for entitlement aggregation or you’re just trying to detect them off of the account aggregation query? Also, if you can, share the query you’re using to aggregate.

In your account schema, check if you need the ‘multivalued’ flag enabled in case a user on this source can have multiple entitlements. Also try to validate if there are any special characters in the entitlement name that may be causing any unexpected errors.

Issue seemed to have solved itself over the weekend…

Aggregation of entitlements was based on account aggregation.
In the schema multi-valued was selected.

1 Like

I do believe it is better to also have a separate entitlement aggregation setup if at all possible. This way you can have users request entitlements that haven’t been assigned to any existing user yet.

@JacobMareenGT Glad it’s working. Did you check for the reason it wasn’t working with SailPoint Support? Perhaps for future reference on this thread, you can leave the details in here.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.