Skip to Content

Hello Folks,

As we know we have an ODBC driver available for SAP HANA. We can use Microsoft Query to connect to SAP HANA Database to access tables.

Proceedure:


  1. Select “DATA” and goto “ Other Sources” and select “From Microsoft Query” as shown below.

A211.jpg

Now Choose the “Data Source” i.e. ODBC connection which you have created to SAP HANA DB. In my case it is “DS4”

A212.jpg

It will ask for Credentials as shown below:

A213.jpg

Now you can see that excel is trying to connect to the “Data Source” as shown below:

A214.jpg

Thus we are able to connect to SAP HANA DB and we can access “Tables” and “Views”.

A215.jpg

Note:

This feature is not recommended by SAP as it has a limitation on no. of tables that can be accessed.

Thanks for reading this document. 🙂 .Please add your valuable suggestions to this document.

To report this post you need to login first.

2 Comments

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

Leave a Reply