Solved

Adding sFTP delivery method

8 replies
3121 views
Translate All

Hello,

I need send daily reports to an sFTP server. Currently, my Analytics instance on shows FTP as a delivery option. How can I add sFTP delivery options?

Analytics

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Hyder_ZiaeeAccepted solution

Adobe Employee

Yes, Select the FTP option.

Insert the host and username. You can leave the password blank, as SFTP would be working on SSH public/private keys.

Make sure that the host name has the sftp:// protocol in the beginning. and the port is set to 22.

Download the public key from Admin > Data Feeds section (or have customer care provide it to you). Place it in the /.ssh/authorized_keys file on your server.

Keep in mind that Adobe uses one-factor authentication, so if your server is asking for password authentication after the keys, it would fail.

Here is the article: https://marketing.adobe.com/resources/help/en_US/whitepapers/ftp/ftp_sftp_dw.html

-Hyder

Hyder_Ziaee

Adobe Employee

Hi Nicholas,

You can send via SFTP, reports through Data Warehouse and Data Feed files.

Other tools do not support SFTP functionality currently.

-Hyder

Translate

nicholasm843373Author

Thanks - but my Data Warehouse only shows delivery options for FTP, not SFTP. Any suggestions?

Translate

Hyder_Ziaee

Accepted solution

Adobe Employee

Yes, Select the FTP option.

Insert the host and username. You can leave the password blank, as SFTP would be working on SSH public/private keys.

Make sure that the host name has the sftp:// protocol in the beginning. and the port is set to 22.

Download the public key from Admin > Data Feeds section (or have customer care provide it to you). Place it in the /.ssh/authorized_keys file on your server.

Keep in mind that Adobe uses one-factor authentication, so if your server is asking for password authentication after the keys, it would fail.

Here is the article: https://marketing.adobe.com/resources/help/en_US/whitepapers/ftp/ftp_sftp_dw.html

-Hyder

Translate

nicholasm843373Author

Thanks! That is very helpful.

Translate

K

kirubel_tseh

Hyder,

Our segments are too complicated to use data warehouse to sFTP our reports. Can you explain how I can sftp reports from Ad-Hoc Analysis tool? Is Data Feeds an option?

I believe our server only accepts sFTP connections, so I'm trying to figure out a workaround.

Thanks,

-KB

Translate

Hyder_Ziaee

Adobe Employee

Unfortunately Ad Hoc doesn't allow SFTP connections.

However, if you can setup a extraction script, you can use Adobe hosted server, and have the file from Ad Hoc sent over to it. Then from your server connect to Adobe's using SFTP and fetch the file.

DataFeeds would not be an option, as that is raw data, and would not allow for segmentation.

-Hyder

Translate

K

kirubel_tseh

Thanks for the feedback.

I'm not familiar with the above methods. Can you provide some links to documenation that i can lookup and read up on about extraction scripts and access to Adobe hosted server?

Thanks,

-KB

Translate

Hyder_Ziaee

Adobe Employee

I am not familiar with the working of the process as well. It is usually done by Network and Database management teams. You can check within your organization about this. For reading up on this, google search "ETL process"

As for the Adobe FTP server, Customer Care provides 10 GB of complimentary server space for temporary storage of data. You can ask your organization's supported user to open a ticket with us for this. However, I would recommend reusing the ones that are already created. I can see about 21 such spaces already provided. This information can also be obtained from Customer Care.

-Hyder

Translate

Sign up

Login with SSO

Login to the community

Login with SSO