SAP HANA XS Advanced, explore the basic tools

The XS CLI is also available by default in the SAP HANA server with XS Advanced applications. In the case of SAP HANA, express edition, you can access it from the same SSH console you used to start and configure your platform.

The XS CLI enables you to maintain not only the applications that are deployed to the XS advanced run-time environment, but also the run-time environment itself, and the users who access and use it.

Note: You can get it from the download manager for SAP HANA, express edition or from the SAP Service Marketplace. Make sure you have the latest version in order to avoid issues.

This tutorial assumes you are using the CLI from the operating system in your SAP HANA, express edition instance.

From a console connected to the operating system, switch to user hxeadm and log in as follows:

sudo su - hxeadm
xs login

Note: hxeadm is the default administration user in the operating system in SAP HANA, express edition.

Enter the master password to log in with XSA_ADMIN. You are now logged in to the default organization and space. You can later log in to a different organization or space by adding -s for space or -o for organization.

Note: If you get an SSL error because you are using the default self-signed certificate from SAP HANA, express edition, add --skip-ssl-validation to your login command.

Alternatively, only from the CLI available in the SAP HANA, express edition instance, you can use the following command to log in as XSA_ADMIN specifying only the password

xs-admin-login

The XS CLI allows you to perform most of the administration tasks available in the XS Advanced Cockpit. The available commands can be found in the SAP Help Portal

Use command xs target -s SAP to switch to the SAP space, where XS Advanced applications such as the Administration Cockpit and the SAP Web IDE for SAP HANA can be found.

You can check on the status of the running applications with command xs apps. This will also tell you the URL for the important applications you will need for administration and the SAP Web IDE for SAP HANA.

You can also see a list of running services with command xs services. You can find more details about service types and the service marketplace in the SAP Help portal.

Go back into the database explorer, click + to add a database and use the options below to connect to the SYSTEM database.

SAP HANA supports multiple databases, isolated form each other, in the same environment. This concept is known as multi-tenancy. There is one database, the system database, that has limited SQL capabilities and is used to perform administration tasks over the contained databases, called tenants. Tenant databases have all of the SQL capabilities enabled. SAP HANA, express edition, brings one default first tenant called HXE.

For SAP HANA, express edition, these are the defaults:

• Host: hxehost or localhost
• Instance number: 90
• If you wanted to connect to the tenant database, the name is HXE. Make sure you choose the radio button for tenant database in that case.

Use the SQL button and enter the following query.

select * from dummy;

Use F8 or the green run icon to execute the query. Enter the result of the query in the box below to complete the validation.