type here...

Where can I find information about the available tools for SAP HANA (all types of use)?

last updated: 2023-06-02

Introduction

Several tools are available for the SAP HANA database for different purposes. The knowledge belongs to the tools are very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). In order to simply and make content consumption easier I have created a centralized page. Further I would like to help you to find the fastest way to get the necessary information.

Different categories are a kind of definition of tools.

  • SAP HANA Administration Tools
  • SAP HANA Developer Tools
  • Other Tools for SAP HANA

I would also like to share some personal experiences, such as prerequisites, installation, configuration of different tools.

Architecture

In my scenario I am using Windows 11 operating system on my laptop. I am running SAP HANA, express edition (preconfigured) Server + applications virtual machine on VMware Workstation.

Prerequisites

Table of Content

  1. Where can I find information about the available tools for SAP HANA?
  2. SAP Help Portal
  3. SAP Support Portal
  4. SAP HANA Academy
  5. Tools
    1. SAPCAR (archiving/extracting tool)
    2. SAP HANA Studio
    3. SAP HANA Cockpit (and the Database Explorer)
    4. Eclipse IDE
    5. Visual Studio Code
  6. What blog posts can be helpful?
  7. Other articles belongs to SAP HANA, express edition
  8. Other articles in this series
  9. Other articles in connected series


Where can I find information about the available tools for SAP HANA?

  • SAP Help Portal – Home
  • SAP Support Portal – Home
  • SAP Community – Home
  • SAP Guided Answers – Home
  • SAP Support/Community Wiki – Home
  • SAP HANA Academy – YouTube
  • SAP Notes & Knowledge Base Articles


SAP Help Portal

This is the initial entry point of the official SAP HANA documentations belongs to the available tools.

SAP Help Portal – Home


SAP Support Portal

This is the initial entry point of the official SAP Notes, Knowledge Base Articles, Guided Answers and more. Also the SAP Software Download Center is available from here.

SAP Support Portal – Home


SAP HANA Academy

The SAP HANA Academy provides Technical Enablement, Implementation and Adoption Support for Customers and Partners with 1000’s of free tutorial videos.


Tools

Several tools can be used for the administration/monitoring/development/database access of SAP HANA.

❗Remark: The below list is not a complete list of the available tools only an extract from the most important ones. The list contains the tools which I have personal experiences with.


🔧 SAPCAR (archiving/extracting tool)

SAPCAR is a tool for extracting *.SAR files. This tool is necessary to have, to be able to extract the downloaded media before installing it.

SAP Help Portal:

SAP Knowledge Base Articles:

  • 212876 – The new archiving tool SAPCAR
  • 2632047 – How to download SAPCAR for extracting .SAR files – SAP ONE Support Launchpad / SAP for Me
  • 2695522 – How to Extract SAR Files on Windows OS

Useful SAP Community answer:


🔧 SAP HANA Studio

“The SAP HANA studio is the legacy development environment and administration tool for SAP HANA, based on the Eclipse platform. Full administration of SAP HANA 2.0 is not possible with the SAP HANA studio. Certain tasks require the SAP HANA cockpit.” source SAP Help Portal.

SAP Help Portal:

SAP Knowledge Base Articles:

  • 2073112 – FAQ: SAP HANA Studio
  • 2902153 – How to download HANA Studio?
  • 2375176 – SAP HANA Revisions and SAP HANA Studio Versions
  • 3049961 – How-To: find HANA studio version based on media name

Useful blog, which contains general steps to investigate the connection problems:

Useful SAP Community blog posts by the SAP HANA Academy:

To demonstrate the SAP HANA Studio tool, I use my virtual environment (in Prerequisites section) to connect.


🔧 SAP HANA Cockpit (and the Database Explorer)

“The SAP HANA cockpit is a Web-based HTML5 user interface that you access through a browser. It runs on SAP HANA extended application services, advanced model (XS advanced). You can use it to administer and monitor SAP HANA databases…” source SAP Help Portal.

SAP Help Portal:

SAP Knowledge Base Articles:

  • 2800006 – FAQ: SAP HANA Cockpit
  • 2433181 – SAP HANA 2.0 Cockpit Revision and Maintenance Strategy

