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.
- Select “DATA” and goto “ Other Sources” and select “From Microsoft Query” as shown below.
Now Choose the “Data Source” i.e. ODBC connection which you have created to SAP HANA DB. In my case it is “DS4”
It will ask for Credentials as shown below:
Now you can see that excel is trying to connect to the “Data Source” as shown below:
Thus we are able to connect to SAP HANA DB and we can access “Tables” and “Views”.
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.