Managing Native DataStore Object

The Manage-UI as part of HRTT (HANA Runtime Tools/Database Browser) is the central tool for managing loads and activations of the NDSO.

To manage the NDSO, switch to the HANA Runtime Tools (HRTT).

Then select and connect to the according HDI container, which was previously generated.

The NDSO object is visible within the DataStores section of the lower screen once you click the section:

The NDSO Manage-UI pops up once you click the NDSO object.

The primary use-case is to:

  • monitor the data load status,

  • react on error-situations (e.g. resolving the error situation or removing a certain dataload) and,

  • check and validate the generated table structures.

Within the Advanced tab, it’s possible to switch between:

  • Upload File, to load CSV files into the NDSO inbound table

  • Generate Data, to generate test data to be loaded into the NDSO inbound table

  • Insert as Select, to load data from an available HANA object into the NDSO inbound table (SQL INSERT statement will be generated to be adjusted to fulfill your needs).

Note

The data is generated randomly based on the respective column data types. There is no validation and, thus, no guarantee that the data can be activated. The Generate Data functionality generally serves for testing purposes only.

The Manage tab provides the NDSO request info on loaded data sets. Here, it’s also possible to activate the data sets (select the certain request), once a data set has been loaded (see also the section on Creating and Connecting a Flowgraph to Native DataStore Object in the SAP HANA Data Warehousing Foundation - Native DataStore Object Administration Guide).

Click the Inbound Table, Active Data Table or Change Log Table links to have a separate tab opened displaying the structure and content.

The dependencies between the load request and activation request are visible by clicking on the icon, which is also reflected in the corresponding requests section in the lower part of the screen.

Housekeeping

In the housekeeping tab, you can perform checks on the NDSO consistency as well as clean metadata, based on a date or request. You can also clean change logs, to delete the content of the change logs based on a date or a request.

Subscription

The subscriptions show all connected data sources (NDSOs connected to other NDSOs). They act as a delta pointer, and prevent data that cannot be extracted from being deleted.

If new data is loaded into the first NDSO (1), with a new activation ID, and this new data is processed into a second NDSO (2), it is possible to only process the delta data from NDSO 1 to NDSO 2 based on the request ID of the activation in the subscription.

If you extract via a Flowgraph with an NDSO as your source, a subscriber will automatically be created and the max request ID will be updated. The subscriber name receives the same name as the Flowgraph name.

Tables

Within the Tables section, all created tables of the NDSO on the database as well as all NDSO management tables are visible.