Transfer Analytics Report Files to SFTP Server by CSV Format

[KK]

Hi.

I configure to transfer analytics report files to SFTP server according below article.
https://forums.saviynt.com/t5/identity-governance/upload-using-sftp-connector/m-p/60399

Then analytics report file is sent to SFTP server as zip format.

How to send analytics report file to SFTP server as csv format?

Best Regards,

[rushikeshvartak]

• You need to use custom jar to unzip and send csv
• Refer https://forums.saviynt.com/t5/identity-governance/how-to-send-csv-file-instead-of-zip-using-sftp-con...

[KK]

@rushikeshvartak 
Thanks for reply.
I see below information from your reference article.

Use saviynt APIs

1. To Run Report https://documenter.getpostman.com/view/23973797/2s9Ykhh4VH#f3737269-0c06-4273-8d38-d7622e655da8 
2. Upload csv file in datafiles https://documenter.getpostman.com/view/23973797/2s9Ykhh4VH#d192104b-2fe3-4bc7-9b3a-e391cb9da057 

• API 1 will run report and stored file in location specified in Report
• Once report is generated extract zip using below sample code 
• Upload files in databases using API2

Let me 
Do I have to call API1 and execute java program and call API2?
Are these operation out of Saviynt?
Do we have to prepare the external system that call APIs and execute java program?
Aren't these operation realize in Saviynt system itself?

Best Regards,

[rushikeshvartak]

• Do I have to call API1 and execute java program and call API2? Yes
• Are these operation out of Saviynt? - Yes inside saviynt
• Do we have to prepare the external system that call APIs and execute java program? - You can do in saviynt data files
• Aren't these operation realize in Saviynt system itself? - In saviynt itself

[KK]

@rushikeshvartak 
Thanks.
I understand these operations can be done within Saviynt system.
Let me ask further.

• API 1 will run report and stored file in location specified in Report
  -> This can be done by RunAnalyticsJob, right?
• Once report is generated extract zip using below sample code
  -> How to do this using data files? Could you give instruction?
• Upload files in databases using API2
  -> How to do this in Saviynt system itself?

Best Regards,

[rushikeshvartak]

• API 1 will run report and stored file in location specified in Report
  -> This can be done by RunAnalyticsJob, right? --> API will do this  you dont need to run job
• Once report is generated extract zip using below sample code
  -> How to do this using data files? Could you give instruction? -- Use API to push file in data files  https://documenter.getpostman.com/view/36611902/2sA3s6DpEt#9d744501-5e74-419a-b534-a5494f68bd2e 
• Upload files in databases using API2
  -> How to do this in Saviynt system itself - it will be in Server not in Database

[KK]

@rushikeshvartak 
Thanks.
What I want to know is that, these API should be called from outside system or it is possible in Saviynt system itself.
My understanding is that I have to have outside system to call API to Saviynt EIC, am I right?

Best Regards,

[rushikeshvartak]

All will be in Saviynt

[KK]

@rushikeshvartak 
So, these APIs can be executed within Saviynt?
How to execute these APIs within Saviynt?

Best Regards,

[rushikeshvartak]

Using custom jar

[KK]

@rushikeshvartak 
Sorry, I don't know how to use custom jar.
Do you have any instructions?

Best Regards,

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/saviynt-knowledge-base/store-and-read-blob-data-from-user-update-histo...

[KK]

OK, I will check it.