How do we make use of a stored Procedure in Connector Xpress

[Wesley Masunika]

Good day

I hope you are well.

We have connector built for a Sybase database. We would like to update/sync the password from CA IDM making use of a stored procedure to encrypt the password.

Can you please provide me a detailed guide on how i can make use of the stored procedure to encrypt the password and update it on the endpoint.

If you can, can you find out how they used it as per the below link:

https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=30986

Regards

Wesley

[Praveen Jain]

Hi Wesley,

You call stored procedures on BEFORE and AFTER state of Create, Modify, Delete user event. You configure this under Operation Bindings in Connector Xpress

[Wesley Masunika]

Hi Praveen

Thanks for the above.

In my case i would like to call a stored procedure called sp_password. It will encrypt and update the password.
The store procedure takes three parameters,  sp_password("adminpassword", "UserNewPassword","useraccount") 

In connector Xpress, what properties in the classes section should I map?

Thanks and regards
Wesley