• SAP HANA changes explanatory knowledge. It conveys propelled information handling for content, spatial, graph, and arrangement information in one framework. In addition, it furnishes further bits of knowledge with intense prescient analysis and machine learning abilities.

• SAP HANA changes database administration. It forms exchanges and analytics in-memory on a solitary data copy – to convey ongoing bits of knowledge from live information. It additionally disentangles operations with modern apparatuses and a protected, shake rock-solid foundation.

• SAP HANA changes app development. The next-gen platform offers adaptable advancement and sending devices to help you rapidly model, approve, construct, and convey smart and modern applications that keep running on preface or in the cloud.

• SAP HANA changes information administration. The platform implants information virtualization and quality capacities to quickly get to and dissect information from any source – successfully disposing of storehouses.


SAP HANA is one of the main information administration platforms to deal with both exchanges and analytics in-memory on a solitary information duplicate. It joins a best in class database with advanced analytical processing, application improvement capacities, data integration and data quality. You pick up a solitary secure environment for all your mission-critical data resources, so you can oversee vast volumes of organized and unstructured information productively to decrease add up to cost of proprietorship. In the meantime, you can rearrange your IT landscape and diminish authoritative exertion by uniting various workloads onto SAP HANA. Having the capacity to Run Simple helps you convey understanding into continuous exchanges, so your association can react progressively to market change, seizing new open doors more rapidly than your rivals. Furthermore, you can create imaginative applications on SAP HANA that join exchanges and analytics and convey connecting with customized encounters over any device.

Course Content:

1. SAP HANA Introduction and Architecture
• SAP HANA Overview
• SAP In-Memory Computing Overview
• SAP HANA Features
• Look and Feel of SAP HANA
• SAP HANA Architecture
• SAP HANA Landscape
• Structure of SAP in-memory computing studio
• Row Store and Column Store Architecture
• Multi-Version Concurrency Control (MVCC)
• Persistence Layer in In-memory Computing Engine
• Back-up & Recovery
• High-Availability
• Distributed System
• Data Provisioning Options in SAP HANA
• Reporting Options on SAP HANA
• Security Options in HANA
• SAP HANA Appliance Model
• How SAP HANA Appliance is delivered
• Sizing Considerations
• SAP HANA– Licensing Options
• SAP HANA Project Implementation
• Overview: Key Activities
• Key Roles
• Key points to keep in mind
• Administration
• Modeling

2. Basic Modeling

• Modeling Overview
• Terminology
• SAP HANA Studio Features
• Information Modeler: Overview
• Installation and Configuration of HANA Studio
• Prerequisites for Modeling
• Modeling Considerations
• Levels of Modeling
• Attribute Views
• Analytic Views
• Calculation Views
• Modeling Considerations
• Joins: Different types and when to use what.
• Where Clause Vs Constraint Filters
• HANA Studio Preview (use with caution)
• Impact of Query Execution
• Demo
• Modeling Suggestions
• Troubleshooting Modeling Issues
• Export and Import Models

3. Analytics Option on HANA

• HANA, Reporting Layer & Connectivity Options
• Reporting on HANA Clients.
• Reporting on HANA Open Interfaces
• Prerequisites for reporting on SAP HANA
• IMDB client installation
• Setting up new connection
• SAP Business Objects BI 4.0 : Overview & tool comparison
• Analytical Reporting on HANA
• Relational Reporting on HANA
• Reporting on HANA: (Demo Included)
• Native Excel Interface via ODBO
• SAP Business Object Analysis (Office Edition)
• SAP Business Object Explorer
• Semantic Layer Approach
• IDT Vs Universe Designer
• SAP BOBJ WebI
• SAP BOBJ Xcelsius
• SAP Crystal Reports
• Enterprise Vs 2011
• Front end tool reporting considerations on top of HANA
• Troubleshooting common reporting issues

4. Advanced Data Modeling with SQL Script

• Modeling Overview
• Calculation View: Overview & Types
• SQL Script: Motivation
• SQL Script: Overview
• SQL Script Processing
• Data Type Extensions
• Scalar Data type
• Table type
• Functional Extension
• Concept
• Procedure
• Procedure Calls
• Implementing Functional logic
• Operators
• SQL Script/Built-in Function
• Debugging and troubleshooting SQL Script
• Restrictions for SQL Statement

5. Data Provisioning: Data Services and Sybase Replication

• Data Provisioning: Overview
• Data Provision Options
• Trigger Based Replication
• ETL-Based Replication
• Log-Based Replication
• SAP Business Objects Data Services 4.0 and HANA
• ODP enabled Extractor Support in Data Services 4.0
• HANA and Data Service Process flow for SAP and non-SAP data
• How it works for SAP System
• How it works for Non-SAP System
• Advanced Data Service Options
• column tables creation
• Bulk Loader Options & Config
• bulk extracting Options & Config
• Log-Based Replication Overview
• Technical System Landscape
• User Administration
• Authorization
• Installing Log-Based Replication
• Updating the SAP Host Agent on Source System
• Installing Sybase Components
• Deploying the SAP HANA Load Controller and Related Components
• Configuring Log-Based Replication
• Configuring Sybase Components
• Sybase Replication Server
• Enterprise Connect Data Access (ECDA)
• Sybase Replication Agent
• Test Sybase Components
• Configure SAP HANA Load Controller on SAP HANA System
• Initializing Replication using SAP HANA Load Controller

6. Data Provisioning : SAP LANDSCAPE TRANSFORMATION (SLT)

• Data Provisioning Overview
• SAP Landscape Transformation Set-up
• Options for SLT Landscape Installation
• Post-Installation Step
• Concept of SLT Replication
• Architecture and Key Building Block
• Technical Requirement and System Set-up Information for LT Replication Server
• Key Benefits of LT Replicating Server
• Transformational Capabilities• Operations

7. Security and User Management in HANA

• Creation of Users
• Creation of Roles
• Assignment Privileges to Roles
• Assignment of Users to roles

Contact us:

Website: http://www.sapvits.com/
Email id: [email protected]
IND: +91 992 284 8898
USA: +1 678 389 8898
UK: +44 141 416 8898