i wanted to ask what are the main differences between Data Warehouse and Reporting API in order to understand which is the best to use.
We have to export a csv file to an external data lake (they need aggregated metrics with a specified granularity).
I see less effort in implementing Data Warehouse export to an FTP location, but can it be more efficient the Reporting API?
@nico9 There are some metrics and dimensions which are not supported in data warehouse which can be exported through reporting api. You would need to know what are the metrics and dimensions you want to report based on that you can decide which one to use.
Here is the documentation on which of the metrics and dimensions that are not supported
If you are looking to extract large datasets out of Adobe Analytics, Data Warehouse is a recommended Tool.
Data Warehouse should be used:
Not all components and segments are compatible with Data Warehouse (Discussed here- Components | Segments). As an alternative Reporting API steps in. Reporting API 2.0 has sure advantages over the Reporting API 1.4.