What is Sap HANA?
SAP HANA is the latest ERP Solution from SAP, which is a combination of Hardware and Software. HANA has unprecedented adoption by the SAP customers.

SAP HANA is latest, in-memory database, and platform which can be deployed on-premises or cloud. SAP HANA is a combination of hardware and software, which integrates different components like SAP HANA Database, SAP SLT (System Landscape Transformation) Replication server, SAP HANA Direct Extractor connection and Sybase replication technology

SAP HANA Database & Platform
SAP HANA Database – SAP HANA Database is a hybrid in–memory database. SAP HANA Database is the heart of SAP in-memory technology. In SAP HANA, Database table are of two types –
Row Store
Column Store
SAP HANA Platform – SAP HANA Platform is a development platform with an in-memory data store which allows the customers to analyze a large volume of data in real time. SAP HANA Platform works as a development platform, which provides infrastructure and tools for building a high-performance application based on SAP HANA Extended Application Services (SAP HANA XS).
SAP HANA Edition
There are different types of SAP HANA edition, some of them as below-

SAP HANA Platform Edition – It provides Core database technology. It Integrate SAP component like SAP HANA database, SAP HANA Studio and SAP HANA clients. It is for customers who want to use ETL-based replication and already have a license for SAP Business Objects Data Services.
SAP HANA Enterprise Edition – It contains data provisioning (SLT, BODS, DXC) component including core database technology. It is for customers who want to use either trigger-based replication or ETL-based replication and do not have all of the necessary license for SAP Business Objects Data Services.
SAP HANA Extended Edition – It contains data provisioning (Sybase) features more than Platform and Enterprises edition. It is for customers who want to use the full potential of all available replication scenarios including log-based replication.
The following diagram shows difference between all editions –
Why to choose SAP HANA?
SAP HANA is a next-generation in-memory business platform. It accelerates analytics and application on a single and in-memory platform.

Mentioned below are the few reasons why to choose SAP HANA –

Real Time – SAP HANA Provides Real-Time Data Provisioning and Realtime Reporting.
Speed – SAP HANA provide high speeds processing on massive data due to In-Memory Technology.
Any Data/Source- SAP HANA can access various data source including Structured and Un-Structured data from SAP or Non-SAP data source.
Cloud- SAP HANA database and application can be deployed to the Cloud environment.
Simplicity – SAP HANA reduce efforts behind ETL process, Data Aggregation, Indexing, and Mapping.
Cost – SAP claims that SAP HANA Software can reduce Total IT cost of a company.
Choice Option – SAP HANA is supported by different hardware vendor and Software provider, so based on the requirement, the user can choose the best option.
SAP HANA In-Memory Strategy
SAP HANA has many processes running on the SUSE Linux Server. SUSE Linux server manages the reservation of memory to all process.

When SAP HANA starts up, Linux OS reserves memory for the program code, program stack, and static data. OS can dynamically reserve additional data memory upon request from the SAP HANA Server.

SAP HANA create a memory pool for managing and tracking the consumption of memory. The memory pool is used to store all the in-memory data and system tables, thread stack, temporary computations and all other data structure required for managing the database.

HANA Admin


Unit 1 HANA Introduction

Hana Architecture

Hana In-Memory Concept

Use main memory as data store

Data Persistence

Minimizing Data Movement


Columnar Storage

Delta-merge and bulk inserts

Pushing Application Logic to the DB

Parallelization on Multlicore systems

Data Partitioning and ScaleOut

Benefits of In-Memory Computing

Hana vs Traditional Databases and Hana Vs BWA

HANA Revisions

Unit: SAP HANA as a Database and as an Applicance


Unit: SAP HANA Sizing

Sizing Criteria

Memory Sizing

Disk string

CPU Sizing

Unit: SAP Hana Software Components

SAP HANA Database

Hana Client

Hana Studio

Hana Studio Repository

Hana Landscape Management structure

Host Agent

Hana Lifecycle Manager

Hana Lifecycle Manager Tools


Sizing & Scale Out

SAP Hana Life Cycle Management Tools


Distributed System Installation

Post Installation Steps

Updating SAP Hana

 HANA Installation Preparation

H/W and S/W requirements

Preparing File system and Directories

Installation Config file

Installation Parameters

 HANA installation Tools

Hana Unified Installer Tool

Installation Phases

Install Hana Client

Linux & Windows Options

Client install Checks

HANA Studio Installation

Studio Usage & Features

Linux & Windows Options

Post Install Steps

Applying Support Packages and Updates

Post Configuration Steps with Hana Studio & Command Line Options

Unit: Migration to SAP HANA

Overview of Migration Options for SAP systems to HanaDB

New Installation

Classical Migration (Upgrade & then Migraton)

One Step Migration using DMO Option (SUM)

DMO Option in Detail

DMO preparation: MOpz, SAP Host Agent, new UI

DMO procedure: start, configuration, monitoring

Unit: Hana Memory Management & Data Persistence

Optional Transaction Management & Concurrency Control

Software Packaging

Unit: Deployment Options

Administrative Tools for SAP HANA

HANA Studio

DBA Cockpit

HDBSQL Command Line Tool


Start/Stop HANA

Hana Table Administration

Periodic Tasks

Unit: Data Replication Methods for SAP Hana

Data Replication Methods for SAP Hana

Introduction to SLT

Benefits of SLT

Types of Replications – Trigger/ETL/Extractor(DEC)/Log(Sybase)

SLT Architecture

Configuration Options

S/W Components & Dependencies – DMIS Support Packs

Setup of LT Replication Server

DMIS SP Installation

Kernel & DBSL Installation

RFC& DB Connections

configuration of a Scenario

Parallelization Settings

SLT Monitoring and Performance Optimization

SLT Maintenance – Activation and Reactiction

LTRS and new Web UI

Unit: Hana Software Life Cycle Management (ALM/CTS+)

ALM Transports Setup

Exporting and Importing

ALM Data Units – Delivery Unit, Product ..

Export and Import of ALM ObjectsTypes of Backups


Backup Strategy

Data Area Backup

Recovery Options

Log Area Backup

Recovery in Replication Scenarios

Recovery Scenarios

Recovery Strateges

Additional Topics

Unit: Database Copy



Monitoring Hana Landscape

MONITORING Hana Processes/Threads/Sessions

Hana Studio & Command Line Monitoring

Solution Manager Monitoring (MAI)

Performance Analysis

Trace Configuration

EarlyWatch Alert

Unit: Hana Database Configuration

Configuration of parameters & maintenanceUnit: Remote Support

Unit: HANA Security

User Creation

User and Role Concepts

Previleges and Assignment

SQL Previleges

System Previlges

Analytic Previleges

Authorizations for Various views


Unit: HIGH Availability & Disaster Tolerance

Continuous Availability

Scale Out



Unit: SAP Hana Use-Cases

Hana as a Technology Platform

Hana for Operational Reporting

Hana as a Accelerator

SAP Products on Hana

Next Gen Applications on Hana

© 2016 Copyright. All rights reserved.

Click Me