Clients (Mac) - Client download package for Mac. Use the client packages to access developed SAP HANA, express edition applications from a client PC. The package includes: hdbclientmac.tgz - Reduced HANA client for Mac. Contains the HANA client package, drivers, and required licenses. This article describes how to connect Tableau to an SAP HANA database and set up the data source. Note: This connector uses JDBC drivers for Mac, Linux, and Windows. The JDBC driver for Windows is new in Tableau version 2021.1. Apr 22, 2019 Clients (Mac) - Client download package for Mac. Use the client packages to access developed SAP HANA, express edition applications from a client PC. The package includes: hdbclientmac.tgz - Reduced HANA client for Mac. Contains the HANA client package, drivers, and required licenses. 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.
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
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 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
Recently, we have updated a number of SAP HANA Academy tutorial videos for the playlist
In this blog, I will provide some references and background information about installation automation with the SAP HANA platform lifecycle management tools.
This blog is part of a series:
- SAP HANA Installation Automation (this blog)
SAP HANA Academy – SAP HANA Installation and Update (YouTube Playlist)
Tutorial Video
SAP HANA Academy – SAP HANA Installation and Update: Installation Automation
Create the Configuration File
In the previous blogs about SAP HANA 2.0 platform lifecycle management and SAP HANA 2.0 Server Installation, I already briefly mentioned installation automation. Using a combination of configuration files together with optional command line options, you can automate installations, that is, create a repeatable process that can be scheduled without any further human intervention.
The process is simple. First, you create a configuration or response file by running the hdblcm installation tool with the dump_configfile_template and action parameter.
The location and name of the file, including the extension (if any), are for you to choose.
This command will generate both the configuration template file and a password template file.
Configure the Configuration File
Next, we need to edit the installation parameters. There are a bit over 100 parameters available so it might take a bit time to get this right, depending on the requirements. However, the good news is that all parameters have a default value, except for the sid (system identifier) and password parameters.
Sap Hana Client Install
For the parameter reference, see
- Parameter Reference – SAP HANA Server Installation and Update Guide
General and Action
In the General section, you specify where the installation media is located (component_medium, _dirs, _root), whether to use a master password – for the operating system accounts <sid>adm and sapadm and database users SYS and SYSTEM (amongst others, see below) and which components to install.
It also includes the configuration of remote execution which concerns a distributed (multi-host) installation which itself is configured in the AddHosts section (see below).
For remote execution of multiple-host system operations, see
The Action section only has a single parameter, action, which will have been already set with the value you provided on the command line when running the hdblcm command.
As I explained in the SAP HANA 2.0 platform lifecycle management blog, hdblcm is a ‘wrapper’ tool that calls other executables for the different actions. Action=install will call hdbinst and action=update will call hdbupd. In the Client section below, you can see that we can run these tools independently as well with a response file, for example, when installing the SAP HANA client on a client computer.
Server
In the Server section, all the parameters specific to the HANA database server are specified. The sid is required, all others are optional.
For more information about these parameters, see
Storage
The storage_cfg parameter points to the directory where you have placed the customized global.ini file. This makes it possible to set up a storage connector, allowing SAP HANA to use hardware vendor-specific scripts for automated resource allocation and input/output fencing during failover.
For an example of such an implementation, see
For the documentation, see
- Tutorial: Using Custom Configuration Files – SAP HANA Server Installation and Update Guide
Note that the hdbparam utility is no longer included with SAP HANA 2.0 and has been deprecated.
Sap Hana Client Mac Free
Storage Configuration Best Practices for SAP HANA TDI on Dell EMC VMAX 33 Solution Guide
Implementing High Availability and Disaster Recovery Solutions with SAP HANA on IBM Power Systems
The AddHosts section covers the parameters relevant to distributed (multi-host) systems: the hostname of the hosts and the host role.
Optional Components
There is a dedicated section for each of the different host roles (Streaming Analytics, Dynamic Tiering, Accelerator for ASE and Remote Data Synch. When these components are not listed in the General section, these sections are ignored by the installer.
For more information about these features, see
XS Advanced
For the XS Advanced runtime, there is another dedicated parameter section.
For more information about these parameters and about installing XSA, see
Client and Studio
Finally, there is a section about the SAP HANA client and studio. See
Configure the Password File
As we have seen, there are several locations where passwords can be specified in the configuration file. Master password in the General section, operating system accounts (root, sapadm, <sid>adm) and database users in the Server section, accounts for features, and for XS Advanced.
Typically, a security administrator will not be amused when passwords are specified in text files.
For this reason, the read_password_from_stdin=xml parameter is available to indicate to hdblcm when running in batch mode to get the passwords from ‘standard input’, which for UNIX refers to commands entered on the command line.
However, as we still want to automate the installation, we are now going to set the passwords in another configuration file, this time in XML format, which we can secure and include in the installation process as appropriate.
Sap Hana Client Mac Os
In the vi editor, you can use the substitute command to easily change the asterisks to a new master password.
For more information, see
- Specifying Passwords – SAP HANA Server Installation and Update Guide
Install in Batch Mode
When we are done with editing the configuration and password file, we can simply run the install in batch mode with the -b (or –batch) parameter together with —configfile.
Parameters passed as call options to the installer take precedence over parameter defined in the configuration file.
You could, for example, generate the SID parameter using a script and pass it to the installer in case you need unique values.
To include our password parameter file, we are going to make use of more UNIX magic: the pipe. This allows us to pass the passwords to the installer without displaying them on the console or in command history.
SAP HANA Client
To automate installations of the SAP HANA client (or studio) on a system that do not contain an SAP HANA server installation, we can use the same approach.
First, generate a configuration file and edit the parameters. This time, use the hdbinst or hdbupd executable directly (and hence we no longer need to specify the action= parameter). Again, the name and extension of the response file are irrelevant.
To install, run the command specifying –batch (-b) with configfile.
For the parameter reference, see
- Command and Call Option Reference – SAP HANA Client Installation and Update Guide
References
For more information see:
SAP HANA Academy Playlists
SAP Community Blogs
SAP Documentation
Sap Hana Client For Mac Download
- Tutorial: Automating Installation – SAP HANA Server Installation and Update Guide
- Tutorial: Using Custom Configuration Files – SAP HANA Server Installation and Update Guide
- Parameter Reference – SAP HANA Server Installation and Update Guide
- Specifying Passwords – SAP HANA Server Installation and Update Guide
- Command and Call Option Reference – SAP HANA Client Installation and Update Guide
Notes
SAP Partner Documentation
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