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.
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 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|
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|
|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|