Skip to Content

Configure a Space to Develop on a Tenant Database (XS Advanced)

Assign a tenant database to a space.
You will learn

This tutorial will show you how to assign a tenant database to a space using the SAP HANA Service Broker in the Administration Cockpit.

jung-thomasThomas JungJanuary 5, 2021
Created by
Lsubatin
December 15, 2017
Contributors
jung-thomas
Lsubatin

Prerequisites

  • You have access to SAP HANA on premise or SAP HANA Express – This tutorial will not work with HANA Cloud
  • SAP HANA, express edition already comes with a tenant database called HXE. If you are using a different deployment, you can create a tenant database following this guide
  • SAP HANA, express edition already comes with a development space. If you want to create a separate one or are using another deployment, you can create a space as explained on this tutorial.
  • You have the proper administration rights

Note: SAP HANA, express edition, comes with a default first tenant called HXE and an XS Advanced space called development.
If you are already using the development space, make sure you re-create the database services to point at the tenant database.

  • Step 1

    Log in to the XS Advanced CLI as XSA_ADMIN. Use command xs-admin-login from the prompt in the virtual machine as hxeadm

    CLI login

    Note: If you are not using the command line from the operating system in the virtual machine, use command xs login -a <https://hxehost:39030> --skip-ssl-validation or adapt it to your deployment.

    CLI login

    Use the following commands to map the HXE tenant to the development space in the organization HANAexpress. Replace the values with the appropriate ones if you are using a different deployment

    text
    Copy
    xs enable-tenant-database HXE
    
    

    Once you get confirmation of the mapping, use the following command to complete the mapping:

    text
    Copy
    xs map-tenant-database -o HANAExpress -s development HXE
    

    Note: Unless you have changed them, the passwords for the user SYSTEM in both SYSTEMDB and the tenant are the master password you set during setup.

    ###Mark the rest of the steps as done and complete the validation in step 5.

  • Step 2

    Do NOT perform these steps if you performed option 1.

    If you are using SAP HANA, express edition, go into https://hxehost:51036 or https://hxehost:39030 to access the xsa-cockpit app.

    Cockpit log in

    Click on the button to open and log in to the XSA Cockpit

    Cockpit log in

    If you are not using SAP HANA, express edition, or you have changed the ports, you can find out the right URL using command xs apps on the Command Line Interface and look for the URL for application xsa-cockpit. You can access the CLI directly from an SSH console on the server or download it using the Download Manager. You can get the Download Manager after registering at the Download site

     

    You need a user with administration rights, such as XSA_ADMIN. Log in to the Administration tool with it

  • Step 3

    Click on Enable

    Cockpit click on logical setup

    You will be prompted for the credentials to the tenant database

    Tenant database credentials

    Wait until you will see the database is enabled. Do not refresh or navigate away from this site. You will see a success message

    Tenant database credentials
  • Step 4

    Click Map

    Logical Database

    Select the space you want to map to the tenant database and click on Map

    Broker mapping

    Wait until you get a response that the database has been mapped.

    You can now use the space mapped to a tenant database in your Multi Target Applications.

  • Step 5

    What do you see under Mapped spaces for the tenant you have just mapped in the XS Advanced Cockpit (default, https://hxehost:51036/cockpit#/xsa/logicalDatabases )

    What are the value under `Mapped Spaces`

Back to top