Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Transfer Analytics Report Files to SFTP Server by CSV Format

KK
Regular Contributor
Regular Contributor

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,

12 REPLIES 12

rushikeshvartak
All-Star
All-Star

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

KK
Regular Contributor
Regular Contributor

@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,

  • 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

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

KK
Regular Contributor
Regular Contributor

@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,

  • 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

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

KK
Regular Contributor
Regular Contributor

@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?

KK_2-1726200128925.png

Best Regards,

All will be in Saviynt


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

KK
Regular Contributor
Regular Contributor

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

Best Regards,

Using custom jar


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

KK
Regular Contributor
Regular Contributor

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

Best Regards,

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


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

KK
Regular Contributor
Regular Contributor

OK, I will check it.