1. Babelway
  2. Babelway User Guide
  3. Chapter 4. Manage & Build

4.2.4.4. SFTP Client Gateway In

 

With an SFTP Client Input Gateway, incoming messages are transferred to an external SFTP server. Babelway platform polls this server at regular intervals and retrieves incoming files to process them.

The specific settings are:

 Server 

 Sftp server host name. 

 Username 

 Login or username to access files on this external sftp server. 

 Password 

 Password associated with the username. 

 Private key 

 Private key associated with the username. 

 Directory 

 Directory where files are to be fetched on the server. 

 File pattern 

 The file pattern is a regex used to filter files to import (ex: '.*\.csv' for all files ending with '.csv' or '(?!proc_).*\.csv' for all csv files that don't start with 'proc_'. If left empty, all files will be transferred. 

 Cron expression 

 Cron expression. Allows to define complex time expression like every weekday night at 23:00 (0 23 ? * MON-FRI) and the time zone for the polling. If left empty, the system will check at least once every 15 minutes. For easy creation of your cron expression, you can use the online cron maker tool available at http://www.cronmaker.com/. 

 Suffix during transfer 

 Suffix that will be appended to the file name when a file is being transferred. This mechanism is used to prevent that a file is transferred twice. 

 After transfer behavior 

 What will happen to your file after we have read it. This behavior is important so that your file is not read again at next poll. The possible values are : 

  • Delete. It is the default. After having read it, the file will be deleted from the remote server. 
  • Rename. A suffix will be appended to the file name. 
  • Move. File will be moved to another folder of the remote server. 
  • Move and rename. File will be moved to another folder, and renamed. 
  • DoNothing. Don't do anything. Be very careful with this option, as it could mean that your file will be redownloaded at each poll. Should only be used with servers that move or delete the file automatically at download. 

 

 Suffix after transfer 

 Suffix that will be appended to the file name when a file has been completely transferred. 

 Folder for transferred files 

 Directory where transferred files will be moved. 

Note:

  • Babelway By default connect to the remote SFTP server on port 22 but if you want to connect to this remote SFTP server using different port then use the below.

    In the Server field add the port number you want to use it, For example if use X.X.X.X:1722 in the Server field which means connect to the remote SFTP server X.X.X.X on port 1722.

  • In the "General" page for this Gateway In you can see the "Poll now" button. When clicking on this button this will poll all of the messages immediately (and will not wait for the next defined moment).

  • In Babelway, we're using the standard Java version of REGEX, and it's the same used all over the system.
  • If there is a file name provided in the "Message In" or "Message Out" which contain ~ tilde character, All browser based on Chromium will replace the ~ tilde character by the _ underscore character when you try to download the file from the Babelway interface, For more details you can check this link https://bugs.chromium.org/p/chromium/issues/detail?id=479419
  • You can check bunch of info like last success date, last message date …etc. by pressing on Run Info button.

mceclip1.png

  • The maximum file size accepted by this gateway is 100/250 MB.