Connecting HANA TABLES to Excel

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

Password.

Select Required table

Next

We can set filters by providing operator for operands

Next

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

Table

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:

Name

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)

“ADMIN”:-

Administrator activities in HANA STUDIO:-

Administrator console screen area: