Skip to Content

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

1 Comment
You must be Logged on to comment or reply to a post.