Hello and welcome to the SAP HANA Academy.
The topic of this video tutorial series is SAP HANA Cockpit and in this video we will
talk about a new SP 07 feature: Configuration Templates.
This video has been recorded on release SAP HANA cockpit 2.0 SP 07 from August 2018.
For earlier or later releases, please check the playlist on the SAP HANA Academy.
Hi, I am Denys van Kempen.
You can use Configuration Templates for two distinct purposes.
You can compare the configuration parameters for different systems, or more accurately,
managed resources: could be a system, could be a tenant database, or a host (a server),
and you can capture a collection, a set of parameter values, save them as a template,
and apply them to other managed resources.
Any cockpit user can apply templates.
However, to create and/or manage them, you need a new user role, Cockpit Template Administrator.
So, let’s start with that.
You can add the System Configuration Template Administrator Role to existing cockpit users,
and, of course, when you create a new cockpit user, you can select Allow this user to manage
system configuration templates.
OK —Let’s connect and then here, under Manage Landscape, we have two new cards, or
tiles, if you prefer,
Configuration Templates and Compare Configurations.
Let’s start with Configuration Templates.
Select Create Template
Give the template a name.
For this template, we are going the change the settings of the HTTPServer for XS Classic,
so I will name this template HTTPServer.
You can use any name you want.
Step two is to select your model system, your source system, so to speak.
System is maybe not the best word here as we can select from the layer not only System
but also the host (the server) and tenant databases.
I will select DATABASE.
My tenant databases are listed.
As source, I will select the default tenant HA0, which was created during the installation.
In step 3, we are going to select the parameters.
They are ordered by the configuration file, by the INI file.
For tenant databases, we only have a couple we can add to a template, so let’s select
httpserver under xsengine.ini.
The parameter is ‘embedded’ and the value is ‘false’.
Select Review.
Should you have made any error, you can fix that here, and if not select Create Template.
Here we have our new template.
Created by, Creation date, Model Resource, Layer.
All the information we need.
We can select our templateand then select Apply to Databases.
Select the target database, the database you want to apply the template to.
I will pick Alphaand a message is returned: Templates applied successfully.
OK —On this screen, we can also rename our template and add a description, should we
have changed our mind, or delete a template, should we no longer need it.
Let’s go backand open the Configuration Manager.
Select your tenant databases.
Select the database.
This time, I will select Beta, and select Compare
Beta is our source system.
As target, I will select Alpha.
We could have done this the other way around, or course, this doesn’t really matter here.
A difference is detected in the xsengine.ini file, which is why it is listed here with
a number.
If we then select Show differences only, We can see that Beta, our source, has the configuration
embedded=true for both the database and system layer, whereas our target, Alpha, has the
value false.
OK —Let’s go homeand select Compare Configurationsagain, select tenant databases, and pick Beta
This time, I am going to select the Snapshots tab.
No data, there is no shapshot yet.
So, let’s create one, with the plus here, on the toolbar.
Add a description.
Let’s use Baseline.
Click OK.
And here we have our baseline snapshot.
Back Home again, this time I will move a bit quicker, as we have already seen this.
Configuration Templates
HTTPServer
Apply to Databases
Select Beta
Apply Template
Templates applied successfully.
OK
Back Home
Compare Configurations
Tenants
Beta
Snapshots
Add
Description?
Well, HTTP Template
OK
Now we can select Compare Snapshots.
So, instead of comparing different databases or different systems, we are comparing the
configuration or a single system or single tenant database at different points in time.
Again, xsengine is returned.
Show differences only, and now we can see that the baseline value for embedded was false,
the default, but that the current value, or at least at the time of the snapshot, it is
true: httpserver is embedded.
Very, very easy.
With Compare Configurations, we can compare the configuration of a particular database
in time or in space, I guess, with other systems that is, and with Configuration Templates,
we can create a template with certain desired values for our tenants, for our system databases,
and/or for our hosts, which we can then apply to other systems.
OK —That’s it.
Working with Configurations and Configuration Templates is documented in the SAP HANA Administration
with SAP HANA Cockpit Guide, which you can view or download, free of charge, from the
SAP Help Portal on help.sap.com.
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 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 this video.
Thank you for watching.