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_keysfile is in the
.sshdirectory within the root directory of the user you log in with
ftp.omniture.com. SFTP protocol between Adobe’s internal servers is not supported.
To successfully send a Data Warehouse request via SFTP:
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.
sftp:// protocol is only permitted when using SFTP. Regular FTP requests should omit the protocol prefix (such as,
ftp.omniture.com instead of
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.
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.
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.