Symantec Identity Management

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  How do we make use of a stored Procedure in Connector Xpress

    Posted 09-06-2019 05:36 AM

    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



  • 2.  RE: How do we make use of a stored Procedure in Connector Xpress
    Best Answer

    Posted 09-07-2019 10:51 AM
    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


  • 3.  RE: How do we make use of a stored Procedure in Connector Xpress

    Posted 09-09-2019 08:22 AM
    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