Blogs / Tips and Tricks / Connecting Directly to your HANA System from Analysis for Office

Connecting Directly to your HANA System from Analysis for Office

May 31, 2017

SHARE

If you have a HANA system, you can connect directly to your HANA system from Analysis for Office. This enables you to bypass the need for universes and connect directly your HANA views.

The below steps illustrate how this can be achieved.

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
Connecting Directly to your HANA System from Analysis for Office

4. Select the driver HDBODBC32

Analysis Office connects to SAP HANA always via an ODBC layer. It is necessary, hence, to install the HANA ODBC middle-ware on the local machine where the tool is running.

The HANA middle-ware has to be of the same bit version than Analysis office: 32 bit or 64 bit.

From Windows, make sure you start the correct ODBC driver manager.

(File name for the 32bit version: C:\Windows\SysWOW64\odbcad32.exe;

File name for the 64bit version: C:\Windows\System32\odbcad32.exe).

Connecting Directly to your HANA System from Analysis for Office

5. Provide a name and description

Connecting Directly to your HANA System from Analysis for Office

6.Provide your credentials. Connect.

Connecting Directly to your HANA System from Analysis for Office
Connecting Directly to your HANA System from Analysis for Office

Launch Analysis for Office from Desktop

Start -> All Programs -> SAP Business Intelligence -> SAP BusinessObjects Analysis -> Analysis for Microsoft Excel

Connecting Directly to your HANA System from Analysis for Office


Navigate to Analysis Tab.  Click Insert Data Source.

Connecting Directly to your HANA System from Analysis for Office
Connecting Directly to your HANA System from Analysis for Office

A prompt to connect to SAP BI Platform appears

Connecting Directly to your HANA System from Analysis for Office


Data Source can be chosen either by ‘search’ tab or ‘folder’ tab

Connecting Directly to your HANA System from Analysis for Office

Got questions? Click here to reach out.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This Blog!

Share this blog with your friends and colleagues!