How are we calling stored procedures for provisioning operations in JDBC connector

[AsGoyal (Aayush Goyal)]

Hi All,

How are you guys calling a stored procedure to do provisioning operations like create/update account in a jdbc source under provisioning queries.

Are you facing issues with the same?

[suraj_gorle]

Hi @AsGoyal ,

You can call a stored procedure in the JDBC connector under Provisioning Queries, as shown below.

Although I have previously used SQL queries and they worked fine, I did not get a chance to test a stored procedure after this update. Are you currently facing any errors while executing it?

Thank you.

[AsGoyal (Aayush Goyal)]

Hey @suraj_gorle ,

I tried this and I am getting error executing this query.

[suraj_gorle]

@AsGoyal

I tried this and I am getting error executing this query.

Can you please share the error also value is populating as per expectation in plan ?

[Deepak_Chaudhary (Deepak Chaudahry)]

@AsGoyal

How are you guys calling a stored procedure to do provisioning operations like create/update account in a jdbc source under provisioning queries.

HI @AsGoyal SailPoint’s JDBC connector supports executing stored procedures by using callable statements in Provisioning Query blocks.

Could be please let us know what operation you are trying to achieve for eg. create,update,disable accounts using procedures ?