Adobe supports the export of Data Warehouse requests to SFTP servers.
Ensure that the following tasks are completed:
Adobe supports the export of Data Warehouse requests to SFTP servers, provided the following are met:
sftp://
protocol is specified in the host field (for example, sftp://ftp.example.com
) and ONLY port 22 is used when requesting a Data Warehouse report. You can also use the sftp+norename://
option, as described below.authorized_keys
file is in the .ssh
directory within the root directory of the user you log in withftp.omniture.com
. SFTP protocol between Adobe’s internal servers is not supported.To successfully send a Data Warehouse request via SFTP:
Obtain the authorized_keys
file by having one of your organization’s supported users contact Customer Care.
After this file is obtained, log in to the FTP 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 the authorized_keys
file there.
Go to the Data Warehouse request manager. Configure the request as desired, then click Advanced Delivery Options.
In the pop-up window, click FTP, then specify the ftp site (including the sftp://
protocol, such as sftp://ftp.omniture.com
) via port 22.
Including the sftp://
protocol is only permitted when using SFTP. Regular FTP requests should omit the protocol prefix (such as, ftp.omniture.com
instead of ftp://ftp.omniture.com
).
Enter the name of the folder you want to place the file in the Folder field. A folder is required.
Enter the same username and password used in Step 2.
Click Send.
The sftp PUT command places a temporary file with an extension of .part in the specified directory. When the upload completes the file extension is renamed to the final extension, at which point it is ready for your use.
Alternatively, sftp+norename://
can be specified instead of sftp://
to upload the file directly with the final name, without a temporary .part
file name during upload. This approach is appropriate when the SFTP server handles file renaming during upload automatically, and there is no chance of the file being processed before upload is complete.