Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

SAP HANA 2.0 Client Installation and Update – by the SAP HANA Academy

Introduction

Installing or updating the Sap Hana client takes 20 seconds, if that, and is very easy to do.

When using the Windows installer hdbsetup, you will have to decide whether to install or update, click Next and then click Install or Update corresponding to your first selection.

When using the command line installer hdbinst, you can make reduce installation anxiety even more by running the command with the -b for batch parameter and the tool will make any decision for you using the (documented) default selections. This makes it very easy, of course, to fully script the update of the SAP HANA client so this can be performed at midnight during a maintenance window on all 20, 50 or 400 client systems in your landscape.

Although the task is easy, it is still important to properly prepare yourself before performing the activity. What ODBC, JDBC, ADO.NET or Python client versions are included exactly in the SAP HANA client? Which SAP HANA server releases exactly are compatible with the latest SAP HANA client?

To address these questions, we have recently updated two SAP HANA Academy tutorial videos about the SAP HANA client included in the SPS 02 Installation and Update playlist:

  • SAP HANA Installation and Update – SAP HANA 2.0 SPS 02

For an introduction to the SAP HANA installation and update topic, see:

  • SAP HANA 2.0 installation and update

In this blog, I will provide some references and background information for the client installation and update videos of the series.

SAP HANA Academy – SAP HANA Installation and Update (YouTube Playlist)

SAP HANA Client Supported Platforms

The SAP HANA client is supported on a wide range of desktop computers to enterprise-class hardware and operating systems:

  • Microsoft Windows Server 2008 R2 and later
  • Linux (32 and 64-bit, Intel any distribution)*
  • Linux (IBM Power Systems LE/BE)
  • IBM AIX, HP-UX (Itanium), Oracle Solaris (x64, SPARC)
  • IBM i (IBM Power Systems)
  • Microsoft Windows 7 and later (32 and 64-bit Intel)
  • Mac OS X Yosemite (10.10) and later

For SAP HANA 1.0, it was very common to install the SAP HANA client on a workstation (Desktop) as the regi.exe executable was required to perform repository synchronizations for native development using the SAP HANA XS classic model and SAP HANA studio. This explains the support for both the rather old-fashioned 32-bit platforms and the more fashionable, but a-typical for SAP, Mac OS X platform.

For SAP HANA 2.0, XS classic, the repository (regi.exe), and the SAP HANA studio are no longer in development as this platform now offers the SAP Web IDE for SAP HANA and the SAP HANA cockpit as development and administration tools, respectively.

As the SAP HANA client is also frequently found on SAP Netweaver AS ABAP application servers and as this AS runs on many enterprise-class systems we also find support for IBM Power System, Oracle SPARC, and HP Itanium architectures with its corresponding operating systems.

Normally, you would find technical release information about supported platforms listed in the  Product Availability Matrix (PAM) on the SAP Support Portal. However, according to SAP Note 2499500, even the matrix does not have enough fields for the full range of client platforms and requirements.

For the fine print about supported platforms (particularly on Linux the kernel version and glibc version), see

  • SAP HANA, platform edition 2.0 (SAP HANA as listed in PAM)
  • 2499500 – SAP HANA Client Supported Platforms

Unboxing the SAP HANA Client

The SAP HANA client bundles a number of clients, some of which have been included since day one, like the ODBC, ODBO and JDBC clients for C/C++, OLAP/XMLA, and Java database connectivity, respectively, and the SQLDBC libraries included for good measure.

SQLDBC, originally, are MaxDB client libraries. Why MaxDB? Take a look at the MaxDB SQLCLI client commands and call options and compare this to ones for the SAP HANA Interactive Database Terminal (hdbsql) and you will see the origin of the species. Same for hdbuserstore and XUSER and, on the server-side, much of the persistence infrastructure of SAP HANA.

In an entertaining blog from the very early days of SAP HANA (2011), Lars Breddemann teaches us, HANA novices (pretty much everybody at the time), as a MaxDB veteran, some backup best-practices:

  • HANA backup script hint… a little bit more security, please!

The Python DB API has been included as well from the very early days, not as supported database client – this was only introduced in the latest SAP HANA 2.0 SPS 02 release – but for internal housekeeping. Python was the lingua franca of the TREX Search Engine, which technology made its way into HANA as well.

Apart from Python support, SAP HANA 2.0 SPS 02 also introduced support for the Go language. Support for the Node.js client was introduced a couple of months earlier in SPS 01.

For more information, see the blogs by Tom Slee (SAP HANA product management for client interfaces) on the topic:

  • SAP HANA 2.0 SPS02: New client interface features
  • SAP HANA 2.0 SPS02 new feature: updated python driver
  • SAP HANA 2.0 SPS02 new feature: Go language driver
  • Install the node.js driver for SAP HANA in under a minute

Support for Microsoft ADO.NET was added in SAP HANA 1.0 SPS 08. In the SAP HANA Client Interface Programming Reference and on the SAP Community wiki, you can find some tutorials to get started with .NET programming for SAP HANA.

