Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Dataware house SFTP request

pradeep_07
Level 4
Level 4

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

Datawarehouse request
1 Accepted Solution
ishans52004352
Correct answer by
Employee
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.

View solution in original post

7 Replies
ishans52004352
Employee
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_07
Level 4
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
pradeep_07
Level 4
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.
ishans52004352
Correct answer by
Employee
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.

View solution in original post

jantzen_belliston-Adobe
Community Manager
Community Manager
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?
jr_13
Level 1
Level 1

@pradeep_07 @ishans52004352 

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