Hi Everyone,

As some of you might be knowing that with HANA SPS06, SAP introduced Web IDE for SAP HANA and it had to be installed explicitly to access it.

With HANA SPS07, we get a new HANA Web IDE that is installed by default.

I couldn’t try Web IDE on HANA SPS06, so gave it a try with SPS07 and wanted to share my experience and compare it with HANA Studio.

Web IDE is a lightweight browser based IDE for creating, editing and debugging development artifacts without using HANA Studio.

The URL to open the IDE is http://<hostname>:80<InstantNumber>/sap/hana/xs/ide/

1.JPG

As seen from the above figure, we have four tools – to access these tools we also have some pre-delivered roles that need to be assigned.

You can learn more about these roles and features of Web IDE from the below document from Kai-Christoph Mueller

HANA XS development with the SPS07 Web IDE (focus on debugging)

Lets start with Editor tool

On opening the Editor tool, we get to see packages and their content:

Editor.JPG

Editor tool is like the Content folder of our HANA Studio and shows all the development Objects – It gives us full access to the SAP HANA Repository and we can create, delete and rename packages here.

One of the features that I like most here is Delivery Unit Management

As we all know in HANA Studio, to create, change or remove a Delivery Unit, the easiest way is to go to Quick Launch tab and Click on Delivery unit and then below screen shows up:

S6.JPG

We can also create as well as export Delivery Units using this Editor tool, for that we just need to R-Click on the Content folder

E14.jpg

On clicking Create Delivery Unit, the below popup appears, where we can define Delivery Unit details

E15.JPG

On clicking Export Delivery Unit, the below popup appears and then we can select the Delivery Unit that we want to export

E16.JPG

But with the help of HANA IDE Editor, we can also assign a package to a Delivery Unit or unassign it from a Delivery Unit by just Right Clicking on a Package and then Selecting  Delivery Unit -> Assign or Unassign. This is not possible in HANA Studio as shown below

S1.jpg

But it is possible with HANA IDE Editor

E9.jpg

On clicking Assign, it gives the following popup and from the drill down option, we can select the Delivery Unit to which the package needs to be assigned.

E12.JPG

Similarly on clicking  unassign a Delivery Unit, we get a popup as shown below:

E13.JPG

Editor tool also has Search functionality and we can search any file

E5.JPG

Search in HANA Studio is also there but it shows only Models, Tables and Column Views

S4.jpg

Similarly we can also search for File Content in both HANA Studio and HANA IDE by Right Clicking on a package.

But HANA Studio triumphs HANA IDE with Quick Access option which has many features:

S8.jpg

We also have some template applications present in Editor, for accessing them R-Click in the Content folder and select Create Application

E17.jpg

Using template, I just created a HANA XS Hello World Template App inside test  package and following files were generated automatically

E18.JPG

We can run this app directly on browser and we also get option to simulate SAPUI5 apps on IOS or Android

E19.JPG

With HANA Studio, we can only run the file in Browser:

S9.jpg

The JavaScript Editor present is very handy – it has syntax highlighting, code folding, code formatting, code checking and other features like HANA Studio

As shown in the below figure, editor is dynamically showing that Line 10 is missing Semicolon and while an artifact is being edited its name is shown in Yellow color as shown below

E22.jpg

We can press “Ctrl + Space” for code completion similar to HANA Studio

E21.JPG

The best thing I like about JavaScript Editor is that on pressing Save button – the Editor checks and activates the Object

On clicking a package, we create a new file  and by default it is a .js file and we can also change the extension and also revert it(delete)

V5.jpg V6.jpg

For me the best capability of Editor tool is Version Management

We can see multiple versions of an artifact and then compare them and see what is different between the two versions.

For seeing Versions, just R-Click on a file and select Versions

V.JPG

Another awesome feature of HANA IDE is Multi File Drop Zone

To use this, we just click on the package and then we can drag and drop files into that package

V2.jpg

Once files are copied, we can see notification below

V3.JPG

And then we can see these files inside that package:

V4.JPG

We can also see HANA Views using the Editor tool but they open in XML format

E1.JPG

On clicking Settings button, we can change Editor settings and enable inactive testing

E8.JPG

We can also directly open other tools from any IDE tool

Others.JPG

On Clicking Information button, we can see FAQs and Text Editor Shortcuts

E6.JPGE7.JPG

Lets look at the Catalog tool

Catalog.JPG

The Catalog tool shows all the Schemas that we have access to and so we can view procedures, functions, sequences, tables etc

If we right click on any table, we can only generate Create and Select statements and also delete the files

L4.jpgL6.JPG

In HANA Studio, we can generate Create and Select statements but additionally we can also use Visual SQL and do many other things as shown below

S11.jpg

Using Visual SQL, we can create joins, select fields for output and test the result

S16.JPG

S17.JPG

But we cannot create a table using HANA IDE

L3.jpg

Now Lets look at the Security tool

Security.JPG

The Security tool shows all the Users and Roles

We can see any role or user and see all its priviliges

S2.JPG

We can also see the Modeling role with HANA Studio and  we observe that we are not able to see Analytic Privileges in HANA IDE

S19.JPG

We can also create new users and new roles and assign them roles and privileges

S1.JPG

L2.JPG

But we cannot set Auditing or Password policy using HANA IDE and can be done only using HANA Studio

S18.JPG

Finally, Lets look at the Trace tool


Using the trace tool, we can view the XSEngine and Index Engine traces and can also set the Trace Levels


T1.JPG

T2.jpg

We can also directly access HANA Application Lifecycle Management tool through any of the Web IDE tools


Through this tool, we can perform a lot of operations – transportation, change management and also maintain delivery units

To learn more about it, you can refer to the below blog:

SAP HANA Application Lifecycle Management | SAP HANA

V8.JPG


Conclusion:

For me the main features of HANA Web IDE are:

1.) Version Management and ability to directly make changes in the Server version of the Object – helps in resolving conflicts in Objects too

2.) The Text Editor of the tool is great and its best feature for me is that by only pressing “CTRL + S” we can check and activate the objects

3.) Debugging capability is also very good

4.) We can drop and drag and copy multiple files at a time in a particular package

5.) General User Administration can be done with ease using Web IDE

6.) We don’t need access to HANA Studio and can access HANA artifacts anywhere on the go

We can conclude that HANA Web IDE is a great tool for developing XS based applications and for General User Administration

As we can see it is missing lot of features compared to HANA Studio

I know HANA IDE is not meant to replace HANA Studio and features like Modeling and Administration are not suitable for it as it is meant to be a lightweight Web based IDE

Hope to see further development in the Web IDE

Thank You for reading my blog

Regards,

Vivek  

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

    1. Vivek Singh Bhoj Post author

      I would say SPS7 is the most stable build of HANA and there seem to be lot of performance improvements under the hood and most of the existing features have been improved

      You should definitely go for the update

       

      Regards,

      Vivek

      (0) 
  1. Patrick BECH

    Awesome, great initiative, great job (nice & well written) as it helps HANA lovers, developers moving foward and learning faster.
    Cheers, Patrick

    (0) 

Leave a Reply