Symantec IGA

  • Private Community
Back to discussions
Expand all | Collapse all

IDM Connector Xpress sql server endpoint autoincrement without 'Identity'

  • 1.  IDM Connector Xpress sql server endpoint autoincrement without 'Identity'

    Posted Jul 06, 2018 12:48 PM

    We need to insert a record into a table (users) whose PK it's NOT  'Identity' enabled;

    The problem we are having is that after inserting a second record the account template synchronizes this value into all records which would violate the PK

     

    We need a procedure to achieve the autoincrement without changing the table structure that is without "Identity" enabled



  • 2.  Re: IDM Connector Xpress sql server endpoint autoincrement without 'Identity'
    Best Answer

    Posted Jul 16, 2018 04:44 AM

    Hello,

    Create a policy Xpress policy to generate a unique value in IDM and store the same in a attribute (Dummy Attribute) and map the same attribute with the sql table column.

     

    Thanks,

    Bherulal Dhakad