How to connect adobe analytics data to tableau?

[surajyadav1041]

How to connect adobe analytics data to tableau or export the same data in a CSV file on a desktop?

[leocwlau · Accepted solution]

You can use the "Data Warehouse" function under the "Tools" menu and refer to https://experienceleague.adobe.com/docs/analytics/export/data-warehouse/data-warehouse.html?lang=en for documentation.

You have to select dimensions and metrics for the export and this determine the final export file size. If you use email as the destination, there are size limit on the final data size, and there is no size limit and you can choose to use tableau as export format if you use FTP as the destination.

[eknott]

Hi! 
As far as I know, there isn't yet a way to access your adobe data directly in tableau but there are some connectors that have been developed. 

Daexus is a free connector https://www.daexus.io/products/ it also runs locally on your machine so its safe as no 3rd party servers access the data.

To the second part of your question, I would reference @leocwlau answer for export. Here is also a visual explanation and other additional great resources/detail on this blog https://blog.openbridge.com/how-to-automate-adobe-data-warehouse-exports-490115329a8  

[CristinaDaexus]

Hey there, I'm Cristina and I helped found Daexus, I'm more than happy to set you up with a free trial account if you want to check it out. Just like @eknott pointed out, it's super safe as it only runs on your computer. More than happy to answer any questions!

https://www.daexus.io/products