Skip to Content

Does SAP Sybase IQ enable NLS for non-OLAP systems ?


I know that SAP Sybase IQ NLS facilitates archiving of SAP BW InfoProviders.

Is this also enabled for non-OLAP tyep applications ? I do not see any documentation indicating that it is possible. Though conceptually, it is possible that it will be developed. Perhaps in a future release this will occur, for example in support of S4/HANA.

Many thanks,


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 28, 2020 at 03:30 PM


    NLS is a feature of BW to archive data. Side note, it was related to the Data Tiering Option in BW4/HANA.

    S4/HANA (as well as ECC and Suite on HANA) have a feature called ILM, information lifecycle management. Much like NLS, this allows customers to archive data to an IQ store.

    Both NLS and ILM are application features that drive how, when and where to move data out of the primary system. Other applications like SAP CAR (Customer Activity Reporting) have similar features.

    Move data from the primary HANA to a lower cost, lower performing system must be done via the application so that data integrity, security, etc can all be maintained.

    SAP HANA has a built-in ability to tier data to lower cost, lower performance stores. Here is a great blog on this topic. SAP HANA can tier to HANA internal disk using the Native Storage Extension (NSE) feature. SAP HANA can also tier to the external engine using the dynamic tiering feature. There is also a hybrid that keeps all data in HANA memory but allows you to over commit memory on one node. We call this architecture SAP HANA extension nodes.

    As we progress, our applications will start using the built in HANA features for their aging strategies. Today, S4 and Business Suite can leverage some of the NSE features. See SAP Note 2816823 for details. SAP BW and BW4 leverage dynamic tiering, extension nodes, and NSE (coming this year) as well. The key is that the application must support those features, they cannot just be implemented without application knowledge. Some tiering options can force a structure change that the applications need to be aware of.

    This hasn't even touched our cloud offerings in SAP HANA Cloud where tiering is built into SAP HANA Cloud using NSE as well as a data lake based on SAP IQ, similar in use to dynamic tiering.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.