HANA
Sap HANA is one of the fastest growing products in Sap’s era and is viewed by the industry as a break through solution for in-memory databases. Sap HANA is an in-memory platform for processing high volumes of data in real-time. HANA allows data analysts to query large volumes of data in real-time. Sap HANA claims that it accelerates analytics and applications on a single, in-memory platform as well as combining databases, data processing, and application platform capabilities.
HANA COURSE CONTENTS
- Evolution of HANA
- Introduction of HANA
- Introduction of Sap HANA
- Introduction of Sap in memory
- Strategy and technology
- HANA compare to BWA
- Sap HANA landscape
- Sap in memory computing products
- Strategy and roadmap
- In memory Computing Studio
- Administration views
- Navigator View
- System View
- Information Modeler
- Architecture Overview
- IMCE and surroundings
- Row Store
- Column Store
- Loading data into HANA
- Data Modeling
- Reporting
- Persistent Layer
- Backup & Recovery
- Replication Server
- Replication process
- Replication Architecture
- Data services
- Sap BODS and HANA
- Basic Data service connection types
- Data Services 4.0
- Full Extractor through ODP
- Configure Import server
- Create and execute a Data service job to populate HANA
- Introduction to information Modeler
- Levels of modeling in Sap HANA
- Attribute Views
- Analytic Views
- Calculation Views
- Export & Import
- HANA Reporting Layer Connectivity options
- Business Objects BI 4.0
- Business Objects BI 4.0 Explorers
- Business Objects BI 4.0 EntSaprise
- Crystal reports via ODBC/JDBC Connections
- Others & MS Excel
- • Creation of Users
- Creation of Roles
- Creation of Role Hierarchy
- Assignment of users to roles
- Authentications
- IMCE Authorizations
- Positioning and key concepts
- Overview on configuration Aspects
- Data Replication at a glance
- SLT based transformation concepts
- Selective Data Replication
- Transformation of Data
- Extension of (target) table structure
- Specific Considerations
- Persistency Considerations
- Sap HANA Engine Overview
- Choosing views for the information Model
- How to connect tables Using:
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Text Outer Join
- Referential Join
- Union
- Creating Attribute Views
- Using Hierarchies
- Creating Restricted & calculated Measures
- Using Filter Operations
- Using Variables
- Sap HANA SQL – Introduction
- SQL Script and Procedures
- Using Currency Conversion
- Validating Models
- Comparing Versions of Information Objects
- Checking Model References
- Generating: Auto Documentation
- Schemas
- Import & Export Copying Objects
- User Management & Security
- Types of Privileges
- Template Roles
- Administrative