SAP HANA Training

  • Overview
  • Course Content
  • Drop us a Query

HANA training covers all the architecture and technical functionality required for working on HANA. This training does not only gives an overview put provides in-depth knowledge on in-memory computing, architecture, data provisioning and replication. The ERP-HANA training also allows the aspirants to build capabilities on using Information Modeler and advanced modeling features. Details regarding creation of reports using Business Objects and Crystal Reports via ODBC/JDBC connections are also discussed.

Upon the completion of SAP HANA Training, you will inculcate the following skills:

  • Understanding of HANA, in-memory computing, and comparison between HANA and BWA
  • Identify the look and feel features of In-Memory Computing Studio
  • Understanding the architecture and loading of data into HANA
  • Marinating backup and recovery of data
  • Configure import server and manage replication server functionality
  • Work on different views of modeling including attribute, analytic, calculation, filter options, and currency conversion
  • HANA User Management and Privileges
  • Use Business Objects for creating reports
Target audience
  • Freshers/professionals looking to build career in HANA database
  • Professionals willing to enhance their HANA skills
  • Professionals engaged in the implementation of HANA
  • ABAP consultants who wants to acquire HANA skills
Prerequisites

Candidates with basic knowledge of SQL, database and database warehouse can take best out of SAP HANA Training.

1. Introduction

  • Evolution of HANA
  • Introduction to  HANA
  • Introduction to  In‐Memory
  • Strategy and Technology
  • HANA compare to BWA
  • HANA Landscape
  • In‐Memory Computing Product
  • Strategy and Roadmap
  • HANA In-memory

2. Sizing Look & Feel

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

3. Architecture

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

4. Data Provisioning & Replication

  • Replication Server
  • Replication Process
  • Replication Architecture
  • Data Services
  • BODS and HANA
  • Basic Data service Connection types
  • Data services 4.0
  • Full Extractor though ODP
  • Configure Import server
  • Create and execute a Data Service Job to Populate HANA

5. Modeling

  • Introduction to Information Modeler
  • Levels of Modeling
  • Attribute Views
  • Analytic Views
  • Calculation Views
  • Export & Import Trigger‐based replication with  Landscape
  • Approaching  HANA Modeling Connecting tables
  • Advanced Modeling features
  • Hierarchies
  • Restricted & Calculated Measures
  • Filter Operations and Variables
  • Currency conversion
  • Introduction to SQL script and Script based
  • Processing Information Models
  • Managing Modeling Content
  • HANA User Management and Privileges

6. Reporting

  • HANA, Reporting Layer and Connectivity option
  • Business Objects BI 4.0
  • Business Objects BI 4.0 Explorer
  • Business Objects BI 4.0 Enterprise
  • Crystal Reports via ODBC/JDBC Connections
  • Others, MS Excel

7. User Management

  • Creation of Users
  • Creation of Roles
  • Creation of Role Hierarchy
  • Assignment of Users to Roles
  • Authentication
  • IMCE Authorizations

A Few Things You'll Love!

What our Students Speak

+