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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Exporting Adobe Analytics Data Warehouse Data

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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-...

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/

View solution in original post

0 Replies

Avatar

Correct answer by
Community Advisor

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-...

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/