Question about how to setup external SFTP/FTP and API

Avatar

Avatar

martinh36864894

Avatar

martinh36864894

martinh36864894

09-08-2018

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

hyderziaee
Employee

09-08-2018

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

Answers (6)

Answers (6)

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

hyderziaee
Employee

09-08-2018

API is not available for raw data (data feed)

Avatar

Avatar

martinh36864894

Avatar

martinh36864894

martinh36864894

09-08-2018

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

Avatar

martinh36864894

Avatar

martinh36864894

martinh36864894

09-08-2018

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

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

hyderziaee
Employee

09-08-2018

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

Avatar

martinh36864894

Avatar

martinh36864894

martinh36864894

09-08-2018

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

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

hyderziaee
Employee

09-08-2018

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?