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

Declan,

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.

Mark