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’.
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.
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.