BESTWAY TECHNOLOGIES LOGO

+91 - 9000567126, +91 - 9848686581

[email protected]

SAP HANA ADMINISTRATION


SAP HANA ADMINISTRATION Course Content 

SAP HANA Technology Overview

  •  Introduction to SAP HANA
  •  SAP In-Memory Strategy
  •  HANA compare to BWA
  •  In-Memory Computing
  •  Hardware-Innovations
  •  Software-Innovations
  •  SAP HANA simplified Architecture
  •  SAP HANA Extended Architecture
  •  Business Intelligence Clients with HANA
  •  HANA Columnar Store
  •  SAP HANA row store vs Columnar Storage

SAP HANA Versions

  •  HANA 1.0 SPS03
  •  HANA 1.0 SPS04—NEW Features
  •  HANA 1.0 SPS05—NEW Features
  •  HANA 1.0 SPS06—NEW Features
  •  HANA 1.0 SPS07—NEW Features
  •  HANA 1.0 SPS08—NEW Features
  •  HANA 1.0 SPS09—NEW Features

SAP HANA Editions

  •  SAP HANA Platform Edition
  •  SAP HANA Enterprise Edition
  •  SAP HANA Enterprise Extended Edition

SAP HANA Sizing

  •  SAP HANA In-Memory Database Sizing elements
  •  RAM, Disk, CPU
  •  Memory Sizing
  •  CPU Sizing
  •  SAP HANA Scale Out

SAP HANA Pre and Post Installations

  •  Preparing SAP HANA Installation
  •  Reviewing SAP HANA Installation
  •  Post-Installation steps

Look and Feel

  •  In-Memory Computing Studio
  •  Administration view
  •  Navigator View
  •  System Monitor
  •  Information Modeler

Architecture

  •  Architecture Overview
  •  IMCE and Surroundings
  •  Row Store
  •  Column Store
  •  Loading data into HANA
  •  Data Modeling
  •  Persistent Layer
  •  Backup & Recovery

SAP HANA Hardware and software Requirements

  •  Prepare Installation parameters
  •  Users created during Installation
  •  Required Installation media
  •  Prepare Installer Configuration file

Installing SAP HANA

  •  SAP HANA unified Installer Tool
  •  Unified Installer to install the Sap HANA SERVER
  •  Components installed by Installer
  •  Command based Installation
  •  GUI based Installation

SAP HANA Tool Overview

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

Install HANA Studio

  •  System Requirements
  •  Supported Platforms
  •  Install SAP HANA Studio

Post-Installation Steps

  •  Starting and Stopping SAP HANA System
  •  Displaying Process List
  •  Logging on to HANA system using HANA studio
  •  User Security
  •  Monitoring HANA Landscape

SAP HANA Operation

  •  Starting & Stopping SAP HANA
  •  Starting SAP HANA Database
  •  Stopping SAP HANA Database
  •  Displaying Process List
  •  Monitoring HANA Landscape
  •  Periodic Manual Tasks

Data Provisioning Using SLT

  •  Positioning and benefit of SLT for SAP HANA
  •  Key benefits of Trigger-Based Approach
  •  Architecture and building Blocks
  •  Architecture for SAP Source Replication
  •  Architecture for NON-SAP Source Replication
  •  Set-up of LT replication server
  •  Installation Aspects
  •  Configuration Steps for SLT replication server
  •  Setup Data Replication
  •  Database-Supportability
  •  Landscape strategy of SLT replication server
  •  SLT replication server Installation Options
  •  Technical Requirements and system setup Information
  •  Configuring HANA Studio for importing Metadata
  •  Importing Metadata
  •  Mass Import
  •  Selective Import
  •  Load Data Via Data services into SAP HANA

SAP HANA Direct Extractor Configuration

  •  Introduction to SAP HANA Direct Extractor
  • Connection (DXC)
  •  Limitations of DXC
  •  Setup and Configurations
  •  Enabling Services
  •  HTTP Connection
  •  Test Connection

Maintaining Users & Authorizations (SAPHANA Security)

  •  Create Users
  •  User and Role Concept
  •  Creating Roles
  •  Assigning Privileges to Roles
  •  Privileges
  •  SQL Privileges
  •  System Privileges
  •  Analytic Privileges
  •  Reporting and Privileges
  •  Modeling required PrivilegesSAP HANA DB Backup and Recovery
  •  System Configuration Parameters
  •  Monitoring and system state parameters
  •  Backup & Recovery SAP HANA
  •  Need of Backup
  •  Backup Types
  •  Data Backup
  •  Log Backup
  •  Recovery Options
  •  Recovery in Replication Scenarios
  •  Backup to External Backup Destinations
  •  Recovery Scenarios
  •  Power Failure
  •  Disk Failure

Monitoring and Troubleshooting

  •  Configuring Remote Support
  •  Solution Manager Integration
  •  Remote Service Connection
  •  Availability Monitoring
  •  Setting up Monitoring
  •  System Monitoring Setup
  •  Status Overview
  •  Services Overview
  •  System Load History
  •  Disk Usage Details
  •  Checking System Configuration
  •  Alerts

SAP HANA Logs & Traces

  •  Regular administration tasks
  •  Troubleshooting
  •  Analyzing performance
  •  Auditing SAP HANA
  •  Global Audit Configuration
  •  Manage Audit Policies
  •  Audit Events
  •  Audit Trail

Updating SAP HANA STUDIO Software Lifecycle Management

  • Request Demo