Skip to Content
Technical Articles
Author's profile photo Denys van Kempen
Denys van Kempen
December 14, 2017 7 minute read

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 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:

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 platforms from desktop computers to enterprise-class hardware and operating systems:

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

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, with 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:

 

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:

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

For the exact versions of the supported clients, see

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:

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:

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, 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 Downloads

SAP Documentation

SAP Blogs

SAP Notes

/wp-content/uploads/2016/02/sapnwabline_885687.png

Share and Connect

Questions? Please post as comment.

Useful? Give us a like and share on social media.

Thanks!

If you would like to receive updates, connect with me on

Over the years, for the SAP HANA Academy, SAP’s Partner Innovation Lab, and à titre personnel, I have written a little over 300 posts here for the SAP Community. Some articles only reached a few readers. Others attracted quite a few more.For your reading pleasure and convenience, here is a curated list of posts which somehow managed to pass the 10k-view mile stone and, as sign of current interest, still tickle the counters each month.

/wp-content/uploads/2016/02/sapnwabline_885687.png

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Kyaw Lin Zaw
      Kyaw Lin Zaw

      Hello Denys

      Nice blog!!!

       

      Can I have one question?

      While installing RSP, we are getting an error "SAP HANA database client has not been found". We are installing this on Windows Server 2019 64-bit machine. We installed the SAP HANA database client on this machine and were able to SAP B1 in this machine before.

      Please advise how to proceed further from here.

      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Kyaw,

      You can have many questions!

      However, this may not be the best place to ask, as this article dates from 2017 and no longer gets that many visitors (nor does everyone reach all the way down to the comment section). Personally, I am not all that (or rather not at all) familiar with SAP Business One (B1, that much I could guess) and RSP (had to look this up).

      Suggest to post this to the forum, answers.sap.com, tag with "SAP Business One" and "SAP Support". Copy/paste would be fine IMO.

      To give a little advise nonetheless, are you familiar with these ressources?

      • https://blogs.sap.com/2019/12/24/sap-rsp-remote-support-platform-to-support-your-customers-business-one/
      • https://help.sap.com/doc/012002523100003645362015e/3.2/en-US/B1_RSP_FAQ.pdf
      • https://support.sap.com/en/offerings-programs/support-small-medium-enterprises/business-one/remote-support.html

       

      Author's profile photo Kyaw Lin Zaw
      Kyaw Lin Zaw

      Hi Denys,

      Thank you for your reply.  I just want to clear about why we are getting an error "SAP HANA database client has not been found" but already installed. If you suggest it, I will be very grateful to you.

      Thanks and Best Regards,

      KLZ