SAP HANA Administration
SAP HANA is a powerful database from SAP built on In-memory technology. SAP HANA usually needs less administration than other databases, SAP is suggesting their customers to migrate from other traditional databases to HANA Database which is 3500 times faster Analytics and 4500 faster reporting speed.The SAP HANA Studio is the main GUI tool for SAP HANA Admin 2.x Training, So the future would be the HANA database with most of the customers.
Each SAP HANA Administration Online Training Module builds on top of the preceding Module so that the learning process is progressive. The examples given in this training are practical, and you will be able to see the immediate result of your efforts. We will first cover setting up HANA Platform i.e pre and post installations, Direct extractor configuration and much more, followed by project. By end of our SAP HANA Administration training, students can confidently update their profiles with knowledge and Hands on experience.
SAP HANA Administration Training Curriculum
Introduction to SAP HANA
SAP HANA Basics, 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.
Different HANA Versions and Editions
HANA .0 SPS03, HANA .0 SPS04—NEW Features, HANA .0 SPS05—NEW Features, HANA .0 SPS06—NEW Features, HANA .0 SPS07—NEW Features, HANA .0 SPS08—NEW Features, HANA .0 SPS09—NEW Features.
SAP HANA Platform Edition, SAP HANA Enterprise Edition, SAP HANA Enterprise Extended Edition.
SAP HANA In-Memory Database Sizing elements, RAM, Disk, CPU, Memory Sizing, CPU Sizing, SAP HANA Scale Out
Pre and Post Installations
Preparing SAP HANA Installation, Reviewing SAP HANA Installation, Post-Installation steps
Configuring Look and Feel
In-Memory Computing Studio, Administration view, HANA Navigator View, System Monitor in HANA, Information Modeler
HANA System Architecture
Architecture Overview, IMCE and Surroundings, HANA Row Store, Column Store, Loading data into HANA, Data Modeling in HANA, Persistent Layer in HANA, Backup & Recovery.
SAP HANA Hardware Requirements
Prepare HANA Installation parameters, Users created during HANA Installation, HANA Required Installation media, Prepare Installer Configuration file.
SAP HANA Installation
SAP HANA unified Installer Tool Unified Installer to install the Sap HANA SERVER, HANA Components installed by Installer, Command based Installation, GUI based HANA 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
HANA Post-Installation Steps
Starting and Stopping SAP HANA System, Displaying Process List, Logging on to HANA system using HANA studio, HANA User Security, Monitoring HANA Landscape.
SAP HANA Operations
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.
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, Connection (Dxc)
Introduction to SAP HANA Direct Extractor, Limitations of DXC, Setup and Configurations, Enabling Services, HTTP Connection and 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
This module presents, how to troubleshooting performance in SAP HANA and also configuration to manage log file.
Regular administration tasks, Troubleshooting, Analyzing performance, Auditing SAP HANA, Global Audit Configuration, Manage Audit Policies, Audit Events, Audit Trail.