Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Remove string from username

Sitarasmi
Regular Contributor
Regular Contributor

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

 

2 REPLIES 2

vivek9237
Regular Contributor
Regular Contributor

@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','')"
  ]
}

 

Regards,

Vivek Mohanty


If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

Sitarasmi
Regular Contributor
Regular Contributor

Hi Vivek,

Thanks for quick response, its working fine.

Regards,

Sitarasmi