Modeling NDSO with NDSO Editor (recommended)

Model your NDSO with the NDSO editor.

NDSO Editor

When creating an NDSO, the NDSO editor opens up displaying different parameters that can be filled in or selected. Hover over each field on the image below for more information.

NoteThe following image contains links to more information.
Give your element a name. Select the type: primitive, native or reference type. Choose a data type, for example string or int. Choose from three types: primitive, native or reference. A default length parameter is entered automatically, but can be changed manually. A default scale parameter is selected automatically, but can be changed manually. Select whether your element is a key. Default parameters are entered automatically and can be changed. See the section "Native Data Store Default Values" for more information. Set the aggregration behavior: none, min, max or sum. Choose the action for your inbound queues: move, ignore or aggregrate. Further inbound queues will be seen here when a new one is added. Click on the inbound queue to change the name or to delete your inbound queue. Import an existing NDSO. This will overwrite the current entries. Find and append further external structures to the elements, for exmple, tables or views. Choose from three types: primitive, native or add a new inbound queue. It will be added on the right side of the table. Add a new element. Add a sub element. Set flags to allow a change log to be written or to support snapshot. Set the partition specifiction assignment. Set your partition specification definition.
NDSO Editor

When creating an NDSO, the NDSO editor opens up displaying different parameters that can be filled in or selected.

Field Names
Field Name Description
Import NDSO

You can import an existing NDSO (for example an NDSO that was created with the CDS editor). Note that when doing so, the current values will be overwritten as the parameters for the imported NDSO will replace them.
Import Elements

You can search for elements such as tables, table functions or views by entering the object's name and then import these elements.
Partition Specification Definition

Define partition specifications for your NDSO. The partitioning is selected by default, but you can also add further definitions and select different parameters or select further levels. You can choose between hash and range partitioning.

Partition Specification Assignment

Assign partition specifications to your active data, change log, and inbound queues.

For more information on the data types, see SAP HANA to CDS Data-Type Mapping. Note that geospatial data types are not supported.

Options
Option Description
Support Snapshot

Once the snapshot setting has been flagged, only modified records are processed into the NDSO. If the NDSO is a staging layer type where only full loads are processed into, only the delta records are processed into the inbound queue table. Request rollback and deletion are still supported.
Write Change Log

Select this option if the change log (delta) information should be captured or are required for further delta data set processing.
Partition Specification Definition

Hover over each field in the image below for more information.

NoteThe following image contains links to more information.
Add or delete existing partition specifications. Give your partition specification a name if needed. Select a partition type. Add or delete elements.
Partition Specification Definition
After Configuration

After configuring your NDSO, click Save. Your NDSO is now ready for the build process. For more information on building the NDSO, see Building Native DataStore Object.

For more information on partitioning, see the SAP HANA Administration Guide for SAP HANA Platform and search for "Table Partitioning".

Related Information