Skip to Content
avatar image
Former Member

Analysis for Office (32Bit), Windows 7 (64 Bit), HDBODBC32 connectivity

Hi Experts,

as title mentioned, we use Windows 7 (64 Bit) and MS Office 2010 (32 Bit). I want to connect with Analysis for MS Office (we use the latest Patch 10 from decemder 2014) and Hana directly - the local Option.

I read the blogs and Using Design Studio with SAP HANA end to end-Part 1 and Design Studio 1.0: Connect to SAP HANA .

I installed the HDB Client and then I make a ODBC connection in the Administration Console from Windows. As mentioned I use the 32 Bit one with the prompt " %windir%\SysWOW64\odbcad32.exe " in the comand line. After this I follow the steps to create a new ODBC Connection. I wondered because I didn't had the option HDBODBC32 - so I choose the SAP HANA for MS Excel Option. I tested it with the option connect and all works fine. Then I startet Analysis for Office and skip the first Option so I get the local mode to connect a SAP BW oder even HAN. But my Connection I created is still missing.

When i try this with the 64Bit Version of the ODBC it works in the ODBC Administration console and when I start Analysis I see the HANA connection, but it didn't works because this is the wrong ODBC connector (64Bit)

I'm frustrated, because I just tried the connector with Design Studio, and the 32Bit ODBC Connector is displayed and it worked all fine.

Does anybody can help?

In attach you can see the screenshots from the ODBC Administration Console.

Regards Toni

odbc_02.JPG (53.2 kB)
odbc_01.JPG (42.0 kB)
odbc_admin.JPG (62.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 09, 2015 at 11:26 AM

    Hi Toni,

    Is your Analysis Office 32 bit or 64 bit?

    If Analysis Office is 64 bit then install 64 bit HANA Client otherwise install 32 bit HANA Client

    Install same HANA Client Version or higher version as your HANA DB version.

    Your screenshots show HANA Client for Excel driver and do not show HANA Client Driver.

    Please check the below screenshot that shows HDBODBC32 driver as HANA Client 32 bit is installed.

    HANA Client for Excel is separate from this as shown below.

    You have to create ODBC source using this HDBODBC (64 bit) or HDBODBC32(32 bit) driver

    Then sources are seen as below.

    Once ODBC source is created then you can connect Analysis Office to HANA:

    The source that you have created are using Client for Excel driver that is why excel connection is working and Analysis Office connection is not working.



    Ao.JPG (35.2 kB)
    Am.JPG (35.2 kB)
    DB.JPG (24.3 kB)
    Ao.jpg (35.4 kB)
    Add comment
    10|10000 characters needed characters exceeded