Expand my Community achievements bar.

SOLVED

Dataware house SFTP request

Avatar

Level 7

Hi,

 

I am trying to send data from adobe analytics Data warehouse to SFTP location. We received a hostname as IP address and username, password. According to adobe while sending file to SFTP we have to include prefix as SFTP.  Question is, the SFTP prefix protocol need to be configured at the server end (Along with IP address) or its just prefix we need to add in the host field.

 

Thanks,

 

Pradeep

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

The public keys (authorized_keys) file need to be placed in .ssh folder in the root directory of your location. Our IP addresses should be whitelisted. I'd recommend that you reach out to our Client Care team with the DW request ID and we will get this resolved for you asap.

View solution in original post

7 Replies

Avatar

Employee Advisor

You will need to just add the SFTP protocol to the host name in the Data Warehouse setting. For example, if the FTP host name is abc.xyz.com, you will need to mention sftp://abc.xyz.com in the host field along with port 22.

Avatar

Level 7
Thanks ishan. What if the destination host is SFTP and host name is IP address? do we still need to add SFTP as prefix

Avatar

Level 7
Thanks Ishan, I have followed all steps to send data to SFTP server . For some reason , I am getting below error. Error: The transfer process may have left behind incomplete report files on the destination server.

Avatar

Correct answer by
Employee Advisor

The public keys (authorized_keys) file need to be placed in .ssh folder in the root directory of your location. Our IP addresses should be whitelisted. I'd recommend that you reach out to our Client Care team with the DW request ID and we will get this resolved for you asap.

Avatar

Level 10
Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?

Avatar

Level 1

@pradeep_07 @Ishan_Sinha_ 

Did the question get answered:

"What if the destination host is SFTP and host name is IP address? do we still need to add SFTP as prefix"

I am in the same boat but I only have an IP address 

thanks,

Justin