There are various tools that can be used to perform administration tasks in single container or multiple container system. All the tools are used to perform database level administration and the system level administration can be performed using SAP HANA Cockpit.

Following are common HANA Administration Tools −

SAP HANA Cockpit

This is an administration tool to manage your SAP HANA system and is based on SAP Fiori Launchpad based navigation to access long range of HANA applications. SAP HANA cockpit can be accessed via a web browser.

SAP HANA Studio

Using SAP HANA Studio, you can perform system administration and monitoring activities in a distributed environment. You can create users with different access privilege, backup and recovery, and data provisioning using HANA Studio.

HANA Studio is an Eclipse-based tool and is available for Window, Mac, and Unix OS.

SAP HANA Lifecycle Manager

This is an administration tool to manage SAP HANA components after installation. You can add/remove hosts or rename using the Lifecycle Manager.

SAP Solution Manager

This tool is used to integrate your SAP HANA platform with other business solutions.

SAP HANA HW Configuration Check

You can use this tool to check the interoperability of SAP HANA system with enterprise storage.

SAP HANA XS Administration Tools

This tool is used to manage and administration applications developed on the top of HANA database sing XS Classic model and XS Advanced model. You can perform security and define user authentication for applications developed and hosted in SAP HANA environment.

SAP HANA Application Lifecycle Management

This tool is used to perform the transport of delivery units, upload or download transports and to perform transport management tasks.

SAP HANA Admin – Cockpit

You can also use SAP HANA Cockpit in an offline mode to perform administration tasks – starting HANA system to fix performance-related issues.

SAP HANA Cockpit with Fiori-based Launchpad shows the content in the form of tiles arranged in groups. Using these tiles, you can access individual applications and can also access app-specific data for immediate review.

You can also perform a drill on these tiles to see the detailed information about specific applications.

Following roles are required to open and access tile-based SAP HANA Cockpit −

sap.hana.admin.roles:: Monitoring or sap.hana.admin.roles:: Administrator

To open SAP HANA Cockpit via a web browser, you need to have browser support SAPUI5 library sap.m.

You can also open SAP HANA Cockpit via HANA Studio. Navigate on HANA system → Configuration and Monitoring → Open SAP HANA Cockpit.

SAP 212

A single-container system is accessed through the following URLs −

https://<host_FQDN>:43<instance>/sap/hana/admin/cockpit
https://<host_FQDN>:80<instance>/sap/hana/admin/cockpit

Host name is SAP HANA system name and Instance number is SAP HANA system Instance number.

SAP 22

SAP HANA Cockpit for Offline Administration

You can also open HANA Cockpit in an offline mode using a web browser or via standard SAP HANA Cockpit tool. This is used to perform administration tasks – starting SAP HANA system, other offline administration activities.

To login to SAP HANA Cockpit for offline administration, following perquisites should be met −

You need to have credentials for Operating System user <sid> admuser created at the time of installation.
Port 1129 should be open for communication.
You need to have browser support SAPUI5 library sap.m.

There are two ways to open SAP HANA Cockpit in an offline mode −

Using the Web Browser

Enter the following URL in the web browser.

https://<host>:1129/lmsl/hdbcockpit/<sid>/index.html

You can directly enter the above URL in the web browser and it opens SAP HANA Cockpit for offline administration. You have to authenticate via Operating system user <sid> admuser.

This method is not recommended as it transfers the password in plain text via HTTP.

Using the Standard SAP HANA Cockpit

You can open SAP HANA cockpit by entering the following URL.

https://<host_FQDN>:43<instance>/sap/hana/admin/cockpit

Navigate to SAP HANA Database Administration group → Select SAP HANA Cockpit for offline administration as shown in the 2nd last box of the following screenshot.

SAP 23

There are various options under SAP HANA Cockpit for offline mode, when you click on the options as shown in the following screenshot −

SAP 24

Start, Restart and Stop

