Skip to Content
Author's profile photo Former Member

Connecting HANA and Analysis for Office

Following are the steps to create the connection between HANA and Analysis for Office(32 Bit):

1. Navigate to C:\Windows

2. Run odbcad32.exe

3. Under USER DSN tab –> Add

hana 1.png

4. Select the driver HDBODBC32

hana 2.png


5. Provide a name and description

hana 3.png

6. Provide your credentials. Connect.

hana 4.png

hana 5.png


Launch Analysis for Office from Desktop

Start –> All Programs –> SAP Business Intelligence –> SAP Business Objects Analysis –> Analysis for Microsoft Excel

hana 6.jpg


  • Navigate to Analysis tab. Click insert Data source.


hana 7.jpg

hana 8.jpg

  • A prompt to connect to SAP BI Platform appears,

hana 9.jpg

Once connected, Data source can be chosen either by ‘search’ tab or ‘folder’ tab.

hana 11.png

Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Nick VanLent
      Nick VanLent

      This shows how to add an ODBC connection to HANA, but what I'm missing is how to use that ODBC connection in Analysis for Office.