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 Adobe Experience 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 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.
Log in to Adobe Experience Platform and then 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. If this is your first time using this connector, select Configure. Otherwise, select Add data to create a new SFTP connection.
The Connect to SFTP page appears. On this page, you can either use new credentials or existing credentials.
If you are using new credentials, select New account. On the input form that appears, provide a name, an optional description, and your credentials. When finished, select Connect and then allow some time for the new connection to establish.
The SFTP connector provides you different authentication types for access. Under Account authentication select Password to use a password-based credential.
Alternatively, you can select [SSH public key] and connect your SFTP account using a combination of Private key content and Passphrase.
The SFTP connector 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 value.|
To connect an existing account, select the FTP or SFTP account you want to connect with, then select Next to proceed.
By following this tutorial, you have established a connection to your FTP or SFTP account. You can now continue on to the next tutorial and configure a dataflow to bring data from your cloud storage into Platform.