SAP HANA Administration


SAP HANA Administration


HANA is used as a DATABASE to improve the performance of the reports or fasten the data access of the company's Existing Business Warehouse tool. So, for a HANA consultant, it is must to understand the reporting as well as the BW concepts. The Combination of BW, Hana & Business Objects (Reporting) will make you familiar with all the skills that you require to work independently and also the skills that any Industry look for. At the end of the course, we will be working on 2 LIVE SCENARIOS i.e. BW on HANA & ABAP on HANA to understand the system much better.

What does this course include?

SAP HANA Administration Overview

  • SAP In-Memory Computing Overview
  • SAP HANA Administration Features
  • Look and feel of SAP HANA Administration
  • SAP HANA Administration Architecture
  • SAP HANA Administration Landscape
  • Structure of SAP in-memory Computing studio
  • Row store and column store Architecture
  • Multi Version Currency Control(MVCC)
  • Persistence Layer in In-memory Computing Engine
  • Back up &Recovery
  • High-Availability
  • Distributed System
  • Data Provisioning options in SAP HANA Administration
  • Reporting options on SAP HANA Administration
  • Security options in HANA
  • SAP HANA Administration Appliance Model
  • How SAP HANA Administration Appliance is delivered
  • Sizing Considerations
  • SAP HANA Administration - Licensing Options
  • SAP HANA Administration Project Implementation Overview: Key Activities Key Roles
  • Key Points to keep in mind
  • Administration

SAP HANA Administration Modelling

  • SAP HANA Extended Architecture
  • Business Intelligence Clients with HANA
  • SAP HANA Column Store
  • SAP HANA row store vs Column Storage SAP HANA Versions
  • List of HANA 1.0 SPS - New Features
  • List of SAP HANA EDITION Types
  • SAP HANA Sizing
  • SAP HANA In-Memory Database Sizing elements
  • RAM, Disk, CPU
  • Memory Sizing

SAP HANA Administration and Operations

  • Define Run Schedules
  • Enter run dates
  • Posting transactions
  • Execute run schedule
  • Create Batch input Session

Account Payable

  • What is SAP HANA, Components, Scenarios
  • Rapid Deployment Solutions RDS
  • SAP HANA Information Sources

SAP HANA Architecture

  • SAP HANA Persistence
  • Sizing SAP HANA
  • SAP HANA Scale Out

SAP HANA Tool Overview

  • SAP HANA Studio
  • DBA Cockpit
  • HDBSQL Command Line Tool

SAP HANA Pre & Post Installation

  • Preparing SAP HANA Installation
  • Review SAP HANA Installation
  • Post-Installation Steps

SAP HANA Operation

  • Starting and Stopping SAP HANA
  • Configuring SAP HANA
  • Periodic Manual Tasks

Backup and Recovery

  • Concept of Backup and Recovery
  • Data Area Backup
  • Log Area Backup
  • Backup of Configuration Files and Backup Catalog
  • Recovery
  • Database Copy
  • High Availability

Maintaining Users and Authorizations

  • User Management
  • Types of Privileges
  • Standard Roles
  • Administrative Tasks
  • Authentication Methods
  • Information Sources for Administrators and Auditing

Data Provisioning Using SLT

  • Positioning and Key Concepts
  • Landscape Strategy and Sizing Aspects
  • Installation Procedure
  • Configuration Aspects
  • Data Replication at a Glance
  • Monitoring of Replication
  • Other Operations Aspects

Monitoring and Troubleshooting

  • Monitoring with SAP HANA Studio
  • Monitoring with DBACOCKPIT
  • Monitoring with SAP Solution Manager
  • Remote Support
  • SAP Early Watch Alert

Software Lifecycle Management

  • Transporting Changes
  • Updating SAP HANA