Skip to main content

Importing Data via sFTP

E
Written by Elbert Pranoto
Updated over 2 weeks ago

1. sFTP Connection Details

Protocol

SFTP (SSH File Transfer Protocol)

Port

22

Supported Authentication Method

SSH Authentication

Each Sapia.ai data center operates its own dedicated SFTP server. Please connect to the appropriate region based on your server location and use the IP addresses listed below for whitelisting purposes if required. If you are not sure about your region, contact Sapia.ai

Region

sFTP Endpoint URL

IP Addresses

AU
(ap-southeast-2)

s-68b2a2cc4a4f49f9a.server.transfer.ap-southeast-2.amazonaws.com

15.134.76.92

13.237.199.78

EMEA
(eu-west-1)

s-7fb77caa27314a839.server.transfer.eu-west-1.amazonaws.com

54.155.36.192

54.195.21.137

US
(us-east-1)

s-a09eae11de474a8c8.server.transfer.us-east-1.amazonaws.com

52.0.164.228

54.204.101.64

2. Setup and Requirements

  1. Generate your SSH key pair (public and private keys) with the supported algorithm (See below)

  2. Submit your public key (.pub file) to Sapia.ai

  3. Sapia.ai will issue your SFTP username upon receipt

Important: Keep your private key secure and never share it. Only the public key should be sent to Sapia.ai.

3. Supported Algorithms for SSH/SFTP Authentication

Use one of the following algorithms when generating SSH key pairs:

  • RSA (Recommended)

Compatible with most SSH clients and servers, and FIPS-compliant. Use with SHA-2 hashing for enhanced security:

rsa-sha2-256

rsa-sha2-512

  • ECDSA

ecdsa-sha2-nistp256

ecdsa-sha2-nistp384

ecdsa-sha2-nistp521

4. How to connect

To establish SFTP connectivity, you'll need:

  • SFTP Username: Provided by Sapia.ai after setup is complete and your public key file has been received.

  • Private Key File: For secure authentication (you retain this)

  • Public Key File: Must be supplied to Sapia.ai

5. Things to Note

  • One SFTP Account Per Customer ID
    Each Sapia.ai customer ID receives one SFTP account. If you have multiple Sapia.ai customer IDs, you will have multiple SFTP connections.

  • User Permissions
    SFTP users have read and write permissions for files only. You cannot create, modify, or delete any folder.

  • Folder Structure
    Sapia.ai will create the relevant folders for specific data types (e.g., hired data, leavers data, etc.). You can read from or write to these designated folders. Sapia.ai will provide the folder names and structure as needed.

Did this answer your question?