Sap Hana Client Mac

  1. May 30, 2019 Prerequisites. Installation of the SAP HANA client and a working JDBC connection to your SAP HANA instance. This can be confirmed using various Workbench tools such as SQLWorkbenchJ and DBeaver.
  2. The SAP HANA client can be installed or uninstalled on supported UNIX, macOS, and Linux operating systems. We use cookies and similar technologies to give you a better experience, improve performance, analyze traffic, and to personalize content.

Download the client installer for your platform (Microsoft Windows, Linux, or Mac) from the SAP Development Tools website under the HANA tab and the SAP HANA Client 2.0 section. An alternate location to download the client installer (SAP Software Downloads) is described in step 3 which includes the SAP Common Crypto library and additional. SAP provides HANA Client for Intel ( x8664 architecture) Mac OS computers only. According to APPLE documentation, it is possible to create Universal binary to support Intel & Silicon for HANA Client.

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 2.0 Client Installation and Update (this blog)

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:

  • 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)

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

Sap

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.

Studio

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

SAP Downloads

  • SAP HANA, platform edition 2.0 (SAP HANA as listed in PAM)

SAP Documentation

SAP Blogs

SAP Notes

  • 1577128 – Supported clients for SAP HANA (SAP HANA 1.0, does not apply to HANA 2.0)

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

So recently I’ve been playing around a lot with our “Server Only” version of the SAP HANA, express edition (HXE). Now with that server only version I am mainly focused on just using more of the Database features than anything else. Trying SQL and working with the PAL libraries.

With our activities and ability to quickly load HXE into the Google Cloud Platform I also thought how else could I speed of some of my time. I mean I am only working with SQL on some of these things so could I use the JDBC driver and find a tool that would do nicely for it?

I was quite surprised by how many are out there and I started playing with a few of them.

Sap Hana Client Installation Guide

I’ve now tried a good half a dozen or so and decided that the current one I will play with the next few weeks would be DBeaver.

This of course is by no means the “only” choice it’s just one of them, and frankly one of MANY!

Couple of things I liked about this one was how quickly I was able to connect to my server as the system already identified SAP databases.

Sap Hana Client Mac

In addition it already had the option to pick my class location for my existing JDBC driver from my “SAP HANA Client” installed (option when you download HXE).

Update: The following connection string when editing will allow you to easily add your system and the tenant you wish to connect to.

After giving the location of my jar file via the “Add File” option I was then able to tell it to “Find Classes” and be ready to go.

Then it was a matter of putting in my connection details.

Sap Hana Client Mac Download

Test the connection.

Hana Client Compatible With Hana Db Version

Save it and then view some of my schemas.

Sap Hana Client 64

All in all extremely fast and easy and a perfect one to play with and try out to begin with.