Hello and welcome to the SAP HANA Academy.
You are watching the video tutorial series: SAP HANA, express edition.
The topic of this video tutorial is getting started with HANA express on the Google Cloud Platform.
Hi, I am Denys van Kempen.
Before we can create and launch our instance of SAP HANA, express edition on the Google Cloud Platform,
we first need to create an account.
So, go to cloud.google.com
of course, you can use any browser but I will be using Google Chrome here
and select the “Try it free” button.
Note that I am already connected with my Google account.
If you don’t have one yet, it might be a good idea to create one.
Enter your country and select if you want to opt-in for any updates by email,
accept the Google API Terms of Service and the Google Cloud Platform Free Trial Terms of Service.
You can open the Terms and Conditions in a new window and for once,
it is actually something one can read and understand.
Hats off, Google, well done.
Next, enter name and address, contact information and payment method.
Note that there is no autocharge after the free trial ends.
The credit card is to make sure you are not a robot.
You get a 12 month free trial with $300 credit.
Again, hats off, Google.
Feels like it’s my birthday.
Then, select “Start my free trial”.
A welcome screen appears with the option to tour the console.
So, you can navigate the menus a bit and get familiar.
Then in the Getting Started tile, select “Deploy a prebuilt solution”.
Select "Filter by" >Database"
Scroll down a bit and select SAP HANA, express edition.
On the overview page, we get a cost estimate - this is against our credit of $300.
No worries, nothing gets billed.
We see the version: HANA 2 SPS 0, last update, and the operating system: SUSE Linux.
Select “Launch on Compute Engine”.
The Cloud Launcher will then initialise.
If you have worked with Amazon Web Services, AWS, before, this is similar to EC2.
So, the instances section.
There are many, many types of cloud services.
Compute instances is one of them and that is what we are starting here.
Takes a few minutes… is printed.
It took less than that for me.
Blazingly fast platform, awesome.
Then we need to tune our deployment a bit.
Give it a name, or accept the default.
Select your zone.
It makes sense to select one that is close to where you or your developers are, your customers maybe.
Then, I am going to customize the machine type.
Default selection is 2 cpus and 13 Gigabyte of RAM.
I will double that to 4 cpu and 25 gigs and get the offer to save some by selecting another machine type.
This would be a $226 a month, if you leave it running 24/7.
Effective hourly rate is 31 cents.
So, for development purposes, that would be about $2,50 day.
It is a steal!
With our $300 credit that’s about 120 days of development.
All for free.
OK.
Enough sales.
Boot disk, you can select standard persistent or SSD, solid state, the flash disk.
You don’t really need this for HANA.
It is all in-memory, so I will leave it at standard.
Maybe for production, later on, you might want to take a look at it.
For the disk size, I will enter 120 Gigabytes
Then, very conveniently, the default ports that need to be open for us to connect
to our HANA instance are already defined.
We have port 22 for secure shell.
That’s the command line.
We have the ports for the SAP host agent to stop and start, so you can connect HANA studio, for example,
and the HTTP and HTTPS ports for HANA XS.
Select “I accept the Google Cloud Launcher Terms of Service” and click “Deploy”.
This will bring us to the Deployment Manager.
While on the left pane we get a status of the deployment process, on the right pane
we have some links to the most important resources.
There is the documentation, the FAQ, and of course, highly recommended,
the Self-Learning Video Playlist, which - surprise, surprise - will get you to the SAP HANA Academy.
OK.
Fast forward.
Minute or so later, the solution is deployed.
It is really, really fast.
Did I already mention that?
Suggested next steps proposes to change the master database password.
At least 8 characters, uppercase, lowercase and a digit.
You need to change user first to the HANA express operating system administration account,
hxeadm
select the dropdown arrow next to SSH and take a look at your options.
You can open SSH in a browser window or use your favourite SSH client,
maybe PuTTY on Windows or Terminal on the Mac.
I will open the browser version.
I am connect here by default with my username account, which has root privileges.
So, as we just saw, run the command “superuser do, sudo, space dash space hxeadm”.
Then we are prompted to change the master database password.
Now, to be fair, there is no such thing as a master password with HANA.
This is just shell script that comes with HANA express, to secure the platform a bit
as it comes out of the gates.
The password you are going to define here will set the password for the database super user,
SYSTEM and it will also be used for the backup password of the root keys.
The script also changes the SSFS master key and generate some new root keys.
We have discussed this topic in another video on the HANA Academy so if you are curious,
please check that out.
I will a link in the description below to this video.
Database will be stopped and started, fast forwarding here a bit, and we are done.
With the “HDB info” command, we can get a process list.
The output is the same as with the Linux ps command, which you can see here.
We only have a name server up, hdbnameserver, and some support processes,
so those a little bit familiar with HANA, can tell that this is the HANA express server-only version
not the full version with XS advanced model
and also, that we only have a system database running.
So before you start to do any development, make sure, you create a tenant database first.
Again, of course, you will find video tutorials in the SAP HANA Academy about how to proceed.
Don’t forget:
before you stop the VM, make sure to stop the HANA database first.
Use the command ‘HDB stop’ for this.
With ‘HDB start’ you can start the database again
but this typically you won’t use that much as starting up the VM will also startup HANA.
Another suggested next step is to assign a static IP to the VM.
Select “Learn more” to find out how you can do that and then select
GO TO THE EXTERNAL IP ADDRESSES PAGE
to perform the configuration.
This will bring us back to the Google Cloud Platform console, section Networking.
External IP addresses.
Then, just switch the type from Ephemeral to Static.
Give it a name and, optionally, a description.
And we are good
and this allows you to connect to the VM with the same IP each and every time.
So you can add the IP to the local hosts file of your computer, for example.
It is a bit more convenient.
While we are at it, this is also where you can configure firewall rules.
I have not made any modifications, these are the defaults.
For example, we have port 8090 for HTTP traffic from the HANA XS classic model.
So, if we enter the IP of our express instance in the URL bar with the port 8090,
we can see that the XS engine is up and running.
OK
I will stop HANA now: ‘HDB stop’
and then in the cloud platform menu go to Compute Engine
and stop the HANA express virtual machine instance.
Wait a couple of seconds and were done.
OK
So much for getting started with HANA express on the Google Cloud Platform.
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.