Deploying a SAP HANA Cloud Database Instance

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

After completing this lesson, you will be able to:

  • Deploy a SAP HANA Cloud Database

Creating a SAP HANA Cloud Database

The SAP BTP Cockpit

Now that you have created a SAP.com account, and setup a SAP BTP instance most of your time will be spend in the SAP BTP Cockpit. The easiest way to get to the SAP BTP Cockpit is by using a direct link to the SAP BTP Cockpit. Choose one of the following links:

Use the following path to navigate from the SAP BTP Cockpit to the SAP HANA Cloud area:

  • On the SAP BTP Cockpit Global Account page, select the trial subaccount in the Subaccounts area. Next on the Subaccount: trial - Overview page, select the dev space in the Spaces area. The breadcrumbs area (1) shows your location in the SAP BTP.
  • On the Space: dev - Applications page, in the menu panel select the SAP HANA Cloud (2) button.

    On the SAP HANA Cloud overview page you get an overview of the status of all your SAP HANA Cloud, SAP HANA Database instances. In the trial SAP BTP account you can only create one SAP HANA Cloud, SAP HANA Database instance. In an enterprise SAP BTP account the number of database instances depends on your entitlements in the license agreement with SAP.

  • To open the SAP HANA Cloud Central where you can create a new SAP HANA Cloud, SAP HANA Database instance select the Manage SAP HANA Cloud (3) button.

The SAP HANA Cloud Central

Use SAP HANA Cloud Central to perform database administration tasks on SAP HANA Cloud databases and SAP HANA Cloud data lakes that you have access to. The following administration tasks can be performed in SAP HANA Cloud Central: 

  • Get an overview of the status of all SAP HANA Cloud instances that you can access.
  • Review notifications and alerts.
  • Check the configured memory, compute, and storage consumption of an instance.
  • Check the High Availability configuration of an instance.
  • Deploy new SAP HANA Cloud instances.
  • Change the configuration of an instance.
  • Add a data lake to an existing instance.
  • Start, stop and delete instances.
  • Recover or Recreate an instance.
  • Open the SAP HANA Cockpit for an instance.
  • Open the database explorer for an instance.

Create a Database Instance using SAP HANA Cloud Central

In the SAP HANA Cloud Central choose the Create button to start the Create Instance wizard. The Create Instance wizard is a guided procedure that will help you to setup a new SAP HANA Cloud instance. The guided procedure consists of the following steps:

The SAP HANA Cloud Central is the place to provision and manage your SAP HANA Cloud instances. In a new SAP BTP account the SAP HANA Cloud Central is empty, but with the Create (1) button you can start the Create Instance Wizard and deploy your first SAP HANA Cloud instance.

In the first step of the Create Instance Wizard, you need to decide which type of instance you want to create. The following options are available:

  • SAP HANA Cloud, SAP HANA Database provides an in-memory and multi-model database system to store and analyze relational but also document data which allows for real-time data analytics and transactional processing in one combined system. The in-memory database can handle OLAP and OLTP workloads, setup hybrid Extension to on-premise SAP HANA systems and can be associated with a data lake instance.
  • SAP HANA Cloud, Data lake SAP HANA data lake efficiently and securely stores, manages, and analyzes large amounts of structured, semi-structured and unstructured data. The data lake instance manages access to files in the data lake through Files component and can be used for high performance analysis on petabyte volumes of relational data with HANA Cloud, data lake Relational Engine.
Caution
In this learning material the steps to create a SAP HANA Cloud, SAP HANA Database will be explained. The follow-up steps for the other choices will be different.

In the step you need to provide the location, instance name, description and the administrator password.

  • In the (1) Location area you need to fill-in the location space, which is the Cloud Foundry Organization name and the Cloud Foundry Space name. If your company has multiple Organizations and Spaces created for different projects, then select the correct Organization and Space from the drop-down menus.

  • In the Basics area you need to specify the database instance name and description of the SAP HANA database instance you want to create. An instance in SAP HANA Cloud is like a tenant for a on-premise SAP HANA database and isn't restricted to 3 characters.

    Note
    As of QRC 03/2022 the database administrator can also choose which version to install. The selection is two releases in the past plus the current release. This means with release QRC 03/2022, you could also select QRC 02/2022 or QRC 01/2022 for installation.

    You also need to specify the password for the database administrator user account DBADMIN that will be created and assigned to your SAP BTP account. The password need to be at least 8 characters long, with one UPPER and two lower case letters and one number.

There is no SYSTEM user available, you need to use the DBADMIN user for the initial setup tasks. The DBAMIN is the "super" user for your SAP HANA Cloud, SAP HANA Database instance. This user shouldn't be used on a daily basis. Create new user accounts and roles for all users accessing the database.

