Application onboarding using flat file

[AtrayeeDutta]

Hi Team,

We have a requirement to onboard application using flat file. Saviynt will received the file through SFTP. Issue is we are getting the csv from app team, but that is not in Saviynt supported format..we have the .sav for the file schema, as far I know .sav file takes Saviynt recomemded and Saviynt OOTB attributes headers only like below:

SystemName=<sec system>
FileNameStartswith=Accounts
ENTITLEMENT_TYPE=ACCESS
DELETEACCOUNTENTITLEMENT=YES
OVERWRITE_USER_ASSIGNED=TRUE
ACCOUNT_NOT_IN_FILE_ACTION=SUSPEND
IGNOREFIRSTLINE=TRUE
FILEIMPORTDELIMETER=,
ACCOUNTNAME,endpointname,status,CUSTOMPROPERTY1,CUSTOMPROPERTY2, but .csv have completed diff headers like Email Address Name External ID  Status Password Never Expires User Must Change Password at Next Login Batch User Allow SSO Login Allow Web Login Access Group.

Is there any feature by which we can convert the csv file or use that csv apart from using JAVA code.

Regards,

Atrayee

[nimitdave]

There is not limitation that sav file and csv data file should have same column name. The sav files stores the mapping of csv columns with actual saviynt object columns. Like for example as below:

sav file has below:

ACCOUNTNAME,endpointname,status,CUSTOMPROPERTY1,CUSTOMPROPERTY2

Then csv file can have data as below:

Email Address,App Name,status,password nerver expires,User Must Change Password at Next Login

The things is,

1. the number of columns defined in sav file should match with nunber in csv file.

2. Mapping should be proper as per desired use case. 0th column in sav file will store data from 0th column of csv , 1th column from sav will capture details from 1th column and so on.

3. endpoint name maps to application name and is mandatorey.