Product Information
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:
- The packaged application approach using SAP BW or SAP BW/4HANA.
- The native SQL driven approach with SAP HANA.
- 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
| Cloud-Native Development with SAP Cloud Platform | Open SAP Course |
| SAP Cloud Platform Version Control with Git | Open SAP Course |
| Cloud-Native Operations with SAP Cloud Platform | Open SAP Course |
| Introducing the new Application Programming Model for SAP Cloud Platform | Blog |
| Connecting the SAP HANA Service on Cloud Foundry to SAP Analytics Cloud – The lazy approach Part 1, Part 2, Part 3 | Blog Series |
| How to connect HANA DB on Cloud Foundry environment to Neo environment with SDI Agent | Blog |
| Binding Node.js Application to HANA Databases | Blog |
| Cloud Foundry Authentication – how it works step-by-step | Blog |
Synonyms
| Synonyms in HANA XS Advanced, Introduction | Blog |
| Using Synonyms in SAP HANA | Blog |
| The process described in this blog Synonyms in HANA XS Advanced, Accessing Objects in an External Schema has evolved. This new blog describes how XSA is Accessing Remote Sources & External Objects | Blog |
| Synonyms in HANA XS Advanced, Configuration, Templating, Service Replacement | Blog |
| Seamless transition of HANA-models from virtual to persistent data access by leveraging Synonyms | Blog |
Data Modeling
Data Provisioning
Deployment, Run & Operate
Hybrid Scenario with SAP Data Warehouse Cloud NEW
| SAP Data Warehouse Cloud – Hybrid – access to SAP HANA for SQL data warehousing NEW | Blog & Recording |
| SAP Data Warehouse Cloud integrated with SAP SQL data warehousing sharing a single DB-Tenant NEW | Blog & Recording |
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 |
As of TechEd it was not possible to do HANA SQL DW in a public cloud setting (e.g. AWS). is this now available?
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.
If you use an instance of SAP HANA 2.0 SPS02 this works on AWS like it does on-prem.
Best regards
KP
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
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.
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/
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
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
Added/updated the new community pages for the SAP HANA Data Warehousing Foundation, SAP SQL Data Warehousing, SAP BW/4HANA and SAP Business Warehouse.
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.
Thanks Klaus for your great aportation. Its the best.
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.
Hi Klaus-Peter Sauer ,
Do you have document for step by step installation SAP SQL Data Warehousing with HANA ?
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
Dear Klaus-Peter Sauer
Thank you for you answer, If I want to install SAP HANA Data Warehousing Foundation , What should I do ?
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
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.
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.