About Trainer

  • 10+ years of IT experience
  • 2+ years of onsite experience
  • Certified
  • Working as an Architect
  • Excellent in Communication



Course Pre-requisites:

  • Basic DB Admin Knowledge

Lab setup: RHEL 32/64 bit

Training Material:

  • Class PPT’s (Soft Copy)
  • Session recordings (optional)
  • Manuals

SAP HANA Online Training Course Outline: :
  • SAP HANA Studio
  • Architecture of SAP HANA
  • Modelling in SAP HANA
  • Reporting
  • Data Provisioning or data loading
  • Administration in SAP HANA
  • User Management & Security
  • COPA Accelerator
Course Contents:
Unit 1: SAP HANA Studio
  • Modeler
  • Administration View
  • Navigator
  • System Monitor
Unit 2: Architecture
  • Row Store
  • Column Store
  • Database Engine of HANA
  • Data modelling
  • Reporting Architecture
  • Administration
Unit 3: Modelling in SAP HANA
  • Create Attribute Views
  • Design Analytical Views
  • Create Calculation Views from multiple analytical Views
  • Best Practices while Creating Information Models
  • Performance Optimization techniques in SAP HANA
  • Currency Conversion
  • Variables in HANA
  • Meta data import to SAP HANA Using SAP BODS
  • Export Models
  • Import Models
  • SQL Script
  • CE Functions
  • Procedures
  • Hierarchies – Level Based Hierarchies and Parent Child Hierarchies
  • Restricted Measures & Calculated Measures & Calculated Attributes
  • Joins in SAP HANA : Referential Join, Text Join, Inner Join, Right Outer Join & cardinalities
  • Auto Documentation of Information Models
Unit 4: Reporting
  • SAP BI BO 4.0 Reporting Tools connectivity with SAP HANA
  • IMCE Clients – ODBO , ODBC, JDBC, BICS
  • Microsoft Excel 2010 Connection to HDB
  • Create Universe through Information Design Tool using JDBC Connections.
  • Web Intelligence Document on SAP HANA Universe.
  • Design studio
  • Lumira
  • BO Analysis for Office
  • BO Analysis for OLAP
  • BO Explorer
  • Crystal Reports for enterprise
Unit 5: Data Provisioning/Data Loading
  • SAP LANDSCAPE Transformation – SLT
  • SAP BODS Load to SAP HANA – ODP Enabled Data Sources
  • SAP DXC – Direct Extractor Connection
  • Flat File Upload to SAP HANA
  • SAP BODS : Overview Data Services Workbench and Designer
  • Creating Data store for ECC and HANA
  • Create Data Services Job and Load the data to SAP HANA DB
Unit 6: Administration in SAP HANA
  • Backup & recovery
  • SAP HANA Studio Installation and Configuration
  • Clients installation
  • Create ODBC Connections
  • Monitor HDB
  • Multi Version Concurrency Control – MVCC
  • IMDB Installation
  • Distributed System Handling – Cold backup and Hot Backup
  • Persistency Layer
Unit 7: User Management & Security
  • Creating Users
  • Creating Roles
  • Assign privileges to Users/Roles
  • Template Roles
  • SQL Statements for user management
  • Analytical Privileges, Package Privileges, System Privileges, SQL Privileges
Unit 8: COPA Accelerator
  • COPA Overview COPA Reporting in HANA
  • Architecture for CO – PA Accelerator , Use Case Scenarios , Scope
  • DBSL – Database Shared Library Connection for HANA as secondary Database
  • SLT Replication – SAP HANA Model.
Unit 9: SAPBW on HANA
  • Overview of SAP BW
  • SAP BW Powered By Hana as database
  • In Memory Optimized Info cube
  • In Memory Optimized DSO
  • Bex Report on SAP HANA Transient Provider
  • SAP BW Composite provider on HANA model


  • The fact that they have a set format of teaching, which creates a schedule for a student, and a step-by-step process that covers the entire Netezza syllabus. I can surely assure eTraining provides a great help for Netezza curriculum.
    - Shannon D.

  • The BEST I liked about the tutors in eTraining is the amount of practical knowledge these guys have and the way they bring in the same to students perspective while Teaching. Glad I took DB2 course from eTraining.
    - Rubeena Khan

  • I found classes very helpful. What you Teach is AWESOME
    - Gopal