Create a multi-tenant container database in `HANAExpress`

How-To Details

Provides instruction on how to create a multitenant container database in HANAExpress and how to connect and verify the new database.

1. 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:

   

2. 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""

1. Verify that you can connect to the database using a HANA client tool such as HANA Studio. To do so, select the Add System command in HANA Studio:

   View from HANA Plugin for Eclipse after adding “MTDB1”:

   

Next Steps

• Go to the SAP HANA, express edition tutorials page