Hello and welcome to the SAP HANA Academy.
The topic of this video tutorial series is SAP HANA platform Installation and Update
and in this video, we will look into installing SHINE for SAP HANA, express edition.
Hi, I am Denys van Kempen.
In one of the previous videos in this series, we installed SHINE for SAP HANA platform edition.
This involved downloading the component, it is a zip file, from the SAP ONE Support Portal,
the download center.
For SAP HANA, express edition, the setup process is a bit different.
First of all, for Express, we have community support, so we cannot assume access to the
SAP Download center.
For this reason, to download SHINE, we are going to use the Download Manager for HANA express.
Two scenarios.
For those that already have HANA express up and running, you can download SHINE using
the download manager included with the VM.
Of course, in this case, the VM needs to be able to access the internet, but if so,
this is for sure the easiest approach.
I will show you how you can do that in a minute.
Alternatively, and that’s what I am showing you now, we can download SHINE using the same
Download Manager you used to download HANA express.
If you are really just getting started, or in case you want to download the latest version
of the VM, make sure to select the Server + Applications version (or the equivalent binary download)
and then also select SAP HANA Interactive Education.
If you are already working with the VM, you can just download SHINE as well, of course.
The SHINE download itself is about 200 MB.
It is a zipped TAR file with the TGZ extension.
Typically, you will have downloaded the file to your Windows or Mac client computer and
now need to copy it over to the HANA VM or, in case you are running
SAP HANA, express edition in the cloud, to the hosted VM.
For this, you can use Windows Secure Copy (WinSCP) which uses SSH, secure shell.
It is a free download just like PuTTY for telnet.
For the cloud-based environments, it is probably easier to use the cloud SDK of the vendor.
Google provides gcloud scp (secure copy) using your SSH key, for example.
Very convenient.
If you already have express up and running, as mentioned, we can use the download manager
included with the VM.
Here, I am connected to a HANA express system running on Google Cloud.
I have just created a new instance and performed the required pre-requisite steps.
There are videos in the SAP HANA express playlist that show you how you can do this.
Now, just change directories to ‘/usr/sap/HXE/home’
It is just one level up.
and run the command from the bin directory
HXEDownloadManager_linux.bin linuxx86_64 (there are 2 x’s) vm shine.tgz
And this will download the file directly to the VM.
Assuming the VM has internet connectivity, of course, and there is no firewall blocking access.
Let’s list the file with the ls command.
It is in the Downloads directory, which should have been created, and then we need to extract our file.
For this, use the command tar -x (for extract) z (for zipped) f (for file) and you
can add v for verbose, if you want, for some progress indication.
Make sure to add it before the ‘f’.
If we briefly look at the installation script, we can see that it is quite comprehensive.
Checks for the files, version, and so on.
Creates the SHINE user
And grants the required permissions.
Checking for the required services; same thing as when you are doing a SHINE installation
on the HANA platform yourself.
OK.
In the documentation is mentioned that you need to first run a script to free up some memory.
hxe_gc.sh
It is in the bin directory under home.
Frees up about 1 GB on my system.
And then we simply install SHINE using the script included with the download.
Confirm the instance number, defaults to 90
Enter the password of the SYSTEM database user
Enter the password of the XSA_SHINE user.
This user is going to be created.
Confirm it
And enter Y for Yes to proceed with the installation.
As you can see, again the garbage collection is taking place - so it wasn’t really necessary
to run the gc (garbage collection) script before but it doesn’t hurt either.
What follows it the regular output we have seen with the ‘xs install’ command on
the platform edition.
So basically, it is the same approach, except that we do not have to manually create our
SHINE user and grant the required role privileges.
The installation takes about 10 minutes, give or take.
Let’s first connect, ‘xs l’, l for login, as XSA admin.
For the installation logs, you can execute ‘xs display-installation-logs’
The log is pretty verbose.
With ‘xs a’ a for apps, you can view all the applications and here we have our shine-web
with the URL
It will open with hxehost as hostname on my system, so I have added this as an alias to
the local hosts file, we have covered this in another video tutorial or, alternatively,
just enter the IP address in the URL bar of your browser.
Username is XSA_SHINE, the password you provided yourself and then we get the What’s New
screen with prerequisites check.
Let’s briefly do this.
We need to create the SHINE_ADMIN Role Collections
which we then have to grant to our XSA_SHINE user
We will be logged out automatically and before we log on again,
let’s first add the role collection.
For this we are going to use the XS Advanced administration tool
Connect as XSA_ADMIN
User Management
Select XSA_SHINE
Role collections tab
Add
Scroll down
SHINE_ADMIN
Select it and click OK
Click Save.
You might get this error (or hopefully it will be fixed).
The user was created without a valid email ID.
This is fine when using SQL but not when using the Admin tool.
So, let’s fix this.
Any name will do with an @ and dot.
Save
Return home and log out.
And if we now return to our SHINE web
And log on as XSA_SHINE again
Check Prerequisites.
We can now generate time data.
Just click the button.
OK
And if we open the Data Generator, we get, what looks like an error, permissions required,
but is, in fact, a warning, but we already granted the SHINE_ADMIN role to XSA_SHINE
so we are good to go. Continue
Select Generate Data and enter a value for the number of purchase orders and sales orders.
You can enter a number between 1 to 5.
Let’s make that 2 and 3
Execute
Yes I am sure.
And here we have our data.
If we return to the SHINE home page and open the Sales Dashboard, for example,
We first get a pop-up that provides some background information.
I will uncheck the Do not show this again, so I can read this at my leisure next time
Continue
And “voila”, here is our Sales Dashboard.
OK
Please check the documentation for the next steps on how you can use SHINE to learn how
you can build beautiful XS Advanced applications running natively on SAP HANA.
That’s it.
Thanks for watching.
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.