Skip to Content

Create a Tenant Database

Beginner
15 min.
SAP HANA, express edition, Tutorial, Beginner, How to
Learn how to complete common tasks when setting up a new database. In this tutorial, you will create a tenant database using either HANA cockpit or an SQL command line.
You will learn
  • How to create a tenant database using either HANA Cockpit or an SQL command line

Prerequisites

When creating a tenant database, expect your system to use more memory. Ensure your system has enough memory to run an additional database.

  • Step 1

    Note:
    This option requires a SAP HANA, express edition Server + Applications installation.

    1. Open SAP HANA Cockpit and log in using XSA_ADMIN.

    2. Open your system database in the Resource Directory window.

    3. Under Tenant Monitoring and Administration, click System Running in the Overall Tenant Statuses tab to open the Manage Databases page.

      Overall Tenant Statuses

    4. On the bottom right of the page, click … then Create Tenant Database.

      Manage Databases Page

    5. Give your tenant database a name and its SYSTEM user a secure password.

      Click Create Tenant Database when you are done.

      Create Tenant Database

      A message will display that you have successfully created a new tenant database.

      Successfully Created Tenant Database
  • Step 2

    Using SAP HANA studio or another connected SQL console, execute the following command to create a tenant database:

    bash
    Copy
    CREATE DATABASE <database_name> SYSTEM USER PASSWORD <SYSTEM_user_password>

    Example:

    CREATE DATABASE TENANTDB SYSTEM USER PASSWORD Password1

    This creates the tenant database “TENANTDB” with the SYSTEM user password “Password1”.

Back to Top
Back to top