SAP Web IDE for SAP HANA
Modeling in SAP HANA is supported by a graphical browser-based interface with the name SAP Web IDE for SAP HANA.
You need to obtain the URL from your administrator to be able to launch the SAP Web IDE for SAP HANA. The URL includes the host and port where SAP HANA database and the SAP Web IDE for SAP HANA is installed. Google Chrome is recommended as the browser. You will need an SAP HANA logon with some privileges to get started. This is technically a different user from SAP BW/4HANA.
The Development view and the Database Explorer view are the main work environments in the SAP Web IDE for SAP HANA. You toggle between these views using the buttons on the left of the interface.
To get started with modeling you first need to create a Project in the Development view of SAP Web IDE for SAP HANA. To support the isolation of development environment, SAP Web IDE for SAP HANA allows developers to use dedicated spaces in XS Advanced for building and running their projects. A project needs to be assigned to a Space. Within your project you then create a Module to sub-divide the development artifacts. There are a number of different types of modules provided by SAP to organize your development objects. Modelers usually only work with HDB (HANA Database) module type. Within a module you develop source files that are allowed for the type of module. For example, in a HDB module you create database artifacts such as calculation views, procedures and functions.
Development in SAP Web IDE for SAP HANA is completely file-based, which means that each source artifact is a simple file (identified with an extension) that is easy to export and import within and also across SAP HANA.
Each file you create has its own extension, such as .hdbfunction or .hdbcalculationview, which makes it easy to identify its type. This is also how the SAP Web IDE for SAP HANA knows which editor to open for each type of artifact. Certain files types can be opened in only a text editor or a graphical editor. Some files type can be opened in both.
In order to generate a run-time object from the source file we need to execute a build. In SAP BW/4HANA this would be the equivalent of an Activation.
The Database Explorer view of SAP Web IDE for SAP HANA is used to explore all types of catalog objects such as tables, views, procedures and functions. The run-time objects that were created with the Development view can also be displayed here.
Obsolete Tools in SAP HANA
In case you are wondering why we didn't cover SAP HANA Studio or SAP HANA Web-Based Development Workbench we will briefly cover the reasons below:
SAP HANA was launched in 2011 and since then has undergone significant developments. A key development was the move away from XS Classic to XS Advanced which uses the HANA Deployment Infrastructure (HDI). Along with that came the introduction of new tooling which had an impact on calculation view modeling.
- SAP HANA Studio is a client-side installation based on Eclipse. This is the same interface for modeling in SAP BW/4HANA where we use the special Eclipse add-in called SAP BW Modeling Tools, (BWMT). It is also the same interface used for ABAP development on-premise where we use the add-in ABAP Development Tools, (ADT). SAP HANA Studio can also be used for SAP HANA database administration, but modeling calculation views should only be done using the new SAP Web IDE. Calculation View modeling in SAP HANA Studio is still possible, but the interface only supports the weaker (XS Classic) version of the calculation views.
- SAP HANA Web-Based Development Workbench provides a web-based interface to build development artifacts in the SAP HANA environment. It was introduced with SAP HANA 1.0 and is based on the obsolete SAP HANA XS, also known as SAP HANA XS Classic. This interface never reached the functional scope of SAP HANA Studio and was never widely in use. It was meant to provide the SAP HANA Studio developer with a lightweight browser-based development tool to replace SAP HANA Studio. Again, this should not be used to develop calculation views because this interface only supports the weaker XS Classic version of the calculation view.
- SAP Web IDE for SAP HANA is a browser-based, integrated development environment (IDE) and is the recommended tool for native SAP HANA Modeling and database administration. It was introduced with SAP HANA 2.0 and works with the replacement of XS Classic which is called SAP HANA Extended Application Services Advanced (XS Advanced or simply XSA). The SAP Web IDE is the successor of the two UIs mentioned above. SAP Web IDE supports the development of the more powerful version of the calculation view.
In this learning journey, we follow SAP's recommendation and use the SAP Web IDE for SAP HANA to manage the SAP HANA database and for all native SAP HANA Modeling tasks.
Launch the next demo to explore SAP Web IDE for SAP HANA: