Question about how to setup external SFTP/FTP and API

[martinh36864894]

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

[Hyder_Ziaee]

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]

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

[Hyder_Ziaee]

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]

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

[Hyder_Ziaee · Accepted solution]

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

[martinh36864894]

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?

[Hyder_Ziaee]

API is not available for raw data (data feed)