Creating a Tenant Database in SAP HANA Multitenant Database Containers

The data is the most important piece in almost all system, for that reason the platform selection and the data structure design are the first step to consider. We are going to work with a Tenant Database in a Multitenant Database Container.

Prerequisites

  • Create a SAP HANA Cloud Platform account (Tutorial).

Step-by-Step

In your SHCP cockpit, click on:

  1. SAP HANA / SAP ASE
  2. Databases & Schemas
  3. New

00

Type an ID for your new HANA DB, the system need to be HANA MDC and for the password (Password must contain at least one lowercase letter, one uppercase letter, and one numeric digit). The web access is ON, press Save.

01

The creation and startup will take some minutes.02

  1. Click on Overview. Your screen should look like this image.
  2. Click on SAP HANA Cockpit. A new window browser is opened.

Please see that the database will be stopped automatically some hours later. If this occur you should Start it again.

04

  1. Username is SYSTEM and the password that you typed when the data base was created.
  2. An Information message appear, press OK.
  3. A successful message appear, press Continue.

05

Go back to the Cockpit / Persistence / Databases & Schemas / myhanadb / Overview. Now click on SAP HANA Web-based Development Workbench. This one is opened in a new window. Click on Security option.

06

We are going to create a new user and add specific Roles to our user. Right click in Users and click on New User.

07

  1. Type a user name.
  2. Check the Password check box and set a new password.
  3. Save the changes.

08

The roles basic recommended are documented in https://help.hana.ondemand.com/help/frameset.htm?d7c4ca5dac4f4dbbb47901eebe9ea0d1.html and to work with eclipse is important add ide roles too (in find roles, type ide and add all). Last but not least add CONTENT_ADMIN role.

  1. Select the new user.
  2. Granted Roles tab.
  3. Press Add button and find the roles.
  4. Press Save.

09

The result should look like this.

10

Tenant Database is ready to work.

spanish-version

 

Advertisements

One thought on “Creating a Tenant Database in SAP HANA Multitenant Database Containers

  1. Pingback: How to build a basic solution with SAP HANA – part 1 – “The Data Model” | Innovators at Heart

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s