In this tutorial you will learn how to setup a SAP HANA Cloud database. The free trial allows you to test SAP HANA Cloud for 30 days. You can renew the trial period every month until you reach 360 days.
SAP HANA Cloud is a service available in the SAP Cloud Platform and is based on SAP HANA. This means that you get to use all the capabilities HANA has to offer, combined with the flexibility and other advantages of a cloud product.
We will cover the following 4 steps in this tutorial:
- Register for the free SAP HANA Cloud trial
- Set up your SAP HANA Cloud instance
- How to open the SAP HANA Cockpit and Database Explorer
- Set up the SAP Web IDE
1. Register for the free SAP HANA Cloud trial
Register using the link provided and confirm your e-mail address. Remember the password and e-mail you used for registration. You will use it to access your SAP Cloud Platform account where your SAP HANA Cloud will be based.
After you successfully registered for your SAP Cloud Platform Trial Account, you will be asked to choose the region which is closest to you. This will trigger the creation of your SAP Cloud Platform account structure, which will automatically be generated in the background. After about 2-3 minutes everything has been created and you can now select the “Confirm” button.
Congratulations! You successfully registered for an SAP Cloud Platform Account, which is the basis for using HANA Cloud.
If you click on “Enter Your Trial Account” on the main page, you can enter your freshly created SAP Cloud Platform. In here we will create and manage our HANA Cloud.
2. Set up your SAP HANA Cloud Instance
You have already successfully set up your SAP Cloud Platform account and you are currently logged in and entered your trial account.
The screen you see should look like this:
What you see is the SAP Cloud Platform Cockpit (SCP). This is the area in which you can organize and manage every service the SCP is providing.
On the left side (red) you see different options that change, depending on which subaccount and space you are currently in.
In the top you see a navigation bar (green), which works like a tree table. It shows you in which subaccount / space you are currently in. In our case we are currently on a global account level. The “Trial Home” will navigate you back to the start screen with the tutorials.
Navigate to the dedicate space for your SAP HANA Cloud
We will navigate to the already created subaccount called “trial” to open up the “dev”-space, in which we will create our SAP HANA Cloud instance. To do so, simply click on the square tile called trial (blue).
You are now in your subaccount. As you can see, the options on the left changed and the navigation bar on top updated itself. In the trial-subaccount overview page you get some basic information about the spaces within the subaccount, as well as the active environments and entitlements.
Select the “dev” space to go even deeper into the structure. The smallest possible granularity within the SCP is a space. This is where we will create the services, in our case SAP HANA Cloud.
Create the SAP HANA Cloud instance
To create a SAP HANA Cloud instance, select the SAP HANA Cloud option on the right. This will open a blank canvas, in which you see all your HC instances. So far, its empty. To create an instance, click on “Create Database” on the top right.
Follow along with the setup, most of it is self-explanatory. One thing to keep in mind is to carefully choose the DBADMIN password, since you will need this user in the future. Choose a password you will remember / note it down. If you entered all the necessary information, the second step will be clickable.
In here you can configure the size of your SAP HANA Cloud. Since we are using a trial version, we can’t change anything here. Normal you would be able change the size of your SAP HANA Cloud, depending on your use case.
The third step is optional but important. In here you define the type of connections you want to allow. In our scenario it is the easiest to simply click on “Allow all IP addresses”, so no problems will occur in the future.
In the last step you will be able to create a data lake, this is optional and can also be done afterwards. In our case we create the data lake by clicking the toggle switch and naming it.
Click on “Create Instance” to create your SAP HANA Cloud instance and data lake. This process takes around 10 minutes. You can see the status of the creation in the “Monitor Landscape” dashboard, which opened up automatically after you clicked on “Create Instance”.
When you switch to the space view in your subaccount, you will see your SAP HANA Cloud instance.
You did it! You setup your first HANA Cloud instance! Lets get ready to use it 🙂
3. How to open the Monitor Landscape, SAP HANA Cockpit and Database Explorer
SAP HANA Cloud comes with a set of tools, which will allow you to monitor, administer and work with it. To open one of the provided tools, click on “Actions”.
The monitor landscape screen displays the status of all your SAP HANA Cloud and data lake instances. You can change the status in here and start, stop or delete an instance. An existing instance can also be edited to subsequently increase the memory or change the type of connection. The copy function provides all information to connect to an instance, like SQL Endpoint and Instance ID.
From here you also have the possibility to call the SAP HANA Cockpit and the Database Explorer. You don’t have to start from the overview page to open the different tools.
Administer – SAP HANA Cockpit
SAP HANA Cockpit is a web-based tool for the administration of your SAP HANA Cloud. Everything in here, from database users, role management, storage capacities up to the performance of SQL queries can be analyzed in here.
The SAP HANA Cockpit also links directly to the Database Explorer.
Execute – Database Explorer
The Database Explorer is another web application, which allows you to execute SQL statements and view database objects.
4. Set up the SAP Web IDE
To finally start working with SAP HANA Cloud and build your own projects, you will need to set up an IDE. The choice is yours, you can either use a local IDE like HANA Studio or an IDE which is web based. In the future, the recommended IDE for SAP HANA Cloud will be the Business Application Studio.
For now, we will set up the SAP Web IDE. This will be the IDE we will use in the following tutorials around SAP HANA Cloud.
To add a service to your subaccount, you will need to subscribe to it. Subscriptions are handled on subaccount level. This means that you will need to use the navigation bar on top, to move out of the “dev” space. When you are on subaccount level, you will be able to add a service.
Click on “Subscriptions” on the left and search for SAP Web IDE. Click on the tile to be able to subscribe to it. After you successfully subscribed to the service, you will be able to click “Go to Application” to open the SAP Web IDE.
If you use bookmarks, now is a good time to set one.
5. Add a database to SAP Web IDE
To be able to use our SAP HANA Cloud, we will need to add our database. If it is your first time starting the SAP Web IDE, you will be notified that you have not added any systems yet. It will automatically open the Add Database – window in which you can enter in all the details. In case you accidently closed the message, or you already have worked with the IDE before, simply click on the + next to the refresh symbol to open the dialog again.
It is time to add your database!
To find the details of your SAP HANA Cloud database, open the monitor landscape screen in a different tab. Click on the instance you want to know the details of. In the section Copy > SQL Endpoint you can get the host address with port. Copy it into the field and delete the port behind it.
Provided the details of the database user you want to use. Since we haven’t created any users yet, we will simply use the DBADMIN and the password we defined, when we created the instance.
You can change the name of your database. This makes sense if you are using multiple databases or different users on the same database.
Click on OK to add your database to the SAP Web IDE.
You are all set!