Sftp Setup Guide

Prerequisites

• SFTP server: You will need the host address, username and one of:
  • password
  • private key
  • private key and passphrase

Setup Guide

1. Choose authentication method: Username and Password or SSH
2. Enter Hostname, Port.
3. Depending on the chosen authentication method, enter one of:

• Username + Password
• Username + Private Key
• Username + Private Key + Passphrase

ℹ️ Note:: If using SSH, please provide full private key, including header and footer. For example:

        -----BEGIN OPENSSH PRIVATE KEY-----
        <private key body>
        <private key body>
        <private key body>
        -----END OPENSSH PRIVATE KEY-----

4. Enter a Name for the connector.
5. (Optional) Enter a Description for the connector.
6. Select the Owner of the connector.
7. (Optional) Verify that your Sftp account is successfully connected by clicking on Test Connection.
8. Click Connect.

Supported Sync Modes

• All: All mode creates one file with all the rows in the query results on every sync run.

Supported File Formats

• CSV