Skip to Content

The SAP HANA Data Warehousing Foundation product provides specific data management tools to support (large scale) HANA SQL Data Warehouse use cases.




The SAP HANA Data Warehousing Foundation (DWF) product provides the following tools & solutions:

Data Distribution Optimizer (DOO)  – 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




DWF SAP Help Page:

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Igor dos Santos da Silva

    Hi Axel,

    Great post!!

    I’ve been wondering for a while if we should use this approach instead the BW/4HAHNA approach… I know that SDA will not be enough to stream all data that I need to build my views with good performance, so I need to persist data eventually.

    I can do that with SDI and turn my HANA into a DW repository , but it doesn’t seems a good practice in terms of data governance and it can be a little messy without the proper control over the tables created… Can HANA DW foundation somehow fulfill this gap, and put some sort of governance on the landscape?

    Am I’m going to the right direction, or BW/4HANA  really should be the direction that I should be heading on?!


    Thank you!!

  2. Former Member

    Hi Axel,
    Very nice document indeed and i should say it as a central page where i get everything i want with relates to DWF. I have a technical question, I tried to build the sample DWF project without Enforce user Authentication option . all fine i can see the data in all three tables of NDSO, also can execute Flowgraphs manually. but when i got to DWM(Monitor) to schedule taskchains it says forbiden. any idea why?

    Also it would be great if SAP provides something in detail how to use Enforce user Authentication option . I have gone through

    SAP First Guidance – SAP HANA Data Warehousing Foundation 2.0 SP 02 – How to use DWF functionality in SAP Web IDE




  3. Martin Sautter


    can you put an ADSO (new, changelog, active table) or its partitions at all to an NLS ( Sybase IQ etc)

    Ho to partition an ADSO right ?


    Best Martin?



Leave a Reply