Symantec Identity Management

Expand all | Collapse all

User provisioning through SQL stored procedure

Jump to Best Answer
  • 1.  User provisioning through SQL stored procedure

    Posted 15 days ago
    Hello All,

    We have an requirement to provision user into one of the Application which is using MS SQL as a database. However, CA IM has an out of box connector to acquire the SQL end point, but that's not serving the purpose as application team has build an stored procedure called "IDM_PUSH_USER" and we are not sure how we can call it to provision the user into Application.

    Could you please suggest a way to achieve this.

    Regards

    CA IM


  • 2.  RE: User provisioning through SQL stored procedure
    Best Answer

    Posted 15 days ago
    You would want to look at using ConnectorXpress to create a JDBC connector and then look at Operational Bindings to trigger stored procedures.

    https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/identity-management-and-governance-connectors/1-0/connectors/dynamic-connectors-connector-xpress/connector-xpress.html


  • 3.  RE: User provisioning through SQL stored procedure

    Posted 14 days ago
    As Kenny pointed out, you would need a custom JDBC connector to run the Stored Procedure in the specific way your system is designed, with OP Bindings for specific Stored Procedure.
    The OOTB SQL Connector is for Provisioning Users to the overall DB server (much like sa user etc)