Dear friends of SAP BW/4HANA,
I'm working for SAP since more than 10 years and as a member of the BW product management team I received a lot of questions from customers regarding new functionalities for data lifecycle mangement and data aging strategies in SAP BW/4HANA.
Therefore, I would like to share a summary of the currently available information.
With SAP BW/4HANA 1.0 SP04 SAP is providing functionality to classify persistent BW data into hot, warm and cold.
In this blog, I'll explain the advantages of the SAP BW/4HANA exclusively available new feature for Data Tiering Optimization (DTO) in technical details.
Data Tiering Optimization helps SAP BW/4HANA customers to classify the data in the DataStore object (advanced) as hot, warm or cold, depending on the cost and performance requirements for the data.
Depending on this classification and how the data is used, the data is stored in different storage areas. Data Tiering Optimization provides a central UI, where all storage options can be set. The partitions from the SAP HANA database are used for this.
The following options are available:
SAP Data Tiering Optimization is an option to optimize the memory footprint of data in SAP BW/4HANA and streamline administration and development, thereby reducing TCO.
Introducing one data tiering concept for hot, warm and cold data based on Advanced DataStore Objects enables users to create full flexible partitions based on the data temperature in SAP BW/4HANA. Find the full presentation here:
Data Tiering Optimization with SAP BW/4HANA - Updated Version
Furthermore find a technical overview presentation of the SAP HANA Extension Nodes here:
SAP HANA Extension Node - Technical Overview presentation
Cold Store with SAP IQ (fka Nearline Store)
Warm Store with SAP HANA Extension Node
General Information
Cold Store with SAP IQ (fka Nearline Store)
Warm Store with SAP HANA Extension Node
I'm working for SAP since more than 10 years and as a member of the BW product management team I received a lot of questions from customers regarding new functionalities for data lifecycle mangement and data aging strategies in SAP BW/4HANA.
Therefore, I would like to share a summary of the currently available information.
With SAP BW/4HANA 1.0 SP04 SAP is providing functionality to classify persistent BW data into hot, warm and cold.
In this blog, I'll explain the advantages of the SAP BW/4HANA exclusively available new feature for Data Tiering Optimization (DTO) in technical details.
Overview:
Data Tiering Optimization helps SAP BW/4HANA customers to classify the data in the DataStore object (advanced) as hot, warm or cold, depending on the cost and performance requirements for the data.
Depending on this classification and how the data is used, the data is stored in different storage areas. Data Tiering Optimization provides a central UI, where all storage options can be set. The partitions from the SAP HANA database are used for this.
The following options are available:
- Standard Tier (hot): The data is stored in SAP HANA.
- Extension Tier (warm): The data is stored in a SAP HANA extension node. Only SAP HANA Extension Nodes can be used for warm data storage in SAP BW/4HANA - SAP HANA Dynamic Tiering is not applicable to SAP BW/4HANA.
- External Tier (cold): The data is stored externally (SAP IQ or Hadoop (Hadoop is only available with SAP BW/4HANA 1.0 FP08 or higher)).
Overview presentation:
SAP Data Tiering Optimization is an option to optimize the memory footprint of data in SAP BW/4HANA and streamline administration and development, thereby reducing TCO.
Introducing one data tiering concept for hot, warm and cold data based on Advanced DataStore Objects enables users to create full flexible partitions based on the data temperature in SAP BW/4HANA. Find the full presentation here:
Data Tiering Optimization with SAP BW/4HANA - Updated Version
Furthermore find a technical overview presentation of the SAP HANA Extension Nodes here:
SAP HANA Extension Node - Technical Overview presentation
Getting started
General Information
- SAP Help Portal: Data Tiering Optimization in SAP BW/4HANA
- SAP Note 2517460 - SAP BW/4HANA Data Tiering Optimization: Information, Recommendations and Limitations
Set Up and Installation
Cold Store with SAP IQ (fka Nearline Store)
- SAP First Guidance - SAP BW: Implementation SAP-NLS/SDA with SAP IQ16.0
- Please note that the respective Remote Source (HANA SDA) to IQ (ODBC) needs to be “readwrite” enabled
- SAP Note 1796393 - SAP BW near-line solution with SAP IQ
- End-to-end Document — SAP IQ as a Near-line Storage Solution for SAP BW
- Configuring SAP IQ as a Near-Line Storage Solution
- SAP IQ 16 Hardware Sizing Guide
Warm Store with SAP HANA Extension Node
- SAP Note 2343647 How-To: Configuring SAP HANA for the BW Extension Node
- SAP Note 2453736 How-To: Configuring SAP HANA for SAP BW Extension Node in SAP HANA 2.0
- SAP Note 2415279 - How-To: Configuring SAP HANA for the SAP HANA Extension Node
General Information
- SAP Note 2296290 - New Sizing Report for BW/4HANA
Implementation and Administration
Cold Store with SAP IQ (fka Nearline Store)
- SAP Note 2165650 FAQ: BW Near-Line Storage with HANA Smart Data Access
- SAP Note 2100962 FAQ: BW Near-Line Storage with HANA Smart Data Access: Query Performance
- SAP Note 1999431 SIQ: Setting up SSL for connections to IQ
- SAP Note 2133194 Can SAP IQ run in a cloud environment?
Warm Store with SAP HANA Extension Node
- FAQ: SAP BW/4HANA and SAP BW-on-HANA with SAP HANA Extension Nodes
- SAP Note 2486706 - FAQ - SAP BW/4HANA AND SAP BW-ON-HANA WITH EXTENSION NODES
- SAP Note 2643763 - FAQ – SAP HANA Extension Node for SAP HANA native applications
- SAP Help Portal: Using an Extension Node for Warm Data
- SAP Note 2334091 BW/4HANA: Table Placement and Landscape Redistribution
- SAP Note 2317200 Data lifecycle management for BW on SAP HANA and extension nodes
Bluesky
