Opening SAP HANA Database Explorer

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Open the SAP HANA Database Explorer for SAP HANA Cloud databases

Opening SAP HANA Database Explorer

Lesson Overview

In this lesson, you will learn how to open and navigate the cloud version of the SAP HANA database explorer.

Business Case

As a database administrator, you often need to directly work with tables, schemata and so on. For this the SAP HANA cloud database provides the SAP HANA database explorer.

SAP HANA Database Explorer

Navigate from the Trial home page to your dev space (1) where you will find the SAP HANA Cloud. Click the SAP HANA Cloud (2) button to get an overview of the available SAP HANA Cloud database instances.

Select the Manage SAP HANA Cloud (3) button to open the SAP HANA Cloud Central. From there you can start the SAP HANA Cloud, Database Explorer.

Note
It is also possible to open the SAP HANA database explorer directly from the SAP HANA Cloud Overview page by selecting the Actions drop-down menu.

To administer your SAP HANA Cloud database instance press the Manage SAP HANA Cloud (3) button. This will open the SAP HANA Cloud Central where you get a detailed overview of all the SAP HANA Cloud databases managed by you.

The SAP HANA Cloud Central (1) opens in a new browser tab. This makes it easier to navigate between the SAP HANA Cloud Central and SAP BTP Cockpit.

Press the °°° (2) button to open the Actions Menu for the selected cloud database. From the Actions Menu select the Open in SAP HANA database explorer (3) option.

The SAP HANA database explorer - Overview page (1) opens in a new tab and displays a navigation panel (2) and a SQL Console (3) window.

Note
In the SAP HANA database explorer, by default, the user DBADMIN is used to connect to the databases.

In the navigation panel (2) you can add (+ button) or remove databases.

Open SAP HANA Database Explorer

Save progress to your learning plan by logging in or creating an account