Modify userdata json in SAV4SAV

[Saviynt_learner]

Hello All,

I have a requirement, I'm importing a user via CSV file, and we do it very frequently, so whenever there are some changes in some custom property we need to mention 'YES' in another custom property.

To do this I want to use sav4sav connector. i never used this before. can anyone guide me what will be the flow, and how it works.

Can i use same format as 'Active Directory'  connector for modify userdata json. 

Explanation with a basic example will be appreciated. kindly help me to understand sav for sav connection.

Thanks in advance.

[adriencosson]

Hi @Saviynt_learner ,

You can leverage the preprocessor using the same format as what you have in your MODIFYUSERDATAJSON parameter of your connector.

A sample to set the user's customproperty65 to "Yes" during the import is : 

{
  "ADDITIONALTABLES": {
    "USERS": "SELECT DISTINCT username from USERS"
  },
  "COMPUTEDCOLUMNS": [
    "CUSTOMPROPERTY65"
  ],
  "TABLEINDEXES": {
    "currentusers": [
      "username"
    ]
  },
  "PREPROCESSQUERIES": [
    "UPDATE NEWUSERDATA u SET u.CUSTOMPROPERTY65='Yes'",
  ]
}

Reference Documentation : https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter03-User-Management/User-Impo... 

Hope this helps