SAP HANA Admin

 

1. 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

 

2. 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

 

3. SAP HANA Editions

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

 

4. SAP HANA Sizing

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

 

5. SAP HANA Pre and Post Installations

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

 

6. Look and Feel

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

 

7. Architecture

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

 

8. SAP HANA Hardware and software Requirements

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

 

9. 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

 

10. SAP HANA Tool Overview

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

 

11. Install HANA Studio

• System Requirements
• Supported Platforms
• Install SAP HANA Studio

 

12. 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

 

13. SAP HANA Operation

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

 

14. 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

 

15. Information

• Configuring HANA Studio for importing Metadata
• Importing Metadata
• Mass Import
• Selective Import
• Load Data Via Data services into SAP HANA

 

16. SAP HANA Direct Extractor Configuration

• Introduction to SAP HANA Direct Extractor

 

17. Connection (DXC)

• Limitations of DXC
• Setup and Configurations
• Enabling Services
• HTTP Connection
• Test Connection

 

18. 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

 

19. 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

 

20. 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

 

21. SAP HANA Logs & Traces

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

 

22. Updating SAP HANA STUDIO

• Software Lifecycle Management