Cold Data Tiering Options - SAP HANA on AWS

Cold Data Tiering Options

The following sections discuss cold data tiering options on AWS.

The Data Lifecycle Manager (DLM) tool, which is part of SAP HANA Data Warehousing Foundation, can be used to move data from SAP HANA memory to a cold storage location. For your native SAP HANA use case, you have two options.

DLM with SAP Data Hub

SAP Data Hub is a data orchestration and management solution running on Kubernetes. With this option, you can use the SAP Data Hub product to move data in and out of SAP HANA into your cold store location. On AWS, you are able to use native AWS services such as Amazon Simple Storage Service to store your cold data. Once your data is in Amazon S3, you can use Amazon S3 features such as S3 Intelligent-Tiering and Amazon S3 Lifecycle to optimize your costs. Once you have determined that you no longer need to access your cold data from SAP HANA, you can archive your data in Amazon S3 Glacier for long-term retention.

Note

SAP Data Hub is now released as managed service on SAP Cloud Platform with the name SAP Data Intelligence.

SAP Data Hub on Amazon EKS for cold tier

Figure 4: SAP Data Hub on Amazon EKS for cold tier

DLM with SAP HANA Spark Controller

SAP HANA Spark controller enables SAP HANA to access the data in Hadoop through an SQL interface. With this option, you can use the SAP HANA Spark Controller to allow SAP HANA to access cold data through the Spark SQL SDA adapter. On AWS, you can use an AWS native service like Amazon EMR for the Hadoop cold tier storage location. To use Amazon EMR with SAP HANA, see DLM on Amazon Elastic Map Reduce documentation from SAP. For more information about the Spark controller, see Using SAP HANA Spark Controller .

SAP HANA with Amazon EMR for cold tier

Figure 5: SAP HANA with Amazon EMR for cold tier

Cold Tier Options for SAP BW

For the SAP Business Warehouse (BW) on HANA or SAP BW/4 HANA use cases, you have additional options for cold tier storage.

SAP BW Near Line Storage (NLS) with SAP IQ

With this option, you can use SAP BW Near Line Storage (NLS) with SAP IQ or you can use Data Tiering Optimization (DTO) with SAP IQ to store your cold data. On AWS, you can run your SAP IQ server on Amazon Elastic Compute Cloud (Amazon EC2) instances for the cold tier storage.

SAP BW NLS with SAP IQ for cold tier

Figure 6: SAP BW NLS with SAP IQ for cold tier

SAP BW NLS with Hadoop

With this option, you can use SAP BW NLS with Apache Hadoop instead of SAP IQ, with this option you can persist your Hadoop data in Amazon S3 using a Hadoop third-party connector for Amazon S3. See Hadoop as a Near-Line Storage Solution documentation from SAP, SAP Note 2363218 – Hadoop NLS: Information, Recommendations and Limitations, and Cloud Data Access documentation for details.

SAP BW NLS with Hadoop for cold tier

Figure 7: SAP BW NLS with Hadoop for cold tier

SAP BW/4HANA DTO with Data Hub

This option is similar to SAP Data Hub with SAP HANA. You can use DTO with SAP Data Hub to store your cold data in Amazon S3. This option only applies if you use SAP BW/4HANA.

SAP Data Hub on Amazon EKS with BW4/HANA

Figure 8: SAP Data Hub on Amazon EKS with BW4/HANA

Cold Tier Options for SAP S/4HANA or Suite on HANA

For S/4HANA or SOH, you can use SAP Information Life Cycle Management (ILM) for the cold data tiering. You have few options with ILM for cold tier. See ILM Store documentation from SAP for details.

SAP ILM with SAP IQ

With this option, you can use ILM with SAP IQ. Similar to the SAP BW NLS with SAP IQ scenario, you can run your SAP IQ server on AWS Amazon EC2 instances to store cold data.

SAP ILM with SAP IQ for cold tier

Figure 9: SAP ILM with SAP IQ for cold tier

SAP Archiving

With this option, you can use ILM or your standard data archiving process. You can use Amazon Elastic File System (Amazon EFS) and Amazon FSx for NetApp ONTAP to store your archive file in a highly available, scalable and durable manner. Amazon EFS and FSx for ONTAP can be mounted as your archive file system and you can archive your data from SAP to this file system through SAP transaction code SARA.

SAP archiving with Amazon EFS for cold tier

Figure 10: SAP archiving with Amazon EFS for cold tier

For archiving, another option is to use the Amazon Elastic Block Store (Amazon EBS) sc1 volume type as the underlying storage type for your archive file system. Amazon EBS sc1 volumes are inexpensive block storage and are designed for less frequently accessed workloads like data archiving. To increase durability and availability of your archived data, we recommend that you copy the data to Amazon S3 for backup and Amazon S3 Glacier for long term retention.

SAP archiving with Amazon EBS for cold tier

Figure 11: SAP archiving with Amazon EBS for cold tier