Welcome to the SAP HANA Academy. My name is Julie and in this series of videos
We're going to take a look at the new SAP HANA Express edition.
In this first video we will look at how to register, how to get access to the download manager,
then use the download manager to identify the package that we want to download,
and then import that into a virtual machine player.
First, we will go to sap.com/sap-hana-express
And this will take us to registration page.
We will need to enter our information
Decide if you want to subscribe to the SAP Developer newsletter or not,
and remember that this express edition comes with support through the community
So it's a good idea to go ahead and subscribe to the newsletter because you'll get all the update information from that
We will want to click that we've read the license agreement for the developer edition and
Acknowledge that we've read the privacy policy.
So we can click register
The SAP HANA Express edition uses a download manager file for the installation
And we need to indicate which operating system we are using.
I am using a Mac, so I'm going to choose "Other"
It's going to download a .jar file
Next, I will go to my downloads folder and open that .jar file
It will open the download manager
So first I want to indicate what kind of image I want to download...
is it a virtual machine or the binary installer for Linux? I'm going to choose virtual machine
Next I can indicate where I want to save the download file
I've already created a folder called HANA Express in my downloads folder for this..
We automatically get the Getting Started guide in a PDF format that has information in it that we'll look at in a minute
I can choose the "Server Only" which is the HANA database itself
I can also choose the "Server plus Applications" which includes the XSAdvanced and the WebIDE applications.
And if I'm going to be working in anything other than English or German,
I can also pick up the additional language packs for the text analysis, that is part of HANA.
I don't need those files at this point, so I'm just going to pick "Server Only."
And I'll go ahead and tell it to start downloading. The download will take a few minutes, and so we'll just pause here.
Ok so it has downloaded the file and now it's telling me to refer to the documentation on how to load it.
We will go ahead and do that.
We'll click OK and we can actually quit the download manager.
The next thing to do is go ahead and open up my hypervisor -- or in my case of VMWare Fusion
I'm using VM Fusion because I'm running on a Mac.
I want to do "File > New "and then "Import an Existing Virtual Machine"
click continue
Then use "Choose File" to find the "HXE.ova" file.
which is the file we just downloaded. Go ahead and open that file, and click Continue.
And give your virtual machine image a name.
I'm going to call mine "HANA express server only."
and click Save.
That's going to import into my virtual machine
and again this will take a couple minutes, so I'm just going to go ahead and pause right here
OK, now it's complete.
Now we have a SUSE Linux image with 7GB of memory running in our virtual machine
I can click Finish. That will actually start up the VMWare image.
While that's happening, the other thing that we got in the download was the PDF for the Getting Started Guide
So let's go ahead and open that
And we'll just drag that off to the side so we can keep that handy.
Now from this guide. We've actually already done the Download Manager,
and importing the .ova file into the Vmware steps,
The next thing to do is to log into SAP HANA database within our VMWare image.
The first thing we want to do is we have the HOST log on
We're going to use "HXEAdm"
then the password is a temporary password "HXEHANA1"
(That's described in the Getting Started Guide PDF on the right)
The first thing it is going to do is to prompt us to change the password.
First we put in the existing password,
Which is the HXEHANA1
And then we want to create a new password and we want to use the protocol for Unix
where we have upper and lower case letters, a number, and a special character.
Then let's retype it
Ok now we're in.
The first thing we want to do is take a look and see whether our SAP HANA servers are actually running.
So one thing that we can do is we can use the HDBinfo command,
and that's going to tell us the servers that are running now.
We are looking for these four specific servers from the help file here...
We have the Name Server, the Compile Server, the Preprocessor and the Web Dispatcher.
Here we see those in our VM, so we're good.
if we didn't see those than we could run an HDBStop and HDBStart to restart the HANA server.
So the next thing we want to do at this point is change the default password for the SYSTEM user.
So we can do "HDBsql"
then " -u " for the username, which is "system"
and then "-d" for the database, which is "systemDB"
and then "- p" for the password, which is our temporary password "HXEHANA1"
Again, it's going to prompt us to change the password
We want to use a new password that matches all of the security protocols
And we will enter it again.
Now we're actually logged in as the systemDB, so we can just type "exit" here.
Get back to our login
The next thing we're going to do is to find our iP address for this virtual machine,
because we're going to use that information when we connect later.
Type the command "sbin ifconfig"
to find the Internet address for our virtual machine,
That's all we need right now from the virtual machine,
so let's go ahead and release our cursor and close that down.
The next thing that we want to do is take a look at connecting through Eclipse.
Right now we've connected to the virtual machine, and verified the servers are running.
In the next video, we'll take a look at doing some configuration within that machine,
and connecting to it from Eclipse.
NOTE: If you're following along in the Getting Started Guide the next section covers about testing the XSA and the WebIDE,
We didn't actually download those in this particular video,
we just did the server only version, so we can skip over those parts.
See you in the next video