SAP Hana training in pune

sap hana

Course Features



One Stop Solution!

   Ability to attend missed sessions

    Complete documentation

   Resume preparation

   Certification preparation.

   Interview preparation

   Placement assistance



1.SAP Hana Studio

  • Modeler

  • Administration View

  • Navigator

  • System Monitor

  2.Architecture Of SAP HANA

  • Row Store

  • Column Store

  • Database engine of HANA

  • Data modeling

  • Reporting

  • Architecture

  • Administration

3.Modeling 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

  • 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



  • 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


 5.Data Provisioning Or 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 HAN


 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


7.User Management & Security

  • Distributed System Handling – Cold backup and Hot Backup

  • Persistency Layer

  • Creating Users

  • Creating Roles

  • Assign privileges to Users/Roles

  • Template Roles

  • SQL Statements for user management

  • Analytical Privileges, Package Privileges, System Privileges, SQL Privileges


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




  • 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



no images were found


SAP HANA Training in Pune

SAP HANA ( High performance Analytic Appliance ) is the latest and the fastest growing SAP technology in the market. ETLHIVE is a Training Center for latest technologies in SAP Such as SAP HANA, Cloud & Mobility. It is based on a new type of Database which is built on In-Memory technology for generating the speedy and simple reports. Our aim is to create industry desirable professionals though our unique practical approach to train our students rather than theoretical/bookish methodology. HANA professionals are the Highest Paid ones in the IT sector. Usage of SQL scripts in HANA makes it easier to learn for those who are working in other technologies like C++, JAVA, ORACLE, .NET, MAINFRAMES etc. The reports generated on HANA are up to 10,000 times faster than the regular reports. This drastic improvement is the reason why HANA is rapidly occupying world's Data-warehousing Market.

ETLHIVE is a Trademark of Itelligence Infotech Pvt Ltd.   *PMP®, PMBOK, PMI, PgMP, CAPM, PMI-RMP, and PMI-ACP are registered trademarks of the Project Management Institute, Inc. *ITIL®, IT Infrastructure Library, Swirl Logo, Prince2 are registered trademarks of AXELOS Limited.
Online Demo – Selenium : 4pm (2nd Apr) | Salesforce : 1pm (4th Apr) | Python : 9pm (3rd Apr) | Data Science : 9pm (1st Apr) | Tableau : 9pm (3rd Apr) | Data Science : 2pm (4th Apr) | Devops : 2pm (4th Apr) | AWS : 3pm (5th Apr) |