Symantec IGA

 View Only
  • 1.  User provisioning through SQL stored procedure

    Posted Nov 25, 2019 09:04 AM
    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

    Broadcom Employee
    Posted Nov 25, 2019 10:13 AM
    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

    Broadcom Employee
    Posted Nov 27, 2019 01:59 AM
    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)