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

[Former Member]

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.

4. Double check with admin tool in control panel

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

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