Starting your SAP HANA Cloud database

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

After completing this lesson, you will be able to:

  • Start your SAP HANA Cloud database instance

Start a SAP HANA Cloud Database Instance

Lesson Overview

In this lesson, you will learn how to start your SAP HANA Cloud database instance that you previously created in your SAP Business Technology Platform (BTP) trial account.

Business Case

As a database administrator, you need to start your company's SAP HANA Cloud database deployed in the SAP Business Technology Platform.

Note
The steps to start your trial SAP HANA Cloud database instance also apply to a SAP HANA Cloud database instance that was created in an SAP Business Technology Platform (BTP) enterprise account.

Start a Database Instance using SAP HANA Cloud Central

Your SAP HANA Cloud database instance is part of the SAP Business Technology Platform, to find your SAP HANA Cloud database instance you need to perform the following steps.

  1. Logon to the SAP Business Technology Platform trial account and navigate to the SAP HANA Cloud database area by following on of these paths:
    • For an BTP trial account: <your BTP home page><your trial global account><your subaccount><your development space>from the navigation pane select SAP HANA Cloud buttonselect the button Manage HANA Cloud
    • For an BTP enterprise account: <your BTP home page>your enterprise global account>select the Subaccounts link<your subaccount><your development space>from the navigation pane select SAP HANA Cloud buttonselect the button Manage HANA Cloud
  2. A sign-in tab opens, select your e-mail address to continue the sign in process.
  3. In the new tab you are now logged on to the SAP HANA Cloud Central application.

You are now in the SAP HANA Cloud Central application where you get an overview of all the SAP HANA Cloud database instances that you have deployed in this development space.

In your SAP Business Technology Platform trial you can only deploy one SAP HANA Cloud database instance in the trial subaccount.

Note
In an SAP Business Technology Platform enterprise account, depending on your entitlements and remaining quotas, you can deploy multiple SAP HANA Cloud database instances in a subaccount.

In the SAP Business Technology Platform trial environment your applications and SAP HANA Cloud database instance are automatically stopped every day at midnight to preserve resources. This means that you need to start your SAP HANA Cloud database instance every time when you want to explore and test it's capabilities and features.

Hint
In an SAP Business Technology Platform enterprise account the applications and SAP HANA Cloud database instances are NOT stopped at midnight.

The following steps show you how to start your SAP HANA Cloud database instance:

  1. In the SAP HANA Cloud Central application, locate your SAP HANA Cloud database instance that you want to start and press the °°° (More) button.
  2. From the drop-down menu, select the Start option.

Your SAP HANA Cloud database instance is now being started. The whole start process takes around 2.5 minutes.

Start a Database Instance using Cloud Foundry CLI

It is also possible to start an SAP HANA Cloud database instance using the Cloud Foundry CLI. Before you can start a database instance, you need to install the Cloud Foundry CLI, and log on to the SAP BTP as previously explained.

Start a database using cf cli

To start an SAP HANA Cloud database using the Cloud Foundry CLI execute the following steps:

  1. Open a Linux Terminal or Windows PowerShell.
  2. log-in to the SAP BTP using the command cf login -o <organisation> -s <space> -a <API endpoint> and enter your credentials.
    • -o : The organization to connect to.
    • -s : The space to connect to.
    • -a : The API endpoint to use.
    Note
    If you use the SAP HANA Cloud trial account with one organization and space you can omit the -o, -s and -a options.
  3. To create a new database service, execute the command:
    Code snippet
    cf update-service <service name> -c
    '{"data":
        {
          "serviceStopped": false
        }
     }'
    Copy code

    Example:

    Code snippet
    cf update-service HC200-Trial-Database -c '{ "data": {"serviceStopped": false}}'
    Copy code

    The above command will start the stopped database.

Have a look at the Start and Stop an Instance Using the CLI page to have a complete list of parameters that can be used to start a database instance.

Start a SAP HANA Cloud Database Instance

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