Develop your own custom SQL data warehouse
In the age of big data and the relentless advance of digitalization, new requirements inevitably arise that must be integrated. At SAP, too, there have been a number of innovations in the data warehouse context since the presentation of SAP HANA technology in 2010.
Note: Since the white paper was published in 2022, we are still referring to the SAP Data Warehouse Cloud. This was renamed SAP Datasphere in March 2023 – however, the information about SAP's cloud product remains valid and up to date.
More about the book "
" SQL DATA WAREHOUSING WITH SAP HANA
In the SAP Press book on SQL Data Warehousing, we would like to introduce you to SAP's existing data warehouse solutions against the backdrop of key objectives and current requirements, and in particular, familiarize you with the SAP HANA-based SQL Data Warehousing approach.
In this book, you will learn everything you need to know about SQL data warehousing with SAP HANA—from designing a modern data warehouse and implementing the SQL data warehouse to optimization and expansion.
THE BOOK AT A GLANCE
- Objectives and areas of application of data warehousing
- Introduction to SAP HANA as a platform
- Reference architecture of a modern data warehouse
- Development approach for the SAP SQL Data Warehouse
- Methodological foundations for data warehousing
- Technical fundamentals
- Modeling the conceptual data model
- Modeling of physical data models
- Development of the SQL data warehouse
- Deployment of the SAP SQL Data Warehouse
- Loading and operating the SQL data warehouse
- SAP Analytics Cloud
- SAP Data Warehouse Cloud
- SAP Data Intelligence
Technical details: approx. 550 pages, hardcover. Manual format 16.8 x 24 cm. Printed in black and white on wood-free 90g offset paper. Easy-to-read serif font (TheAntiquaB 9.35 Pt.). Single-column layout.
THE AUTHORS
Martin Peitz has been a consultant at ISR Information Products AG since January 2020. As a master's graduatein business information technology,he dealt intensively with issues of information management and the integration of corresponding systems in the enterprise environment during his studies. Having previously completed a dual degree in business administration, he is also familiar with practical problems and knows the requirements of small and medium-sized businesses with regard to the organization of heterogeneous system landscapes.
Frederik Niemeyer works as a consultant at ISR Information Products AG and specializes in the development of SAP HANA SQL data warehouses.In addition to his project work, he is also an external trainer for the HDW410 course offered by SAP. The training course teaches participants the basics of implementing a HANA-based SQL data warehouse and was developed by ISR in close cooperation with SAP.
Eckhard Schulze is an ISR management consultant in the field of SAP Information Management, specializing in data warehouse architecture, data modeling, and HANA data warehousing. He can apply and expand his knowledge in both best-of-breed and best-of-suite architectures. Within the company, Eckhard Schulze serves as a technical expert in the field of HANA SQL data warehousing and is responsible for the technical BI system landscape (cloud and on-premise). He is also a course trainer and system architect for the SAP HANA Data Warehousing training course (HDW410) at SAP.
Matthias Füsting worked as a technology consultant at ISR, where he used his many years of experience to implement modern data warehouse architectures in the SAP environment. Another focus of his consulting work was the creation of architectures and development approaches for applications on the SAP Business Technology Platform. His expertise ranged from purely native developments on the HANA SQL Database to the implementation of cloud-native applications in the SAP Cloud Platform.
During his time at ISR Information Products AGas a technology developer and advisor,Dominik Fischerfocused on SQL data warehouse architecture. Working closely with SAP product owners, he defined the necessary development methodology, architecture, and project management approaches, which are now considered SAP standards in the field of agile (SQL) data warehouse development.
Free white paper
DEVOPS AND SAP HANA SQL DATA WAREHOUSING
LATEST NEWS ARTICLES ON HANA SQL DWH
SAP Datasphere and HANA SQL – a Perfect Pair?
In our series on hybrid SAP HANA data warehouse architectures, we look at the possible combinations of the three SAP data warehouse solutions. In the first part, we gave you an overview of the key...
What is the current SAP Data Warehouse Strategy?
With SAP BW/4HANA, SAP HANA SQL Data Warehousing, and SAP Datasphere, SAP offers three different data warehouse solutions. The strategic focus is on public cloud products based on...
Is Datasphere the successor to SAP Business Warehouse?
SAP has refined its data warehouse strategy. Datasphere is SAP's strategic application-driven cloud data warehouse solution and will therefore be the focus of future investments and innovations at SAP. Table of contents 1. Is SAP...
Hybrid SAP HANA Data Warehouse Solutions: An Overview
SAP offers three different data warehouse solutions: SAP BW/4HANA, SAP HANA SQL Data Warehousing, and SAP Data Warehouse Cloud. We want to show you the advantages and challenges of hybrid architectures in these three...
Model-driven SAP HANA SQL Data Warehousing
SAP HANA SQL Data Warehousing relies on model-driven development, which provides a high degree of structural flexibility and process agility. Table of Contents 1. Model-Driven Development in the Software Industry...
Tools for HANA SQL Data Warehousing
SAP HANA SQL Data Warehousing offers a high degree of flexibility when it comes to using different tools. The SQL approach, particularly within the context of the DevOps philosophy, enables the use of many well-known (open-source)...
Our Workshops on the Topic:
HANA SQL DWH
Wilhelm Hardering
Senior Executive Manager
wilhelm.hardering@isr.de
+49 (0) 151 422 05 422