SQL Loader issue for provisioning

Identity Security Cloud (ISC) ISC Discussion and Questions
1

Hey Team ,

Integrated SQL Loader connector and also try to provision account into it and it is showing success (completed) through access request center.But while aggreagtion that account is not cmoming into sailpoint ? Any idea

2

Hi @Rakesh_Singh_1234 ,

If provisioning is showing as successful but the account isn’t appearing after aggregation, I’d first check whether the account was actually created in the target SQL table.

Also verify:

  • The aggregation query returns the newly created record.
  • There are no filters excluding the account during aggregation.
  • The native identity/account ID is populated correctly.

In most cases, either the account wasn’t created as expected or the aggregation query isn’t picking it up.

Thanks.

3

For SQL loader, provisioning updates are not performed by the OOTB connector. We need a JDBC provisioning Rule to execute the insert/update/delete operations.

Verify the JDBC provisioning Rule is attached to the source and that it is executing the required write operations.

refer :