Import Users From SFTP Hosted Flat File

[jasonb]

I'm sure this question has been addressed before, but I'm having trouble accessing some of the legacy forum posts:

I know that you can import and update Users from a CSV file manually, including mapping headers to Saviynt User attributes.  Is there a way to create a scheduled job or a Connector that will fetch and import/update users from a CSV (or other flat file) from an SFTP storage location?

[rushikeshvartak · Accepted solution]

• You need to write cron to move files from client location to saviynt data files
• You can use saviynt REST API to move files from clients SFTP to saviynt datafiles 

• 1. Build a custom JAR where you can pull the files using SFTP protocol and place it in the schema based job location. 

  https://saviynt.freshdesk.com/a/solutions/articles/43000618942

  2. If you are using V2021 then you can leverage the REST API to upload the sav and datafiles. Attached REST API guide has those details

  https://documenter.getpostman.com/view/1797923/RWaLwo21?version=latest#8b3704d4-7c3d-45e9-a82f-48773...

[ejeong]

Hello, is this api no long available in v2021? we are preparing to use this api when upgraded to v2021 but I can't find that api in the url any longer.

[jasonb]

Hi @rushikeshvartak - Thanks for the quick response!  Just to make sure I understand:

• You need to write cron to move files from client location to saviynt data files
  Is moving a datafile from a client SFTP location something that can be performed by a Saviynt job/connector?  Or does it require a locally hosted JAR file as described in #1?
• Build a custom JAR where you can pull the files
  Does Saviynt have any other sample code showing a custom JAR file?  The only one I see is the AS400 example.

For reference, I believe we are on the latest version of v2021.

[rushikeshvartak · Accepted solution]

You can use either API(JAR) or Cron (bash script). I am not sure if saviynt have Jar code