SFTP stands for Secure Shell (SSH) File Transfer Protocol, a network protocol used for secure transfer of data over the internet. The protocol supports the full security and authentication functionality of SSH, and is widely used to exchange data between business partners in a variety of industries including financial services, healthcare, retail, and advertising.
To configure the upstream connection, start with creating the SFTP route. Go to the SFTP page, click Add Route and select New SFTP Route from the drop-down menu.
Next, set up the upstream connection by clicking the Add button and filling in the form.
- Upstream Host - Host of the upstream SFTP server
- Port - Port of the upstream SFTP server
- Username - Username to connect to upstream SFTP server
- Password - Password to connect to upstream SFTP server
- Allow for the next credentials - to connect to SFTP proxy server
After filling in a form and configuring filters, click Save. The new SFTP route will be created and a success alert message will show up.
Run the following command:
sftp -P 8022 <access-credentials-username>@<vault-id>.<environment>.verygoodproxy.comThis is a sample VGS echo serverThis is a login from access credentialsThis is a password from access credentialsThis is a HTTP port number to accessThis is a sample VGS alias in a generic formatThis is a sample test vault idThis is a username/password pair of access credentials for a sample test vaultThis is a sample vault url, that contains the vault id and the sandbox environmentThis is a sample vault host, which contains sample test vault id and sandbox environmentThis is a current Organization IDThis is a current vault idThe unique name that identifies a specific iframeThis is a sample VGS alias in a generic format
- access-credentials-username - Username from Access credentials
- vault-id - Vault id
- environment - Environment
Next, enter the dashboard Access Credential password.
Congratulations! Now you are successfully connected to SFTP.
SFTP route editor supports redact/reveal of particular columns in .csv files. It also allows excluding column header from processing.
For CSV redact/reveal:
- Select CSV tab in the filter editor
- Add columns to be redacted/revealed in square braces separated by a comma. For example, to redact columns 1 and 2 add\[1,2\]
- Uncheck CSV has headers? if it's not needed to process CSV headers
- Save the route.