This guide explains how to use SAP HANA data warehousing foundation with all its components on XS Advanced.
SAP HANA data warehousing foundation is a series of packaged tools for large-scale SAP HANA installations that support data management and distribution within a SAP HANA landscape.
Capabilities:
achieve smart data distribution across complex landscapes
optimize the memory footprint of data in SAP HANA
streamline administration and development by setting up tasks and task chains
leverage the functionality of the Native DataStore Objects (NDSO)
| Component | Description |
|---|---|
| Native DataStore Object (NDSO) |
A semantically rich persistency object within SAP HANA that can be used to manage full and delta data loads. |
| Data Warehouse Scheduler (DWS) |
Allows task chains to be scheduled in SAP HANA developments to define dependency graphs for SAP HANA artifacts. |
| Data Lifecycle Manager (DLM) |
Model aging rules on tables to displace "aged" data to SAP HANA extended tables or remote data stores to optimize the memory footprint of data in SAP HANA. |
| Data Warehouse Monitor (DWM) | Provides a comprehensive overview about scheduled, completed, and failed task chains within a selected HDI container, data lifecycle manager profiles, as well as an overview over all Native DataStore Objects. |
To use the components, you should first create a project and preferably use the available project template that has been configured to contain all the necessary modules to get you up and running as fast as possible. See the section on Data Warehousing Foundation Project in SAP HANA Data Warehousing Foundation Administration and Developer Guide for XSA for detailed information.
The following infographic shows specific tasks that can be accomplished by the component in SAP HANA data warehousing foundation. Hover over each tile to see a short description and click the tile to open a page with further details.
The following infographic shows specific tasks that can be accomplished by the component in SAP HANA data warehousing foundation. Hover over each tile to see a short description and click the tile to open a page with further details.
The following infographic shows specific tasks that can be accomplished by the component in SAP HANA data warehousing foundation. Hover over each tile to see a short description and click the tile to open a page with further details.
There are mainly two steps to consider when working with SAP HANA data warehouse foundation. The first step is designing objects, whether they are task, task chains, data lifecycle profiles or NDSOs. This means working in the design-time environment where all configuration takes place. After setting up the foundation for your objects, you can deploy or generate your artifacts. They are then executed in the runtime environment and you can monitor your artifacts in the data warehouse monitoring tool. Here you can check your statuses, delete and create scheduling profiles or download logs. It's not possible directly to change or adjust artifacts. For this, you should switch back to the design-time environment.