Update May 2018
SAP HANA 1.0 SPS 08 is no longer supported.
For a more recent blog on this topic, see
Recently, we have created a number of new tutorial videos for the SAP HANA Academy to show new features and functionality introduced with SAP HANA Support Package Stack (SPS) 08. You can find them collected on the YouTube playlist: SPS 08 – What’s New.
To highlight some, Philip added 19 new videos to the playlist on the Predictive Analysis Library, 5 new videos to the SAP River playlist, 12 new videos on SAP River RDE, while Bob recorded a nice introduction to SAP HANA Answers and provided an update to the playlist on SAP HANA smart data access.
In this blog, my focus will be on what’s new for SAP HANA SPS 08 on the topic of installation and update.
If you want a complete overview of what’s new in SAP HANA SPS 08, I recommend Michael Eacrett’s Blog: What’s New in SAP HANA SPS 08 | SAP HANA on the SAP HANA community site.
SAP HANA Master Guide
Most of you will be familiar with the SAP HANA Master Guide, the central starting point for the technical implementation of SAP HANA. In this guide you will find information about the architecture, software components and deployment scenarios.
In the past, we have seen only minor updates to the Master Guide from release to release, but for SPS 08, the guide has been significantly modified on a number of chapters. The introduction has been improved and sample use cases, architecture configurations, and deployment options are now included. The curious section about how to configure the Excel client ODBO driver has finally been removed and related information, SAP Notes, etc. has been moved to the Appendix, where it belongs.
In this SAP HANA Academy video, I provide a brief overview about the new Master Guide, which also serves as an introduction for those not yet familiar with HANA.
SAP HANA Server Installation
With SPS 08, the information from the Update and Configuration Guide and the Installation Guide has been merged into a single Installation and Update Guide. The update information now includes updating a SAP HANA system and components from both the SAP HANA lifecycle management tool hdblcm(gui) and the SAP HANA lifecycle manager.
Initially, SAP HANA was available only as an appliance with preconfigured hardware and preinstalled software, provided by a SAP hardware partner. With the introduction of Tailored Data Center Integration (TDI FAQ) more flexibility, openness and freedom of choice was given for the SAP HANA customer. See also: SAP Certified Appliance Hardware for SAP HANA
As of SPS 08, RedHat Enterprise Linux (RHEL) is now a supported operating system and a specific Configuration Guide about how to prepare your RHEL system for HANA has been added. The guide is attached to SAP Note 2009879 – SAP HANA Guidelines for Red Hat Enterprise Linux (RHEL) Operating System.
In this HANA Academy tutorial video on HANA server installation, I discuss general preparation topics …
… and in the next video get hands-on with preparing a RHEL system for HANA using the guide.
Some new features have been introduced for the server installation as well with SPS 08:
- Specify the maximum memory allocation for a new system during installation
- Specify the usage type of the system to be installed
We can see this in action in this HANA Academy tutorial video on performing an interactive installation using Lifecycle Manager (hdblcmgui).
Scripted installations using a parameter file and a password file is discussed in the video on automating installations:
System Usage is discussed in this tutorial video (SPS 08 – What’s New playlist as the topic is not restricted to the installation)
SAP HANA Client Installation
As of SAP HANA SPS 08, Windows 2012 R2 is included as a supported operating system for the SAP HANA client, and as client interface Microsoft ADO.NET has been added to complement ODBC, JDBC and ODBO (Excel OLEDB for OLAP driver).
ADO.NET sample code is included in the SAP HANA Developer Guide and in the SAP HANA Data Provider for Microsoft ADO.NET Reference.
In this tutorial video, the SAP HANA Client installation on Windows is demonstrated ..
… and on Linux
SAP HANA Studio Installation
It is now possible to configure role-based SAP HANA studio features. The role-based feature sets are administration, database development, and application development. This allows for a more focused SAP HANA studio environment with targeted menu’s.
Feature-based SAP HANA studio is demonstrated in this tutorial video.
SAP HANA Answers
New with SPS 08 is SAP HANA Answers, a knowledge hub for SAP HANA that can be integrated with SAP HANA studio. When installed it provides a new view in SAP HANA studio allowing you to find answers to questions based on your context or ask questions to the community.
SAP HANA Answers is explained in this playlist by Bob. Below the first video of that list.
Uninstall SAP HANA
The SAP HANA Lifecycle Management tool (HLM) nicely bundles common post-installation configuration tasks, including uninstall. In the video below we see the tool in action in both graphical mode [hdblcmgui] and command line mode [hdblcm] for scripted automation.
The last videos shows common post-installation tasks like making an initial backup, creating a user store key, and starting, stopping and getting process information using the command line.
Thank you for watching
You can view more free online videos and hands-on use cases to help you answer the What, How and Why questions about SAP HANA and Analytics on the SAP HANA Academy at youtube.com/saphanaacademy or follow us on Twitter @saphanaacademy.