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.
Overview
Prerequisites
Prerequisites
- Tutorials: You have completed Start SAP HANA, express edition Server (VM installations) or Test the Installation (Native Linux installations)
Steps
Intro
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/MDXPython (
PyDBAPI)ADO.NET
To install the SAP HANA HDB client on a Windows machine, use either a graphical user interface or a command line.
Install the Download Manager to your client machine and download the client package.
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.
In Download Manager, in the
Imagemenu, select eitherVirtual MachineorBinary Installer.Click
Browseand select a directory where your client package will be saved.Select the
Clients (Windows)package. Clear the Select boxes of all other packages.Click
Download. The fileclients_windows.zipdownloads to your save directory.Use a compression utility to extract the compressed clients file.
This extracts the following files and their contents:
hana_ml- <version>.tar.gzhana.ml.r- <version>.tar.gzhdb_client_windows_x86_32.ziphdb_client_windows_x86_64.zipxs.onpremise.runtime.client_ntamd64.zip
SAP HANA HDB client installation supports both GUI and console methods.
Use a compression utility to extract the downloaded files
hdb_client_windows_x86_32.ziporhdb_client_windows_x86_64.zipfor 32-bit and 64-bit installations respectively.The following file path is created:
Shellhdb_client_windows/HDB_CLIENT_WINDOWS_X86_32or
Shellhdb_client_windows/HDB_CLIENT_WINDOWS_X86_64Navigate to the
HDB_CLIENT_WINDOWS_86_32orHDB_CLIENT_WINDOWS_X86_64folder.In the file explorer, double-click:
hdbsetup.exe- GUI installationhdbinst.exe- Command line installation
Or from a command prompt:
Call the program
hdbsetup(GUI installation) orhdbinst(command line installation) by entering one of the following commands:GUI -
hdbsetup [-a client]Command Line -
hdbinst [-a client] []
Follow the onscreen prompts displayed by the installation tool.
Add the installation path to the PATH environment variable. For information on setting environments variables, see the documentation for your operating system.
The system automatically logs the SAP HANA HDB client installation. The log files are stored at %TEMP%\hdb_client_<time_stamp>.
Connect to a SAP HANA 2.0, express edition system using either JDBC or Python:
Each installation has its own uninstallation tool. Use the hdbuninst command to uninstall the client software from your command prompt.
<unzipped_filepath>/HDB_CLIENT_<version>/hdbuninstFollow the instructions on the screen to uninstall the SAP HANA HDB client.
Resources
Discussion
Share feedback on this tutorial or join the conversation in SAP Community.