Bundle Course - SAP HANA and SAP HANA Admin
Learn SAP HANA concepts & system administration using SAP HANA Cockpit & HANA Studio. Monitor, tune, troubleshoot HANA systems. Manage users & roles.
85% Started a new career BUY THIS COURSE (
USD 23 USD 69 )-
93% Got a pay increase and promotion
Students also bought -
-
- Bundle Course - SAP Technical (ABAP - ABAP on HANA - BO - Data Services - BW/4HANA - HANA)
- 80 Hours
- USD 23
- 220 Learners
-
- Bundle Ultimate - SAP S/4HANA (Finance - TRM - MM - EWM - TM - Logistics)
- 150 Hours
- USD 31
- 2091 Learners
-
- Career Path - Database Administrator
- 50 Hours
- USD 45
- 255 Learners

Courses included in Bundle Course - SAP HANA and SAP HANA Admin are:
1) SAP HANA
2) SAP HANA Admin
SAP HANA is an in-memory database technology encompassing various components which makes it a complete package or suite for a centralized ERP system and business application development. The multi-core processing engines process data parallels within different columns of the same database and return data to the clients in no time. SAP HANA is the first technology which is used for both OLTP and OLAP application processing.
In-memory technology promises the extremely fast analysis and aggregation of huge amounts of data. It removes the limits known from traditional databases. The software has been optimized to take advantage of modern hardware architectures and heavily uses parallel processing. SAP Hana is an in-memory, column-oriented RDBMS. It serves as a database server that stores and retrieves huge volumes of data I real-time.
SAP HANA administration deals with managing SAP HANA system in a single and distributed system environment. SAP Hana Administration includes the following activities:
1) SAP HANA Administration Tools
2) SAP HANA Lifecycle Mangement
3) SAP HANA Backup and Recovery Management
4) SAP HANA Security and User Management
5) SAP HANA Multiple Host system management
The roles and responsibilities of SAP HANA Administrator are:
a) Create and configure connection SLT to HANA
b) Create and configure connection SLT TO ECC
c) Initial Configuration of SLT Replication Server
d) Configure alerts in DS, ST to monitor load failures
e) Hana Database security
f) Expertise in Hana studio
g) Integration of ECC with HANA Database using the SLT Replication Servers or services
h) Starting and stopping of Sap Hana systems
Uplatz provides this complete end-to-end SAP HANA and HANA Administration course covering all topics of SAP HANA and SAP HANA Admin in detail.
Course/Topic 1 - SAP HANA - all lectures
-
In this first session of the SAP HANA tutorial, you will get a brief introduction to what exactly is SAP HANA, along with a pictorial representation of SAP HANA Architecture, HANA Software Editions, terminologies used in SAP HANA, the hardware innovations involved in SAP HAHAN, understanding the Columnar Data Storage, HANA Appliance and lastly the SAP HANA Editions.
-
In this video, you will learn about the Architecture of SAP HANA, starting with the approach for data transfer, components of SAP HANA, the Database Engine view, SAP HANA Appliance, the different views of SAP HANA like the Data Loading View, Reporting View and the Administrative View. Furthermore, you will also be learning about the SAP HANA System Landscaping.
-
This video is a complete practical session on the Data Services involved in the SAP HANA System Landscaping. The trainer will be guiding you with a step-by-step implementation of the whole process.
-
This video is a continuation of the SAP BODS Data Services session where you will learn some more configuration steps involved in the SAP Data Services of the SAP HANA System.
-
In this video, you will get a brief overview of LT Replication Server, learning concepts on SLT Environment Flow, setup of LT Replication Server like Installation Aspects, Configuration Steps, and the Setup Data Replication in SAP HANA. Furthermore, you will be learning about the key benefits of LT Replication Server, the architecture of TDMS Technology, SLT Replication Key Building Blocks, Technical Requirements, and System Set-up Information, SLT Replicator Configuration, details on Transformation Capabilities, Data Processing and Transformation Steps, Parameter based rules and many more.
-
This video will teach you about the concept of Replication in the SAP HANA system where you will be learning about the 4 different ways of loading data into the SAP HANA database. You will also be learning about the HANA Appliance Server Configurations which are the Scale Up and Scale Out configuration. Furthermore, you will be learning about the SAP HANA System Sizing Guidelines and the complete work process of these will be shown by the trainer in the SAP system.
-
In this SAP HANA video, you will learn about the different HANA Studio-Features like Modeling, Data Preview, Import/Export, and others. You will also learn about the HANA Studio Terminologies like Data Views and procedures. Further, you will learn the practical steps involved in creating an Attribute View which will be shown in the SAP system along with the Customer Attribute View.
-
In this video, you will learn how to create package in Product or Material View along with getting the knowledge on Analytical View, Set Parameters, Table Selection, and creating Location Attribute View. You will also learn to create and maintain Operating Concern, its characteristics, database structures in CO-PA, and others.
-
This video is a completely practical tutorial on how to create Location View in the SAP HANA System. You will be shown by the trainer a complete step-by-step process of how to do the work process in the SAP system.
-
In this HANA tutorial, you will learn the whole work process of SLT Based Table Data Provisioning with every step being shown in the system. You will also learn Actual_AView and the Plan_AView and the concepts involved in both in the system.
-
In this video, you will get a brief overview on the Analytics on HANA with the Scale Up Configuration, the client and connectivity options, HANA Analytics Supported Interface, the Reporting & Dashboard Overview, and under it the Semantic Layer Overview, Information Design Tool, the Universe Design Steps and these will be shown by the trainer in the SAP HANA system.
-
In this video, you will be learning about the Analytical Reporting in the SAP HANA, and under it, you will learn about the BOBJ Explorer Set-up with an overview of what is BOBJ Explorer, which will be shown in the system by the trainer. Further, you will get the knowledge on the BOBJ Analysis for Office. You will also get recommendations on Configuration, Information Design Tool, BusinessObjects Explorer 4.0, and Web Intelligence 4.0.
-
In this video, you will learn about the complete SAP HANA System Administration, starting with the In-Memory Database (IMDB) Installation and the steps involved in it. This will be shown in the SAP system by the trainer. Along with this, you will also learn about the Enterprise Server Configuration, Scale Up configuration, Distributed System Handling, Distributed System Landscape, Monitoring the Landscape, and a pictorial representation of the Disaster Tolerance Hardware along with showing it in the SAP HANA System.
-
This is a continuation video to the previous session where you will be learning about the SAP HANA Database with monitoring the landscape, Multi Version Concurrency Control (MVCC), Persistence Layer, the concept of power failure deleting in-memory data and the backup process, disk failure, User Management and Security, HANA Customer Support and SAP Connection, a picturesque view of Creating Users, Managing Users and Assigning Security. You will also be learning about the User and Role concept which will be shown in the SAP system along with the User Provisioning and User Management, assigning Privileges to Roles, creating Role to User, types of Privileges in HANA, and the concept of Analytic Privileges.
-
In this video you will be learning about the Migration of Database in the SAP HANA system, starting with the concept of In-Memory optimized InfoCube which will be shown in the SAP system, a diagrammatic explanation of the In-Memory optimized InfoCube Design in SAP BW, and the overview of Inventory Management with the Conversion Steps and Log Overview.
-
In this video, you will get an introduction to SAP BOBJ Data Services, starting with the Enterprise Information Management (EIM), Business Objects Data Integrator, Data Services Usage, and Architecture. You will also learn about the Data Services Repository and its types, the Object Hierarchy, a brief overview of Work Flow shown, and the complete process in the SAP system.
-
In this HANA tutorial, you will be learning about the ERM, its entities and their relations, the OLAP Database design, and the 4 schemas of MDM. You will get a brief training on the Star Schema as well.
-
In this last session of the SAP HANA training, you will be learning about the LT Replication Server, showing its details in the SAP system, the new update in the SAP BO Data Services 4.0. Along with this, you will also learn about the SLT Environment Flow, the set-up of LT Replication Server with its configuration steps, what are the key benefits of LT Replication Server for SAP HANA, the Architecture of SAP TDMS Technology, SLT Replication Key Building Blocks, the Technical Requirements, and System Set-Up Information, the configuration steps for SLT Replicator. Furthermore, you will be learning about the Events based Rules, the Extension of Tablestructures and many more.
Course/Topic 2 - SAP HANA Admin - all lectures
-
In this first video on SAP HANA Admin tutorial, you will get a brief introduction to what is SAP HANA, what is HANA database, how HANA overcomes the daily irritations like the sub-optimal execution speed, lack of transparency, reactivate business model, how HANA database is much more useful than the normal database and many more. You will also learn about the SAP HANA deployment view, the component Architecture view, the HANA individual components, a pictorial diagram showing the example of Deployment Landscape, and many more.
-
This video is about the installation of SAP HANA, starting with the SAP HANA Sizing, Main Memory Sizing, Disk Sizing, CPU Sizing, what is SAP Quicksizer, what are the requirements for the SAP HANA Single-Host and Multi-Host Database System, the basic components of the SAP HANA system, the installation of single and multiple-SID and lastly the Operating System and Hardware Requirements. Further, you will be learning about the important directories and their sizes and finally the File System Structure for a Multi-SID Installation.
-
This video is a tutorial on the SAP HANA appliance and the sizing of the components. You will get a practical demonstration on how to show certified SAP HANA appliance configurations throughout the session.
-
This tutorial will explain to you the various Lifecycle Management tools for installing SAP HANA starting with a brief introduction to SAP HANA Lifecycle Management Tools, explaining various installation methods, how to install SAP HANA as a single-host, installing and configuring SAP HANA Studio, installing the SAP HANA SHINE content and lastly, explaining a multi-host system installation.
-
This session is an exercise on installing your own standalone SAP HANA System. You will be shown the complete process during the session and lastly, how to update the SAP HANA Studio using an Update Site.
-
This session will teach you about the post-installation steps, updating SAP HANA, the revision strategy of SAP HANA and SHINE; SAP HANA Interactive Education. Here the target audience is taken as the System Administrator.
-
In this tutorial, you will learn how to update SAP HANA with a new support package along with installing the SAP HANA Interactive Education (SHINE) content. The complete and step-by-step work process will be shown throughout the session.
-
In this session, you will learn about the SAP HANA Memory Management and Data Persistence, Software Packaging, SAP HANA Roadmap and Scenarios, and the Deployment Options. Here, the target audience is the System Administrator and the complete session will be shown with a detailed explanation in a step-by-step procedure.
-
This tutorial will explain to you the different admin tools for the SAP HANA, starting with a detailed explanation on the Overview of Administration Tool, the SAP HANA Studio and SAP HANA Cockpit, the DBA Cockpit, and lastly, the HDBSQL Command Line Tool.
-
In this tutorial, you will learn about the process of starting and stopping SAP HANA, the configurations steps involved in SAP HANA, the SAP HANA Table Administration, the Periodic Tasks and the process of Transporting Changes.
-
This practice session is an exercise on the process of starting and stopping SAP HANA. You will learn the complete process of how to do it in the SAP system.
-
In this video, you will learn about the concept of Backup and Recovery, the Data Area Backup, Log Area Backup along with some additional Backup topics. You will also learn about the Recovery process, the Backup, and Recovery using Storage Snapshot, and the Database Copy.
-
This video is an exercise session on the Backup and Recovery process where you will get a complete and step-by-step explanation of the whole work process in the SAP System.
-
In this session, you will learn about the Monitoring and Troubleshooting steps involved in SAP HANA, starting with Configuring Traces, working with Diagnosis Information and Diagnosis Files, SQL Console, and Query Analysis. You will also be learning about the Monitoring with SAP Solution Manager, Remote Support, and lastly the SAP Early Watch Alert.
-
This video will show you the complete work process of how to configure SAP HANA Traces. You will learn each and every step of it during the session.
-
In this video, you will get a complete overview of the Security involved in SAP HANA along with Authentication and Authorization, encryption, and lastly the Auditing.
-
In this session, you will learn about User Management, the types of Privileges, Roles, Administrative Tasks, the information Sources of Administrators, and lastly the SAP HANA Live Authorization Assistant.
-
This video is an exercise session on Maintaining Users and Authorization in the SAP HANA system. You will be getting a detailed workaround of the entire procedure in the SAP system.
-
In this video, you will get the knowledge on the concepts like High Availability and Disaster Tolerance, starting with the Continuous Availability and then moving forward towards High Availability, the SAP HANA Scale Out and lastly the Disaster Recovery.
-
In this video, you will learn a complete step-by-step procedure of the installation of the SAP HANA Scale Out System and the whole work process associated with it.
-
This video will teach you about the Multitenant Database Containers starting with the Architecture and Technology of it, the Administration of Multitenant Database Containers, the Backup and Recovery of Multitenant Database Containers, and lastly the Appendix.
-
This last video is a post-assessment session where you will be asked some questions and based on that, your knowledge of the subject will be measured. The assessment will cover modules like SAP HANA Introduction, Installation and Post Installation, Architecture and Scenarios, Admin Tools for SAP HANA, Operations, Backup and Recovery, Monitoring and Troubleshooting, Security, Maintaining Users and Authorization and lastly about the High Availability and Disaster Tolerance.
•How to create and configure connection SLT to HANA
•How to create and configure connection SLT TO ECC
•About Initial Configuration of SLT Replication Server
•About configure alerts in DS, ST to monitor load failures
•About Hana Database security
•About expertise in Hana studio
•How to Integration of ECC with HANA Database using the SLT Replication Servers or services
•How to Start and stop of Sap Hana systems.
BUNDLE COURSE - SAP HANA AND SAP HANA ADMIN - COURSE SYLLABUS
SAP HANA 2.0
COURSE DETAILS & CURRICULUM
Lesson 1: SAP HANA Foundation
Lesson 2: Deployment Strategies
• On-Premise
• On-Cloud
• Side-Car
Lesson 3: Architecture of SAP HANA
Lesson 4: Replicating Data to SAP HANA
• Business Objects Data Services (BODS)
• SAP Landscape Transformation (SLT)
Lesson 5: SAP HANA Studio Interface
• Attribute View
• Analytic View
• Calculation View
• Catalog - Schemas, HANA Live Package
• SAP HANA - SQL Overview
• SAP HANA Transports Options
• SAP ABAP - HANASAP HANA CDS Views
Lesson 6: SAP HANA Reporting Overview (BOBJ)
• BO WEBi
• BO Crystal Reports Enterprise
• BO IDT (BO UNX)
• BO CMC (Admin-SSO)
• BO AO (Analysis Office)
• BO Design Studio
• SAP Lumira& Smart Business Client
• SAP Fiori& SAP NetWeaver Business Client7
Lesson 7: SAP HANA System Monitoring & Administration
• DBA Cockpit
• Database Migration Option (DMO)
Lesson 8: SAP HANA Security & Authorization
• User Management
• Role Management
Lesson 9: Advanced Features Overview
• SAP HANA Web IDE
• SAP Predictive Analytics on HANA
• SAP BW-BPC embedded on HANA
• SAP S/4HANA
• Rapid Deployment Solutions (RDS) for HANA
• SAP Activate Solution Manager for SAP HANA
SAP HANA ADMIN
Lesson 00 - SAP HANA ARCHITECTURE
Lesson 01 - SAP HANA Architecture
- In-Memory Computing
- Hardware-Innovations
- Software –Innovations
- SAP HANA simplified Architecture
- SAP HANA Extended Architecture
- Business Intelligence Clients with HANA
- HANA Columnar Store
- SAP HANA row store VS Columnar store
- Understanding Columnar Storage
Lesson 02 - SAP HANA Edition
- SAP HANA Enterprise Edition
- SAP HANA Enterprise Extended Edition (As of SPS03)
- SAP HANA Platform Edition
Lesson 03 - SAP HANA Sizing
- SAP HANA In-Memory Database Sizing elements
- RAM, Disk, CPU
- Memory Sizing
- Disk Sizing
- CPU sizing
Lesson 04 - SAP HANA Versions
- HANA 1.0 SPS03
- HANA 1.0 SPS04—New Features
- HANA 1.0 SPS05—New Features
- HANA 1.0 SPS06—New Features
Lesson 05 - SAP HANA INSTALLATION OVERVIEW
Lesson 06 - SAP HANA Hardware and Software Requirements
- Certified Hardware
- SLES 11 Sp1
- Preparing file system & directories
- Prepare Installation parameters
- Users created during Installation
- Required Installation media
- Prepare Installer configuration file
Lesson 07 - Installing SAP HANA
- SAP HANA unified Installer Tool
- Running Unified Installer to install the SAP HANA SERVER
- Components installed by Installer
Lesson 08 - Install HANA Client
- Available Clients on Linux
- Available Clients on windows
- Install SAP HANA Client on LINUX Host
- Install SAP HANA Client on Windows Host
Lesson 09 - Install HANA Studio
- System Requirements
- Supported Platforms
- Install SAP HANA Studio on LINUX Host
- Install SAP HANA Studio on Windows Host
Lesson 10 - Post – Installation Steps
- Starting and Stopping SAP HANA System
- Displaying Process List
- Logging on to HANA system using HANA studio
- User Security
- Configuring SUM for HANA
- Automatic Start of HANA
- Applying Support packages and Updates
- Monitoring HANA Landscape
Lesson 11 - Enabling High availability of SAP HANA
- Concept of HANA high- availability
- Disaster Tolerance
- Redundant Hardware
- Distributed System
- Standby Host
- Installation Planning for Distributed System
- Install HANA distributed system
- Monitoring and Configuring Standby Hosts
Lesson 12 - SAP HANA DATA PROVISIONING
Lesson 13 - Configuring Data Replication with SLT
Positioning and benefits of SLT for SAP HANA
Key benefits of Trigger-Based Approach
Architecture and building Blocks
Architecture for SAP Source Replication
Architecture for Non-SAP source Replication
Set-up of SAP LT replication server
Installation Aspects
Configuration Steps for SLT replication server
Setup Data Replication
Database-Supportability
Landscape strategy of SLT replication server
SLT replication server Installation Options
Technical Requirements and system setup Information
DMIS2010 and relevant Support packs
SAP Kernel and DBSL Installation
Creating RFC Connections
Creating DB Connections
Configuring and Monitoring Dashboard
Creating New Configuration for SAP source
- Creating New Configuration for NON-SAP source
- Monitoring of Replication
- Mass Transfer IDS
- IUUC Synchronisation Cockpit
- Data Transfer Monitor
- Backup and Recovery Strategy
- Data Volume Management
Lesson 14 - SAP HANA Direct Extractor Configuration Overview
- Introduction to SAP HANA Direct Extractor Connection (DXC)
- Limitations of DXC
- Setup and Configurations
- Enabling Services
- HTTP connection
- Test Connection
Lesson 15 - Configuring Data Replication with SAP BODS
- SAP BODS 4.0 and SAP HANA
- SAP BODS 4.0 Architecture
- Configuring BO Data services
- Installing HANA ODBC Driver
- Creating SAP HANA Datastore in Data Services
- Creating SAP ERP Data store in Data Services
- Configuring HANA Studio for Importing Metadata
- Import Metadata
- Mass Import
- Selective Import
- Load Data via Data services into SAP HANA
Lesson 16 - SAP HANA TECHNICAL OPERATIONS
Lesson 17 - Operate SAP HANA
- Starting & Stopping SAP HANA
- Starting SAP HANA Database
- Stopping SAP HANA Database
- Displaying Process List
- Monitoring HANA landscape
Lesson 18 - Configuring SAP HANA DB
- System Configuration Parameters
- Monitoring and system state Parameters
Lesson 19 - Backup & Recovery SAP HANA
- Need of Backup
- Backup Types
- Data Backup
- Log Backup
- Recovery Options
- Recovery in Replication Scenarios
- Backup to External Backup Destinations
- Recovery scenarios
- Power Failure
- Disk Failure
- High Availability for SAP HANA
Lesson 20 - SAP HANA Security
- Create Users
- User and Role Concept
- Creating Roles
- Assigning Privileges to Roles
- Privileges
- SQL privileges
- System Privileges
- Analytic Privileges
- Reporting and Privileges
- Modeling required privileges
Lesson 21 - SAP HANA Monitoring & Troubleshooting
- Configuring Remote Support
- Solution Manage Integration
- Remote Service Connection
- EWA for HANA
- Availability Monitoring
- Setting up Monitoring
- System Monitoring Setup
- Status Overview
- Services Overview
- System Load History
- Disk usage Details
- Checking System Configuration Alerts
Lesson 22 - Analyzing logs & traces
- Regular administration tasks
- Troubleshooting
- Analyzing performance
Lesson 23 - Software Life cycle Management
- Transporting Changes
- CTS/CTS+
- SAP HANA with CTS+
- Exporting and Importing
- Developer Mode
- Delivery Unit
- SAP support Mode
- Exporting Tables
- Updating SAP HANA
- SAP HANA Update and Patching
- SP stack Update
Lesson 24 - SAP HANA PLATFORM
- SAP HANA Native Applications
- Non-Native SAP HANA Applications
Lesson 25 - SAP HANA in Cloud overview
- Access to HANA systems in cloud
- SAP HANA Developer Edition Environment
Lesson 26 - MIGRATION TO SAP HANA
Lesson 27 - SAP BW Powered by HANA
Lesson 28 - SAP ERP on HANA
Lesson 29 - SAP CRM on HANA
Lesson 30 - SAP HANA Rapid Deployment Solutions (RDS)
The SAP HANA and SAP HANA Admin Certification ensures you know planning, production and measurement techniques needed to stand out from the competition.
SAP HANA is an in-memory database for performing real-time data analysis, and development of applications on top of real-time data. HANA administration deals with managing SAP HANA systems in a single and distributed system environment.
Integration of SAP HANA into different remote systems. Exposure to different remote access options in the HANA system. Experience in monitoring, tuning, and troubleshooting of SAP HANA systems. HANA system administration using SAP HANA Cockpit and HANA Studio.
Based on the current scenario, if you are considering the long-term benefit rather than an immediate job, SAP HANA Simple Finance Certification can be the right track for you. Getting additional skill and knowledge will always add value in your career now more than ever.
Uplatz online training guarantees the participants to successfully go through the SAP HANA and SAP HANA Admin certification provided by Uplatz. Uplatz provides appropriate teaching and expertise training to equip the participants for implementing the learnt concepts in an organization.
Course Completion Certificate will be awarded by Uplatz upon successful completion of the SAP HANA and SAP HANA Admin online course.
● SAP BW/4HANA 2.0 Delta.
● SAP Certified Product Support Specialist - SAP Commerce.
● SAP BW powered by HANA SPS12 (Edition 2016)
● Financials in SAP S/4HANA for SAP ERP Finance Experts (SAP S/4HANA 1809)
● SAP Commerce Cloud 1905 Developer.
● System Security Architect.
The SAP HANA and SAP HANA Admin draw an average salary of $98,080 per year depending on their knowledge and hands-on experience. The SAP HANA and SAP HANA Admin job roles are in high demand and make a rewarding career.
SAP certification is an excellent career option for those candidates who dream to become a successful SAP HANA consultant. There is no doubt that SAP HANA job offers complete job satisfaction with a greater salary range.
In the present job market, the SAP HANA experts are in high demand. Well, there are only some professionals who meet the needs of the SAP HANA requirements. As SAP HANA is the most challenging and demanding technology today, the SAP HANA professionals can get the average salary in the range of $51,994 – $145,093.
Note that salaries are generally higher at large companies rather than small ones. Your salary will also differ based on the market you work in.
The following are the job titles:
SAP HANA Administrator.
SAP HANA Consultant.
1) Mention what is SAP HANA?
SAP HANA stands for High Performance Analytical Appliance- in-memory computing engine. HANA is linked to ERP systems; Frontend modeling studio can be used for replication server management and load control.
2) Mention the two types of Relational Data stored in HANA?
The two types of relational data stored in HANA includes
- Row Store
- Column Store
3) Mention what is the role of the persistence layer in SAP HANA?
SAP HANA has an in-memory computing engine and access the data straightaway without any backup. To avoid the risk of losing data in case of hardware failure or power cutoff, persistence layer comes as a savior and stores all the data in the hard drive which is not volatile.
4) Mention what is modeling studio?
Modeling studio in HANA performs multiple task like
- Declares which tables are stored in HANA, first part is to get the meta-data and then schedule data replication jobs
- Manage Data Services to enter the data from SAP Business Warehouse and other systems
- Manage ERP instances connection, the current release does not support connecting to several ERP instances
- Use data services for the modeling
- Do modeling in HANA itself
- essential licenses for SAP BO data services
5) Mention what are the different compression techniques?
There are three different compression techniques
- Run-length encoding
- Cluster encoding
- Dictionary encoding
6) Mention what is latency?
Latency is referred to the length of time to replicate data from the source system to the target system.
7) Explain what is transformation rules?
Transformation rule is the rule specified in the advanced replication setting transaction for the source table such that data is transformed during the replication process.
8) Mention what is the advantage of SLT replication?
- SAP SLT works on trigger based approach; such approach has no measurable performance impact in the source system
- It offers filtering capability and transformation
- It enables real-time data replication, replicating only related data into HANA from non-SAP and SAP source systems
- It is fully integrated with HANA studios
- Replication from several source systems to one HANA system is allowed, also from one source system to multiple HANA systems is allowed.
9) Explain how you can avoid un-necessary information from being stored?
To avoid un-necessary information from being stored, you have to pause the replication by stopping the schema-related jobs
10) Mention what is the role of master controller job in SAP HANA?
The job is arranged on demand and is responsible for
- Creating database triggers and logging table into the source system
- Creating Synonyms
- Writing new entries in admin tables in SLT server when a table is replicated/loaded