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

Does SFTP Connector supports Windows as Target?

Saathvik
All-Star
All-Star

Team,

I want to check if the SFTP connector supports windows as Target to download the files, if we configure the windows machine as SFTP server?

Use case:

  1. We are basically trying to migrate disconnected application integration from existing IGA system to Saviynt
  2. All app teams already have process in place to pushes the files at regular interval to a MFT server. And current IGA system connects to that MTF server to read the files.
  3. So we are trying to analyze if we can reuse the existing MFT server as SFTP server by enabling SFTP protocol, Can Saviynt connect to that server using SFTP connector or not? As we see a push back from app teams to change the existing process.

We already attempted a POC using SFTP connector to connect to Windows machine and we are able to successfully connect to the machine but problem is occuring while transfering the files. As it internally making the full file path using UNIX format as shown in logs below.

Hence we are trying to understand if SFTP connector supports windows as target or not?

If it supports how we can prepare the appropriate JSON?

Below is the current JSON we used for FILES_TO_GET

[
{
"eic_dest_dir": "DataFiles",
"src_dir": "C:\\apps\\sftp_storage\\Saviynt\\Test_Disconnected",
"file_list": ["Test_Disconnected_Accounts_Ents_Import_Data.csv","Test_Disconnected_Entitlements_Import_Data.csv","Test_Disconnected_Entitlements_Owners_Import_Data.csv"]
}
]

Logs:

Exception in downloading file : C:\apps\sftp_storage\Saviynt\Test_Disconnected/Test_Disconnected_Accounts_Ents_Import_Data.csv|com.jcraft.jsch.SftpException: No such file| at com.jcraft.jsch.ChannelSftp.throwStatusError(ChannelSftp.java:2873) ~[na:na]| at com.jcraft.jsch.ChannelSftp._lstat(ChannelSftp.java:2336) ~[na:na]| at com.jcraft.jsch.ChannelSftp.lstat(ChannelSftp.java:2312) ~[na:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.downloadFile(SFTPConnectorService.java:237) ~[na:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.getFilesFromDirectory(SFTPConnectorService.java:181) ~[na:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.getFilesFromTarget(SFTPConnectorService.java:118) ~[na:na]|
 
2023-10-04T12:32:02-04:00-connectorms-c.s.s.s.service.SFTPConnectorService-http-nio-8980-exec-9-DEBUG-Exception in downloading file : C:\apps\sftp_storage\Saviynt\Test_Disconnected/Test_Disconnected_Entitlements_Import_Data.csv|com.jcraft.jsch.SftpException: No such file| at com.jcraft.jsch.ChannelSftp.throwStatusError(ChannelSftp.java:2873) ~[na:na]| at com.jcraft.jsch.ChannelSftp._lstat(ChannelSftp.java:2336) ~[na:na]| at com.jcraft.jsch.ChannelSftp.lstat(ChannelSftp.java:2312) ~[na:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.downloadFile(SFTPConnectorService.java:237) ~[na:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.getFilesFromDirectory(SFTPConnectorService.java:181) ~[na:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.getFilesFromTarget(SFTPConnectorService.java:118) ~[na:na]|
 
2023-10-04T12:32:02-04:00-connectorms-c.s.s.s.service.SFTPConnectorService-http-nio-8980-exec-9-DEBUG-Exception in downloading file : C:\apps\sftp_storage\Saviynt\Test_Disconnected/Test_Disconnected_Entitlements_Owners_Import_Data.csv|com.jcraft.jsch.SftpException: No such file| at com.jcraft.jsch.ChannelSftp.throwStatusError(ChannelSftp.java:2873) ~[na:na]| at com.jcraft.jsch.ChannelSftp._lstat(ChannelSftp.java:2336) ~[na:na]| at com.jcraft.jsch.ChannelSftp.lstat(ChannelSftp.java:2312) ~[na:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.downloadFile(SFTPConnectorService.java:237) ~[na:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.getFilesFromDirectory(SFTPConnectorService.java:181) ~[na:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.getFilesFromTarget(SFTPConnectorService.java:118) ~[na:na]|
 
2023-10-04T12:32:02-04:00-connectorms-c.s.s.s.service.SFTPConnectorService-http-nio-8980-exec-9-DEBUG-Files failed to download with detailed error message : {"C:\\apps\\sftp_storage\\Saviynt\\Test_Disconnected/Test_Disconnected_Accounts_Ents_Import_Data.csv":"No such file","C:\\apps\\sftp_storage\\Saviynt\\Test_Disconnected/Test_Disconnected_Entitlements_Import_Data.csv":"No such file","C:\\apps\\sftp_storage\\Saviynt\\Test_Disconnected/Test_Disconnected_Entitlements_Owners_Import_Data.csv":"No such file"}

 


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.
Who Me Too'd this topic