Remove string from username

[Sitarasmi]

Hi Team,

We have SuccessFactors REST connectors configured in Saviynt. By default it imports usernames for all users with '_onb' as suffix.

We want to remove this suffix from username while user creation.

Please suggest.

Thanks,

Sitarasmi

[vivek9237 · Accepted solution]

@Sitarasmi You can use MODIFYUSERDATAJSON (Inline preprocessor) is REST connector to do this.

This is the document for Inline preprocessor - https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter03-User-Management/User-Impo...

Sample MODIFYUSERDATAJSON  - 

{
  "ADDITIONALTABLES": {},
  "COMPUTEDCOLUMNS": [
    "USERNAME"
  ],
  "PREPROCESSQUERIES": [
    "UPDATE NEWUSERDATA SET USERNAME= REPLACE(USERNAME,'_onb','')"
  ]
}

[Sitarasmi]

Hi Vivek,

Thanks for quick response, its working fine.

Regards,

Sitarasmi