For more information, see

  • Bridging the gap between .NET and HANA
  • Use the Microsoft Code First to a New Database with the SAP HANA Data Provider Tutorial
  • SAP HANA Data Provider for Microsoft .NET Sample Projects

For the exact versions of the supported clients, see

  • 2499500 – SAP HANA Client Supported Platforms

Please Note

The SAP HANA Client Installation and Update Guide documents the installation and update process, which, as mentioned, is a quick and easy one. However, there are a number of SAP Notes that add additional and important information you might want to take note about.

The most frequently asked questions (real or imagined) are the subject of SAP Note:

  • 2393013 – FAQ: SAP HANA Clients

In case you would like to know, which SAP HANA server release corresponds to client 2.2.33.1510080117 and whether that’s cross-version compatible with your server, see SAP Notes:

  • 2339267 – HANA client version and installation manifest file doesn’t match currently available HANA server version information
  • 1906576 – HANA client and server cross-version compatibility

SAP HANA Client Installation

How to install the SAP HANA client is the topic of this first video. As mentioned, it only takes a couple of seconds but in this video, we discuss what you need to know and where to find that information. We show you the easiest way to download the software, how to install using the graphical installer and how to install on the command line for batch installations (scripted).

Tutorial video

SAP HANA Academy – SAP HANA client installation 

SAP HANA Client Update

Once you have installed the SAP HANA client, you will need to update it from time to time to enjoy the latest features. In this second video tutorial, again, we cover downloads, scripted batch updates on Linux and one/off updates on Windows using the graphical installer. We also show you how you can unbox the client SAR file using the SAPCAR swiss army knife included for free.

Tutorial video

SAP HANA Academy – SAP HANA client update

Developer Trials and Downloads

Currently, the only version of the SAP HANA client available for download outside of the SAP Software Download Center (requiring an SAP account) is version SAP HANA 1.0 SPS 12. It is listed on the SAP Developer Community Trials and Downloads page. This will redirect you the SAP HANA Store where the actual download is available.

SAP HANA 1.0 SPS 12 Client Installation and Update

For your convenience, in case you also still need to perform SAP HANA 1.0 SPS 12 client installations and updates, below the corresponding tutorial video.

SAP HANA Academy – SAP HANA 1.0 SPS 12 Installation and Update

References

For more information see:

SAP HANA Academy Playlists

  • SAP HANA Installation and Update – SAP HANA 2.0 SPS 02
  • SAP HANA Installation and Update – SAP HANA 1.0 SPS 12

SAP Downloads

  • Downloads | SAP ONE Support Launchpad
  • SAP Download Manager | SAP Support Portal
  • SAP Developer Community Trials and Downloads
  • SAP HANA, platform edition 2.0 (SAP HANA as listed in PAM)

SAP Documentation

  • SAP HANA Platform | SAP Help Portal
  • SAP HANA Client Installation and Update Guide | SAP Help Portal
  • Use the Microsoft Code First to a New Database with the SAP HANA Data Provider Tutorial
  • SAP HANA Client Interfaces Reference (New and Changed) – What’s New in the SAP HANA Platform 2.0

SAP Blogs

  • SAP HANA Installation and Update – SAP HANA 2.0 SPS 02
  • HANA backup script hint… a little bit more security, please!
  • Bridging the gap between .NET and HANA
  • SAP HANA Data Provider for Microsoft .NET Sample Projects
  • SAP HANA 2.0 SPS02: New client interface features
  • SAP HANA 2.0 SPS02 new feature: updated python driver
  • SAP HANA 2.0 SPS02 new feature: go language driver
  • Install the node.js driver for SAP HANA in under a minute

Notes

  • 2460914 – SAP HANA Platform 2.0 SPS 02 Release Note
  • 2499500 – SAP HANA Client Supported Platforms
  • 1577128 – Supported clients for SAP HANA (SAP HANA 1.0, does not apply to HANA 2.0)
  • 2393013 – FAQ: SAP HANA Clients
  • 2339267 – HANA client version and installation manifest file doesn’t match currently available HANA server version information
  • 1906576 – HANA client and server cross-version compatibility

Thank you for watching

The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.

For the full library, see SAP HANA Academy Library – by the SAP HANA Academy

For the full list of blogs, see Blog Posts – by the SAP HANA Academy

  • Subscribe to our YouTube channel for updates
  • Join us on LinkedIn linkedin.com/in/saphanaacademy
  • Follow us on Twitter @saphanaacademy
  • Google+ plus.google.com/+saphanaacademy
  • Facebook facebook.com/saphanaacademy



This post first appeared on Web Service Testing A Blackjack GUI And API, please read the originial post: here

Share the post

SAP HANA 2.0 Client Installation and Update – by the SAP HANA Academy

×

Subscribe to Web Service Testing A Blackjack Gui And Api

Get updates delivered right to your inbox!

Thank you for your subscription

×