Friday 11 March 2016

Demystifying SAP HANA Administration

Since its release, SAP HANA represented a radical change in the direction of SAP's product architecture. As an SAP Instructor, I’ve been wondering how easy it would be to manage the new SAP HANA platform. Can I use platform and administration tools that are currently in place? Or, do I need to learn a new set of gadgets?

After reading through some of the documentation available in SAP Learning Hub, and reviewing SAP courses such as SAP HANA Introduction (HA100), SAP HANA - Operations & Administration (HA200), and SAP HANA Implementation and Modeling (HA300), I realized that the learning curve is quite easy – if you get some guidance up-front. That’s why I’m here! This blog will demystify SAP HANA administration by listing tools you can use to handle periodic administrative tasks, and by explaining the key capabilities of each and when to use them.

If you’re an SAP System Administrator (BASIS Administrator) or Database Administrator, you may be surprised to learn that although there are new tools to manage SAP HANA, some of the old SAP BASIS tools will also help you get the job done. These are the five major SAP HANA administration tools:
  • SAP HANA studio
  • SAP HANA cockpit
  • SAP DB Control Center
  • SAP Solution Manager/DBA Cockpit
  • Command Line (HDBSQL)
The following figure summarizes the role of each tool.

SAP HANA Administration

Tool #1 - SAP HANA studio

Administrators use SAP HANA studio to start and stop services, monitor the system, configure system settings, perform backup/recovery, and manage users and authorizations.

SAP HANA Administration

SAP HANA Administration

Tool #2 - SAP HANA cockpit

SAP HANA cockpit is an SAP Fiori Launchpad application that provides single point-of-access to a range of web-based applications for the administration of SAP HANA. It’s installed automatically with SAP HANA and displays the content as tiles arranged in groups that can be customized. Additionally, the cockpit provides a role-based concept that enables you to control which tiles/apps from the tiles catalog can be accessed by which administrator.

Demystifying SAP HANA Administration

Tool #3 - SAP DB Control Center

SAP DB Control Center is SAP’s new generation of enterprise-class systems management solutions that enables DBAs to administer and monitor a variety of SAP database products in one graphical user interface, either locally or remotely.
It was first available with SAP HANA SPS 09, and it’s added as a delivery unit that can be downloaded from the SAP Support Portal – Software Downloads.

Demystifying SAP HANA Administration

Tool #4 - SAP Solution Manager/DBACOCKPIT

DBACOCKPIT is an ABAP based database management tool available in SAP NetWeaver ABAP systems such as SAP Solution Manager. It supports SAP HANA as well as other databases.

The transaction code DBACOCKPIT enables you to monitor and administer SAP HANA remotely. Additionally, it provides quick access to a range of analysis information, for example, performance monitoring, space management, and job scheduling.

Demystifying SAP HANA Administration

Tool #5 - HDBSQL – Command Line Tool

SAP HANA HDBSQL is a command line tool for entering and executing SQL statements, executing database procedures, and querying information about SAP HANA databases.

SAP HANA Tutorial and Certifications

No comments:

Post a Comment