Skip to Content

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:

  1. The data warehouse application approach using SAP BW or SAP BW/4HANA.
  2. 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 XS Advanced


SAP Cloud Platform


Data Modeling


Deployment, Run & Operate


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:

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Klaus-Peter Sauer Post author

    Added new section on XS Advanced as people are asking to know more about it, so it is accessible all from here.

    Also check out the new HANA Academy videos on YouTube. Great new additions to the Data Warehousing Foundation Playlist.

    Best regards


  2. Klaus-Peter Sauer Post author

    I have updated a non-functional link and added new links to recent Open SAP courses on Dynamic Tiering and development on SAP Cloud Platform. The data warehousing foundation is currently not available on SCP today, but hopefully soon.

  3. Vijay N


    Thanks for the excellent information, Do you have any information how many customers implemented this and what’s the success rate compare to SAP BW on HANA? i mean do we get all benefits that we currently have in SAP BW on HANA.

    Any customers feedback on this product?




Leave a Reply