Creating HANA Database

In my previous post we have created the SAP HANA Colud developer Account. Now we will see how to create HANA MDC (Row) database.

After Login to the SAP HCP Cockpit, on the Navigation Bar we have “Databases & Schemas” Click that.

Click “New” to create a database and enter the “Database ID” we can choose any name here,

dbcreation

Give the Password for the “SYSTEM” User, this is require to login to the Database in the next step.

Now press “Save” it will take some 15 – 20 min.

we can see the progress in the “Events” tab from Navigation bar. once the event “Database started successfully” is raised, go to the “Overview” tab.

Which look as below.

Where status is “STARTED”

database started

Now we need to configure the Schema in the Database which we created. to do that we need the user for the same.

Lets create the Database user first, we can not use SYSTEM user for db access that’s why.

Creating DB user

Click on the “Administration Tools : SAP HANA Cockpit” link which will open the Fiori Application in new window( Which is called HANA Cockpit).

Then Give the User name as “SYSTEM” and password which is given in previous step

It will say you dont have permission, dont worry we are using Trail account we have to see these errors, click “OK”.

Now in the Fiori Lanchpad click on the “Manage Roles and Users” Tile, which will open the new Fiori app (SAP HANA Web-based Development Workbench: Security) 

hanauser

In the Above Screen right click on the users and select new user in the context menu

Enter the User name, Which is ALLCAPS “SAP Stranded” period, and password (Temp password once user is logged in he has to change this) and Save from the main menu as in the previous screen shot.

usernamepassword

Add Roles user

Click on the “+” icon in “Granted roles” tab

addroles

Search of “ide” as below and select all press “OK”

roles

Do the same to add one more role CONTENT_ADMIN”

Yes, we have created the HANA MDC database and added the User which is having role to access and modify the database though SAP HANA Databse WebIDE

Confirm the user and roles are proper 

Log out from the Security App ( yes we are working on SYSTEM user till now)

Login with the New user which is created, and temp password which is given while creating the user.

Once login it will ask to change the Password for the user.

https://help.hana.ondemand.com/help/frameset.htm?a4b1a6abc13f45d58c9a156b81487d8a.html

Advertisements

2 thoughts on “Creating HANA Database

  1. Pingback: Hibernate + JPA + Spring-data-jpa + HANA Database | Chiru's

  2. Pingback: Deploy the Java web application to HANA Cloud | Chiru's

Leave a Reply

Please log in using one of these methods to post your comment:

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