SAP HANA SQL Data Warehouse – Data Warehousing Foundation

Axel Meier

Posted by Axel Meier on October 30, 2017

Senior Director Big Data Warehousing GTM

More by this author

The SAP HANA Data Warehousing Foundation option is a series of packaged data management tools to support (large scale) HANA SQL Data Warehouse use cases. With SAP HANA Data Warehousing Foundation, you can achieve smart data distribution across complex landscapes, optimize the memory footprint of data in SAP HANA and streamline administration and development. 

In this post, we will introduce the tools and solutions that are available as a part of the SAP HANA Data Warehousing Foundation (DWF) and provide training resources. The tools we’ll be covering include:

  • Data Distribution Optimizer (DDO)
  • Data Lifecycle Manager (DLM)
  • Data Lifecycle Manager (DLM)
  • Native Datastore Object (NDSO)
  • Data Warehousing Scheduler (DWS)
  • Data Warehousing Monitor (DWM)

Data Distribution Optimizer (DDO)  – XS-Classic

The Data Distribution Optimizer (DDO) provides the capability to plan (simulate), adjust and analyze landscape reorganizations for SAP HANA scale out systems (BW4/HANA, BWonHANA, HANA SQL DW, Data Mart, S/4HANA)

 

SAP HANA Academy DWF Channel: 

 


Data Lifecycle Manager (DLM) – XS-Classic

The Data Lifecycle Manager (DLM) provides the capability to archive / displace data from a SAP HANA persistency to Multi-Store Table, HANA Extension Node, Dynamic Tiering, SAP IQ, Hadoop or SAP Vora** (**restricted shipment with DWF 2.0 SP02 – XSA)

 

SAP HANA Academy DWF Channel:


Data Lifecycle Manager (DLM) – XS-Advanced

The Data Lifecycle Manager (DLM) for XSA provides the capability to archive / displace data from a SAP HANA persistency to Hadoop or SAP Vora** (**restricted shipment with DWF 2.0 SP02 – XSA)


Native Datastore Object (NDSO) – XS-Advanced

The Data Warehousing Foundation (DWF) native DataStore Object (NDSO) has been established as the central persistency object to model HANA SQL Data Warehouse systems

The NDSO is integrated with

  • SAP Web IDE for SAP HANA (XSA) for Modeling, Implementation & Administration, Enterprise Architecture Designer (EAD) for Modeling
  • HANA SDI Flowgraph for NDSO Data Load
  • Data Warehousing Foundation (DWF) Task Chain and Data Warehouse Monitor (DWS) to execute and monitor the NDSO Data Load and Data Activation tasks

The NDSO allows merging of delta data and full data loads into its reportable content and also provides delta-data processing capabilities to connected data targets

The NDSO data merge process is triggered by the Data Activation task

The NDSO is capable to process records based on the Source-data specified RECORDMODE values (like: INSERT / UPDATE / DELETE – aka. CDC)

Simplyfied Flowgraph design

  • No need to design specific INSERT / UPDATE / DELETE handling within the flowgraph, as the NDSO manages the individual data processing based on the RECORDMODE values

The NDSO is capable to rollback/delete previous loaded and activated data-sets


Data Warehousing Scheduler (DWS) – XS-Advanced

The Data Warehouse Scheduler (DWS) is capable to maintain dependencies between single tasks with the focus to provision data warehouse models supported task types (HANA SDI Flowgraph+ NDSO Data Activation) and Data Tiering supported tasks (HANA Procedures).


Data Warehousing Monitor (DWM) – XS-Advanced

The Data Warehouse Monitor provides the capability to schedule and monitor the execution of Task Chains in the data warehouse


HANA SQL Data Warehouse – XS-Advanced

Additional resources on SAP HANA SQL Data Warehousing:

DWF SAP SDN Page:

http://scn.sap.com/docs/DOC-62482

DWF SAP Help Page:

http://help.sap.com/hana_options_dwf

Explore next-generation Data Warehousing solutions from SAP.

VN:F [1.9.22_1171]
Average User Rating
Rating: 5.0/5 (15 votes cast)
SAP HANA SQL Data Warehouse - Data Warehousing Foundation, 5.0 out of 5 based on 15 ratings

9638 Views