Hello and welcome to the SAP HANA Academy.
You are watching the video tutorial series: Building Solutions - Live 5.
The topic of this video tutorial is Initial Setup - XS Advanced Administration
Hi, I am Denys van Kempen.
In this video, we are going to perform the necessary configuration of XSA, the built-in
extended application services, advanced model.
Now, for those not yet familiar with XSA, or if you wish to brush up on your knowledge,
I warmly recommend the dedicated playlist on the topic on the SAP HANA Academy by Philip.
I will include the link to the playlist, below in the description of this video.
For this video, I am going to assume that you are familiar so we can dive straight in.
For the configuration, we are going to use the XS Advanced Administration tool, a web
client, so the first thing we need to figure out is how to connect to this tool.
HANA express uses port routing, so we need to find the correct port to use.
There are two ways how you can obtain this information.
One, by using the xs command line tool, and two, by URL.
I will use the second option; it is a bit easier.
The full URL is HTTPS, host name, so for us that’s hxehost, then the port 3 plus instance
number plus 30, which makes 3 90 30 /v2 /info.
It is the URL for the XS Controller.
First time, you will get a warning: HTTPS not secure.
If you select the ADVANCED link, you can read that the certificate is not trusted.
This is because the HANA express host is using a self-signed certificate.
That’s like printing your own money.
So it is good that we get a warning.
If you go beyond using HANA express for training or development purposes, you or your system
administrator need to configure HANA to use a valid certification authority and there
are videos on the Academy about how you can do that.
For our purposes, this is not an issue, so select the “Proceed to hxehost (unsafe)” link.
The XS Controller informs us about the different services available with the corresponding
port number.
We are interested here in xsa-admin, so that’s port 5 10 15.
You can just click the link.
That will first prompt us to logon with a database user account that has the privileges
to connect to the XS Advanced Administrator.
This is the XSA_ADMIN account and the password will be the master password that you defined
when installing HANA express or when connecting for the first time.
We have seen this in a previous video.
We have also seen in a previous video how to configure the Google Chrome browser for
our Live 5 project.
So, make sure you have watched that video and performed the required configuration tasks.
Otherwise, you will get stuck here.
XSA_ADMIN
Master password.
If you are prompted to change the password, please do.
Eight characters or more, one uppercase, one lowercase and one digit, no special characters.
You can change the password policy in the password policy editor.
Here we have the editor in HANA studio, in case you wish to change the policy.
In the XS Advanced Administration tool, click the SAP HANA Logical Database Setup tile.
On the next page, we see two logical databases: HXE, that’s the system database; and SHA,
that’s the tenant database we just created in the previous video.
Select the button Enable for XS Advanced.
Provide database credentials
System database user is system.
Logical database password, in fact, is the password of the system user of the tenant database.
OK
We get a message that the database is now enabled.
Status is running.
All is well.
Select the home button.
Next, select the Organization and Space Management tile.
We have one organization: HANAExpress and two spaces in that organization: development and SAP.
What we are going to do is create another space and call it DEV.
Click “+ Create Space”
Space Name: DEV, all uppercase.
Create
Select the DEV space.
Select Users
Click “+ Add User”
Select the XSA_DEV and XSA_ADMIN users.
OK
Authorise XSA_ADMIN as Manager and Developer.
Authorise XSA_DEV as Developer only.
Click Save.
Return Home.
Select the SAP HANA Service Broker Configuration tile.
Select HANAExpress / DEV and map it to the logical database SHA.
Click Map.
Then, select SHA, tick the box, and then select default.
OK
Database mapping successfully updated.
Return Home.
Now select the Application Monitor tile.
Scroll down a bit until you get to the di-space-enablement-ui application.
Start it with the start button.
Takes a couple of seconds.
The page does not refresh automatically so you might want to manually refresh it.
Open the URL and enable the DEV space by selecting the Enable button.
In the log window we can read that this might take a few minutes, so be patient.
It took less then a minute in my case, your mileage may vary, but if you scroll down to
the bottom of the log window you should see the message the builder has been deployed successfully.
So much for Initial Setup - XS Advanced Administration.
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