Closed
Read CSV File via FTP
So I have this requirement to read csv file that located in ftp server. I have tried connect-ftp but it seems that connect-ftp is used for upload file from pega to ftp server. Been rumaging through pega support center but found things like repository API and more dead links. I also found some stuff related to pega cloud but in this project we decided not to use pega cloud.
***Edited by Moderator Marije to add Enhancement ticket EPIC-29457 ***
Posted: 2 years ago
MOD
Pegasystems Inc.
GB
@yutta the Connect-FTP method in Pega is primarily used to transfer files from the Pega server to an FTP server. It does not inherently support fetching and reading files from an FTP server to the Pega server.
Pega doesn't have inbuilt functionality to retrieve a file from Remote SFTP Non Pega server to Pega for now.
(Enhancement request EPIC-29457 wascreated for supporting full CRUD interoperability with FTP by introducing an FTP repository type. Please contact your AE if you need further details about this cc @snirm )
For fetching and reading files from an FTP server, Pega suggests using OOTB Repositories and file listeners, or custom functionality using JSCH.
JSCH is a pure Java implementation of SSH2 (Secure Shell Version 2) that allows you to connect to an sshd server and use port forwarding, X11 forwarding, file transfer, etc. It is used in Pega for creating custom SFTP (SSH File Transfer Protocol) connections.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
Read File from FTP Server
FTP Server data instances
@yutta the Connect-FTP method in Pega is primarily used to transfer files from the Pega server to an FTP server. It does not inherently support fetching and reading files from an FTP server to the Pega server.
Pega doesn't have inbuilt functionality to retrieve a file from Remote SFTP Non Pega server to Pega for now.
(Enhancement request EPIC-29457 wascreated for supporting full CRUD interoperability with FTP by introducing an FTP repository type. Please contact your AE if you need further details about this cc @snirm )
For fetching and reading files from an FTP server, Pega suggests using OOTB Repositories and file listeners, or custom functionality using JSCH.
JSCH is a pure Java implementation of SSH2 (Secure Shell Version 2) that allows you to connect to an sshd server and use port forwarding, X11 forwarding, file transfer, etc. It is used in Pega for creating custom SFTP (SSH File Transfer Protocol) connections.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
Read File from FTP Server
FTP Server data instances
What is the Pega OOTB mechanism to download a file from a remote SFTP serv
Connect-FTP method > Parameters
JSCH exception Custom SFTP Error