SAP HANA ADMINISTRATION Training

SAP HANA ADMINISTRATION Training

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 Privileges

SAP 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


Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message