Connect to SAP HANA – Enhance Your Skills in In-Memory Database

The following steps are explaining how to connect SAP HANA tables to Excel:

• Open Excel
• Go to Data Tab
• From other sources click on from Microsoft Query
• Then, you will find Dialog Box in Database Tab
• Select ODBC connection for HANA
• In the next dialog box, you need to provide Port No., User ID, and Password.
• Select required table
• You can set filters by providing operator and operands
• Then select Return data to Microsoft Excel
• Then select Finish.
• In dialog box click on the properties button.
• Usage tab
  • Select last refreshed options like
  • Enable background refresh
  • Refresh Every 1 min.
  • Refresh data when opening the file
  • Definition Tab
    • Here you will get Connection String
    • Command Text (SQL Command)
    • Click on Authentication Settings
      • Windows Authentication
      • SSS – SSS ID
      • None
      • Again you need to enter Username and Password and you will get TABLE.

Example:

Note: If we keep Refresh options for both Excel Table, Model, then the system will ask User ID and Password for every interval (specified time in minutes in Refresh option).