Create your own SAP HANA system on the SAP Cloud Platform

How to activate your own SAP HANA system on the SAP Cloud Platform

Did you know that you can activate your own SAP HANA system on the SAP Cloud Platform?

All you need is a gmail

I just activated a system and found it very easy. In this post I'll take you through the required steps to activate this system as well as links to the documentation.

The first step is to make sure that you have an appropriate SAP s or p number. This can be obtained as follows:

Go to sap.com/community  

Click on the logon picture: 

If you already have an SAP logon, you can use your user credentials here, else, simply logon with your google, linked, facebook or twitter account. I will use my google account. Once you have logged into your google account, you will get the following message:

The next step is to link a new SAP account to your google account, by clicking on the 'Create Linked Account' button. 

Fill in the registration details and then submit. You will be greeted with the following message:

Click on the link to activate your account. You will then be taken to the logon screen again. Log on with your email and click on the Link Accounts button:

Your sap and google accounts are now linked and you should be greeted by the following message:

Now, clicking on the logon button again and then selecting 'Account Settings', you can see you S-or-P Number:

Now head over to https://account.hanatrial.ondemand.com and click on Register. If you are still logged into your SAP account, your credentials will be picked up and you should be met with a Welcome screen:

After accepting all the terms and disclaimers, you will be taken to the Cloud Platform Cockpit. There are pletny options to choose from but we are interested in a SAP HANA system. So click on the Neo Trial button:

Your will now be presented with your subaccount and any systems that you may have activated. Since we have not activated anything yet, this screen contains not much information. 

On the menu on the right, select Databases & Schemas:

Any activated databases & schemas will be listed here. Click on New:

Next, select the database ID and the SYSTEM user password. Note this password, as we will use it in the next few steps:

 You database should be created and is being activated:

Once all steps are complete, we can go ahead with the configuration. 

We will complete three steps:

1 - Use the SYSTEM user to create a database user.

2 - Connect eclipse to the HANA Cloud system

3 - Create a repository workspace.

The steps are published here. I will add some screenshots to make the process easier:

Use the SYSTEM user to create a database user.

We will use the SYSTEM user to create the database user, which will also create the schema we need. 

1. Select the relevant SAP HANA tenant database in the list.  
   
2. In the overview that is shown in the lower part of the screen, open the SAP HANA cockpit link under Administration Tools. 
3. In the Enter Username field, enter SYSTEM, then enter the password you determined for the SYSTEM user in the Enter Password field.
   
   A message is displayed to inform you that at that point, you lack the roles that you need to open the SAP HANA cockpit.
   
4. To confirm the message, choose OK.
   You receive a confirmation that the required roles are assigned to you automatically.
5. Choose Continue.
   You are now logged on to the SAP HANA cockpit.
6. Choose Manage Roles and Users.
7. To create database users and assign them the required roles, expand the Security node.
8. Open the context menu for the Users node and choose New User.
9. On the User tab, provide a name for the new user.
   The user name always appears in upper case letters.
10. In the Authentication section, make sure the Password checkbox is selected and enter a password.
    
    NoteThe password must start with a letter and only contain uppercase and lowercase letters ('a' - 'z', 'A' - 'Z'), and numbers ('0' - '9').
11. To create the user, choose Save.
    The new database user is displayed as a new node under the Users node.
12. To assign your user the roles with the required permissions for working with SAP HANA Web-based Development Workbench, go to the Granted Roles section and choose the + (Add Role) button.
13. Type xs.ide in the search field and select all roles in the result list.
14. Choose Ok.
    The roles are added on the Granted Roles tab.
15. Repeat the last two steps to assign the CONTENT_ADMIN role to the user.
    

Use of the Web-Based Development Workbench

At this point, you should be able to log into the HANA database and use the web client:

Select the relevant SAP HANA tenant database in the list again and select:

SAP HANA Web-Based Development Workbench

Log into the HANA system using the Database user created in the steps above:

You may be asked to change your password and then taken to the Web-based Workbench:

Clicking on Catalog takes us to the SAP HANA Modeler perspective, and we can see the DBUSER schema:

Right-Clicking on the schema, select 'Open Sql console". We are greeted with a new tab and a sql console and we can write some sql code:

Connect to your SAP HANA Database via the Eclipse IDE (Neon)

Note the prerequisite. Only Eclipse Neon is supported. If you don't have Eclipse Neon, download it from here

Once downloaded and installed, follow the procedure below:

Procedure

1. Go to Window  Show View  Other.
2. Select SAP HANA  Systems and choose OK.
3. From the Systems context menu, choose  Add Cloud System.
4. Verify the host in the Subaccount Information window.

1. For more information about hosts, see Regions and Hosts Available for the Neo Environment.
2. Enter your SAP Cloud Platform subaccount information:
   • Subaccount name
     For more information, see Accounts.
   • E-mail or user name
   • Password
     (If you select Save password, the password for a given user name will be kept in the secure store.)
   • Note that this is your SAP User account password.
3. Choose Next.
4. In the SAP HANA Schemas and Databases window, select Databases.

1. Select the database you want to work with.
2. Enter your database user and the password you defined for the user.
   For more information, see Creating a Database Administration User.
3. Choose Finish.

At this point, Eclipse will display the catalog as well as the DB user's schema. You should be able to create a sql console and run some code:

Please subscribe if you like this post and check out my courses. Leave comments as well of other SAP related topics you would like to see.