Send Data Warehouse requests to SFTP servers
Adobe supports the export of Data Warehouse requests to SFTP servers, as described in SFTP in the article, Configure a report destination for a Data Warehouse request.
Ensure that the following tasks are completed:
- Only port 22 is used when requesting a Data Warehouse report.
- Adobe’s
authorized_keys
file is in the.ssh
directory within the root directory of the user you log in with. - The destination is not to
ftp.omniture.com
. SFTP protocol between Adobe’s internal servers is not supported. - The destination supports one-factor (PKI) authentication. If there is a two-factor challenge, delivery of the report will fail. Make sure that your server is not configured to attempt two-factor authentication. Adobe Analytics requires that only the key and nothing else is used to log in.
- Adobe supports SSHv2 encryption, and falls back to SSHv1 (RSA key only).
To successfully send a Data Warehouse request via SFTP:
-
Complete the steps described in SFTP in the article, Configure a report destination for a Data Warehouse request, including downloading the public key.
-
Log in to the SFTP site under the same credentials that are used for the Data Warehouse request.
-
In the root directory, navigate to the folder named
.ssh
(if one does not exist, create one) and place theauthorized_keys
file there. -
Complete the Data Warehouse request if you have not done so already, as described in Configure a report destination for a Data Warehouse request.