Hi, my name is Denys van Kempen, SAP HANA Academy. You are watching a video tutorial that is
part of a series about SAP Business Technology Platform certifications,
part of the playlist SAP Certified Development Associate - SAP HANA Cloud
This tutorial covers the topic area SAP HANA Cloud, Modeling, and Administration Basics
This video was recorded in September 2022.
For the latest tutorials on the topic, please check the playlist.
The topic areas for the exam are listed on the exam page on the learning.sap.com website
SAP HANA Cloud, Modeling, and Administration Basics covers 10% or about 8 questions.
The questions are sourced from the first four units of SAP HANA Cloud Foundation,
12 lessons - about 7 hours,
we find the same content in the preparation material of the other
two SAP HANA Cloud exams: administration and modeling,
plus the first unit of SAP HANA Cloud Application Development:
Introducing Application Development in SAP HANA Cloud
We will go through this fairly quick as we cover HANA Cloud administration
extensively in the playlist dedicated to the exam, the same for modeling
if you are completely new to HANA Cloud, suggest to take a look at these series as well.
Let’s start with an illustration of the SAP Business Technology Platform,
as presented last year at the SAPPHIRE event, and later at TechEd
The platform is a portfolio, a box, containing four other portfolios,
database and data management,
analytics, application development and integration, and intelligent technologies
and when we look what’s inside those four portfolios, we find both cloud
services, like SAP HANA Cloud, as on-premises products, like SAP HANA.
Same under anlytics: SAP Analytics Cloud and SAP BusinessObjects BI (on-premises).
Now, not to confuse you but to make a point
if we navigate today to the SAP.com website,
Products,
we find five portfolios listed,
with different labels
more info here under solutions
instead of application development and integration we now have application development and automation
database and data management has been merged with analytics
and when we look at the solutions,
only cloud services are listed
what’s up?
it is called marketing
the SAP Business Technology Platform is a concept,
it is a box, and what’s on the box and inside the box changes over time,
for the exam, however, this is the picture you are expected to be familiar with,
don’t need to memorise all the product names, but know the boxes
you should also be familiar, to some extent, with SAP HANA Cloud key technologies,
The same, for the most part, as with the SAP HANA platform, on-premises.
Books have been written about this, and HANA has been on the market for over 10 years,
so we are not going to spend too much time on this
there is a solution brief you can take a look at
with some illustrations
SAP HANA Cloud is a BTP, a Business Technology Platform, service
with two modules, the SAP HANA database and the Data Lake
It is an in-memory database - all data is stored in-memory,
ranging from 32 GB, smallest size, to 5 or 6 TeraBytes, depending on the platform.
This is for hot data, which needs to be instantly accessible.
For warm data, less frequently queried, we have NSE, native storage extensions,
using disk storage and a buffer cache similar to those found with other relational databases.
For cold data, we can use the HANA Cloud Data Lake,
leveraging Sybase technology IQ, for structured files.
To access other data stores, we can use replication or federation / virtualisation,
technologies know as smart data access (SDA) and smart data integration (SDI).
the HANA database supports what’s called smart multi-model processing, that is,
both transactional and analytical processing, OLTP and OLAP, also known
as HTAP, hybrid transaction/analytical processing, a term coined by Gartner,
a spatial engine, a graph engine, a JSON document store (NoSQL),
business and application function libraries (BFL and AFL), a predicitive analysis library (PAL),
for machine learning scenarios, it is all included
the next illustration shows the different tiering options
the different engines
and the benefits
you can review the material here under SAP HANA Cloud Features
database management
administration
security
virtualization
appliation development
the illustrations show the different tools used by the personas: the database administrator, the DBA,
the developer, the modeler,
== 2
there is also some technical information
with a link to another document
illustrating all the features and functions
and their benefits
we should also mention the documentation,
on the SAP Help Portal
there is an SAP HANA Cloud overview guide
which, in a couple of pages,
describes what you need to know
==
How can we access SAP HANA Cloud?
I am connected here to the SAP BTP Cockpit,
the trial environment, you can sign up for free and get a trial account,
as announced at TechEd last year, 2021, there is now also a free-tier for the platform,
with the advantage of an upgrade option to a paid subscription,
while keeping both data and configuration, maybe you have already developed an app prototype.
In the trial environment, everything is discarded when the trial expires.
It might be that the trial is on the way out,
but training material still references the trail, so we are going use the same,
there are some minor differences between trial and production accounts,
we will cover this as we go along
if you are completely new to the SAP BTP Cockpit,
there is a guided tour you can take, as introduction
here we are on the account explorer,
showing directories and subaccount,
with directories we can organize the environment,
and we can create directories and subaccounts here
when you create a subaccount, you need to select a region and cloud provider,
for the trial these are Amazon Web Services in US East or Microsoft Azure in Singapore
for production, the list is quite a bit longer
and also includes the Google Cloud Platform, and SAP for the legacy Neo environment
subaccounts is where the processing takes place,
where the data is stored, where you actually consume services, for which you can be billed
the global account is just the commercial side, your contract with SAP
this is where you can view the service assignments,
for example HANA Cloud,
and when HANA Cloud is not listed here, you would need to subscribe to the service,
via the SAP Store, or contact your SAP representative and sign up
when a service has been assigned to your global account, you,
the global administrator that is, can configure the subaccount
configure the entitlements of the subaccount
and add the service plan
for the trial this has been setup
for a production account,
you need to configure this yourself
takes a few seconds,
just metadata,
no services are created yet
note that for production accounts, you also need to configure global account security,
create users,
create roles,
configure the trust configuration,
for example to use an external identity provider, like Microsoft Active Directory
before we can create a service instance of SAP HANA Cloud,
we first need to enable the Cloud Foundry environment in our subaccount
also takes a few seconds
and create a space
orgs and spaces are Cloud Foundry concepts, to organize the environment
when we now enter the space
we can take a shortcut
or navigate to spaces
and select the tile, select the card
we now have SAP HANA Cloud on the menu
and here we can create either a database or a data lake
for this we need to sign in,
to launch the SAP HANA Cloud Central webapp,
again, we can choose to either create a database or data lake,
with a bit of marketing, here we find the HANA Cloud features and benefits again
next step
give the instance a name
a description
and a password for the database administration account, DBADMIN
we can see an estimate of the total amount of compute units required for this instance,
the maximum amount of data in-memory and on disk
with the details
next step
here we define the amount of memory and storage we want to assign to our instance
30 gigabytes is the minimum, 5970, 6 terabytes almost, the max, for the AWS EU10 region,
note tha the compute units go up,
as do the number of virtual CPUs,
we can only tweak memory and disk storage, not CPU
minimum storage capacity is 120 GB, max 16 terabytes
next step
here we can add replicas and configure availability zone for high availability,
more of an advanced topic, for the administration exam,
advanced settings
here we can add a script server, for the function libraries and predictive analysis,
machine learning, which requires a third CPU,
same for the document store, these are not enabled by default
you can configure the firewall, allowed connections,
and enable the cloud connector, to connect to an on-premises environment
Review and create shows what we have configured so far
Make sure to review the password and select Create Instance
this takes a little while
we can see the memory and storage allocated, compute units, scale-out nodes, and replicas
and when we return to the BTP Cockpit, HANA Cloud menu, we see the same status on the tile
for the trial this works mostly the same
Cloud Foundry will have been enabled automatically with a dev space created
same steps to create the HANA Cloud instance
Memory and storage are not configurable
Replicas not available
We cannot enable the Script Server or the Document Store,
Same options for connections
we can add a data lake, and we can see this in the estimator,
the administration account is HDLADMIN,
but the number of CPUs for the coordinator and the worker, and the number of workers,
is not configurable, nor is the storage service; EFS is the only option
advanced settings
review and create
and create instance
back to our production account
our instance is now running
from the actions menu
we can manage the configuration, for example, add more storage or more memory,
time of recording the only way is up, to down-size your instance you need
to contact SAP Support, create a service request,
we can upgrade and patch our instance, should a new version be available
we can stop and start the instance, for this we need to use the SAP HANA Cloud Central tool,
same for recovery, to restore an older version of the database from backup
to delete
and to access the instance,
either with the administration tool, SAP HANA Cockpit
we need to provide our database credentials
DBADMIN
and we can switch views
security and user management
administration
monitoring
or access the instance with the SAP HANA database explorer
which enables us to browse the catalog, view the database objects, tables, views,
access the trace files,
or use the SQL Console to execute queries against the database
Although there is an integrated debugger,
the SAP HANA database explorer is not the only development tool available.
If we go back to our trial environment,
trial home
we can access the SAP Business Application Studio
this is available as a subscription,
so for the production environment, you need to add the entitlement to
the subaccount and subscribe to the service, a few clicks
and note that there is also a CLI, a command line interface for BTP,
which enables us to programatically create subaccounts, configure security,
configure entitlements, and other BTP activities.
To create a SAP HANA Cloud service instance on the command line, we need the Cloud Foundry CLI,
another command line tool, which we cover in the tutorials series about
the SAP HANA Cloud administration and provisioning certification.
Click the link
the studio is launched as a webapp
first we need to create a dev space,
this is not related to a Cloud Foundry space, just uses the same terminology,
in fact, what this does is to create a Kubernetes pod, a private development environment,
select the extentions,
you are prompted to select the kind of application you want to create,
each with its own selection of predefined extensions
and possible enhancements
creating the space takes a minute or so,
the time to create the pod, the storage, the services,
note the warning that this is a trial environment, if a space is not running
it will be deleted after 30 days,
we can then access our studio dev space
and start a development project,
either from scratch, cloned from Git, imported from another project, and so on
we will return to the App Studio many times during
this tutorials series and will cover all the menus and options as we go along.
that’s it for our HANA Cloud and SAP BTP introduction
You can find the links to the resources mentioned in the description of this video below.
This video tutorial was recorded by Denys van Kempen, SAP HANA Academy.
Any good? Give us a like, and for updates,
don’t forget to subscribe. Thanks for watching.