Back to blog
Posted January 14 2021
Written by Rinaldo Morais

How to Configure the SAP HANA Cockpit 2.0

What Is the SAP HANA Cockpit?

The SAP HANA cockpit is a powerful web-based apparatus for the administration, monitoring, maintenance and development capabilities of SAP HANA systems. Unifying individual, multiple, and tenant database management, it can be used with systems running SAP HANA 2.0 and SAP HANA 1.0 SPS 12 and higher.

1 Performance Monitor_What Is the SAP HANA Cockpit_How to Configure the SAP HANA Cockpit 2.0It provides system and database administration features such as:
2 system and database administration features_What Is the SAP HANA Cockpit_How to Configure the SAP HANA Cockpit 2.0And much more!

Components of the SAP HANA Cockpit

The main components are:

  • SAP HANA Cockpit Services
    Provides the main functionalities for the managed resources.
  • HANA Cockpit Manager
    Manages all resources and creates groups of resources that other cockpit users will be able to access. A resource is an SAP HANA system, identified by a host and instance number.
  • SAP HANA XS Advanced Runtime Platform
    Provides a broad platform for the development and execution of service-oriented applications, taking advantage of SAP HANA's in-memory architecture and parallel execution capabilities.
  • Cockpit Persistence
    Provides the persistence layer by using an SAP HANA database.

3 Components of the SAP HANA cockpit_How to Configure the SAP HANA Cockpit 2.0Figure 2 - Components of the SAP HANA cockpit

SAP HANA Cockpit Deployment Options

Different deployment options are supported:

  • Dedicated hardware;
  • Shared hardware;
  • Existing SAP HANA system (shared database).

4 Dedicated hardware_SAP HANA Cockpit Deployment Options_How to Configure the SAP HANA Cockpit 2.05 Shared Hardware_SAP HANA Cockpit Deployment Options_How to Configure the SAP HANA Cockpit 2.0

 

 

 

 

 

 

 

 

 

 

6_Shared Database_SAP HANA Cockpit Deployment Options_How to Configure the SAP HANA Cockpit 2.0

