Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/04/2023 09:50 AM
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 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:
Solved! Go to Solution.
10/06/2023 01:40 PM
Hi @Saathvik ,
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.
10/06/2023 03:48 PM
@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
11/14/2023 11:13 PM - edited 11/14/2023 11:14 PM
Hi @Saathvik
Can you try to use the path in this format:
/C:/apps/sftp_storage/Saviynt/Test_Disconnected
11/20/2023 07:12 AM
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