JDBC Provisioning - JDBC Account not reflected or linked to Identity

Hi,

I am working on JDBC connector. Where I have used BeforeProvisioning and Provisioning rules to create account.

However, the entry is successfuly created in the db table but still in IDN UI, the account is not reflected in Identity account tab. Not sure I am missing out.

These what I have done.
1-BeforeProvisioning rule
a) Have set accessRequest.setNativeIdentity(plan.getNativeIdentity());

2-Provisioning rule
a) PreparedStatement
–Set [id] == identity.ADId
–Set [nric] == identity.nric

3-Connector
a) Account Schema -
– Set correlation as uid = [nric]
– Account ID = [ADId]

Note that my Identity Profile, the identity uid is based on identity nric.

Not sure why is not appear under Account after provisioning.

I would start looking at the source correlation logic to ensure that it was correct. It sounds like while the account is being sent and created that it is not correlating to the cube. After this I would look at an existing user who had the account successfully correlated and verify that the new user has all the same data applied to allow for correlation.

Have verified the correlation rule is correct. I assume aggregation is not needed in order to reflect in IDN right?

Do you have your Account Single Query setup? After the rule runs to create the account successfully, it will use the Account ID value your provided in your create policy/provisioning rule to attempt to read the account back after the provisioning result returned from your JDBC rule is in a COMMITTED state. If the single account query is not set up, a full aggregation would be needed after the creation runs to bring the account in.

Hi Patrick,

Do you mean that apart from Account Single Query, it is also required for JDBC Provisioning Rule to set Account ID in the provisioning result variable return?

On top of it, I am not able to see in javadoc for ProvisioningResult and ResourceObject do not have set function.

https://developer.sailpoint.com/rule-java-docs/sailpoint/object/ResourceObject.html
https://developer.sailpoint.com/rule-java-docs/sailpoint/object/ProvisioningResult.html

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