SAP HANA

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

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

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

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 Statemen

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

SAP HANA 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

Security and User Management in HANA

• Creation of Users

• Creation of Roles

• Assignment Privileges to Roles

• Assignment of Users to roles