Connecting HANA TABLES to Excel

20 September, 2018


Related Blogs

Connecting HANA TABLES to Excel

Open Excel -------- Go to data (tab)

From other sources click on from Microsoft Query

So, No will get Dialoguer box in database (tab)

Select ODBC connection for HANA

In next dialogue box provide port no,

User ID


Select Required table


We can set filters by providing operator for operands


We can sort by ascending / descending

Next select Return data to Microsoft excel

And Finish

So we will get dialogue box like this:

Import Data

Select how you want to view in your work box


Pivot table report

Pivot chat and pivot able repute

Only create creation

Interested in mastering SAP HANA Certification? Learn more about SAP HANA Training Material PDF in this blog post.

Where do you want to put the data?


Click on properties

Usage (tab)

Select last refreshed options like

Enable background refresh

Refresh every           mins

Refresh data when opening the file

Defilation (tab)

So we will get connection string as will as command text (SQL command)

Click on Authentication settings

Windows Authentication

Again Enter User name & Password & will get ‘TABLE’SSS – SSS ID:



Note:-  If we keep refresh options for both exact, Table, model, ----------- system will ask user ID, Password

For every Interval (specified time (mins) in Refresh options)


Administrator activities in HANA STUDIO:-

Administrator console screen area:

Screen Area Description
Eclipse standard menu and tab bar Contains Eclipse standard functions
Navigator Contains systems (System landscape with optional       uses – defined folder structure)
Editors and Views Contains editor such as the Administration editor or     the SQL Editor, and views such as the table        definition view.
Manage and context information Contains Error and information messages and context – related information for editors and views (such as properties)

For an Indepth knowledge on SAP HANA, click on below

About Author


Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .