Skip to Content
Author's profile photo Former Member

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

Assigned tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Sreehari V Pillai
      Sreehari V Pillai

      hi try to create an ODBC and test the connection. Is it going through ? Sree

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Former Member
      Former Member

      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 

      Author's profile photo Former Member
      Former Member

      I got the same issue. Does somebody can help here?

      Author's profile photo Lars Breddemann
      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