Hello and welcome to the SAP HANA Academy.
My name is Denys.
The topic of this video tutorial series is Building Solutions: Live 5.
In this video, we are going to setup SAP HANA, express edition to run on a virtual machine.
For those not yet familiar with the free developer express edition, please go to sap.com:
Developer > Products > SAP HANA, express edition.
On this page, you can find all the information you will need about HANA express:
tutorials, blogs and Q&A under Community, and
in the Resources section, documentation and videos from the SAP HANA Academy.
To run HANA express, you have two options:
one is using the installer and the other is using a virtual machine image.
In this video, we will take a look at the second option, the virtual machine image,
which will be the easiest as everything has already been installed and configured.
Here we have our 1-2-3.
You need to register first.
Select your country and enter your e-mail address.
Tick the box that you have read and accept the developer license agreement,
it explains what you can and cannot do with HANA express.
Acknowledge the privacy statement and click register.
A new page will load where you can download, not the VM, but the download manager.
There is one for Linux, one for Windows, and one that is platform independent,
which is the one you will need for Apple MacOS.
I will select the Windows one.
It is a small download and then open it.
The download manager is a Java application,
so you will need to install the Java runtime from java.com if Java is not present on your computer.
This was the case for me, Windows 10 does not come with java, for example.
and then here you can make your selection: virtual machine or installer.
I will select Virtual Machine here. Specify the download directory and make your selection.
There is a getting started PDF document. This is selected by default.
Also selected here is the server-only virtual machine, which I will de-select,
and then select the server + applications virtual machine.
Note that it is quite a bit bigger, 12 Gigabytes instead of 2.
The full version includes the built-in application server, SAP HANA extended services, advanced model, XSA in short,
which we will need for our project.
We do not need the SAP HANA client but we do need the text analysis files for additional languages,
so select that as well. Then, click the download button and give yourself a break.
We will get back to you when the download is finished.
OK. The SAP HANA, express edition virtual machine has been downloaded successfully.
Select Quit to exit the download manager.
Here we have our downloads: a PDF file, getting started
the virtual machine, this is a file with the extension OVA, it is like a ZIP file for virtual machines
and the text analysis files, bundled as TGZ
or zipped tarball, a format common for UNIX and Linux, we will look into this later on.
Let’s open the getting started PDF. I recommend you take a look at this document
You can read about the machine requirements. For example, and this may come as a bit of
a surprise, you will need 16 GB RAM, memory, as a minimum with 24 gigs recommended.
This rules out most laptops as host computer to run the VM.
A MacBook or PC laptop with 16 GB of RAM has to allow about 4 GB for the operating system,
which leaves about 12 GB for the VM, which is about half what you really need.
So this is not going to work. Do not bother trying, it will not work.
You will need a server, or, what I am using here is an Intel NUC - Next Unit of Computing.
Small device, big performance. Here we have the website on intel.com.
It is a mini PC.
The one I have got here has 32 Gigabytes of RAM, which is roughly what we need.
Alternatively, of course, you can use one of the hosted solutions:
Microsoft Azure or Amazon Web Services, for example. This we will look at in the next video.
Then you will need something to run the VM. Supported are VMware and Virtual Box.
I will be using VMware Workstation Player here.
You can download it, free of charge, from the VMware webste: vmware.com
It is a simple install: next, next, next, and then just run it.
Then select Open a Virtual Machine.
Browse to the location where you downloaded the OVA file and select Open.
Then you can enter a name, any name you want, and a location where you want to store the VM and then select Import.
Player will then extract the OVA file and create a configuration file specific to VMware.
Note that this means that OVA file itself is not modified.
So, you do not need to download it again
should anything go wrong, or should you want to start from zero again.
When the import is finished, select edit virtual machine settings.
The initial value for memory is 12 Gigabyte. This is not enough.
I will move the slider up to 26 Gigabyte and then for number of processors, select four,
as recommended in the Getting Started guide.
Note that Network adapter is in Bridged mode, it is the default setting.
Then select Play virtual machine, to start it.
We see the SUSE Linux startup screen
and then we are prompted for a login.
So, let’s return to the Getting Started PDF and scroll down a bit.
Here you can read the login is hxeadm and the temporary password HXEHana1.
HXE stands for HANA express edition, by the way.
After the first logon, you will be prompted to change the password
and then you need to select a strong password with at least 8 characters,
including numbers, upper and lower case and special characters.
Dictionary words, like Password1 or Qwerty123 will not work.
Here is an example. Well, try to remember that! Nope, you are not supposed to use that either.
You should define your own strong password. Let’s return to our VM.
Now, unfortunately, this can be a bit of pain. My keyboard for some reason prints out multiple characters here.
Or you might not have a Qwerty but an Azerty keyboard, like in France.
So, what I recommend you to do is to open up your browser,
go to Google and enter putty: P U TTY.
and download this utility. It is telnet client. Open source.
Simple install. Next, next, next. and then run it.
Note that on the VM console, we have an IP address
Mine is 10.182.169.35 Remember that the VM is configured in bridged networking mode.
So yours maybe in a completely different range.
Enter it here in the host name or IP field. Give the session a name, I will be using hxehost here,
and then under Connection, Data, enter the
login username: hxeadm. Click Save to save it for next time.
Click Open to start a session. First time, you will get a warning.
Security Alert PuTTY is using Secure Shell, SSH.
Server’s host key is not cached in the registry. Confirm the alert with a yes, if you do not
want to see this message again for this connection and then we are back at the login prompt.
Enter the HXEHana1 temporary password Enter it again for the change password sequence.
and then enter your newly defined password. Putty is a Windows program, so you should
have no problems anymore with keyboard mappings. Much easier and also allows to copy and paste
commands, have multiple sessions, and so on. On the Mac, you can use Terminal: same thing.
Next, we are prompted to change the HANA database master password.
Now, in fact, there is no such thing as a HANA master password but this prompt comes
from a script that will set the password for us for a number of database users, like SYSTEM,
the database superuser, XSA_ADMIN, the administration user for HANA extended application services,
advanced model, the built-in application server, and a couple more.
Unfortunately, different password rules apply, as here we are dealing with HANA and not with
SUSE linux. So number, uppercase, lowercase but not special characters.
So you cannot reuse the operating system password you just defined for hxeadm.
OK. Enter your password
Confirm it. Then you will be prompted to enter the proxy
server configuration. This will be important if you want to access
the HANA application server from the outside. In a browser on the host computer, on your
phone, etc. If you are working on a home computer directly
connected to the internet, you can answer no.
If you are working in an office, you probably have to enter a proxy host and port, ask the
network administrator, or local IT, if you don’t know.
For my office location, I have to enter proxy for the proxy host name and port 8080 for
the port. Probably the most common settings, so that’s
easy. Then for the host that do not need proxy,
enter the local host name: hxehost. Again, this is the setting for my office.
Yours may be different or if you are working from home, you may not need a proxy at all.
Proceed with the configuration? Yes. Passwords are set.
The system database is registered to Cockpit. The SSFS master keys and root keys are changed
and a backup is made and the proxy is set.
Congratulation! SAP HANA, express edition 2.0 is configured.
Let’s do a quick check. Enter the command HDB info, HDB in uppercase.
This will give us a process list of the all the HANA processes similar to the ps command on Linux. Looks good.
Also good to know, is the linux ‘top’ command.
Displays processor, CPU, and memory usage. All the processes have started, CPU is almost
idle at 1.5 percent. and 22 gigabytes are used, with 4 gigabytes
free of the 26 gig in total; also good. We can do another quick test
Open up your browser again. and enter the IP of the VM
The same one we see here in the header of our telnet client PuTTY
10 182 169 35 is mine. Yours will be different.
and then a colon and the port 80 + 90, 90 is the instance number of HANA express.
XSengine is up and running. Just testing if we can access the HANA server
on a browser on the host computer. Well, this all looks good.
So, remember
We have our linux host: hxehost our linux administration account: hxeadm
with a password that you defined, the HANA system identifier: HXE
the HANA instance number: 90 and the HANA database master password, which
you also set. One more thing.
If you have worked before with VMware, you probably are accustomed to suspend, shutdown
or restart the guest using this menu here. STOP.
Do not ever use this. HANA was not designed to run on virtual machines.
It is an in-memory database. So everything runs in memory
If you hard reset the database using the VMware menu, you will cause a database crash.
So HANA has to perform a crash recovery each and every time it starts up.
This will take some time. Not a good idea.
What you need to do is stop HANA properly. We do this with the command HDB stop.
Which will run the sapcontrol program with the appropriate flags to gently bring the
database down. And then with the HDB info command, we can
verify that the database is stopped. At this stage, you can suspend the VM, or
use any of the VMware menu options or just run the command: sudo (superuser do) shutdown
dash h for halt (stop) now and SUSE will stop.
PuTTY gives us an error as it has lost the connection, obviously,
which is a good thing. And if we open Player, we can see that the
VM, indeed, is stopped.
OK, so much for getting started with the SAP HANA, express edition, virtual machine.
In the next video we will look at installing HANA express on a hosted computer.
You can find more video tutorials on our YouTube channel,
If you would like to be informed about new video tutorials, please subscribe to our channel
You can connect with us on LinkedIn or follow us on Twitter, as well for updates
and we also have a page on Facebook and Google+.
If you are watching this video on YouTube, do not hesitate to leave your comments to
the video page and, if you like, give us your vote on his video.
Thank you for watching