Skip to Content

1. Download HANA client 32 bit from http://scn.sap.com/community/developer-center/hana, client 64 bit is needed for hana studio, it is ok to install both of them on 64 bit windows OS.

SAP HANA Client Developer Edition Win86 32bit (appr. 42,2 MB)

SAP HANA Client Developer Edition Win86 64bit (appr. 83,2 MB)

2. Install 32bit hana client on C:\Program Files (x86)\SAP\hdbclient

3. Go to C:\Windows\SysWOW64, run odbcad32.exe -> add HDBODBC32 -> server port is: 3 + ins no. + 15.

7-19-2013 5-19-41 PM.jpg

/wp-content/uploads/2013/07/image004_249539.jpg

4. Double check with admin tool in control panel

/wp-content/uploads/2013/07/image006_249540.jpg

5. Connect to hana and retrieve the tables. Open excel 2007 -> data ->

/wp-content/uploads/2013/07/image008_249541.jpg

/wp-content/uploads/2013/07/image010_249543.jpg

6. Connect to MDX provider: data -> wizard ->

/wp-content/uploads/2013/07/image012_249544.jpg

/wp-content/uploads/2013/07/image014_249545.jpg

/wp-content/uploads/2013/07/image016_249546.jpg

To report this post you need to login first.

6 Comments

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

  1. Felix Haeusser

    Thanks Wu Huang, for your tutorial.

    I tried to do as you told, but unfortunately there’s a problem directly at the end of your how-to.
    -> Out-of-memory exception, whenever I connect to the data source
    -> SQL processing error whenever I try to connect via MDX Provider. I seem to have insufficient privilege..

    How could I try and solve that problem?

    Best regards,
    Felix

    (0) 
      1. Felix Haeusser

        Found the problem:

        There were missing Object privileges on _SYS_BIC for my user to “CREATE ANY”. After getting them, it worked. Thanks for your help.

        (0) 
  2. Juhua Huang

    Thanks Wu Huang, for sharing with the tutorial.

    I followed your tutorial to set excel on HANA.

    I can successfully get tables with “From Microsoft Query”, but I got a problem in “From Data Connect Wizard”. I selected HANA MDX Provider, and typed in my hana server info. The test connection is succeeded. However, if I click ok, Excel returns me “The Data Connection Wizard cannot obtain a list of databases from the specified data source”. I’m wondering if you have any ideas about what the problem is. How could I solve this problem?

    Thanks very much,

    Best,

    Juhua 

    (0) 
      1. Lars Breddemann

        This is a well known and often discussed issue.

        The HANA ODBC driver doesn’t implement the required OLE.DB functionality here.

        So, if you want to do access data without MDX and the pivot-tools, you’ll have to either use MS Query or write your own VBA code.

        – Lars

        (0) 

Leave a Reply