This tutorial provides steps for creating an SFTP source connection using the Adobe Experience Platform UI.
This tutorial requires a working understanding of the following components of Platform:
It is recommended to avoid newlines or carriage returns when ingesting JSON objects with an SFTP source connection. To work around the limitation, use a single JSON object per line and use multi-lines for ensuing files.
If you already have a valid SFTP connection, you may skip the remainder of this document and proceed to the tutorial on configuring a dataflow.
In order to connect to SFTP, you must provide values for the following connection properties:
||The name or IP address associated with your SFTP server.|
||The SFTP server port you’re connecting to. If unprovided, the value defaults to
||The username with access to your SFTP server.|
||The password for your SFTP server.|
||The Base64 encoded SSH private key content. The type of OpenSSH key must be classified as either RSA or DSA.|
||The pass phrase or password to decrypt the private key if the key file or the key content is protected by a pass phrase. If PrivateKeyContent is password protected, this parameter needs to be used with the PrivateKeyContent’s passphrase as value.|
Once you have gathered your required credentials, you can follow the steps below to create a new SFTP account to connect to Platform.
In the Platform UI, select Sources from the left navigation bar to access the Sources workspace. The Catalog screen displays a variety of sources for which you can create an inbound account with.
You can select the appropriate category from the catalog on the left-hand side of your screen. Alternatively, you can find the specific source you wish to work with using the search option.
Under the Cloud storage category, select SFTP and then select Add data.
The Connect to SFTP page appears. On this page, you can either use new credentials or existing credentials.
To connect an existing account, select the FTP or SFTP account you want to connect with, then select Next to proceed.
If you are creating a new account, select New account, and then provide a name and an optional description for your new SFTP account.
SFTP supports different authentication types for access. Under Account authentication select Password and then provide the host and port values to connect to, alongside your username and password.
To use SSH public key-based credentials, select SSH public key and then provide your host and port values, as well as your private key content and passphrase combination.
SFTP supports an RSA or DSA type OpenSSH key. Ensure that your key file content starts with
"-----BEGIN [RSA/DSA] PRIVATE KEY-----" and ends with
"-----END [RSA/DSA] PRIVATE KEY-----". If the private key file is a PPK-format file, use the PuTTY tool to convert from PPK to OpenSSH format.
|Private key content||The Base64 encoded SSH private key content. The type of OpenSSH key must be classified as either RSA or DSA.|
|Passphrase||Specifies the pass phrase or password to decrypt the private key if the key file or the key content is protected by a pass phrase. If PrivateKeyContent is password protected, this parameter needs to be used with the PrivateKeyContent’s passphrase as its value.|
By following this tutorial, you have established a connection to your SFTP account. You can now continue on to the next tutorial and configure a dataflow to bring data from your cloud storage into Platform.