This tile shows the status of your SAP HANA system. Following are the most common status messages you can see −

Running
Stopping
Stopped
Initializing

When you click on this tile, it allows you to start, stop, and restart a server.

Diagnosis Files

This is used to open the log files, trace results and other diagnosis files. You can use this tile to get the diagnosis files in zip format and it can be attached to support messages.

It is also possible to search diagnosis files to find specific words and phrases.

Troubleshoot Unresponsive System

This tile is used to access the information required for troubleshooting performance issues.

SAP HANA Documentation Tile

Using this tile, you can see the documentation of all the administrative tasks that you can perform in SAP HANA Cockpit for offline administration.

SAP HANA Cockpit

This tile is used to access the main window where you can access all applications for performing SAP HANA administration online. In case of system replication, this option is only available with primary system.

Note − In multitenant database containers, when you use Start option under SAP HANA Cockpit offline administration → Star, Restart, Stop tile → Footer bar, Start System – this options restarts all the tenant database systems.

When you stop a system, the status of the system under Start, Restart, and Stop tile is changed to Stopped (red) as seen in the following screenshot.

SAP 25

So, this brings us to the end of blog. This Tecklearn ‘SAP Hana Admin Tools’ blog helps you with commonly asked questions if you are looking out for a job in SAP Hana Administration and SAP Domain. If you wish to learn SAP Hana Administration and build a career in SAP domain, then check out our interactive, SAP HANA Administration Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-hana-administraion/

SAP HANA Administration Training

About the Course

SAP HANA Administration training will help you learn SAP HANA administration tools, security and user management, system management and availability, data provisioning and integration with non-SAP systems and more. You will deploy SAP HANA Studio, automate through OS scripts, command line admin tools through hands-on projects and case studies. This course is designed to clear the HA200 SAP HANA Operations and Administration Certification conducted by SAP and helps you get the best jobs in top MNCs.

Why Should you take SAP HANA Administration Training?

The average salary for SAP HANA Database Administrator ranges from approximately $65,843 yearly for Administrator to $143,051 yearly for Enterprise Architect. – Indeed.com
SAP HANA is one of the top tools for working with real-time data due to the transformational nature of this tool. The role of an SAP HANA Administration and Operations personnel is critical of the success of SAP HANA deployment in any industrial set-up.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Overview of SAP HANA

Overview of SAP HANA
Features and Benefits of SAP HANA
SAP HANA Components
Concept of SAP HANA guides
Scenarios in SAP HANA Administration

Architecture of SAP HANA

What is SAP HANA persistence?
Concept of Sizing in SAP HANA
Process of achieving scale out in SAP HANA
How SAP HANA achieves in-memory computation
Concept of columnar database
How SAP HANA is so fast with comparison to other tools

SAP HANA installation

Overview of SAP HANA tools

SAPA HANA Studio for Administration activities in SAP HANA
Accessing local and remote HANA systems using Client Tool
Monitor, Control, Configure and Administer the SAP HANA database using DBA Cockpit
Using HANA Studio Information modelling and data provisioning in HANA database
SAP HANA Transport

SAP HANA Operations

Privileges in HANA
Configure Password Policy and create user in SAP HANA
Auditing in SAP HANA

SAP HANA Smart Data Access

Data Provisioning in SAP HANA

Leveraging SAP HANA technology and integration architecture for enriching, cleansing and transforming data from disparate sources
Data replication with the SAP Landscape Transformation (SLT)
Implementing SLT Configuration with SUSPEND LOAD

SAP HANA Operations

Create Repository and Job Server
SAP GRC Architecture

Administration Operations in HANA Studio

Updating HANA database using lifecycle management
Security in SAP HANA
Sessions and Transactions in SAP HANA
Configure System Replication using HANA Cockpit

Migration to SAP HANA using DMO

Performance Monitoring and Analysis in SAP HANA

Got a question for us? Please mention it in the comments section and we will get back to you.

563