You can import data from an SFTP server to create source datasets in Anaplan Data Orchestrator (ADO). To import data, you need a connection to an SFTP server and either a pipeline or a connection extract.

You must first create a connection to an SFTP server with the SFTP connector in Data Orchestrator. Then use that connection to either create a pipeline or use a connection extract for data import.

Connectivity prerequisites

Before you can create a connection to an SFTP server, you need to meet these prerequisites.

ItemsNotes
SFTP serverAn SFTP server hosted on Amazon Web Services (AWS), on any cloud service provider, or an on-premise SFTP server.
SFTP userA user with a Secure Shell (SSH) private key with at least read permissions for the bucket and objects.
SFTP folder pathA folder path to a subset of the bucket connected to the SFTP server.
SFTP private keyA private key that’s used to authenticate with the SFTP location.
Supported SFTP encryption_algs (ciphers)

The SFTP connector supports these encryption_algs (ciphers): 

  • chacha20-poly1305@openssh.com
  • aes128-gcm@openssh.com
  • aes256-gcm@openssh.com
Supported SFTP key_algs

The SFTP connector supports these key_algs: 

  • curve25519-sha256
  • curve25519-sha256@libssh.org
CSV file in SFTP

Make sure the CSV file in the SFTP server is UTF-8 encoded.

See File requirements for Anaplan Data Orchestrator for more information about CSV file requirements.

Create a connection to an SFTP server

To create a connection:

  1. Select Data Orchestrator from the top-left navigation menu.
  2. Choose a dataspace from the list.
  3. Select Connections from the left-side panel.
  4. Select Create connection.
  5. On the Create connection page, select SFTP, and then select Next.
    If you can't find the connector, enter a search term in the Find... field.
  6. On the Connection details page, enter these details and select Next:
    • Name: Create a name for your connection. The name can contain alphanumeric characters and underscores.
    • Description: Optionally, enter a description about your connection.
  7. On the Connection credentials page, enter your SFTP credentials and select Next:
    • Host: Enter your SFTP server hostname (for example, s-52d4b77da9example.server.transfer.us-east-1.amazonaws.com).
    • Port: Enter the SFTP port (for example, 22).
    • Username: Enter the SFTP server user name (for example, sftp-user).
    • Private Key: Enter the SSH private key (OpenSSH format) linked to the SFTP server.

      You can use the ssh-keygen -t rsa -b 4096 -f <keyfilename> command to generate a key pair. When you run the command, the system prompts you to set a passphrase. Press Enter twice to generate the unencrypted private key without a passphrase.
      This creates a public key (.pub) and a private key. The public key is linked to the SFTP server and the private key is used to make connections.

      Private key example:

-----BEGIN OPENSSH PRIVATE KEY-----
b3BlbnNzaC1rZXktdjEAAAAABG5vbmUAAAAEbm9uZQAAAAAAAAABAAABlwAAAAdzc2gtcn
... (Your private key content in Base64) ...
... multiple lines ...
-----END OPENSSH PRIVATE KEY-----

  1. After the connection test is complete, select Done.

Import data

You can import data from an SFTP server with a pipeline or a connection extract. Use the connection you created to configure the pipeline or connection extract.