What is SAP near line storage?

Near-line Storage (NLS) is used to archive BW data which can still be available for reporting using BEx queries. The Near line data is stored in a compressed form and the storage is inexpensive compared to BW database.

What are the advantages of the SAP BW near line storage on SAP IQ?

The Integration of SAP IQ makes it possible for you to separate data that you access frequently from data that you access rarely, thus making less demand on the resources in the BW system. The near-line data is stored in compressed form. You can thus reduce the costs incurred by data that is accessed less frequently.

How do I archive data in BW?

In your SAP BW system, call the Data Warehousing Workbench (transaction RSA1). Choose the required InfoProvider and choose Create Data Archiving Process from the context menu. The screen Change Data Archiving Process appears.

What is dynamic tiering in SAP HANA?

SAP HANA dynamic tiering is a native big data solution for SAP HANA. Dynamic tiering adds smart, disk-based extended storage to your SAP HANA database. Your application automatically determines which tier to save data to: the SAP HANA in-memory store (the hot store), or extended storage (the warm store).

How do I create an archive request in SAP BW?

Procedure

  1. In your SAP BW system, call the Data Warehousing Workbench (transaction RSA1).
  2. Select the relevant InfoProvider and choose Manage from the context menu.
  3. Choose the tab page Archiving.
  4. To create a new archiving request, choose the Archiving Request pushbutton.

What is ADK in SAP?

Using the data archiving transaction of the Archive Development Kit (ADK), you can use SAP ArchiveLink to store archive files in external storage systems.

Which is near-line storage solution does sap use?

As of BW 7.4 SP 8 and HANA SP7 ‘HANA Smart Data Access (SDA)’ can be used for query access to data in Sybase IQ as a near-line storage solution. It optimizes execution of queries by moving processing as far as possible to the database connected via SAP HANA Smart Data Access.

How is near-line storage ( NLS ) used in bi?

Near-line Storage (NLS) is used to archive BW data which can still be available for reporting using BEx queries. If you are behind BI Optimization, it is a great way to save BW database space by moving less frequently used data to NLS. The Near line data is stored in a compressed form and the storage is inexpensive compared to BW database.

Why is near line storage disabled in BW 7.3?

As of BW 7.3, in the Default setting, access to data in near-line storage is disabled, even if a data archiving process (DAP) with near-line storage exists for an Info Provider. It has to be switched on and controlled to retrieve required data and avoid unnecessary issues caused by NLS.

How to check near line connection in SAP?

You can check connection in following ways: i. Go to Info provider -> Right click -> Data archiving process -> Display -> General settings -> Near line connection ii. Go to Info provider-> Manage -> Archiving tab -> Near Line connection iii. Go to -> SE38 -> ADBC_TEST_CONNECTION ->execute -> Give DB connection name ->Execute