This article does not cover the installation of the SAP HANA cockpit. For details about hardware and software requirements as well the installation procedure, refer to the SAP Note 2380291 (https://launchpad.support.sap.com/#/notes/2380291).

Find installation procedures on the SAP Help portal (https://help.sap.com/viewer/df02d156db744412ad1f9e887aba68ad/2.11.0.0/en-US/753d3b14872d44b9bf8bf513c0a77650.html).

Logging on to the SAP HANA Cockpit

To follow this tutorial, you will need to have access to the SAP HANA cockpit. The URL depends on the hostname and the TCP port defined during the installation. The default system ID is H4C.

DBA Cockpit’s URL: https://<cockpit-host>:<port-number>

  1. Connect to the Cockpit Manager and sign in with the username COCKPIT_ADMIN. The COCKPIT_ADMIN user and corresponding master password were established during the cockpit installation.
    7_Logging on to the SAP HANA Cockpit_How to Configure the SAP HANA Cockpit 2.0
  2. You will land on the SAP HANA cockpit Home page:

8_Home page_Logging on to the SAP HANA Cockpit_How to Configure the SAP HANA Cockpit 2.0Setting Up the SAP HANA Cockpit

After installation, several steps should be performed before other users can access the tool. None of them are mandatory since all administrative tasks can be done using the default administrator user. However, you can set up the SAP HANA cockpit, create users and segregate access to specific functions and databases as follows:

  1. Create other cockpit users and define what actions they will be able to perform.
  2. Register resources or SAP HANA systems you want to manage.
  3. Create resource groups and add registered resources to each group.
  4. Assign cockpit users access to one or more groups of resources.
  5. Determine whether you would like to configure single sign-on authentication to the cockpit and/or the registered resources.
  6. Share the credentials of the newly created cockpit users with the appropriate people, and instruct them to sign in to the SAP HANA cockpit.
    Note: A database user must be available in your SAP HANA database to allow SAP HANA cockpit to connect and view information about the database and access the various administration and monitoring applications. You may want to follow this link to confirm all required permissions: https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.04/en-US/d7d31c767207407fadb3a5ddfeec1321.html

For this tutorial, we will configure a new SAP HANA cockpit user to monitor a development-oriented SAP HANA system.

Step 1: Creating a New User

Log in with the administrator user created during the installation. In the Manage Landscape tab, select the Manage Cockpit tile. You will land on the Cockpit Manager.
9_Manage cockpit_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0Select Cockpit Users from the Categories pane on the left. Select Add a Cockpit User.
10_Cockpit user_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0Click on Create User in the lower part of the screen. Provide the technical details required and click on Step 2.
11_user details_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0

12_Create user_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0Check the Cockpit User Role box as well as both options beneath it. Click on Step 3.
13_Cockpit user role_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0Click on the Create User button.
14_create user_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.015_user created_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0

Step 2: Create a New Resource

To create a new resource (or database), you can use one of the following options:

  • Register Resource: Allows you to set up a new database by providing credentials to the system. The wizard will guide you through the configuration steps. In this tutorial, the HSD SAP HANA system has already been created.
  • Import Resource: Allows you to import a previously exported SAP HANA Studio XML landscape file or an SAP HANA Studio JSON file. The wizard will guide you through the configuration steps.

16_register or import resources_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0Select Register a Resource. Follow the wizard and provide all technical details.

Note: All resources have already been created. This tutorial does not cover resource creation.
17_register a resource_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0

18_create a resource_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0

Next, select Registered Resources from the Categories pane on the left to view the newly created resource.
19_registered resources_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.020_HSD@HSD_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0

New call-to-action

Step 3: Create a New Resource Group

Select Resource Groups from the Categories pane on the left.
21_resource groups_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0Click on Create Resource Group. Select Create Resource Group.
22_create resource groups_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0Provide the technical details required and click on Step 2.
23_group name and description_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0Select the resources to be added to this new group and click on Step 3.
24_select new resources_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0

25_add resources_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0

26_step 3_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0Select the cockpit users who will have access to this resource group and click on Create Group.

27_cockpit users_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.028_add cockpit users_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.029_create group_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.030_resource group details_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0Step 4: Logging in to the SAP HANA Cockpit

Log in with the newly created user.
31_new user created_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0When logging in for the first time, change the password.
32_change password_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0Enter the new password.
33_new password_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0

34_Development and HSD Database_Setting up the SAP Hana Cockpit _How to Configure the SAP HANA Cockpit 2.0Configuring the Database Explorer

The SAP HANA database explorer provides tools to view information about your database's catalog objects, and execute queries. It displays your database objects, grouped by schema, and contains an SQL console for executing SQL statements, an SQL analyzer for analyzing them, an SQL debugger for debugging procedures, and an MDX console for executing MDX queries.

Before you can explore the registered database, you have to add it to the database explorer. On the very first time you access this tool, you will be prompted to add a new resource.

In the Manage Landscape tab, select the Database Explorer tile.
35_Database explorer_Configuring the database explorer_How to Configure the SAP HANA Cockpit 2.0Click Yes to add a new database.
36_Add New Database explorer_Configuring the database explorer_How to Configure the SAP HANA Cockpit 2.0Select the HSD resource and click on OK.
37_HSD resource_Configuring the database explorer_How to Configure the SAP HANA Cockpit 2.0Enter the credentials required and click on OK.
38_credentials_Configuring the database explorer_How to Configure the SAP HANA Cockpit 2.0You have configured the Database Explorer. If you wish to add more resources, hit the Add (+) button.
39_Add more resources_Configuring the database explorer_How to Configure the SAP HANA Cockpit 2.0You can open the Catalog Objects, search for Database Objects and use the following functionalities:

  • Analyze and diagnose errors by tracing and debugging SQL statements and procedures;
  • Configure Tracing and view Diagnostic files;
  • Query the database and use the Statement Library to manage your database;
  • Analyze the performance of SQL statements, SQLScript procedures and functions;
  • Import and export schemas and databases.

To access these options, you can use the context menu by right-clicking the database.
40_catalog objects_Configuring the database explorer_How to Configure the SAP HANA Cockpit 2.0

Conclusion

In this article, we looked at how you can configure the SAP HANA cockpit to monitor and manage your SAP HANA databases. You will also be able to understand the most important functions provided by the tool. For any further information, contact us!

These Articles Could Also Interest You
Author slug - sébastien-castonguay
Sébastien Castonguay
 
Sébastien Castonguay
Posted June 30 2021
Author slug - marjorie-philippon
Marjorie Philippon
 
Marjorie Philippon
Posted June 17 2021
Author slug - cédric-sauzereau
Cédric Sauzereau
 
Cédric Sauzereau
Posted May 20 2021