Illustrating SAP HANA Administration Tools

Objectives

After completing this lesson, you will be able to:

  • Identify the available SAP HANA administration tools

SAP HANA Administration Tools: Overview

Several tools can be used for the administration of SAP HANA.

Following the cloud strategy of SAP, SAP HANA offers Web-based tools for monitoring and administration.

SAP HANA Cockpit

The SAP HANA cockpit provides a single point of access to a range of tools for the administration and detailed monitoring of SAP HANA databases. For example, you can use the cockpit to start and stop systems and databases, monitor databases, configure system settings, manage users and authorizations, and do backups.

The cockpit also integrates the SAP HANA database explorer and the SAP HANA SQL analyzer. The database explorer allows you to query information about the database and view information about catalog objects, while the SQL analyzer helps you to understand and analyze the execution plans of queries.

The SAP HANA cockpit is a Web-based HTML5 user interface that you access through a browser. It runs on SAP HANA extended application services, advanced model (XS advanced). It can be used to administer and monitor SAP HANA databases running SAP HANA 1.0 SPS 12 or higher.

SAP HANA Database Explorer

Use SAP HANA database explorer to query information about the database, as well as view information about your database's catalog objects.

SAP HANA database explorer is integrated into the SAP HANA cockpit. SAP database explorer contains features and functions required by both database administrators and developers.

SAP HANA hdbsql

SAP HANA HDBSQL allows you to execute SQL statements and database procedures, as well as query information about the database and catalog objects, from the command line.

SAP HANA HDBSQL is a command-line tool installed on the SAP HANA server. It is available at /usr/sap/<SID>/HDB<instance>/exe. It can be used to access databases on both local and remote computers.

SAP HANA Studio

As an administrator, you use the SAP HANA studio, for example, to start and stop systems, monitor the system, configure system settings, and manage users and authorizations. Developers can use the SAP HANA studio to create content such as modeled views and stored procedures in the SAP HANA repository.

Note

SAP HANA studio is deprecated. See SAP Note 2396214 - Transition to SAP HANA Extended Services Advanced and SAP HANA Cockpit.

SAP Solution Manager

SAP Solution Manager is a central hub for the holistic lifecycle management of your SAP solution landscape. It contains central alerting infrastructure and business process analytics, end-to-end root cause analysis, monitoring, and a unified alert inbox for the entire solution landscape, guided issue resolution, and business process reporting.

SAP Solution Manager runs on SAP NetWeaver AS for ABAP.

DBA Cockpit

The DBA Cockpit is a platform-independent tool provided by ABAP systems, which you can use to monitor and administer your SAP HANA database.

SAP Landscape Management

SAP Landscape Management is a powerful automated solution designed to simplify, centralize, and orchestrate the management and operations of the entire application landscape powered by SAP HANA. With the enterprise edition of SAP Landscape Management, you can perform various operations on SAP HANA instances, such as start, stop, monitor, or system replication operations.

SAP Landscape Management allows you to automate advanced SAP HANA operations and avoiding business downtime during maintenance activities.

It is a central landscape management solution running SAP NetWeaver AS for Java.

Log in to track your progress & complete quizzes