cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Difference between BW and EDW

Former Member
0 Likes
5,892

Hi All,

I work on R/3 Security. Lately I'm in to EDW security.

So, I got one basic question to ask the experts here.

What is the difference between BW and EDW?

A bit of detailed explanation would be highly appreciated.

Regards,

Bharath

View Entire Topic
Former Member
0 Likes

Hi,

EDW stands for enterprise datawarehousing, right? the "enterprise data warehouse" is your BW if you are staging / reporting only from BW; you could have as well another data warehouse systems combining BW data and other data...

Some would also say that the "data warehouse" is ONE system able to ETL data and present reports based on this data; that would be your BW.

EDW can also be stated as the data warehouse layer where you bring data from the source system and stage it . From EDW, you take it to the final destinations ( called data marts) from where you can develop queries.

Plz find the below doc which explains more abt your topic...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/2341ba90-0201-0010-f1ac-daad61fd...

Assign points if this helps u...

Regards,

KK.