Book Image

SAP HANA Cookbook

Book Image

SAP HANA Cookbook

Overview of this book

SAP HANA is a real-time applications platform that provides a multi-purpose, in-memory appliance. Decision makers in the organization can gain instant insight into business operations. Thus all the data available can be analysed and you can react to the changing business conditions rapidly to make decisions. The real-time platform not only empowers business users and top management to make decisions but also provides the capability to make decisions in real-time.A practical and comprehensive guide that helps you understand the power of SAP HANA’s real-time and in-memory capabilities. It also provides step-by-step instructions to exploit all the possible features of the SAP HANA database, enabling users to harness the full potential of this technology and its features.You will gain an understanding of real-time replications, effective data loading from various sources, how to load data, and how to create re-usable objects such as models and reports.Use this practical guide to enable or transform your business landscape by implementing SAP HANA to meet your business requirements. The book shows you how to load data from different types of systems, create models in SAP HANA, and consume data for decision-making. The book covers various tools at different stages creating models using SAP HANA Studio, and consuming data using reporting tools such as SAP BusinessObjects, SAP Lumira, and so on . This book also explains the in-depth architecture of SAP HANA to help you understand SAP HANA as an appliance, that is, a combination of hardware and software.The book covers the best practices to leverage SAP HANA’s in-memory technology to transform data into insightful information. It also covers technology landscaping, solution architecture, connectivity, data loading, and setting up the environment for modeling purpose (including setup of SAP HANA Studio).If you have an intention to start your career as SAP HANA Modeler, this book is the perfect start.  
Table of Contents (16 chapters)
SAP HANA Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Comparing BWA and SAP HANA


In this section, we will be covering the evolution of SAP HANA and its innovation process. SAP was one of the early pioneers in using in-memory technology as it has been highly consistent in improving the performance for gaining high data compression and achieving real-time analytics.

Evolution of SAP BWA and SAP HANA

TREX and SAP Enterprise Search were some of the first products to innovate and use the concepts of in-memory and column-based storage. Based on the strength of these products, SAP developed SAP NetWeaver BW Accelerator, which is an in-memory product mainly for performance optimization.

With SAP NetWeaver BW Accelerator established in the customer's IT enterprise landscape and market, SAP has consistently expanded its vision to continuously innovate to utilize this in-memory technology to benefit its customers. The vision was to respond to the business requirements for enterprises in combining OLTP and OLAP by removing the requirements of pre-aggregated, precalculated queries/indexes and other related features resulting in data latency and days or weeks in getting the business reports.

SAP's focus on business intelligence has led to the decision to combine the business intelligence functions from SAP BusinessObjects (after SAP's acquisition of Business Objects at the end of the year 2007) with the in-memory analytical engine of SAP NetWeaver BW Accelerator, creating an accelerated business intelligence solution called SAP BusinessObjects Explorer. With a focus on technology-agnostic solutions and heterogeneity, SAP then improvised SAP BusinessObjects Explorer by including data integration capabilities in SAP NetWeaver BW.

The innovative in-memory computing engine of SAP HANA is the next generation analytics technology. It complements today's SAP NetWeaver BW Accelerator with enhancements and additional functions, including the replication and acceleration of transactional data for real-time analytics. Customers can use SAP HANA as not only the technology, but also the platform for delivering accelerated analytical solutions. SAP HANA, currently strategic in-memory real-time analytics, is a solution offered by SAP.

How it works…

Now let us compare BWA and SAP HANA.

Comparison

BWA was specifically designed to accelerate BW queries by reducing the data acquisition time by storing copies of the InfoCube data in-memory. The purpose of SAP BWA is to improve the query performance of SAP NetWeaver BW. The SAP BW 7.0 release and later versions supports SAP BWA. In simple terms, SAP BWA is optimized for SAP BW primarily for performance improvisation.

SAP HANA is an in-memory appliance and platform for delivering high-performance analytics and applications and also real-time analytical solutions. SAP HANA is a full-featured in-memory database, and the data can be loaded into SAP HANA from SAP and non-SAP data sources and be consumed using SAP BusinessObjects frontend tools. SAP HANA also acts as an in-memory database that powers SAP NetWeaver BW 7.3 and later versions; SAP HANA can be used as accelerators also in implementing Sidecar scenarios and SOH—Business Suite on SAP HANA (CRM on HANA, SRM on HANA, and ERP on HANA). In this way, it is optimized and designed to dramatically improve the overall performance of SAP BW.

See also