Time to Complete
5 Min.
Provide simple instructions for a user to create a multitenant database in `HANAExpress`. SAP HANA systems with multitenant database containers can contain multiple tenant databases.
Provides instruction on how to create a multitenant
container database in HANAExpress
and how to connect and verify the new database.
Connect to HANA, express edition
using SYSTEM user and create a multitenant
container database:
% hdbsql -i 00 -n localhost:30013 -u SYSTEM -p
<SYSTEM user password>
"CREATE DATABASE
MTDB1
SYSTEM USER PASSWORD
<password>
"
This will take about 1 min, result will be similar to:
Verify the new multitenant
container database is accessible:
% hdbsql -i 00 -n localhost:30013 -u SYSTEM -p
<SYSTEM user password>
"select * from "PUBLIC"."M_DATABASES""
HANA Studio
. To do so, select the Add System
command in HANA Studio
:View from HANA Plugin for Eclipse after adding “MTDB1”:
SAP HANA, express edition tutorials page
Updated 02/18/2018
Contributors Provide Feedback
5 Min.
HANA, express edition
must be running.