Why SAP HANA SQL Data Warehousing?
Objectives
After completing this lesson, you will be able to:
- Explain why we need an SQL approach to building a data warehouse
- Explain the different SAP data warehousing approaches
Why SAP SQL Data Warehousing
The Different Data Warehousing Approaches from SAP
Integrated View of SAP Data Warehousing Solutions
SAP responds to the drivers mentioned above with three different data warehousing approaches; the BW/4HANA approach, the SAP Data Warehouse approach, and the SAP SQL Data Warehousing approach. Today, it is more common to see a combination of these approaches. This is known as the hybrid or mixed approach. Even though the three approaches - SAP BW/4HANA, SAP Data Warehouse Cloud, and SAP SQL Data Warehousing are based on different concepts, they are all running on the SAP HANA database. This means they all utilize the strengths of SAP HANA to allow for customized, mixed approaches.
Key Characteristics of SAP BW/4HANA, SAP Data Warehouse Cloud and SQL Data Warehousing
SAP SQL Data Warehousing in Detail
Set Up the Training Environment
ExerciseStart Exercise
