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

While doing user import - Can we refer multiple datasets in preprocess (MODIFYUSERDATAJSON)

IAM_99
Regular Contributor II
Regular Contributor II

Hi Team,

Can we refer multiple dataset for user profile attribute transformations ?

"DATASET_VALUES": "SELECT ATTRIBUTE1 FROM DATASET_VALUES

"DATASET_VALUES_OTHER": "SELECT ATTRIBUTE1 FROM DATASET_VALUES

 

Thanks,

10 REPLIES 10

Rajesh-R
Saviynt Employee
Saviynt Employee

@IAM_99 - Yes you can refer to multiple datasets.


Thanks
Rajesh Ramalingam
Saviynt India

Manu269
All-Star
All-Star

@IAM_99 yes we have the feassibility to use.

Note :

Can you use the upper case while using datasets

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

IAM_99
Regular Contributor II
Regular Contributor II

Thanks @Rajesh-R @Manu269  for the response.

Could you share sample for this if possibile ?

IAM_99
Regular Contributor II
Regular Contributor II

 Hello @rajesh-ram @Manu269 

Can you share sample - how multiple datasets look like ?

{
"ADDITIONALTABLES": {

"DATASET_VALUES": "SELECT ATTRIBUTE1 FROM DATASET_VALUES"

"DATASET_VALUES1": "SELECT ATTRIBUTE1 FROM DATASET_VALUES"


}

...
}


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

IAM_99
Regular Contributor II
Regular Contributor II

thanks for the response.

Will Saviynt understood this automatically ?

 

 

"TABLEINDEXES": {
"CURRENTUSERS": [
"USERNAME"
],
"NEWUSERDATA": [
"USERNAME"
],
"CURRENTDATASET_VALUES": [
"ATTRIBUTE1"
],
"CURRENTDATASET_VALUES1": [
"ATTRIBUTE1"
],

},

Ideally yes cna you try and let us know outcome


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

@IAM_99  Did it worked for you?


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

IAM_99
Regular Contributor II
Regular Contributor II

Sorry lost track on this it didnt work.

Never mind its working i have tested

https://forums.saviynt.com/t5/identity-governance/same-table-multiple-times-in-pre-processor/td-p/80...


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.