Benefits of using SAP BW compared to a simple relational Database like Oracle or MS SQL Server

[Former Member]

Hi folks,

a few weeks ago I started to learn using SAP BW 7.4.

Everything is fine except for the motivation behind the implementation of a SAP Business Warehouse. It seems to me very time- and money-consuming to integrate a SAP BW into the enterprise. To create all the InfoObjects, InfoProviders, DataFlows etc. you will not only need a lot of time but also you need a lot of knowledge about SAP BW.

So my question to you all is: What are the benefits of a SAP Business Warehouse compared to a simple (relational) Database?

Why do we need to create all those Objects and rules and so on?

Are there any realistic examples or case studies where I can see the benefits of SAP BW?

I am very grateful to all of you in advance.

Best regards

Arthur

[Former Member]

Hi Arthur,

First thing - BW and RDBMS (Oracle or MSSQL or whatever), both are different layers. BW is an Application layer and RDBMS is your Database layer.

For benefits of BW - Google with a key word "Benefits of BW", there are many links.

Regards,

Harish Karra