SFTP

SFTP (Secure File Transfer Protocol) is a network protocol that provides secure file access, transfer, and management over a reliable data stream.

You can use SFTP storage as a source for Import and Data Flow, or as a target for Export and Data Flow.

Establishing Connection

To create a connection with SFTP server, specify the host, port, working directory, authentication type and enter the credentials.

Skyvia will access your server from the following IPs: 40.118.246.204, 13.86.253.112, and 52.190.252.0.

Connection Editor window

Creating Connection

To connect to the SFTP server, specify the following connection parameters:

  • Host - specifies the domain name or IP address of the host to connect to.

  • Port - this parameter specifies the TCP port, the SFTP server listens on.

  • Working Directory - a path on the SFTP server to use as a root folder in Skyvia. You may use this parameter, for example, if you only have access to a specific folder on the SFTP server, and cannot access its root folder.

  • User - a user name to log in with.

  • Authentication Type - type of SSH authentication to use. Allowed values are User Name & Password, Keyboard Interactive, multi-Factor or Public Key. After selecting the authentication type, enter the credentials. The required credentials depend on the selected authentication type:

    Authentication type Required credentials
    User name & Password or Keyboard Interactive SSH password
    Multi-factor Password, SSH passphrase, and SSH private key
    Public Key SSH passphrase, SSH private key

Skyvia supports RSA and DSA private keys in both OpenSSH and ssh.com formats.

  • Password - a password to log in with.

  • SSH Passphrase - a passphrase for a private key. You can set it while generating public and private key files through a key generator tool, for example PuTTygen. Available if Public Key SSH Authentication Type is selected.

  • SSH Private Key - arivate key. Paste the content of the key file into the box or click the button to open a multiline editor and paste the content of the key file there. Available if Public Key SSH Authentication Type is selected.

Connector specifics

File Masks

When you use SFTP as CSV source, you can specify a file mask using a date/time template instead of selecting a file. When integration runs, it will search the file in the folder by substituting the current date to the mask.

SQL Server SFTP Integration tutorial

Salesforce FTP / SFTP integration tutorial

On This Page