Skip to Content

Install the SAP HANA Client

test
0 %
Install the SAP HANA Client
Details

Install the SAP HANA Client

July 9, 2020
Created by
March 29, 2020
Learn about the multiple ways to install the SAP HANA client.

You will learn

  • How to install the SAP HANA client
  • The two locations where SAP HANA client installs can be downloaded from

Prerequisites

  • A Microsoft Windows, Mac, or Linux machine

This tutorial will demonstrate how to install the SAP HANA client. The next tutorial in this mission will demonstrate how to use HDBSQL, which is a command line utility included with the client’s installation, to connect to SAP HANA.


Step 1: The SAP HANA Client

The SAP HANA client provides a set of utilities and drivers to connect to and query a SAP HANA database from multiple programming APIs, such as Node.js, Python or Java. For a complete list, see SAP HANA Client Interface Programming Reference.

For a list of newly added features, see SAP HANA Client Interfaces (New and Changed), New and Changed Features in the SAP HANA Client, or the release notes.

The SAP HANA client can be used to connect to different versions of SAP HANA. For example, a current 2.4.x client can connect to SAP HANA Cloud, SAP HANA Service, SAP HANA 2.0 or an SAP HANA 1.0 SPS 09 or higher server. For more information, see SAP HANA client and server cross-version compatibility.

Log on to answer question
Step 2: Install from SAP Development Tools
  1. 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 is given in step 3.

    Client Download
  2. On Microsoft Windows, unzip the downloaded file in a temporary location (e.g., C:\Temp).

    On Linux or a Mac, use the following:

    tar -zxvf hanaclient*.tar.gz
    
  3. Start the graphical installer hdbsetup or use the command line installer hdbinst.

    hdbsetup.exe
    
    ./hdbsetup
    

    Set the install directory to a location, such as C:\sap\hdbclient.

    Client-install

    This tutorial mission covers Microsoft Windows, Linux and Mac. If there are commands that are different depending on the platform, multiple sets of commands will be provided and the title will say Shell (Microsoft Windows) or Shell (Linux or Mac). Note that on Microsoft Windows, the shell used is the Command Prompt.

  4. After the installation process is completed, update your path environment variable so that the SAP HANA client programs such as hdbsql can be found on your path. On Microsoft Windows, click the Start icon and search for environment variables.

    Environment variable

    For details on how to configure your path on a Mac see this blog post.

  5. In the hdbclient folder, notice that files such as hdbsql and the client database drivers are available.

    Clients Post Installation
  6. Run the following command in a newly opened shell to verify the installation succeeded and the path is correct.

    hdbsql -v
    
    Version of HDBSQL

    To uninstall at a later time, run hdbuninst from the folder where the client is installed. For example c:\sap\hdbclient\install\hdbuninst.

The install from SAP Development Tools does not contain the SAP Cryptographic Library. This can be seen by examining the C:\SAP\hdbclient\manifest.mf file.

The SAP Cryptographic Library is only required when client-side data encryption is used, for LDAP Authentication or for cases where a preference is to use the SAP Common Crypto Library over the libraries provided by the OS. For more information, see the following:

Log on to answer question
Step 3: Alternate Install Option, SAP Software Downloads

Another download location is the Software Downloads site, which requires signing in before downloading. This version of the SAP HANA client download includes the SAP Common Crypto Library.

If you have a license for SAP HANA Cloud, follow the instructions at Download and Install the SAP HANA Client.

If you have a license for an on-premise version of SAP HANA, follow the instructions provided at SAP HANA Client Installation and Update Guide.

The downloaded software is the same regardless of which one is used.

Software Downloads

The downloaded file is a .sar file and the utility SAPCAR is needed to extract it. SAPCAR can also be downloaded from Software Downloads.

The command to extract a .sar file is shown below. The command options are extract, verbose and file.

SAPCAR.EXE -xvf IMDB_CLIENT20_005_86.SAR
chmod u+x SAPCAR
./SAPCAR.EXE -xvf IMDB_CLIENT20_005_86.SAR

For further information on SAPCAR or if you are having troubles using it, see SAP HANA, SAPCAR, and macOS.

Congratulations! You now have the SAP HANA client installed.

Which of the following statements are true?
×

Next Steps

Back to top