Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

data warehouse vs data feed

Avatar

Level 2

Hello,

 

In my company we've been through many iterations of our ETL pipeline using the DW extract from Adobe Analytics. Most recently, Adobe representatives have told us we should start using the Data Feed method for our ETL instead.

I asked support directly if they could share any technical documentation that would support the recommendation they made and didn't receive a response.

I guess I am looking to understand what are the use cases for each method and why Data Feeds is the recommended method of extraction for ETL.

Thanks,

Ana

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Basic difference between Data Warehouse and Data Feed is that DWH send processed data while Data Feed files has raw/unprocessed data. It depends on your business use case which one you would want to use.

View solution in original post

10 Replies

Avatar

Level 2

Hi, I've seen this documentation before. This is not what I am asking. To make it super clear: What are the use cases of the DW vs Data Feed?

Avatar

Correct answer by
Employee Advisor

Basic difference between Data Warehouse and Data Feed is that DWH send processed data while Data Feed files has raw/unprocessed data. It depends on your business use case which one you would want to use.

Avatar

Level 2
I understand that. I am interested in knowing why the Adobe team is suggesting to use Data Feeds vs DW for our ETL. Is that the standard?

Avatar

Employee Advisor
That is not a standard and solution divided is based on the business requirement. If you can share more details on your business case I can share my comments over the solution.

Avatar

Level 2

your statements contradicts with adobe docs. 

"Introduction to data warehouse" >> The data warehouse request tool in Adobe Analytics gives you access to query the raw data

on this page - https://experienceleague.adobe.com/docs/analytics-learn/tutorials/exporting/data-warehouse/introduct...

Avatar

Level 2

abhijithr_0-1674236985543.png

Again per this slide, both on right hand side; after processed

Avatar

Level 2

Did you get to the bottom of this?

From the thread it looks you didn't even though the answer is tagged as accepted solution. Is it?

Avatar

Level 1

I also had a similar issue and later found this Adobe documentation.


This page compares various Adobe Analytics products: Analysis Workspace, Report Builder, Data Warehouse, Data Feeds, and Analytics API 2.0. 

https://experienceleague.adobe.com/docs/analytics/analyze/admin-overview/analytics-product-compariso...