Exporting Adobe Analytics Data Warehouse Data | Community
Skip to main content
owenk83195475
May 15, 2019
Solved

Exporting Adobe Analytics Data Warehouse Data

  • May 15, 2019
  • 1 reply
  • 1150 views

Hello,

I'm currently exporting custom field data from the Adobe Analytics -> tools -> datawarehouse section. I see from here that I can export via email or ftp.

What other ways can I export this data?

1. Can I export to an sftp location? How?

2. Is there an API that I can use to export this data?

3. Is there a direct database connection option which I can connect a db client to the tables with this data?

4. Are there any other ways of exporting the data?

Cheers,

Owen

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Urs_Boller

Hi Owen

here some hints:

1) sftp is possible: https://docs.adobe.com/help/en/analytics/export/ftp-and-sftp/secure-file-transfer-protocol/ftp-sftp-dw.html

2) yes, use API 2.0: https://github.com/AdobeDocs/analytics-2.0-apis

3) there are some connectors available. ask your client if he has already some tools, maybe there is a connector to Adobe Analytics

4) have a look at "data feed": http://datafeedtoolbox.com/how-to-setup-adobe-analytics-data-feeds/

1 reply

Urs_Boller
Community Advisor
Urs_BollerCommunity AdvisorAccepted solution
Community Advisor
June 17, 2019

Hi Owen

here some hints:

1) sftp is possible: https://docs.adobe.com/help/en/analytics/export/ftp-and-sftp/secure-file-transfer-protocol/ftp-sftp-dw.html

2) yes, use API 2.0: https://github.com/AdobeDocs/analytics-2.0-apis

3) there are some connectors available. ask your client if he has already some tools, maybe there is a connector to Adobe Analytics

4) have a look at "data feed": http://datafeedtoolbox.com/how-to-setup-adobe-analytics-data-feeds/