SAP HANA is an in-memory data platform that is deployable as an appliance or in the cloud. At its core, it is an innovative in-memory relational database management system that makes full sense of the capabilities of current hardware to in…
4.8 · Rated by learners Certificate of completion
Duration
30 Hours
Mode
Live + Recorded
Level
Beginner → Pro
Language
English / Hindi
AI practice, included with this course
Rehearse the interview and test yourself before the real thing.
Available in your student dashboard as soon as you enrol —
no extra charge, nothing to install.
Course overview
About the SAP HANA program.
SAP HANA is an in-memory data platform that is deployable as an appliance or in the cloud. At its core, it is an innovative in-memory relational database management system that makes full sense of the capabilities of current hardware to increase application performance, to reduce cost of ownership, and to enable new scenarios and applications that were not possible before. With SAP HANA, you have the opportunity to build applications that integrate the business logic, control logic, and the database layer with unprecedented performance. As a developer, one of the key questions is how you can minimize data movements. The more you can do directly on the data in memory next to the CPUs, the better the application will perform. This course will introduce you to native software development on SAP HANA.
Why learn with BISP
Trusted by professionals across 30+ countries.
Industry trainers
Certified consultants with 12+ years of real project experience.
Hands-on practice
Real-time scenarios & live project modules, not just slides.
Placement support
Resume building, mock interviews & job referrals.
Certification
BISP certificate + full guidance for official exams.
Course curriculum
Designed by real-time industry professionals around current job roles.
04Method 2 - Data Provisioning using BODS 4.0 (ETL Based Approach � Building AGILE Data Marts)25 topics
BODS 4.0 Architecture in detail
Data Stores in BODS
Meta Data
BODS Objects and components Hierarchy
Building Data Flows in Designer (to Load the Data to SAP HANA)
Query Transform in the Data Flow
Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files and COBOL copybooks) Using Merge Transforms, Date Generation Transforms, SQL Transforms, Pivot Transforms, Reverse Pivot, Match Transform, Match Results Transform, Case Transforms, Validation Transforms, KEY Generation Transform, R Generation Transform, Table Comparison Transform, History Preservation Transform, Map operation Transform with Insert, Map Operation transform with Updates in BODS Data Flow to load the data to SAP HANA
Creating Repository Users
Creating a Local Repository
Setup Central Management Server (CMC)
Setup of Data Service Job Server
Creating Central repository and using it
Loading the Data from different SAP ERPS (like ECC, CRM) using SAP BODS to DSAP HANA for COPA Scenarios, FI Scenarios, Sales Scenarios, Purchasing Scenarios, Marketing Scenarios and Opportunity Scenarios and Service Scenarios.
SMART DATA ACCESS Connecting to Remote SQL SERVER using SMART DATA Access. Creating Calculation view Using Remote DataSource. SAP RIVER.
A) Workbench User Interface Replication job editor Datastore editor Data Flow editor Monitoring editor File Format editor
B) Information Steward
Getting started with Cleansing Package Builder
About cleansing data
About cleansing packages
Cleansing package types
Create cleansing packages
Assign standard forms and variations
Updating a published cleansing package
Viewing published cleansing packages
Person and firm cleansing
05Method 3 - Data Provisioning using SLT
Positioning and Key Concepts
Overview on Configuration Aspects
Selective Data replication
06Method 4 - Data Provisioning using Direct Extractor Connection (DCX)2 topics
Using SAP provided Business Content Extractor
ABAP Data Flows for Table and Pool clusters
07Modeling30 topics
Purpose of Information Modeler
Levels of Modeling 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 for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
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 Modeling
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 Modeling Content
Manage Schemas
Import and Export data Models
Copy Information Objects
08Reporting15 topics
HANA, Reporting Layer
Connectivity options
SAP Business Objects BI 4.1
Designing Complex Universes in IDT based on HANA Tables and HANA Views
WEBi 4.0 on HANA
Crystal Report for Enterprise with HANA
Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
SAP Business Objects BI 4.1 Explorer
Designing Information Space based on SAP HANA Information Model using BO Explorer 4.1
Exploring the Data using BO 4.1 explorer based on Information Spaces created on HANA
Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection)
Analysis edition for Microsoft Excel, Microsoft Powerpoint
SAP Visual Intelligence on HANA
Crystal Reports via ODBC/JDBC Connections
Others & MS Excel 2010
09User Management6 topics
Creation of Users
Creation of Roles
Creation of Role Hierarchy
Assignment of Users to Roles
Authentication
IMCE Authorizations
10Security and Authorizations4 topics
User Management and Security
Types of Privileges
Template Roles
Administrative
11User Management2 topics
User Management (SAP BI 4.0 Integration)
User Management (Single-Sign-on SSO)
Course details
Who it is for, what you need, and how it is delivered.
Who should learn SAP HANA?
This course is designed for Data analytics professionals, Database Architects,
SAP Development &BI consultants, Data warehouse professionals
Prerequisites
Understanding on Data Warehousing Concepts
Knowledge of Database concepts
Delivery methodology
We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.
Class delivery
Live Interactive classes with expert
Certificate of completion
Earn an industry-recognised BISP Trainings certificate when you finish the course.
Yes. You may attend a demo class before enrollment for training quality evaluation, and interact one-to-one with the trainer for any specific requirement.
Can you schedule training as per my availability?
Yes. We discuss it with the trainer and schedule the training at a convenient time for you.
What if I miss a class?
You get the recorded session. You may also retake the whole training multiple times within a 6-month period with the same trainer.
Is there live project training?
Yes. The curriculum includes real-time scenarios and live project modules, with the trainer explaining every topic end-to-end.
How can I pay for the course?
Enroll securely via the payment gateway on this page using card, UPI or net-banking. EMI options are available.
More queries?
Call us at +91 769-409-5404 & +1 678-701-4914, or write to support@bisptrainings.com.
Call Us: +91 769-409-5404
