Skip to Content

SAP HANA Database Explorer Overview

Learn about the SAP HANA database explorer and how to start using it with the SAP HANA Cloud trial, free tier, or SAP HANA, express edition.
You will learn
  • About the features provided by the SAP HANA database explorer
  • Details about the version differences between the SAP HANA database explorer in SAP HANA Cloud and in an on-premise installation (SAP HANA, express edition)
  • How to get started with the SAP HANA Cloud trial, free tier, or SAP HANA, express edition

danielvaDan van LeeuwenAugust 17, 2022
Created by
danielva
October 20, 2020
Contributors
danielva
thecodester

Prerequisites

  • A machine that can run SAP HANA, express edition if the SAP HANA Cloud trial or free tier is not used

Access help from the SAP community or provide feedback on this tutorial by navigating to the “Feedback” link located on the top right of this page.

  • Step 1

    The SAP HANA database explorer is a web-based tool for browsing and working with SAP HANA database objects such as tables, views, functions, stored procedures, importing and exporting data, debugging SQLScript, executing SQL statements, creating remote sources, working with multi-model data such as graph, spatial and JSON collections, viewing trace files, and troubleshooting.

    It was previously named SAP HANA Runtime Tools (HRTT) and was introduced in SAP HANA 1.0 SPS 12. As it is web-based, individual users do not need to worry about installing the software or applying patches. The SAP HANA Cloud version offers support for data lake Relational Engine connections, and as of March 14 2022, support for the data lake Files container.

    database explorer

    The following tools also provide the ability to execute SQL queries.

    The SAP HANA database explorer can be opened from multiple locations as shown below:

    • From the SAP Business Technology Platform (SAP BTP) Cockpit from an SAP HANA or Data Lake instance.

      opening the SAP HANA database explorer from the SAP BTP Cockpit
    • From SAP HANA Cloud Central on either a SAP HANA or Data Lake with Relational Engine enabled.

      opening the SAP HANA database explorer from SAP HANA Cloud Central
    • From the SAP HANA cockpit

      opening the SAP HANA database explorer from the SAP HANA Cockpit
    • From the Business Application Studio in a SAP HANA Native Application development space

      BAS SAP HANA Dev Space

      The command palette or the SAP HANA Projects panel can be used to open the SAP HANA database explorer.

      BAS Open SAP HANA Database Explorer
    • From the SAP Web IDE for SAP HANA with the extension enabled

      opening the SAP HANA database explorer from the SAP Web IDE

      Once the SAP HANA database explorer extension is enabled, the SAP HANA database explorer can be shown by selecting the icon highlighted above.

    The following are some related documentation links for SAP HANA and the SAP HANA database explorer.

    Version Notes
    SAP HANA Platform 2.0 Released in November 2016. Current version is 2.0 SPS 06, which was released in December, 2021
    SAP HANA Platform 2.0, SAP HANA Database Explorer Current version is 2.14, which was released in December 2021
    SAP HANA Platform 2.0, SAP HANA Database Explorer What’s New What’s new since the previous on-premise release. New features are released approximately twice per year
    SAP Web IDE for SAP HANA SAP Help documentation set
    SAP HANA, express edition Released in September 2016. Current version is 2.0 SPS 06
    SAP HANA, express edition, release notes for SPS 06, revision 61 Note that the version of the Database Explorer (HRTT) for this release is 2.14
    SAP HANA Cloud Released in March 2020 with quarterly new releases
    SAP HANA Cloud, SAP HANA Database Explorer New features are released as often as every two weeks.
    SAP HANA Cloud, SAP HANA Database Explorer What’s New What’s New. This link is also available from the Help menu in the database explorer. A filter can be applied to limit results to SAP HANA database explorer updates only.
  • Step 2

    The SAP HANA database explorer releases independently of SAP HANA. New features appear first in SAP HANA Cloud and are available to the on-premise version if applicable, in a later release. Features are also enabled based on the database being connected to. For example, the ability to import and export from cloud storage providers is a feature of an SAP HANA Cloud database.

    The screenshots below show the version of the SAP HANA database explorer in SAP HANA Cloud and on-premise.

    The image below shows the SAP HANA database explorer running in SAP HANA Cloud.

    latest available version in SAP HANA Cloud

    The image below shows the SAP HANA database explorer running in an on-premise installation.

    latest available version for on-premise

    For the on-premise edition, only the currently released version receives patches. For example, now that version 2.14.X has been released, there will no longer be fixes made to the 2.13.X release. For additional details see SAP Note 2433181 - SAP HANA 2.0 Cockpit Revision and Maintenance Strategy.

    The SAP Software download links (requires an S-User ID to access) below are for the on-premise version of the SAP HANA Cockpit, the SAP Web IDE, and the SAP HANA database explorer. These pages also contain links to release notes that describe fixes made to each release.

    SAP HANA Cockpit Download from SAP Software Downloads (Includes the SAP HANA database explorer)

    SAP HANA Web IDE Download from SAP Software Downloads

    SAP HANA Runtime Tools 2.0 (Adds the SAP HANA database explorer to the SAP HANA Web IDE)

  • Step 3

    To complete the tutorials in this group, an SAP HANA instance is needed. Steps 3 and 5 in this tutorial provide two different, free options that can be used to set up an SAP HANA instance. Only one of these steps needs to be completed if you currently do not have access to an SAP HANA instance. When creating an SAP HANA instance, a Data Lake is not needed. Creating a Data Lake will be covered in a later tutorial.

    Continue on to the next tutorial in this group once you have created an SAP HANA Cloud instance as shown below.

    SAP HANA Cloud Trial instance

    Note that the SAP HANA Cloud trial or free tier instances are shut down overnight and will need to be restarted before working with them the next day. Details on how to start or manage your trial or free tier instance can be viewed at Provision an Instance of SAP HANA Cloud, SAP HANA Database or via the Cloud Foundry CLI in the next step.

    The instructions on how to setup a free SAP HANA Cloud trial or free tier within SAP BTP are well covered in a number of other sources listed below.

    For more information on the SAP BTP see the following:

  • Step 4

    The Cloud Foundry Command Line Interface (cf CLI) provides users another option for managing their SAP HANA Cloud instances. The software can be downloaded from the Cloud Foundry Foundation and is available for Windows, Linux, and macOS operating systems. The following steps will demonstrate how to start and manage an SAP HANA Cloud instance using the CLI.

    1. Complete the installation process by following the guide Installing the cf CLI.

    2. Copy the API endpoint from your SAP HANA Cloud account. This information can be found on the Overview page of your SAP BTP Cockpit. The API endpoint is listed under the Cloud Foundry subheading. Save the API endpoint for use in the next step.

      Find the API Endpoint from the BTP Cockpit
    3. In your terminal, type the following command. Replace the API endpoint with the one you copied from the previous step:

      Shell
      Copy
      cf api https://api.cf.XXXX.hana.ondemand.com
      

      You will be asked to login with the email and password on your SAP HANA Cloud account. Finally you will be prompted to select your targeted space within your account. Additional details on logging in can be found at Getting Started with the CF CLI.

      Cloud CLI API
    4. Next, view the list of services.

      Shell
      Copy
      cf services
      
      cloud foundry services
    5. The hana service can be started with a file named start.json with the below contents and the following command.

      JSON
      Copy
      {
      	"data":
      	{
      		"serviceStopped":false
      	}
      }
      
      Shell
      Copy
      cf update-service HC_HDB_Trial -c start.json
      
      starting a SAP HANA Cloud database

    For more information on the operations available with the CLI, refer to the documentation Using the Cloud Foundry CLI with SAP HANA Cloud.

    Note that SAP HANA Cloud Central provides an option in the actions menu to copy the JSON configuration of a running instance. This can be used with the cf create-service command perhaps to create multiple instances of a database configured in the same way.

    copy Configuration

    Another tool that can be used to manage a SAP HANA Cloud instance is the SAP Automation Pilot. It provides commands for working with an SAP HANA Cloud instances as well as Cloud Foundry applications. The below is an example command used to stop an SAP HANA Cloud instance.

    stop SAP HANA Cloud command

    The Automation Pilot also provides a scheduler and integration with SAP Alert Notification Service. For further details see Take Action Following a SAP HANA Cloud Database Alert with SAP Automation Pilot.

  • Step 5

    This step only needs to be completed if you currently do not have access to an SAP HANA instance and did not setup an SAP HANA instance through the SAP HANA Cloud as explained in step 3.

    An alternative option to using the SAP HANA Cloud trial or free tier is to use the SAP HANA, express edition. SAP provides a free, streamlined version of SAP HANA that runs on developer laptops called SAP HANA, express edition.

    SAP HANA runs on certain versions of Linux. SAP HANA, express edition provides a binary install as well as virtual machine images that can be run on Microsoft Windows, macOS, and Linux machines. This is described in the SAP HANA, express edition documentation under the implement section. A database-only option and a database + XS Advanced Applications option are available. The database + XS Advanced Applications install includes the SAP HANA cockpit, the SAP HANA database explorer, and the SAP HANA Web IDE for SAP HANA.

    Database + XS Advanced Applications, requires sufficient disk space and memory (32 GB).

    Once installed, a useful starting point is the page below.

    XSA is up and running

    It contains links to the SAP Web IDE for SAP HANA, SAP HANA cockpit, and the SAP HANA cockpit manager.


    Congratulations! You have configured an instance of SAP HANA, either through the SAP HANA Cloud trial, free tier, or SAP HANA, express edition. You’ve also learned how to start, stop, and manage an instance of SAP HANA Cloud via the Cloud Foundry Command Line Interface.


    Select all the statements that are true:

Back to top