Configuring SAP HANA Cockpit

To monitor and manage databases, you need to register the system database and all the tenants of an SAP HANA database system as a database in SAP HANA cockpit. These databases can be grouped together and assigned to dedicated users.

You can register an SAP HANA system to the SAP HANA Cockpit Manager using the COCKPIT_ADMIN user account credentials. This user account is automatically created during the installation of SAP HANA cockpit.

To register a database, follow the guided procedure steps and provide the required information, like host, instance number, technical user, connection type, and group assignment.

Before you can register an SAP HANA tenant or system database as a database in SAP HANA cockpit, you need a technical user in that specific tenant or system database. This technical user can easily be created during the Register Database procedure in SAP HANA cockpit.

When you create the technical user during the Register Database procedure, the required system privileges are assigned automatically. The technical user requires the CATALOG READ system privilege, and SELECT on the _SYS_STATISTICS schema.

It is also possible to create the technical user by using the SQL console from SAP HANA database explorer.

In the SAP HANA database explorer SQL console, you can create this user manually and grant the minimum necessary authorization by executing the following SQL commands:

123
CREATE USER <username> PASSWORD < password> NO FORCE_FIRST_PASSWORD_CHANGE;
GRANT CATALOG READ to <username>;
GRANT SELECT on SCHEMA _SYS_STATISTICS to <username>;

A group is a named set of one or more registered databases. A group associates a set of registered databases with cockpit users. In this way, the cockpit users can use SAP HANA cockpit to manage and monitor the databases within their responsibility. Use the Cockpit Manager application to assign databases and cockpit users to groups.

A registered database can belong to a usage type group. The usage type groups Development, Test, and Production are automatically created when the database is assigned a usage type of Production, Test, or Development. The usage type is assigned during the installation of an SAP HANA database, but can be changed after the installation.

To create a group, follow the guided procedure steps and provide the required information like group name, database assignment, and cockpit user.

The cockpit administrator can use the groups to view and administrate similar SAP HANA databases. The cockpit administrator can also control which other users have access to a database.

In order to have access to a database, a cockpit user must belong to one of the groups that you have created containing the database. It is not possible to assign users to an auto-created group, so to manage the databases, you have to create your own groups.

You can choose to hide one or more of the auto-created groups through the Cockpit Manager by selecting Settings, then Display, and deselecting or selecting each box. Opting to hide the auto-created groups does not affect the system usage type associated with the database. It simply prevents the cockpit from organizing the display of databases by auto-created group.

After you have finished the configuration of your landscape in Cockpit Manager application, you can access the SAP HANA cockpit to monitor and administer the SAP HANA systems in your landscape.

With the Cockpit Manager application, you can create cockpit users and assign them to groups of databases.

Cockpit users are SAP HANA cockpit application users. Therefore, they are separate from the database user credentials associated with the database managed and monitored through the cockpit. Each cockpit user can be assigned access to groups of databases.

COCKPIT_ADMIN, created during the installation, is the administration user who can create other cockpit users and assign roles and permissions.

To create a cockpit user, follow the guided procedure steps and provide the required information, like user name, password, and group assignment.

When a cockpit user is assigned to a group, this user can monitor each of the databases within that group. The user also sees the aggregate data for the group. If no groups currently exist, you can add users to a new group after you have created the group.

A cockpit user that is not assigned to any groups, or is assigned to an empty group, can access the SAP HANA cockpit. However, the cockpit shows no data because the cockpit user is not assigned to any database.

From the aggregated health view, you can navigate to the SAP HANA Database Overview page. The Database Overview page displays the detailed status of the selected SAP HANA database.

The cards in the detailed Database Overview provide information about the status of the SAP HANA database. The screen can be configured to auto-refresh. This ensures the cards always display the current monitoring information.