❗Remark: I didn’t have to install SAP HANA Cockpit because it was already installed on SAP HANA, express edition (preconfigured) Server + applications virtual machine on VMware Workstation.

To demonstrate the SAP HANA Cockpit tool, I use my virtual environment (in Prerequisites section) to connect.

Database Explorer


🔧 Eclipse IDE

“Eclipse is an integrated development environment (IDE) used in computer programming. It contains a base workspace and an extensible plug-in system for customizing the environment.” source Wikipedia.

Official website: https://eclipseide.org/
SAP Development Tools site: https://tools.hana.ondemand.com/
SAP Learners site: How to Install SAP HANA Tools in Eclipse or HANA Studio

SAP Help Portal:

SAP Knowledge Base Article:

  • 2791513 – Support for SAP HANA Tools for Eclipse

To install the SAP Development Tools follow the next menu: Help – – > Install New Software…

To demonstrate the Eclipse IDE tool, I use my virtual environment (in Prerequisites section) to connect.


🔧 Visual Studio Code

“Visual Studio Code, also commonly referred to as VS Code is a source-code editor tool” source Wikipedia.

Official website: https://code.visualstudio.com/

SAP Help Portal:

SAP Knowledge Base Article:

  • 3208558 – How to set up a local environment with Visual Studio Code for SAPUI5 application development

SAP Developers:

Useful SAP Community articles:

To connect to the database you have the following options:

  1. SAP HANA Database Explorer (Extension)
  2. SQLTools
    Prerequisites:
    – node.js (https://nodejs.org/en)
    – SAP HANA Client
    ▶ 2941449 – SAP HANA Client 2.0 Releases
    ▶ 2952352 – How to: Download HANA Client
    – SAP HANA Driver for SQLTools (Extension)

Installed extensions:

Connecting SAP HANA database (HXE tenant) with ☝ SAP HANA Database Explorer.

Connecting SAP HANA database (TDB tenant) with ☝ SQLTools.

❗Remark: During setup the database connection the correct Port number of the Tenant DB needs to be used.

SAP Help Portal:

SAP Knowledge Base Article:

  • 2101244 – FAQ: SAP HANA Multitenant Database Containers (MDC) ➡ 6. Usually we connect to SAP HANA Database through indexserver which also serves as SQL port so how do we connect to SYSTEM DB when there is no indexserver?

Other Reference:


What blog posts can be helpful?


Other articles belongs to SAP HANA, express edition

✍ SAP HANA, express edition uninstall SHINE before upgrade to HANA 2.0 SPS06

✍ SAP HANA, express edition and SAP HANA smart data integration – Complete Tutorial

✍ SAP HANA, express edition and SFLIGHT demo database, modeling – Complete Tutorial

✍ Upgrading SAP HANA, express edition from SPS05 to SPS06 (solution for failed HRTT service deployment)

✍ How to enable SAP HANA Web-based Development Workbench in SAP HANA, express edition for Multiple Databases


Other articles in this series

✍ Where can I find knowledge and information belongs to SAP HANA?


Other articles in connected series

✍ Collected information about memory in context of SAP HANA

✍ Collected information regarding partitioning in SAP HANA (with examples)

✍ Collected information regarding High Availability and Disaster Recovery in SAP HANA

✍ Collected information about reclaim / shrink / defragmentation topic in context of SAP HANA persistence (with example)

Do you have further questions?

Please do not hesitate to contact me if you have question or observation regarding the article.

Q&A link for SAP HANA: https://answers.sap.com/tags/73554900100700000996

Contribution

If you find any missing information belongs to the topic, please let me know. I am happy to add the new content. My intention is to maintain the content continuously to keep the info up-to-date.

Release Information

Release Date Description
2023.06.02 First/initial Release of the SAP Blog Post documentation (Product Information).

 

Original Article:
https://blogs.sap.com/2023/06/02/where-can-i-find-information-about-the-available-tools-for-sap-hana-all-types-of-use/

ASK SAP EXPERTS ONLINE
Related blogs

LEAVE A REPLY

Please enter your comment!
Please enter your name here

© SAPIN APP. ALL RIGHTS RESERVED.