Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Question about how to setup external SFTP/FTP and API

Avatar

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

Avatar

Correct answer by
Employee Advisor

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

Avatar

Employee Advisor

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?

Avatar

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

Avatar

Employee Advisor

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?

Avatar

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

Avatar

Correct answer by
Employee Advisor

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

Avatar

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?

Avatar

Employee Advisor

API is not available for raw data (data feed)