Install HANA client on Ubuntu
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.
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
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
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
can you print out your regi version using command?
regi version
Thanks
Ethan
How should I do this as regi is not working.......???
Seems rather a setup issue than a versioning problem.
Hello Joerg,
regi is only working on 64 Bit. What Linux do you use?
Best regards,
Karsten
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
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"
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
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
Have you found a working download link?