Dataware house SFTP request

Avatar

Avatar
Validate 1
Level 1
pradeep_07
Level 1

Likes

2 likes

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Give Back
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
pradeep_07
Level 1

Likes

2 likes

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Give Back
Boost 1
Applaud 5
View profile
pradeep_07
Level 1

02-02-2021

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

324 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

324 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
ishans52004352
Employee

02-02-2021

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.

Answers (3)

Answers (3)

Avatar

Avatar
Level 1
jr_13
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
jr_13
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
jr_13
Level 1

26-05-2021

@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

Avatar

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

324 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

324 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
ishans52004352
Employee

02-02-2021

Yes, @pradeep_07 .

Avatar

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

324 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

324 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
ishans52004352
Employee

02-02-2021

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.