NLS Data

The purpose of this document is to explain to the end-user the process of installing, using, and updating DataVard's OutBoard – a data lifecycle management application for Near Line Storage (NLS) of SAP BW data.
This document is aimed primarily at SAP system administrators and BW consultants who should primarily work with OutBoard.
What is NLS?
Nearline storage (contraction of near-online) is used to describe an intermediate type of data storage that represents a compromise between:
• online storage → supporting frequent, very rapid access to data
• offline storage / archiving → used for backups or long-term storage, with infrequent access to data

In this section:

Both archiving and Nearline allow a reduction of a database size ⇒ that results in improved speed of performance (online system). However, accessing archived data is more complex and slower than is the case with Nearline storage, and can also negatively affect the performance of the main database (In case of data reload into that database).
NLS in the Context of ILM for SAP BW
Relevant data ⇒ BW Accelerator
Irrelevant data ⇒ Offline Archive
Potentially relevant ⇒ NLS storage (compressed data management)

_{ILM in SAP BW System}

_{Data flow in BW ILM with Outboard NLS}

NLS Writer for OutBoard by Datavard

NLS Writer for OutBoard is an enhancement of standard SAP process for loading and activation in SAP BW. NLS Writer enables loading (for InfoCubes) and activation (for DataStore Object) of data within a locked period and the subsequent moving of data to OutBoard archive.
Normally, when data is loaded into SAP BW and part of this data is archived by OutBoard, the request will fail, because of the locked period. However, there are some scenarios there may be the need for old data to be loaded into the system on a frequent basis. To avoid failed load requests due to archived data in Outboard, the NLS Writer was developed.
The NLS Writer extension solves this particular issue in the following way:
1. Data Store Object:

Before data activation, NLS Writer recognizes whether records are from a locked area.
In case these records are in a locked area, the NLS writer loads records with the corresponding key from NLS to an active table
Locked data check is suppressed, and the request is activated in a standard way by SAP.
After activation, locked records from the active table are moved back to NLS archive.

2. InfoCube:

During data load (Data Transfer Process or InfoPackage), NLS Writer recognizes if loaded records are from a locked area.
In case that records are in a locked area, NLS archive is updated with this data.
Locked records are removed from the data load.
Only non-locked data is loaded into InfoCube using a standard way.

NLS Writer with ADSO support

NLS Writer with ADSO support, in addition to DSO and InfoCubes, enables Writer for following objects:

Advanced DSO - Data warehouse layer - delta calculation (ADSO like DSO)
Advanced DSO - Data warehouse layer - data mart (ADSO like Cube).

Browser not supported