Updating User Profile Data

[Community_User]

Originally posted on August 18 2020 at 05:56 UTC

Hi Team,

I have a following requirement to be performed in SSM :

a) Fetch all the user account which have AD account provisioned and has a particular entitlement. [Completed]

b) Based upon those accounts retrieved, I need to update the User Profile custom property 21 as "Yes". (Through Either Transformation/Query Job)

[Need support]

As I am familiar this can be configured either through SSM Custom Query Job and SSM DB to DB Transformation.

But I am bit confused which component of SSM DB connection (JSON field) to be used for the same? Please share a sample example?

Further, Can i also have audit trail for this. How?

If there is any other possible way also let me know.

[Community_User]

Originally posted on August 19 2020 at 03:29 UTC

Hi Manish,

You can use the inline pre-processor capability where in you need to use the accounts and entitlements table as additional tables. This is used during the user import.

https://saviynt.freshdesk.com/support/solutions/articles/43000571860-user-import-preprocessor

THanks

Ajay

[Community_User · Accepted solution]

Originally posted on August 19 2020 at 05:06 UTC

Thanks Ajay for prompt answer.

I have used the component of User Import.

Thanks

Manish