SAP SQL Data Warehousing with HANA
A growing community of customers and partners is using the SAP HANA in-memory platform for data warehousing purposes for a long time. In recent years, several innovations occurred in this area. Especially the introduction of SAP HANA extended application services advanced version (XSA) and SAP HANA 2.0 changed the way of your traditional software development to a modern and agile data warehouse development in a DevOps style.
At SAP TechEd and other events, we received great interest about these innovations, but were also asked to provide a central place where developers, architects and other people from the community can get more and up to date information.
Therefore, this blog serves as a landing page for SAP SQL Data Warehousing using SAP HANA 2.0 and focusing on native SQL data warehouse development. It is a collection of valuable information in terms of blogs, videos, presentations, and first guidance documents on various aspects of this topic and will further grow over time as some of the documents are currently work in progress. Visit the page regularly to get the latest updates.
To make it clear upfront, SAP offers two ways of data warehousing using SAP HANA:
- The data warehouse application approach using SAP BW or SAP BW/4HANA.
- The native SQL driven approach with SAP HANA.
Both approaches complement each other and can be combined using mixed architectures. In case you are looking for SAP BW related information please have a look at the community pages:
SAP BW/4HANA Community or SAP Business Warehouse Community.
Overview information
SAP HANA SQL Data Warehouse – An Introduction | Blog |
Build and Run an SQL Data Warehouse on SAP HANA | Presentation |
Build and Run an SQL Data Warehouse on SAP HANA | TechEd Lecture 2017 |
Building an SAP HANA SQL Data Warehouse with HANA 2.0 (Coming January 2018) | First Guidance Document |
Data Modeling
Designing your agile DW with EA Designer – SAP HANA SQL Data Warehouse | Blog |
SAP EAD: Designing your agile DW with EA Designer | SAP HANA Academy Video |
Modeling the Data Warehouse with SAP Enterprise Architecture Designer (EAD) | Video Recording |
Clone, Edit and Build the Data Warehouse Artefacts using SAP Web IDE for SAP HANA | Video Recording |
Develop your agile DW with SAP Web IDE – SAP HANA SQL Data Warehouse | Blog |
Replicate ABAP CDS Views from SAP S/4HANA Cloud to SAP Cloud Platform | Blog |
How to leverage the XSA based components of HANA Data Warehousing Foundation 2.0 in SAP WebIDE to create new DWF projects and enable DWF capabilities in existing projects | First Guidance Document |
Deployment, Run & Operate
Leverage the Data Warehousing Monitor to execute an monitor the Task Chain | Video Recording |
Synonyms in HANA XS Advanced, Introduction | Blog |
Using Synonyms in SAP HANA | Blog |
Synonyms in HANA XS Advanced, Accessing Objects in an External Schema | Blog |
Synonyms in HANA XS Advanced, Configuration, Templating, Service Replacement | Blog |
HANA SPS03 – HANA Web IDE Full-Stack (SCP) for SAP HANA to support Git merge and conflict resolution | Blog |
How to prepare the HANA XSA environment to run HANA Data Warehousing Foundation 2.x components | First Guidance Document |
How to deploy an application to another space (coming soon) | First Guidance Document |
SAP HANA Data Warehousing Foundation
The SAP HANA Data Warehousing Foundation (DWF) option is a series of packaged data management tools to support SQL Data Warehouse use cases using SAP HANA. These tools are:
- Data Distribution Optimizer (DDO)
- Data Lifecycle Manager (DLM)
- Native DataStore Object (NDSO)
- Data Warehousing Scheduler (DWS)
- Data Warehousing Monitor (DWM)
For more information about DWF:
SAP HANA Data Warehousing Foundation | Overview Page |
SAP HANA Data Warehousing Foundation/HANA SQL Data Warehouse | Blog |
SAP HANA Data Warehousing Foundation | SAP HANA Academy Video |
SAP HANA Data Warehousing Foundation 2.0 SP 02 | First Guidance Document |
Introducing the NDSO: Part One – How to create a NDSO NEW | Blog |
Introducing the NDSO: Part Two – NDSO services (Delta Capabilities) NEW | Blog |