Week 1: Basics and Tooling

Unit 4: The SAP HANA Cockpit

SAP HANA Cockpit
Simplified architecture

Three main pieces:

SAP HANA Database Explorer

SAP HANA
1. Built on SAP HANA extended application
cockpit MTA MTA
services, advanced model (XSA), a micro-

XSA
services platform for the development and Cockpit admin + View/interact with
database database objects +
execution of native, data-intensive applications management analyze SQL queries
2. Cockpit features are implemented as XSA multi-
target applications (MTAs) Persistence (embedded SAP HANA, express edition)
3. Persistence: configuration and historical data
SAP HANA cockpit
store
<sidadm> OS user Named database user

The SAP HANA cockpit is installed as a HTTP/XML SQL client

single software stack – no need to install SPS12
each piece individually Host HANA SPS12
Host
SAP SAP HANA 1.0orSPS12
Agent or
Agent
Host HANA 2
or
HANA 2
Agent SAP HANA 2.0

© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 2

SAP HANA Cockpit
Internals

Cockpit Cockpit
Administrator User

Cockpit manager UAA SAP HANA cockpit Database Explorer MTA

(cockpit-admin-web-app) (cockpit-web-app)
Cockpit admin UI / App Router Security Cockpit UI / App Router sqlanlz-
sqlanlz-ui
SAP HANA cockpit MTA

svc
cockpit-landscape-svc
SAP HANA XSA

Info about systems in the enterprise

hrtt-
hrtt-core
cockpit-adminui-svc cockpit-hdbui-svc service
Cockpit Manager back-end services Micro- Cockpit back-end services
services
interact
with each
cockpit-persistence-svc cockpit-hdb-svc SAP Host Agent
Local persistence of app data other Monitored db service
SAP HANA 1.0 SPS12
cockpit-collection-svc or
Scheduled tasks to retrieve monitored db info
SAP HANA 2.0

Monitored
Persistence (embedded SAP HANA, express edition) databases
© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 3
SAP HANA Cockpit
System requirements

Processor Memory Hard Disk Operating Web Browser

System
For Intel x64: Google Chrome
Minimum 16 GB + ▪ Red Hat Enterprise
Minimum 16 GB Linux for SAP HANA
Intel x64 space required for
RAM 7.2
data
Mozilla Firefox
▪ SUSE Linux
Enterprise Server for
SAP Applications 12
Microsoft Internet
SP1
Explorer 11

For IBM PPC LE:

Microsoft Edge
IBM PowerPC Little ▪ SUSE Linux
Endian Enterprise Server for
SAP Applications 12
SP1 Apple Safari

© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 4

SAP HANA Cockpit
Deployment scenarios

Dedicated Hardware Shared Hardware

Server 1 Server 2 Server

SAP SAP
Application Application

SAP SAP
System System
SAP HANA SAP HANA
Cockpit Cockpit
DB Schema DB Schema
SAP HANA SAP HANA

Operating System Operating System Operating System

Storage Storage Storage

Production Non-Production
© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 5
SAP HANA Cockpit
Getting started – Download

▪ SAP HANA platform 2.0 includes the installation media for SAP HANA cockpit
▪ SAP HANA cockpit periodically releases support packages (SPs) including new functionality, fixes, and
security patches. Each SP includes all the features of the previous SP
▪ The cockpit also provides patches for the most recently released SP that include fixes and security patches.
Once a new SP is released, SAP provides no patches for earlier SPs
▪ Download the latest SAP HANA cockpit SP and patch from the “Support Packages & Patches” section of the
SAP Software Download Center:

Support SAP HANA SAP HANA

SAP Support Software SAP HANA
My Support Packages & H Platform Platform
Portal Home Downloads Cockpit 2.0
Patches Edition Edition 2.0

© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 6

SAP HANA Cockpit
Getting started – Installation

Installation scripts
▪ For command-line installation, execute hdblcm.sh
▪ For GUI installation, execute hdblcmgui.sh

Default install configuration

▪ Settings in the file auto_install.cfg inside the folder HDB_SERVER_LINUX_X86_64/configurations
▪ Database server properties in *.ini files inside the folder custom
▪ DBAs are free to change these settings and properties as appropriate for their deployment

Installation/upgrade log file created in /var/tmp

Application URLs provided at the end of installation:

▪ Launch SAP HANA cockpit by opening https://<hostname>:51021
▪ Launch SAP HANA cockpit manager by opening https://<hostname>:51023
▪ Installation assigns free ports, but it’s possible to specify them beforehand – see SAP Note 2389709
© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 7
SAP HANA Cockpit
Launching cockpit manager and SAP HANA cockpit

Cockpit Manager SAP HANA Cockpit

[https://<hostname>:51023] [https://<hostname>:51021]
▪ Use for cockpit administration ▪ Use to manage remote SAP HANA systems
(users/resources/groups/settings) (called “resources”)

© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 8

Thank you.
Contact information:

open@sap.com
© 2017 SAP SE or an SAP affiliate company. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company.

The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and its distributors contain proprietary software components
of other software vendors. National product specifications may vary.

These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP or its affiliated
companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP or SAP affiliate company products and services are those that are
set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this docume nt or any related presentation, or to develop or release
any functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ st rategy and possible future developments, products,
and/or platform directions and functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason without notice. The
information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. All forward-looking statements are subject to various
risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements,
and they should not be relied upon in making purchasing decisions.

SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trade marks of SAP SE (or an SAP affiliate company)
in Germany and other countries. All other product and service names mentioned are the trademarks of their respective companie s.
See http://global.sap.com/corporate-en/legal/copyright/index.epx for additional trademark information and notices.