Hello and welcome to the SAP HANA Academy.
The topic of this video tutorial series is SAP HANA as a Service and in this video we
will take a look at how we create SAP HANA databases, as a service, in the Cloud Foundry
environment on the SAP Cloud Platform.
This video has been recorded in December 2018.
For earlier or later releases, please check the playlist on the SAP HANA Academy.
Hi, I am Denys van Kempen.
This video is part of a series.
In the first video, we provided a bit of background and showed you where to find more information.
In the second video, we looked at database creation in the Neo environment.
There are already videos about how to create HANA databases on the Cloud Platform, so I
am not going to repeat that material here.
The focus will be on the differences between both environments, so you will know which
one to choose.
OK — we are back at SAP Cloud Platform Cockpit.
Go into your global account, then, before you open your subaccount, make sure there
is quota assigned to the HANA service.
Enter Entitlements.
Under All Services, you can select SAP HANA.
Click Edit, and make sure you have at least 1 service assigned: standard or enterprise,
or both.
Then we can go to the subaccounts section and this time select the Cloud Foundry environment,
and note that the assigned quota is listed here.
Very well.
In Cloud Foundry, we first need to go into a space and then we need to check that the
SAP HANA Service is enabled.
We also did this in the Neo environment.
The documentation link brings you to the Getting Started Guide for the SAP HANA Service for
Cloud Foundry.
How to create database instances is all documented here.
The Support link opens the page, in the same guide, that explains how you can make your
service request with SAP Support, should you want to make some changes to the environment
not covered by self-service.
Then, we can go to instances, and here we can create a new instance.
From the Neo video, you may recall that at this stage, we first had to create a database
system and we could choose between single-container (HANA XS) and multiple-database container
(MDC) systems.
We do not have this on Cloud Foundry, there is no MDC.
It is all single-container.
Choose your Service Plan, the edition that is, standard or enterprise.
We discussed this in the first video of this series when we talked about the Feature Scope
Description.
You will need to have assigned quota for this plan in order to proceed.
Then we are going to specify the parameters
The system user password, just like when we created a tenant database in Neo.
Memory in blocks.
So, unlike Neo, we can specify in Cloud Foundry the size of the instance when we create it.
Whitelisted connections.
Basically, you create a firewall rule for this instance and then the Capabilities: Script
Server for Predictive, Machine Learning, Data Provisioning Agent for Smart Data Integration,
the Document Store, and High Availability.
Optionally, assign applications to bind, you can do this later on as well, of course.
Enter the instance name and this is just to reference in the Cloud Platform Cockpit.
Creating an instance will take some time.
Fast forward
When created, instances will be listed under Services, Service instances.
Service type is hana-db.
From here you can open the dashboard, bind the service, or delete it.
If you select the instance, you can do the same
Let’s open the dashboard.
This will launch in a separate window or tab, we are in fact connecting to the HANA Service
as an app on Cloud Plaform.
You connect with your SCP ID, your cloud platform account.
SAP HANA Service Dashboard
We get the endpoints to connect to the service: direct SQL or web socket - this is all explained
in other video tutorials in this series.
Note that in Neo we only had a JDBC URL.
We can configure some settings: the IP Whitelist, for example, and the capabilites.
We can stop the SAP HANA Service from here.
Remember that in Neo, we could stop and start tenant databases but not the HANA System.
Here we can.
And we can connect to the SAP HANA cockpit.
Cockpit 2.0, that is, not Cockpit 1.0 as for Neo.
The version is what looks like HANA 2.0 SPS 04, to be release next year, but we are, in
fact, looking at the SAP HANA Cloud Edition and versioning works a bit different but we
can see that it is cloud-first these days.
The latest functionality is first release for the SAP HANA service.
From here you can also open the SAP HANA Database Explorer with the SQL Console and the Catalog
browser.
Works the same as on-premise
OK —That’s it.
SAP HANA as a Service on Cloud Foundry.
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.