Learn SAP HANA Developer Course Online

Online SAP HANA Developer Training and Placement

Course Content:

Introduction to SAP HANA:

• SAP In-Memory Strategy
• HANA compare to BW
• Architecture
• Architecture Overview
• IMCE and Surroundings (In memory Computing Engine)
• Row Store & Column Store
• Installation and deployment scenarios

Navigation:

• Introduction to HANA Studio
• HANA Administration Prospective
• Modeler Prospective
• System monitoring.

LT (Landscape Transformation) OR Trigger Based Replication:

• Remote Function Calls
• Creating RFC Destinations in SAP ABAP
• Replicating SAP tables from OLTP Server using Trigger based Replication
• Real time Replication
• Job Scheduling and monitoring.
• Parallel and Multi-Thread processing.

SQL Scripts:

• Data Types
• Table Creation, Modification, Updating and Deletion operations.
• SQL Select Statements
• Joins and Unions
• String Operations
• Stored procedures
• CE (Calculation Engine) Functions.
• Aggregations and lot more.

Modelling:

• Applying star schema technique in SAP HANA
• Attribute Views
• Calculated Columns
• Hierarchies
• Time Data Generation
• Analytic Views
• Variables & Input Parameters
• Calculated & Restricted Columns
• Currency & Quantity Conversions
• Calculation Views
• Star Joins, Cubes & Dimensions
• SQL Script based Views
• Calculation Engine Functions Depth.

HANA -ETL Replication Methodology:

• BODS (Business Object Data services)
• HANA As a Central Repository
• JDBC & ODBC connectivity.
• Replicating data from SAP OLTP Server Using BODS
• Replicating data from Flat File Source systems
• Replicating data from BI System
• Backward replication technique.
• Bulk Load & Scheduling
• Extracting ECC data using BW Extractors
• Scheduling Stored Procedures

Working with HANA on BW Platform:

• BI and BODS connectivity
• Data Extraction form SAP BW into Hana-Server using BODS
• Reporting on BW Infocubes using Dashboards

Transformations using BODS:

• Merge Transform
• Pivot & Reverse Pivot Transformations
• SQL Transformation
• Key Generation Transform
• Validation Transform
• Case Transform

Business Objects CMC & Information Design Tool

• Creating Repository
• Relational Database & OLAP Connections
• Working with Universes
• Creation of Project & Data Foundation to Build the Universe
• Creating Data Services Repository User

Xcelsius / SAP BO Dashboards:

• Consuming BEx Query
• Consuming an Universe to Design a Dashboard
• Working With TABs
• Working with Workbook
• Visualizing the data in Charts
• Using Selectors

SAP HANA Reporting Using MS Excel:

• SAP HANA MDX Provider
• Creating ODBC Connection
• Reporting Fundamentals
• Using Filters and Hierarchies
• Graphical Reporting
• Advanced Reporting Techniques.

Reporting Using Business Object Explorer 4.0:

• Creating HANA Source Systems
• Managing Info-Spaces
• Geographical Reporting
• Time based reporting
• Hierarchical Reporting
• Configuring & Indexing the Views
• Creating Exploration Viewset
• Creating URLs for Web-based Reporting
• Reporting with BOEx in Depth

Crystal Reports with SAP HANA:

• Creating Relational Database Connection
• Reporting on HANA tables
• Reporting on HANA Views
• Reporting on Stored Procedures

SAP BW on HANA:

• End – To –End implementation Scenario
• Introduction to SAP HANA DXC (Direct Extractor Connection)
• HANA as a Source System Via DB connect
• Concept of HANA optimized DSOs
• HANA optimized InfoCubes
• Migrating DSOs & Info Cubes to HDB
• Authorizations
• Backup and Recovery

SAP ABAP on HANA:

• End – To – End Implementation Scenario
• The ADBC connection
• Creating External Views on HANA
• Working & consuming stored procedures on ABAP
• SAP ABAP for HANA
• Creating Interfaces and & Proxy Classes to Communicate with SPs
• Optimizing ABAP reports Using HANA (Live Scenario)

Software Development on SAP HANA:

• SAP HANA XS engine
• Deploying Java Script based Application on HANA
• SAP HANA with Odata Services
• SAP HANA UI5 based Development

HANA Administration:

• Creating Users
• Assigning Roles
• Authorizations
• Backup and Recovery