SAP HANA Data Warehousing Foundation Developer Guide for XS Advanced

This guide explains how to use SAP HANA data warehousing foundation with all its components on XS Advanced.

Introduction

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)

To accomplish all of these tasks SAP HANA data warehousing foundation offers different components on XS Advanced:
DWF Components
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.

Working with the Native DataStore Object

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.

NoteThe following image contains links to more information.
To use the components, you first need to create a project. We recommend to use the available DWF project template. See SAP HANA Data Warehousing Foundation Project for more information. Create a new Native DataStore Object After creating an NDSO you can model your Native DataStore Object. Adjust and manage your Native DataStore Object in a dedicated section of the tool. You can activate all requests of a given data store. You can either load your NDSO as an initial action or load the delta information. See the Scheduler Guide for more information on how to create a task. Create a task chain in the data warehousing foundation scheduler. Create a scheduling profile to execute a load or activation. Monitor your tasks and task chains in the monitoring section. Monitor all your Native DataStore Objects. Execute a task chain immediately without a scheduling profile. Create, model, and execute an NDSO. See the Native DataStore Object Guide for more details.
Working with the Data Lifecycle Manager

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.

NoteThe following image contains links to more information.
See the Data Lifecycle Manager Guide for detailed information. To use the components, you first need to create a project. We recommend to use the available DWF project template. See SAP HANA Data Warehousing Foundation Project for more information. Configure your data stores and rule to create a profile. Create a location to fetch from or send data to. Use an Extension Node to optimize memory footprint of data in SAP HANA. Relocate data to a specified remote data store. You can either relocate with a single table or using the grouping table feature to select multiple tables. Monitor all data lifecycle profiles in your project. Generate the database artifacts. Set up your rules to determine what data goes where.
Working with the Scheduler

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.

NoteThe following image contains links to more information.
For detailed information, see the SAP HANA Data Warehousing Foundation Scheduler Guide. See the Scheduler Guide for more information on how to create a task. To use the components, you first need to create a project. We recommend to use the available DWF project template. See SAP HANA Data Warehousing Foundation Project for more information. Execute a task chain immediately without a scheduling a profile. Create a task chain in the Data Warehousing Scheduler. Create a profile to schedule the execution of procedures and tasks within in a task chain. Monitor your task chains. Monitor all your Native DataStore Objects. You can select a task to execute another task. Activate all requests of a given data store. Write the result set of a query to a specified inbound table. Retrieve a csv resource from the Web and write it to a specified inbound table in your NDSO. Execute a flowgraph without parameters Execute a procedure, for example, an SAP HANA database procedure. Delete all logs older than a selected parameter. View the status and further details of your lifecycle profiles.
Runtime and design-time

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.