Skip to Content

Create a Tenant Database

test
0 %
Create a Tenant Database
Details
// Explore More Tutorials

Create a Tenant Database

Daniel Wroblewski

11/26/2018

Beginner
15 min.
SAP HANA, express edition, How to, Tutorial, Beginner
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

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: Using SAP HANA Cockpit

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 an SQL Command Line
View Full Instructions

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

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”.

Next Steps

Next Steps

Prerequisites

Navigate tutorial steps

QR Code

Back to top