Skip to Content

How to setup excel 2007 on HANA SP05 with windows 7 64bit

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

6 Comments
You must be Logged on to comment or reply to a post.
  • 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

  • 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