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

Question about how to setup external SFTP/FTP and API

martinh36864894
Level 2
Level 2

Hi Adobe expert,

We are trying to bring our adobe analytic data to one of hour database/datalake, so trying to test with features within Adobe Analytics to help us.

  1. We internally setup an SFTP server (SFTP is preferred in our organization). But we test with SFTP and FTP configuration under data feed. It keeps failing.
  2. It looks like we can also apply Adobe hosted FTP. Could you show us how we can apply?
  3. Is there any API that we could utilize? There are a lot of API options, but we are not sure which one is best suitable.

We'd like to have as much data as possible so we could combine our internal data to further study.

Appreciate your guideline and help,

Best,

Martin

1 Accepted Solution
hyderziaee
Correct answer by
Employee
Employee

Yes, it needs to be added to the authorized_keys file under '/.ssh' folder

Here is a document for Data warehouse connection, but kind of works for data feed as well.

Sending Data Warehouse Requests to SFTP Servers

View solution in original post

7 Replies
hyderziaee
Employee
Employee

If you are setting up datafeeds, you can use either FTP/SFTP or S3. API is not available for datafeeds.

Can you expand on what error are you receiving when try to connect via SFTP?

martinh36864894
Level 2
Level 2

Sure.

Our SFTP we setup uses following setting, we tested with external FTP client, it works fine.

  • Host: sftp.{ourdomain}.com
  • Port: 22
  • User: {username}
  • Password: {password}

In Adobe Data Feed, we set

  • Type: SFTP
  • Host: sftp.{ourdomain}.com
  • Username: {username}
  • There is no password but RSA/DSA Public Key, but I leave it as is.

The error we get is

     "FTP Connect Error"

Thank you,
Martin

hyderziaee
Employee
Employee

Thanks for the details.

Make sure that the connection is only using the key for authentication. The password is not supported. Also, check with your network team, if they can see the logs to find why your server refused the connection attempt by our server.

As for the public key, how did you install it?

And when you tested, did you use a ssh key-pair to test?

martinh36864894
Level 2
Level 2

I believe SSH key-pair test is something missing. Our network team only provides us a password.

We didn't test with SSH Key pair.

Since password is not support, should we download the RSA or DSA key from Adobe Data Feed under SFTP and place it to somewhere in our folder?

Thank you,

Martin

hyderziaee
Correct answer by
Employee
Employee

Yes, it needs to be added to the authorized_keys file under '/.ssh' folder

Here is a document for Data warehouse connection, but kind of works for data feed as well.

Sending Data Warehouse Requests to SFTP Servers

View solution in original post

martinh36864894
Level 2
Level 2

Got it. Thanks for the instruction. I will test it and let you know.

One last question, if we would like to pull raw data through API, which API is one we should look at?

hyderziaee
Employee
Employee

API is not available for raw data (data feed)