• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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?

Screenshot_51

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

Screenshot_52

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:

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

Summary
Review Date
Reviewed Item
Connecting HANA TABLES to Excel
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Connecting HANA TABLES to Excel"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.