Dataware house SFTP request

Forum|Forum|4 years ago
February 2, 2021
5 replies
2766 views

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

Analytics

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

Best answer by isinha

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.

I

isinha

Adobe Employee

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.

pradeep_07Author

Level 4

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

I

isinha

Adobe Employee

Yes, @pradeep_07 .

pradeep_07Author

Level 4

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.

I

isinha

Accepted solution

Adobe Employee

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.

jantzen_b

Adobe Employee

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?

J

jr_13

@pradeep_07 @isinha

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