Does SFTP Connector supports Windows as Target?

[sk]

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"}

[DaanishJawed]

Hi @sk ,

It looks like it is able to call the path but fails to find the file.

Can you try with the below -

JSON 1:

[
{
"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"]
}
]

JSON 2:

[
{
"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"]
}
]

JSON 3:

[
{
"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"]
}
]

Thanks.

[sk]

@DaanishJawed : Thanks for the response actually none of them worked.

JSON2 and JSON3 the path is in the format of UNIX based machine so it is failing to find the path. Whereas JSON1 giving same error as the original. Because when it is adding filename to the path it is doing /filename whereas for windows it should be like \filename hence it is failing.

JSON1 Error

2023-10-06T18:36:28-04:00-connectorms-c.s.s.s.service.SFTPConnectorService-http-nio-8980-exec-5-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

JSON2 Error(without / at end of path and with / at end of path)

2023-10-06T18:38:52-04:00-connectorms-c.s.s.s.service.SFTPConnectorService-http-nio-8980-exec-10-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

2023-10-06T18:46:02-04:00-connectorms-c.s.s.s.service.SFTPConnectorService-http-nio-8980-exec-8-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

[rashid_raza · Accepted solution]

Hi @sk 

Can you try to use the path in this format:
/C:/apps/sftp_storage/Saviynt/Test_Disconnected

[yogesh]

Please get this added to the SFTP connector documentation as well, it will be very helpful for other people in future who are integrating with windows targets