SAP SQL Data Warehousing with HANA

[kpsauer]

+++ 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 SQL Data Warehousing	Community Page
SAP SQL Data Warehousing Training Course - HDW410	Training
SAP HANA SQL Data Warehouse – An Introduction	Blog
SAP Big Data Warehousing Playlist (18 Videos)	SAP HANA Academy Video
SAP SQL Data Warehousing trial | FAQs	Blog
Data Bits & Bites for Busy People – SQL Data Warehousing Sessions Part 1: How is an SAP HANA Data Warehouse Different? Part 2: Conceptual Modeling with SAP Enterprise Architecture Designer Part 3: Physical Modeling with SAP Enterprise Architecture Designer Part 4: Clone, edit and build data warehouse artifacts with SAP Web IDE & Git Part 5: How to Use Continuous Integration & Testing in your Data Management Environment Part 6: How to Leverage Run & Operate in Your Data Management Environment Part 7: Who is using SAP HANA for Data Warehousing and Why?	Webinar Series
From zero to Analytics Part 1: Setting up your own SAP HANA instance, Part 2: Creating a calculation view with data privacy, Part 3: Setting up a user for the HANA Analytics Adapter, Part 4: Installing the HANA Analytics Adapter	Blog/Tutorial Series
Development | SAP HANA 2.0 – An Introduction	Blog

SAP HANA XS Advanced

SAP HANA Developer Guide for XS Advanced Model	SAP Help
XS Advanced for (not so) dummies Part 1, Part 2, Part 3, Part 4	Blog Series
The Path to SAP HANA Extended Application Services, Advanced Model	Blog
Best practices and recommendations for developing HDI-based roles Blog | How-to Paper	Blog
Grant privileges in mixed XSC/XSA scenarios	Blog
Consume Calculation Views from XS Advanced via Information Access	Blog
The easy way to make your HDI container accessible to a ‘classic’ database user	Blog
SAP HANA XS Advanced, Access a classic schema from an HDI container	Tutorial
SAP HANA XS Advanced - Cross-container access	Tutorial
Developing with HANA Deployment Infrastructure (HDI) without XSA/CF or Web IDE	Blog
How to leverage the XSA based components of HANA Data Warehousing Foundation 2.0 in SAP WebIDE to cr...	First Guidance Document
How to prepare the HANA XSA environment to run HANA Data Warehousing Foundation 2.x components	First Guidance Document
Set up the analytics adapter for SAP HANA XS Advanced with SSO for SAP Analytics Cloud	Blog
Tracking Coronavirus COVID-19 Near Real Time with SAP HANA XSA	Blog

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

Develop your agile DW with SAP Web IDE – SAP HANA SQL Data Warehouse	Blog
Clone, Edit and Build the Data Warehouse Artefacts using SAP Web IDE for SAP HANA	Video Recording
Modeling the Data Warehouse with SAP Enterprise Architecture Designer (EAD)	Video Recording
Designing your agile DW with EA Designer – SAP HANA SQL Data Warehouse Blog | Video	Blog
Creating «Extreme» added value services for companies using Data Vault with PowerDesigner as automat... – older blog but very good	Blog
Develop your Agile SQL Data Warehouse on SAP HANA: GIT Repository & Containers	Blog
Introducing the NDSO Part 1: How to create a NDSO Part 2: NDSO services (Delta Capabilities)	Blog
SAP Web IDE workspace and HDI container isolation, or how to work on one schema with multiple develo...	Blog
Overview Modeling in SAP Web IDE Compared to SAP HANA Studio	Blog
Introduction of Join Cardinalities In SQL With SAP HANA 2.0 SPS04	Blog
How to pivot/unpivot in SAP HANA	Blog
What is the difference CalcView versus SQL View?	Blog
When to use Execute in SQL Engine for Calculation Views	Blog
FAQ Modeling HANA Calculation Views in Web IDE	FAQ
Hands-On Tutorial: Machine Learning push-down to SAP HANA with Python	Blog

Data Provisioning

Replicate ABAP CDS Views from SAP S/4HANA Cloud to SAP Cloud Platform	Blog
Extraction from SAP S/4HANA and other ABAP sources into HANA SQL DW with Smart Data Integration	Blog
Smart Data Integration: HanaAdapter from HANA Express to HANA as a Service	Blog
Best Practices for SAP HANA Data Loads – older blog bust still relevant	Blog
Test data generator for SAP HANA for large initial and delta data sets	Blog
Real Time Social Media Analysis in SAP Analytics Cloud	Blog
Replicating Data from Oracle to HANA using SAP HANA Web IDE SDI	Blog

Deployment, Run & Operate

Leverage the Data Warehousing Monitor to execute an monitor the Task Chain	Video Recording
HANA SPS03 – HANA Web IDE Full-Stack (SCP) for SAP HANA to support Git merge and conflict resolution	Blog
Continuous Integration (CI) Best Practices with SAP HANA XSA	Tutorial
Automated Deployment & Testing with SAP HANA SQL Data Warehousing	Blog
First Guidance document for Git branching and automation integration	First Guidance Document
SAP HANA Native Storage Extension: A Cost-Effective & Simplified Architecture for Enhanced Scalabili...	Blog
Generate CDS artifact definitions from SQL statements	Blog
How to set up a Continuous Delivery workflow from SAP’s Project "Piper" on an Amazon AWS EC2	Tutorial
Continuous Integration (CI) Best Practices with SAP	Tutorial

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