Skip to Content

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.


To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. Joerg Latza

    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

    (0) 
    1. Ethan Zhang Post author

      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

      (0) 
      1. Joerg Latza

        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

        (0) 
  2. Harald Kuersten

    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

    (0) 
  3. imane black

    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

    (0) 
  4. Amey Kelekar

    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

    (0) 

Leave a Reply