Layer 7 Identity Management

Expand all | Collapse all

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

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

    Posted 11 days ago

    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

    Posted 10 days ago
    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 8 days ago
    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