Skip to Content
Product Information
Author's profile photo Klaus-Peter Sauer

SAP SQL Data Warehousing with HANA

+++ Updated: August 10th 2020 +++

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. Visit the page regularly to get the latest updates.

To make it clear upfront, SAP offers different ways of data warehousing using SAP HANA:

  1. The packaged application approach using SAP BW or SAP BW/4HANA.
  2. The native SQL driven approach with SAP HANA.
  3. The public cloud software service SAP Data Warehouse Cloud.

The approaches complement each other and can be combined using mixed or hybrid architectures.

The SAP HANA Data Warehousing Foundation (DWF) offers a set of packaged data management tools to support SAP SQL Data Warehousing use cases using SAP HANA. For more information please check out the DWF Community Page.

Overview information

SAP HANA XS Advanced

SAP Cloud Platform

Synonyms

Data Modeling

Data Provisioning

Deployment, Run & Operate

Hybrid Scenario with SAP Data Warehouse Cloud NEW

Archive

SAP HANA Data Warehousing Foundation/HANA SQL Data Warehouse Blog
Build and Run an SQL Data Warehouse on SAP HANA
PDF | Video
SAP TechEd 2017 Lecture

Assigned tags

      18 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      As of TechEd it was not possible to do HANA SQL DW in a public cloud setting (e.g. AWS). is this now available?

      Author's profile photo Former Member
      Former Member

      Been reading through the content... the first guidance document How to prepare the HANA XSA environment to run HANA Data Warehousing Foundation 2.x components

      Is not found.

      Author's profile photo Klaus-Peter Sauer
      Klaus-Peter Sauer
      Blog Post Author

      If you use an instance of SAP HANA 2.0 SPS02 this works on AWS like it does on-prem.

      Best regards
      KP

      Author's profile photo Klaus-Peter Sauer
      Klaus-Peter Sauer
      Blog 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

      KP

      Author's profile photo Klaus-Peter Sauer
      Klaus-Peter Sauer
      Blog 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.

      Author's profile photo Klaus-Peter Sauer
      Klaus-Peter Sauer
      Blog Post Author

      The SAP SQL Data Warehousing Trial version is now available.

      Please check out this blog for more details and the link to the CAL image: 
      https://blogs.sap.com/2018/05/31/sap-sql-data-warehouse-trial/ 

      Author's profile photo Vijay N
      Vijay N

      Peter,

      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?

      Thanks,

      Vijay

      Author's profile photo Klaus-Peter Sauer
      Klaus-Peter Sauer
      Blog Post Author

      Hi Vijay,

      I do not have any numbers. This is not a product like the SAP Business Warehouse, so anyone using SAP HANA could start a project. There have been many customers talking about this approach. The latest one I am aware of was at SAPPHIRE Now: https://sessioncatalog.sapevents.com/go/agendabuilder.sessions/?l=169&sid=59557&locale=en_US

      Best regards
      Klaus-Peter

      Author's profile photo Klaus-Peter Sauer
      Klaus-Peter Sauer
      Blog Post Author

      Added/updated the new community pages for the SAP HANA Data Warehousing Foundation, SAP SQL Data Warehousing, SAP BW/4HANA and SAP Business Warehouse.

      Author's profile photo Klaus-Peter Sauer
      Klaus-Peter Sauer
      Blog Post Author

      Just added a very good step-by-step blog/tutorial series showing how to go from zero to building analytics using SAP HANA and SAP Analytics Cloud.

      Author's profile photo Marcos Antonio Monzón Martel
      Marcos Antonio Monzón Martel

      Thanks Klaus for your great aportation. Its the best.

       

      Author's profile photo Klaus-Peter Sauer
      Klaus-Peter Sauer
      Blog Post Author

      Just added a very interesting and up-to-date blog on how you can create yourself a simple app to track the COVID-19 status in near real time with SAP HANA XS Advanced and display it in a web server or with SAP Analytics Cloud using custom widget.

      Author's profile photo Maitree Sodsee
      Maitree Sodsee

      Hi Klaus-Peter Sauer ,

       

      Do you have document for step by step installation  SAP SQL Data Warehousing with HANA ?

       

       

      Author's profile photo Klaus-Peter Sauer
      Klaus-Peter Sauer
      Blog Post Author

      Hello Maitree Sodsee,

      SAP SQL Data Warehousing with HANA is a use case for SAP HANA and not a separate software package. Therefore you can use the SAP HANA installation guide: https://help.sap.com/viewer/product/SAP_HANA_PLATFORM/2.0.05/en-US?task=implement_task

      Best regards
      KP

      Author's profile photo Maitree Sodsee
      Maitree Sodsee

      Dear  Klaus-Peter Sauer

       

      Thank you for you answer, If I want to install SAP HANA Data Warehousing Foundation , What should I do ?

      Author's profile photo Klaus-Peter Sauer
      Klaus-Peter Sauer
      Blog Post Author

      Just follow the installation guide which is available here: https://help.sap.com/viewer/product/SAP_HANA_DATA_WAREHOUSING_FOUNDATION/2.0.5.0/en-US

      Author's profile photo Maitree Sodsee
      Maitree Sodsee

      Dear Klaus-Peter Sauer

       

      Do I must to install both SAP HANA Data Warehousing Foundation Installation Guide for XS Advanced Components and SAP HANA Data Warehousing Foundation Installation Guide for XS Classic Components? Thank you  for your suggestion to me.

      Author's profile photo Klaus-Peter Sauer
      Klaus-Peter Sauer
      Blog Post Author

      That depends on the component you want to use. For DDO you need the XS Classic guide. The others require XS advanced. Have a look at the getting started and development guides on SAP Help and you will get a better idea.