The SAP HANA Multitenant Database Containers (MDC) feature enables hosting multiple SAP HANA databases on a single SAP HANA system. All tenant databases in the same system share the same system resources (memory and CPU cores) but each tenant database is fully isolated with its own database users, catalog, repository, persistence (data files and log files) and services. And now you can use all this on a trial landscape.
Note: You can have only one tenant database per account.
Create a tenant database on trial landscape
To be able to access a trial landscape, you need to have a developer account first. If you still need to create a developer account, you can start from here: Signing Up for a Developer Account.
To create and configure a trial tenant database, follow these steps:
- Log on to the SAP HANA Cloud Platform cockpit and select an account.
- Choose Persistence and then Databases & Schemas from the menu on the left. Choose New.
- In the Database ID enter a unique ID that contains lower-case letters and numbers.
- In the Database System field select the HANA MDC (<trial>) option. Fill in the SYSTEM User Password field. Choose Save.
The Events page is displayed. It shows the progress of the database creation.
- Wait until the tenant database is in state Started. It might take a while.
Note: If there are no free resources available you will not be able to create a tenant database. You should try again later.
Now you have your tenant database created and configured.
Web IDE scenario
In case you want to work with your tenant database from the Web IDE, you have to do an additional configuration after the tenant database is started:
- In the overview of the new tenant database, open the link SAP HANA Cockpit.
- Enter SYSTEM in the Username field and the password you have set in the Password field. When you choose Log On, an Information dialog appears. It says you are not authorized to open the SAP HANA Cockpit and you will be assigned the necessary role. Just choose OK and proceed. Another dialog appears. Choose Continue.
- The SAP HANA Cockpit opens for the new tenant database.
- Go back to the SAP HANA Cloud Platform cockpit and then go to the tenant database page in Databases & Schemas. Open the link SAP HANA Web-based Development Workbench.
- (Optional) Choose the Security option. Add all the roles described here: Roles Required for Web-based Tools. To assign the roles to the SYSTEM user, you have to:
- Go to Users and then SYSTEM.
- In the Granted Roles tab, choose Add.
- In the Search field enter the required roles and choose OK.
- Save the changes.
- To work with the Web IDE Editor, you need a database user first. Here you can find out how to create a database user with permissions for working with Web IDE: SAP HANA Cloud Platform
To open the Web IDE, you have to go to SAP HANA Web-based Development Workbench for this tenant database. Select the Editor option and now you have the Web IDE ready to work.
Eclipse IDE scenario
If you want to use Eclipse IDE to try out the tenant database on the trial landscape, you can use your own test application. This is what you have to do:
- Install the SAP HANA Tools in the Eclipse IDE. If you haven’t done this already, read this procedure: Installing SAP HANA Tools for Eclipse.
- If you want to import your test application delivery unit (DU), continue with the procedure.
- Go to Eclipse and open the SAP HANA Development perspective.
- In the System view, choose Add Cloud System.
- In the Account Information page, enter your developer account details. Choose Next.
- In the SAP HANA Schemas and Databases, enter the tenant database details you have set when you created it. Choose Finish.
- To import the DU, choose File and then Import.
- Expand SAP HANA Content and then choose Delivery Unit. Choose Next.
- The target system is your tenant database in the trial landscape. Choose Next.
- Browse to the YOUR_DU.tgz file you have downloaded in the File field and choose Finish.
When you create a tenant database, you can use it for 12 hours. After that it will be automatically shut down to free resources. You can start it again from the SAP HANA Cloud Platform Cockpit. Have in mind that if you don’t use this tenant database for 7 days it will be automatically deleted.