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:
- We are basically trying to migrate disconnected application integration from existing IGA system to Saviynt
- 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.
- 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,SaathvikIf this reply answered your question, please
Accept As Solution and give
Kudos to help others facing similar issue.