Install HANA client on Ubuntu

former_member186273 · ‎2012 Sep 14

In my last post of Hana with odbc on Ubuntu 12.04,I mentioned I will write another post about how to install HANA client on Linux, well, here it is. Install HANA client on Linux is a little bit tricky. Several things need to bring out just in case someone else run into the same issues.

1, Download HANA client

Download HANA client installation zip file from here, make sure you select the appreciate version.

2, Unzip the downloaded file

Navigate to the unzip folder and go into SAP_HANA_CLIENT

3, Execute following Command

chmod +x hdbinst

chmod +x hdbsetup

chmod +x hdbuninst

chmod +x instruntime/sdbrun

The last execution command is very important, otherwise hdbinst, hdbsetup and hdbuninst couldn't execute due to missing sdbrun.

4, Install

In order to install hana client on Ubuntu, type following command in your terminal.

sudo ./hdbinst -a client

If everything run smoothly, you will get following response.

ethanz@ubuntu:~/Downloads/SAP_HANA_CLIENT$ sudo ./hdbinst -a client

SAP HANA Database Client kit detected.

SAP HANA Database Installation Manager - Client Installation 1.00.32.363548
***************************************************************************

Select a SAP HANA Database Client installation:

No | Installation Path                    | Version        | Mode
-------------------------------------------------------------------
[0] | /opt/sap/hdbclient                   | 1.00.32.363548 | 64bit
    |                                      |                |
1   | Install new SAP HANA Database Client | 1.00.32.363548 | 64bit

Enter number [0]:

You can install HANA client into your favorite folder, as you can see, mine was installed under /ops/sap/hdbclient

5, Last Step

It's not finished, now if you run ./hdbsql, you probably will get error "hdbsql error while loading shared libraries: libaio.so".

what you need to do is install libaio-dev package by running following command.

sudo apt-get install libaio-dev

6, Test your connection

Congratulations if you see this

ethanz@ubuntu:/opt/sap/hdbclient$ ./hdbsql

Welcome to the SAP HANA Database interactive terminal.

Type: \h for help with commands

\q to quit

hdbsql=>

Congratulations, now you can play around HANA on Ubuntu. you can run test script and anything allowed.

JoergLatza · ‎2013 May 09

Hi Ethan,

thanks for the documentation. It helped me to setup the hdbclient.

But when executing regi I get the following error:

ubuntu@ip-10-0-0-131:/$ regi

regi: error while loading shared libraries: libSQLDBCHDB.so: cannot open shared object file: No such file or directory

But the same is available in /usr/sap/hdbclient and the environment variable for path is set as you can see (calling it from root and regi is found)

We need regi only, calling it from node.js....no other tools.

Any ideas ?

Kind Regards,

Joerg

former_member186273 · ‎2013 May 09

Hi Joerg

can you check the version of your regi? As far as I know, some build-in regi might not match SAP HANA Client version.

Thanks

Ethan

JoergLatza · ‎2013 May 09

Hi Ethan,

its the most recent internally released Weekstone.

mainfest file:

compversion-id: 01200615320200017866

keyname: HDB_CLIENT

keyvendor: sap.com

release: 1.00

rev-number: 26

rev-changelist: 360651

sp-number: 26

sp-patchlevel: 26

comptype: HDB_CLIENT

makeid: 738639

date: 2012-04-04 08:30:58

platform: linuxx86_64

fullversion: 1.00.26 Build 0360651-1410

auxversion: 2012.14.0

changeinfo: P4 360651 (HANA_WS_COR)

compiletype: opt

compilebranch: HANA_WS_COR

sapexe-version: 720

sapexe-branch: 720_EXT_REL

sapexe-changelist: 1282311

Thanks for your suport !!

KR, Joerg

former_member186273 · ‎2013 May 10

can you print out your regi version using command?

regi version

Thanks

Ethan

JoergLatza · ‎2013 May 10

How should I do this as regi is not working.......???

Seems rather a setup issue than a versioning problem.

harald_kuersten · ‎2013 Jun 21

On my Ubuntu VM, I am only able to add a Hana system into my Studio when I launched it with sudo. Do you know what needs to be modified so that I can also do this under my normal user?

Thanks, Harald

kkoetter · ‎2013 Jun 23

Hello Joerg,

regi is only working on 64 Bit. What Linux do you use?

Best regards,

Karsten

Former Member · ‎2014 Nov 19

Hi, can you please try and make available the SAP HANA client for Linux 64 bit, because I don't think the 64 bit version can be downloaded from the link that is provided.

I am also not able to get through https://my300155.sap.ondemand.com/sap/cp/ui/resources/store/html/SolutionDetails.html?pid=0000012950 which contains "SAP Hana Client 100_74 for Linux x86 64 bit"

Former Member · ‎2016 Feb 28

Hi,

Thanks for your post.

I have installed Hadoop ecosystem using cloudera on Ubuntu 12.04 in a virtual machine, and I want to know if it is possible to connect sqoop to HANA client in the host machine?

(sqoop(linux) ---HDB_Client(Windows)) because I don't have the HDB_Client for linux.

Regards,

Imane

Former Member · ‎2017 Jul 19

Hi Ethan,

I am new to SAP Hana.

Download HANA client installation zip file link: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/webcontent/uuid/402aa158-6a7a-2f10-0195-f43595f6fe5f
does not work.

Can you please share the link from where I can download the zip file?

Regards,

Amey Kelekar

former_member531162 · ‎2017 Oct 11

Have you found a working download link?