SAP HANA & ADMINISTRATION

This course is a combination of SAP HANA & Administration. The course will teach participants how to use SAP HANA (High-Performance Analytical Appliance) in memory, column store database to supports real-time data loads and analytics. The coverage will provide insights on how SAP HANA revolutionizes database platform that helps a business to run faster and analyze decision-making in real time, thus helping users to analyze data within seconds.

COURSE OBJECTIVE

LESSON PLANS


​SESSION 1: SAP HANA INTRODUCTION
Session Goal
  • SAP HANA.
  • Environment & Components.
  • Replications Methods in SAP HANA.
  • SAP In-Memory Strategy.
  • HANA Comparison  to BWA.
  • Look & Feel of HANA.
  • In-Memory Computing Studio.
  • Administration view.
  • Navigator View.
  • System Monitor.
  • Information Modeler.

​SESSION 2: SAP HANA ARCHITECTURE
Session Goal
  • Overview.
  • IMCE and Surroundings.
  • Row Store.
  • Column Store.
  • Loading data into HANA.
  • Data Modeling.
  • Reporting.
  • Persistent Layer.
  • Backup & Recovery.

​SESSION 3: DATA PROVISIONING
Session Goal
  • Replication Server.
  • Replication Process.
  • Replication Architecture.
  • Data Services.
  • SAP BODS and HANA.
  • Basic Data service Connection types.
  • New to Data services 4.0, Full Extractor though ODP.
  • Configure Import server.
  • Create and execute a Data Service Job to Populate HANA.

​SESSION 4: DATA MODELLING
Session Goal
  • Purpose of Information Modeler.
  • Levels of Modeling in SAP HANA.
  • Attribute Views.
  • Analytic Views.
  • Calculation Views.
  • Creating Advanced Calculation Views using GUI and SCRIPT methods.
  • Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios.
  • Export & Import – Server and Client sides.
  • Using Hierarchies (Level Based and Parent-Child Hierarchies).
  • Creating Restricted and Calculated Measures.
  • Using Filter Operations.
  • Using Variables, input parameters.
  • SAP HANA SQL Introduction.
  • SQL Script and Procedures.
  • Using Currency Conversions, Create hyperlinks.
  • Persistency Considerations.
  • SAP HANA Engine Overview.
  • Choosing Views For Information.
  • Using SAP HANA Information Composer for Modeling.
  • Procession Information Models.
  • Connecting Tables.
  • Managing Modeling Content.

​SESSION 5: SAP HANA REPORTING
Session Goal
  • HANA, Reporting Layer.
  • Connectivity options.
  • SAP Business Objects BI 4.1.
  • Designing Complex Universes in IDT based on HANA Tables and HANA Views.
  • WEBi 4.0 on HANA.
  • Crystal Report for Enterprise with HANA.
  • Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0.
  • SAP Business Objects BI 4.1 Explorer.
  • Designing Information Space based on SAP HANA Information Model using BO Explorer 4.1.
  • Exploring the Data using BO 4.1 explorer based on Information Spaces created on HANA.
  • Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection).
  • Analysis edition for Microsoft Excel, Microsoft Powerpoint.
  • SAP Visual Intelligence on HANA.
  • Crystal Reports via ODBC/JDBC Connections.
  • Others & MS Excel 2010.

​SESSION 6: SAP HANA USER MANAGEMENT
Session Goal
  • Creation of Users.
  • Creation of Roles.
  • Creation of Role Hierarchy.
  • Assignment of Users to Roles.
  • Authentication.
  • IMCE Authorizations.

​SESSION 7: SECURITY & AUTHORIZATIONS
Session Goal
  • User Management and Security.
  • Types of Privileges.
  • Template Roles.
  • Administrative.

​SESSION 8: SAP HANA VERSIONS & EDITIONS
Session Goal
  • 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.

​SESSION 9: SAP HANA TOOLS & PRE/POST INSTALLATION
Session Goal
  • SAP HANA Studio.
  • DBA Cockpit.
  • HDBSQL.
  • 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.
  • Preparing SAP HANA Installation.
  • Review SAP HANA Installation.
  • Post-Installation Steps.
  • Auditing.

​SESSION 10: SAP HANA ADMIN & OPERATIONS
Session Goal
  • Starting and stopping SAP HANA.
  • Configuring SAP HANA.
  • Periodic Manual Tasks.
  • Enabling high availability of SAP HANA.

​SESSION 11: DATA PROVISIONING USING SLT
Session Goal
  • 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.

​SESSION 12: EXTRACTION & CONNECTION
Session Goal
  • Introduction to SAP HANA Direct Extractor.
  • Limitations of DXC.
  • Setup and Configurations.
  • Enabling Services.
  • HTTP Connection and Test Connection.

​SESSION 13: BACK-UP & RECOVERY
Session Goal
  • Concept of Backup and Recovery.
  • Data Area Backup.
  • Log Area Backup.
  • Backup of Configuration Files and Backup Catalog.
  • Recovery.
  • Database Copy.
  • High Availability.

​SESSION 14: SECURITY
Session Goal
  • 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.
  • Standard Roles.
  • Administrative Tasks.
  • Authentication Methods.
  • Information Sources for Administrators and Auditing.

​SESSION 15: MONITORING & TROUBLESHOOTING
Session Goal
  • Configuring Remote Support.
  • Solution Manager Integration.
  • Remote Service Connection.
  • Availability Monitoring.
  • Setting up Monitoring.
  • Monitoring with SAP HANA Studio.
  • Monitoring with DBACOCKPIT.
  • System Monitoring Setup.
  • Status Overview.
  • Services Overview.
  • System Load History.
  • Disk Usage Details.
  • Checking System Configuration.
  • Alerts.

​SESSION 16: SAP HANA LOGS & TRACES
Session Goal
  • Regular administration tasks.
  • Troubleshooting.
  • Analyzing performance.
  • Auditing SAP HANA.
  • Global Audit Configuration.
  • Manage Audit Policies.
  • Audit Events.
  • Audit Trail.

​SESSION 17: SOFTWARE LIFECYCLE & MANAGEMENT
Session Goal
  • Updating SAP HANA.
  • Updating SAP HANA Studio.
  • Transporting Changes.
CASE STUDY AND PROJECTS
Case studies are integral part of training. As part of this course we will ensure you  implement Real-time Case studies ​in various domains which includes:
  • Banking.
  • Telecom
  • Ecommerce.
  • HealthCare.​
These case studies will be evaluated by domain experts and you would get an opportunity to get Feedback on the work.
TRAINING FEATURES
1) Extensive Real Time Live Examples, Projects & POCs for improved practical competency, ensure deployment readiness and implementation.
2) Custom Lab, Software and Environment provided with Real-time Project Simulation.
3) Recorded Videos complemented with corresponding lecture ppts, materials & lab guides. (Provided in the form of MP4 videos, pdf, ppt for offline access as well).
4) Certification and Job-Interview Counselling & Coaching after every training.