4 Star Rating: Very Good 4.40 out of 5 based on 315 ratings.
  • Overview
  • Course

The SAP HANA studio is a collection of applications for SAP HANA.It enables technical users to manage the SAP HANA database, to create and manage user authorizations, and to create new or modify existing models of data in the SAP HANA database. It is a client tool, which can be used to access local or remote SAP HANA databases. The HANA depends on the chosen deployment model. If a customer chooses the SAP HANA tailored data center integration, the components of SAP HANA must be installed on validated hardware by a certified administrator or official SAP HANA hardware partner.

If a customer chooses an SAP HANA appliance, then the components of SAP HANA can only be installed by certified hardware partners on validated hardware running a specific operating system. Any othersystem or content developed with systems of this type is not supported by SAP. Support Package Stacks (SPS) can be downloaded and applied to appliances in accordance with agreements with the respective hardware partner. HANA studio does not depend on an external JVM installation. During the installation and the update of the SAP HANA studio a SAP JVM is being installed or updated.

The SAP HANA studio uses the default Eclipse secure storage to store passwords. Depending on whether you are running a 32-bit installation or a 64-bit installation, different password providers are used. This means that switching between a 32-bit and a 64-bit installation results in the clearing of stored passwords. It is possible to override the default Eclipse configuration for password storage using the command line arguments eclipse and password.

Key Features of SAP HANA SP.9 Training are:

  • Design POC (Proof of Concept): This process is used to ensure the feasibility of the client application.
  • Video Recording of every session will be provided to candidates.
  • Live Project Based Training.
  • Job-Oriented Course Curriculum.
  • Course Curriculum is approved by Hiring Professionals of our client.
  • Post Training Support will helps the associate to implement the knowledge on client Projects.
  • Certification Based Training are designed by Certified Professionals from the relevant industries focusing on the needs of the market & certification requirement.
  • Interview calls till placement.


  • Introduction to SAP HANA
  • SAP In-Memory Strategy
  • HANA compare to BWA
  • Importance of HANA


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

Data Provisioning

  • Method 1 – Data Provisioning using FLAT FILES
  • Method 2 – Data provisioning using SLT
    • Positioning and Key Concepts
    • Overview on Configuration Aspects
  • Method 3 – Data provisioning using BODS 4.2
    • BODS 4.2 Architecture in detail
    • Overview on Configuration
  • Method 4– Director Extractor Connection (DXC)
    • Details about SAP ERP Extractors
    • Architecture of DXC
    • Overview on Configuration.
  • Method 5 – Smart Data Access (SDA)

 Look and Feel HANA Studio

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


  • Purpose of Information Modeller
  • Levels of Modelling 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
  • 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 Modelling
  • Procession Information Models
    • Validating Models
    • Comparing Versions of Information Objects
    • Checking Model References
    • Generate Auto Documentation
    • Connecting Tables
    • Joins (Inner, Left Outer, Right Outer, Full Outer, Text, Referential and Union)
    • Managing Modelling Content
    • Manage Schemas
    • Import and Export data Models
    • Copy Information Objects


  • HANA, Reporting Layer
  • Overview on reporting using BOBJ 4.2
  • Overview on Lumira

Drop us a query

Contact us : +918851281130

Course Features

Real-Life Case Studies
Lifetime Access
Expert Support
Global Certification
Job Portal Access