Specify the required RAM and disk storage (1) for this SAP HANA Cloud database instance. The number of vCPUs depends on the amount of RAM you specify.

In the SAP BTP trial account you can't change the size of the memory and disk storage allocated to the database instance. This is limited to 30 GB RAM and 120 GB disk space.

A SAP HANA Cloud, SAP HANA Database instance in an enterprise SAP BTP account can allocate up to 5790 GB RAM, 16000 GB disk space and 440 vCPUs.

Note
The required disk space and virtual CPUs (vCPUs) can't be changed manually, but are automatically assigned to the database instance. The amount of disk space and vCPUs depends on the assigned RAM.

See the following video for Create Instance Wizard - Step 4.

You can setup maximum of 2 replicas for SAP HANA Cloud. One synchronous replica in the same availability zone, and one asynchronous replica in a different availability zone.

Caution

Adding additional replicas to your instance incurs additional costs based on the size (CPU, memory, disk) of the replica database. You can use the SAP HANA Cloud Capacity Unit Estimator to estimate the number of capacity units per month required for your particular use case. Link to the SAP HANA Cloud Capacity Unit Estimator

In the SAP HANA Database Advanced Settings step, you can setup some additional features. In the (1) Allowed Connections area, you can choose which IP addresses are allowed to connect to your SAP HANA Cloud database instance.

The Cloud Connector: You also need to decide whether you want your SAP HANA Cloud, SAP HANA Database to connect to your on-premise remote data sources through the cloud connector.

The Cloud Connector serves as a link between SAP Business Technology Platform (BTP) applications and your on-premise systems. It allows you use your existing on-premise assets without exposing the entire internal landscape to the outside world. It combines an easy setup with a clear configuration of the systems that are exposed to the SAP BTP.

The Cloud Connector runs as on-premise agent in a secured network and acts as a reverse invoke proxy between the on-premise network and SAP BTP. It provides fine-grained control over your On-premise systems and resources that can be accessed by cloud applications. It also allows you control over which cloud applications can use the Cloud Connector.

Note
In the SAP HANA Cloud Central, you can use the Edit option in the Actions menu to activate the cloud connector after the SAP HANA Cloud database instance was deployed.

The Cloud Connector provides the following features for business-critical enterprise scenarios:

  • Automatic recovery of broken connections.
  • Audit logging of inbound traffic and configuration changes.
  • High-availability setup.

In the enterprise SAP BTP account, you can also add a SAP HANA Script server and a SAP HANA Document Store as additional features to the SAP HANA database instance. When adding these features to a SAP HANA database instance may require more vCPUs (compute) and increase your licensing cost.

In the 6th and final step of the Create Instance Wizard you can decide to add an integrated data lake instance to your SAP HANA database instance. This integrated data lake allows you to ingest, store, and analyze high volumes of data, economically and securely. You can access and manage the integrated data lake from your SAP HANA database.

Integrated SAP HANA Data Lake: The Integrated SAP HANA Data Lake gives you the option to store the older and rarely used, but still important, cold data in a data lake controlled by the SAP HANA database instance. This database instance already stores your hot data in memory and the warm data in the SAP HANA Native Storage Extension (NSE). With the addition of a data lake to the SAP HANA Cloud database instance you have access to all your data from one single framework.

The SAP HANA Cloud database instance is being created. Refresh the screen every few minutes to see an updated status.

What is setup during the creation process of SAP HANA Cloud, SAP HANA database:

  • A SAP HANA database instance is created with data at rest encryption enabled.
  • The SAP HANA database instance is connected to SAP HANA cockpit.
  • The SAP HANA database instance is connected to SAP HANA database explorer.
  • The database user DBADMIN is created for administration purposes.
  • The SAP HANA database is connected to backup infrastructure via the Backint interface.
  • A backup cycle of 15 backup generations is setup, and the initial backup is created.

As soon as all these tasks are performed the SAP HANA Cloud, SAP HANA trial database is available for you to explore.

Create a Database Instance using Cloud Foundry CLI

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

Create a database using cf cli

To create 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 create-service <service offering> <service plan> <service name> -c 
    '{"data":
        {
          "memory": <xx>, 
          "systempassword":"<password>"
        }
     }'
    Copy code

    Example:

    Code snippet
    cf create-service hana-cloud hana HC200-Trial-Database -c '{ "data": {"memory": 32, "systempassword": "Welcome1"}}'
    Copy code

    The above command will create a database service named HC200-Trial-Database with 32GB memory and the DBADMIN user will get the password Welcome1.

    Note
    In an SAP HANA Cloud trial account you can only create a 30GB database instance.

Have a look at the Create an SAP HANA Database Instance Using the CLI page to have a complete list of parameters that can be used to create a database instance.

Create a SAP HANA Cloud Database Instance

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