Skip to Content

Installing SAP HANA HDB Client (Windows)

Install the client package if you intend to develop XS applications on a machine that will not have a local SAP HANA 2.0, express edition installation.
You will learn

How to install the SAP HANA client on a Windows machine, using either a graphical user interface or a command line.

aplata-sapAdrian PlataOctober 28, 2020
Created by
JCurrie27
April 13, 2018
Contributors
JCurrie27
aplata-sap

The server machine in these instructions refers to the laptop on which SAP HANA 2.0, express edition is installed, while client machine refers to your local machine. You do not need to install the two on the same machine or VM.

The clients let you access SAP HANA 2.0, express edition, from your client machine. This is the Reduced SAP Client package.

The clients included with the SAP HANA HDB client software package are:

  • JDBC

  • ODBC

  • SQLDBC

  • ODBO/MDX

  • Python (PyDBAPI)

  • ADO.NET

To install the SAP HANA HDB client on a Windows machine, use either a graphical user interface or a command line.

  • Step 1

    Install the Download Manager to your client machine and download the client package.

    1. Save the Download Manager installation files to your client machine and open it. For instructions on downloading and running the Download Manager, see either the Installing SAP HANA 2.0, express edition (Binary Installer Method) or Installing SAP HANA 2.0, express edition (Virtual Machine Method) tutorials, or go straight to the SAP HANA, express edition registration page.

    2. In Download Manager, in the Image menu, select either Virtual Machine or Binary Installer.

    3. Click Browse and select a directory where your client package will be saved.

    4. Select the Clients (Windows) package. Clear the Select boxes of all other packages.

    5. Click Download. The file clients_windows.zip downloads to your save directory.

    6. Use a compression utility to extract the compressed clients file.

      This extracts the following files and their contents:

      • hana_ml- <version>.tar.gz

      • hana.ml.r- <version>.tar.gz

      • hdb_client_windows_x86_32.zip

      • hdb_client_windows_x86_64.zip

      • xs.onpremise.runtime.client_ntamd64.zip

  • Step 2

    SAP HANA HDB client installation supports both GUI and console methods.

    1. Use a compression utility to extract the downloaded files hdb_client_windows_x86_32.zip or hdb_client_windows_x86_64.zip for 32-bit and 64-bit installations respectively.

      The following file path is created:

      bash
      Copy
      hdb_client_windows/HDB_CLIENT_WINDOWS_X86_32
      

      or

      bash
      Copy
      hdb_client_windows/HDB_CLIENT_WINDOWS_X86_64
      
    2. Navigate to the HDB_CLIENT_WINDOWS_86_32 or HDB_CLIENT_WINDOWS_X86_64 folder.

    3. In the file explorer, double-click:

      • hdbsetup.exe - GUI installation

      • hdbinst.exe - Command line installation

      Or from a command prompt:

      Call the program hdbsetup (GUI installation) or hdbinst (command line installation) by entering one of the following commands:

      • GUI - hdbsetup [-a client]

      • Command Line - hdbinst [-a client] [<option list>]

      Follow the onscreen prompts displayed by the installation tool.

    4. Add the installation path to the PATH environment variable. For information on setting environments variables, see the documentation for your operating system.

  • Step 3

    The system automatically logs the SAP HANA HDB client installation. The log files are stored at %TEMP%\hdb_client_<time_stamp>.

  • Step 4

    Connect to a SAP HANA 2.0, express edition system using either JDBC or Python:

    Use Clients to Query an SAP HANA Database

  • Step 5

    Each installation has its own uninstallation tool. Use the hdbuninst command to uninstall the client software from your command prompt.

    bash
    Copy
    <unzipped_filepath>/HDB_CLIENT_<version>/hdbuninst
    

    Follow the instructions on the screen to uninstall the SAP HANA HDB client.

Back to top