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

Flat files

PA
New Contributor III
New Contributor III

Hi Team,

For some applications that we receive flat files periodically in a shared location/folder we have python script to normalize the file consumable by Saviynt and upload it to our SQL database server. This process is automatic as we are running python script job in SQL server.   We then create a DB connection from Saviynt and run the account and entitlement import jobs. we do this mostly for entitlement review purposes. This process, even though is automatic, has many points of failure. 

Is there a better way or standard practice in such scenario? Instead of having SQL server in between, is there a better way to directly pull normalized files from the folders to Saviynt?

1 REPLY 1

rushikeshvartak
All-Star
All-Star

You can use java jar code to normalize file and upload file and use schema import


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