SFTP Integration with Sharepoint or OneDrive

[adriencosson]

Hello folks,

We have a use case where the customer would like some analytics from Saviynt to be pushed as Files into a Sharepoint / OneDrive folder.

• Is this doable with the SFTP integration capabilities of Saviynt ?
• If there is a custom way to do it (e.g with custom jar), can anyone provide details for the same ?
• Otherwise, should we first drop the file to a dedicated folder using SFTP integration, and then the customer must build a script to transfer the file to the appropriate Sharepoint ?

Thanks a lot !

[rushikeshvartak]

Yes, this use case can be handled, and there are a couple of ways to push analytics from Saviynt to SharePoint or OneDrive folders. Below are the options to consider, including utilizing SFTP integration and custom approaches:

Option 1: Using SFTP Integration with Intermediate Folder

1. SFTP Integration in Saviynt: Saviynt supports SFTP integrations out of the box, which can be used to export the analytics data into a CSV or other file formats.
   • You can schedule Saviynt analytics reports to be generated and automatically pushed to a dedicated folder via SFTP.
2. Customer Script to Transfer File to SharePoint: After the file is dropped into the SFTP folder, the customer can set up an external script or automation (using PowerShell, Python, or any other tool) to transfer the file from the SFTP folder to SharePoint or OneDrive.
   • Power Automate can be leveraged to monitor the folder and move the files to SharePoint.
   • Azure Logic Apps or Microsoft Flow can automate the file transfer to SharePoint once the file is placed in the SFTP folder.

This option is simple and effective, leveraging standard SFTP capabilities within Saviynt and leaving the SharePoint-specific integration on the customer’s side.

Option 2: Custom Solution (Custom JAR or API)

If the customer prefers a more direct approach, you can implement a custom solution using Saviynt's extensibility features, such as writing a custom JAR file or using APIs.

1. Custom JAR Approach:

   • You can develop a custom JAR that uses SharePoint or OneDrive APIs to directly upload the analytics file to a specific folder.
   • The JAR can be invoked as a custom job within Saviynt once the analytics report is generated. You can configure Saviynt to run the custom code at the desired intervals.

2. Microsoft Graph API Integration:

   • SharePoint and OneDrive both support file upload via Microsoft Graph API. You can write a custom connector or REST-based integration within Saviynt to directly push the files to the respective SharePoint/OneDrive folder.
   • The workflow would look like:
     • Generate the analytics report.
     • Use REST API calls (using Microsoft Graph API) to authenticate and upload the file to the desired SharePoint/OneDrive location.
   • Saviynt can handle the API-based approach using REST connectors or custom code in the Import/ExportJSON configuration.

Recommended Approach

If you are looking for a simple, maintainable solution:

• Option 1 is easier to implement, utilizing existing Saviynt capabilities and minimizing custom development.
• Option 2 provides more flexibility and direct integration but requires custom development, which may need ongoing support and maintenance.