SAP BW upgrade to BW 7.4 and DB migrate to SAP HANA

Until HANA was invented. SAP BW the data warehousing and reporting application is running on SQL server, IBM DB2, and Oracle.

SAP HANA which is in-memory computing  and columnar database technology has made real-time reporting with SAP BW an easy job.

With SAP BW 7.4 on HANA
Understanding each object and its properties will help rearchitecting BW system for faster reporting environment.

1. HANA optimized DSO
2. HANA optimized Infocube
3. Virtual Provider/Transient provider
4. Composite Provider
5. Open DSO

SAP S/4 HANA - Overview

S/4 HANA is SAP Business Suite for HANA.

Lets recap a bit, Business Suite by SAP covers ERP, SRM, CRM, PLM, and SCM. These modules are available as different system. So there is a need to establish connection between these systems inorder to combine data sets and do reporting. Even in case of SAP BW , you need to connect with each system to pull respective data.


With the invent of HANA, SAP has introduced entire suite on HANA which provides the existing customer to completely reimagine the data models, business processes, and ofcourse business decision.
All the modules in the suite is now packaged as one. Morever, it is OLAP + OLTP. The system will be so powerful and faster that you can analyze the real time data.

Also, enterprise who intends for digital transformation, S/4 HANA is the right choice as it it allows you to remodel things and gives you SAP Fiori UX.