Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/29/2024 05:08 AM
Hi Team,
We are getting feed data in CSV file and in that CSV file we have multiple entries for single user. Could you please suggest how to handle multiple entries for same in feed during import in preprocessing.
Scenarios:
1. same role different cost center
2. different role same cost center
3. different role and different cost center
We need to assign birthright AD group on role role start date and remove them on role end date but our main issue is that we are not sure how to handle multiple entries in feed for single user while importing in Saviynt. Please suggest.
Sample Data:
Username | EmployeeID | Role | RoleStartDate | RoleEndDate | CostCenter |
user1 | 10001 | Finance | 29-08-2024 | 29-09-2024 | 50001 |
user1 | 10001 | Finance | 29-08-2024 | 29-10-2024 | 50002 |
user2 | 10001 | Finance | 29-08-2024 | 29-09-2024 | 50001 |
user2 | 10001 | IT | 29-08-2024 | 29-10-2024 | 50001 |
user3 | 10001 | Finance | 29-08-2024 | 29-09-2024 | 50001 |
user3 | 10001 | IT | 29-08-2024 | 29-10-2024 | 50002 |
07/29/2024 07:55 AM
07/30/2024 03:42 AM
Hi Rushikesh,
I tried to achieve this using concatenate role values in pre-processing but it did not work.
Summary:
To concatenate role we are trying to get role value from NEWUSERDATA table but this table holds the details of last record from the feed. Example - We have one record in feed at row number 10 and another record for same user at row number 100 then NEWUSERDATA holds the values of record at row number 100.
So storing role value from record number 10 to some cp12 and concatenate that cp12 value with role value from record number 100 doesn't work because both cp12 and role value from record number 100 are same.
Please suggest.
07/30/2024 08:58 PM
07/31/2024 05:18 AM
Hi Team,
Could you please suggest any other way because we need to iterate through all records of a particular user in feed and capture the different role values in one of the identity attribute.
07/31/2024 09:17 AM
Hi Team,
Is it possible to call NEWUSERDATA table in ADDITIONALTABLES in User Pre-processor JSON? When I tried am getting error
Error:
---------------
User Pre-processor Config JSON
--------------------------------
{
"ADDITIONALTABLES": {
"USERS": "SELECT USERNAME,CUSTOMPROPERTY1,CUSTOMPROPERTY2,CUSTOMPROPERTY3,CUSTOMPROPERTY10,CUSTOMPROPERTY11 FROM USERS ",
"CUSTOMROLES": "SELECT USERNAME as combousername,group_concat(NEWUSERDATA.customproperty1 SEPARATOR '|') as COMBO from NEWUSERDATA GROUP BY USERNAME"
},
"COMPUTEDCOLUMNS": [
"CUSTOMPROPERTY10",
"CUSTOMPROPERTY11"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET NEWUSERDATA.CUSTOMPROPERTY10 = (SELECT COMBO from CURRENTCUSTOMROLES where combousername=NEWUSERDATA.USERNAME)",
"CUSTOMFUNCTION###FUNCTIONTEST"
],
"CUSTOMFUNCTIONS": {
"FUNCTIONTEST": {
"FULLCLASSNAME": "com.test.saviynt.utility.test",
"METHODNAME": "test"
}
}
}
07/31/2024 09:26 AM
No you can't call table like that