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

Share on FacebookShare on LinkedInTweet about this on TwitterGoogle+

Join our SAP HANA online training and unlock your opportunities in HANA. There is a great demand for SAP HANA training because of it is a very renowned column-oriented, in-memory and relational database system.

SAP HANA  Online Training | SAP HANA Tutorial for Beginners

How to connect HANA tables to Excel

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
  • Select Next
  • You can set filters by providing operator and operands
  • Select Next
  • 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:

Sl. No.

CMP NO.

MNO

PRI

QTY

Year

1

C1

M1

123456

9

2009

2

C2

M2

123456

18

2010

 

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).

sap hana online training

SAP HANA Online Training @ BigClasses

BigClasses is one of the best online training organizations offer SAP HANA training. We have qualified and experienced faculties who are responsible for taking the online sessions. We provide study materials and 24 hours support to our national and international learners as well. If you are interested in SAP HANA online training, contact us for the detailed course and the free demo classes.

India: +91-8008114040, USA: +1-7323251626,

Website: www.bigclasses.com, Email: info@bigclasses.com.