Hi All,
I’m using Sailpoint 7.3 version of Sailpoint IIQ. While performing the provisioning the account gets created but the request is stuck in pending state. I tried running Perform Identity Maintenance task as well but no luck.
@bijay_biswas - Please follow the below approach to onboard any DB Application to SailPoint IIQ.
I’ll first divide the whole integration into two parts - Aggregation and Provisioning. Let’s start with Aggregation -
Let say before application onboarding the Application has got 100+ users. In order to manage these existing accounts, we need to bring the account footprint to SailPoint. For this we generally run the Account Aggregation Job. When you run the account aggregation job, the below configuration comes into the picture -
This will iterate all the records from the database. During the iteration it look out for the Correlation stuff, in layman terms this DB account belongs to which SailPoint user. To do this it makes use of Account correlation i.e. through which attribute of Database you can identify a user in SailPoint. In my case, I was checking if my dbID of database matches with name attribute of SailPoint, then account linking will happen.
This is how entire Aggregation works.
Moving to the provisioning part -
As usual we have the Provisioning rule to handle the account creation/modification/deletion in the Database. One Important parameter to look is GetObjectSQL under the configuration Make sure you are having valid query here. Refer the sample below.
This parameter is used when you performed the provisioning and then running the perform Identity Request Maintenance task it will trigger this query to check if the provisioning was successful or not. If this is not configured, you will see Access Requests Stucks in verifying state.
Hope this clarified your doubts. Mark it as solved, If it helps.
@officialamitguptaa - Thanks for the explaination. I think I haven’t defined the GetObjectSQL. Let me configure the same and check.
I’ll keep you updated.
Thanks for your help.
@officialamitguptaa After having the getObjectSQL query placed, the things started to work. However I do have some other glitches but I can take care of them.
Thank for your help. Much appreciated!!
1 Like
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.