Develop a Custom Data Warehouse on SAP HANA

Why SAP HANA SQL Data Warehousing?

Objectives
After completing this lesson, you will be able to:

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

Drivers for Change in the Data Warehouse Environment

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

Save progress to your learning plan by logging in or creating an account