Expand my Community achievements bar.

SOLVED

Ad Hoc Analysis to FTP

Avatar

Level 1

I have been trying to setup sending reports to an FTP server, but nothing appears to be showing up.  I have tested the credentials, whitelisted the IP blocks, the status bar says "Sent!", and the Ad Hoc log doesn't indicate any problems - but I am not seeing the files on my server.

Does it take a while to send? I'm struggling to see if there is a problem with how I am setting it up, or something else.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

If you're able to log in to the FTP site and create a blank text file on the server, the tool should also be able to create a scheduled report.

This might be one to send to Customer Care. Provide them with the login company, user, project name, and FTP credentials. The agent should be able to troubleshoot from there.

View solution in original post

5 Replies

Avatar

Level 2

A couple of things to try:

When sending to FTP via Ad Hoc...

  1. Try using the full FTP address: ftp://ftpsite.site.com
  2. Try leaving the port number empty

For SFTP (Secure File Transfer Protocol), all the information you need is here: Secure File Transfer Protocol

When sending to SFTP via Ad Hoc/Data Warehouse, you will have to have the authorized_keys file in the ...

  1. Per Adobe's instructions found here (https://marketing.adobe.com/resources/help/en_US/whitepapers/ftp/ftp_sftp_dw.html) you need to obtain the authorized_keys file which is in the .ssh directory within the root directory of the user you log in with
  2. To obtain the authorized_keys file, you have to send a request to Client Care via one of your organization's supported users
  3. Adobe will probably send back two files: (1) authorized_keys_RSA.txt and (2) authorized_keys_DSA.txt
  4. Use the RSA file but save it as a file, not as a .txt file naming it "authorized_keys"
  5. After this file is obtained, log in to the FTP site under the same credentials that are used for the Data Warehouse request.
  6. In the root directory, navigate to the folder named .ssh (if one does not exist, create one) and place the authorized_keys file there.

Hope this helps,

-Rob Ferguson

Avatar

Level 1

Rob

Thank you for your help.  The system does not allow me to continue if I leave the port blank.  I am using FTP (not sFTP) and tried using the full FTP URL to no avail.

Avatar

Employee Advisor

Hi Alyssa, are you able to log in to the FTP site using the credentials you have via WIndows Explorer, and create an empty text file on the FTP site? Between all those actions, there should be no issues getting a report scheduled.

Avatar

Level 1

I am on a Mac so I can't attempt that, but I can connect through my FTP program just fine using the same credentials.

Avatar

Correct answer by
Employee Advisor

If you're able to log in to the FTP site and create a blank text file on the server, the tool should also be able to create a scheduled report.

This might be one to send to Customer Care. Provide them with the login company, user, project name, and FTP credentials. The agent should be able to troubleshoot from there.