Assign Organization Based on reconciled attribute

[Community_User]

Originally posted on November 9 2020 at 14:08 UTC

Hi All,

I thought this would be a simple task but I cannot find any information on how to add a user to an organization during the user reconciliation.

I'm trying this when importing users using the DB connector.

How can we automatically add a user to an organization based on some business logic?

Thanks in Advance,

Ousman

[Community_User · Accepted solution]

Originally posted on November 25 2020 at 10:59 UTC

Hi Ousman,

If you already have organizations available in Saviynt, then you can map users table customer attribute against target DB column.

Users table customer attribute value should be same as customerkey of the customer table.

Thanks,

Ranjan

[Community_User]

Originally posted on December 2 2020 at 11:54 UTC

Hi Ranjan,

I have tried that via both the userimport JSON and the modifyuserdatajson, both give the following error :

Not Importing user - either username attribute not found or if vendor is there then user doesnt have access to import the vendor-

ModifyuserJSON - Tried with both the cutomerkey and customer name

{

"ADDITIONALTABLES":

{

"USERS":"SELECT USERKEY,customproperty8 FROM USERS"

},

"COMPUTEDCOLUMNS":[

"customer"

],

"PREPROCESSQUERIES":

[

"UPDATE NEWUSERDATA SET customer = 'NAO'"

]

}

Thanks,

Ousman

[Community_User]

Originally posted on May 7 2021 at 14:19 UTC

Hello, I have the exact same error when trying to change the value or CUSTOMER attribute on a User (I have ADMIN SAV role with all accesses).

Have you find a way to assign Organization Automaticaly ?

Regards,

SANSOUCY Martin

[Community_User]

Originally posted on May 11 2021 at 06:26 UTC

Hello,

The following two configurations should mostly resolve your issue:

a. Add the organization you're trying to add in the "Show Users in Request Access based on Organizations" option of your admin SAV role.

b. Provide customer name instead of customer key in your import file. Saviynt will map the customer key internally.

Regards,

Swathi Hari

[Community_User]

Originally posted on May 11 2021 at 08:05 UTC

Thank you b worked.