Skip to Content
Author's profile photo Chaim Bendelac

Developing with XS Advanced: Add business logic with Node.js

TinyWorld – Part 5

Add business logic with Node.js


Hello again!

The Web IDE supports the development of Node.js server side applications, as well as Node.js applications that use the “xsjs” compatibility layer – a Node.js extension library that supports most of the functionality of the XS Classic JavaScript language.

XSJS support is accomplished by including several SAP-provided Node.js modules, and the easiest way to do this is by checking the “XSJS” checkbox when creating a new Node.js module in your project, which is what we did in part 2 (Get started with the SAP Web IDE for SAP HANA) of this tutorial.

Adding a Node.js application

In part 3 (Create a SAP HANA based client-server application), we used OData to read from the database. While OData supports write/modify/delete actions to tables, most applications use application logic to validate the input values first. One way to do this, is to write a Node.js module that receives inputs over a REST interface, and writes the (validated) data into the database, as follows.

Right-click the tinyjs/lib/ folder, and create a “> New > Folder”. Call it country. Right-click country “> New > File”, and call it country.xsjs.  Add the following text to the file, and save it.

function saveCountry(country) {

var conn = $.hdb.getConnection();

var output = JSON.stringify(country);

var fnCreateCountry = conn.loadProcedure(“tinyworld.tinydb::createCountry”);

var result = fnCreateCountry({IM_COUNTRY:, IM_CONTINENT: country.partof});



if (result && result.EX_ERROR != null) { return result.EX_ERROR;}

else { return output; }


var country = {

  name: $.request.parameters.get(“name”),

  partof: $.request.parameters.get(“continent”)


// validate the inputs here!

var output = saveCountry(country);

$.response.contentType = “application/json”;


What does the app do? It reads the values of two “GET” parameters, name and continent respectively, passes them to a function that calls the SQLScript procedure we previously created to write these values to the country table, and emits a confirmation message. The same could of course also be done via a plain SQL INSERT statement.

NOTE:  we intentionally misuse the HTPP GET method to access a service for creating DB entries, in order to simplify the tutorial; productive applications should always use update methods (POST, PUT, DELETE) for database modification. We will address this issue in part 9 (Application life cycle) of the tutorial.

Now, run the tinyjs/ module again. This module now provides two entry points. Since we didn’t change the index.xsjs app, it will again show the hello message, as we saw in in part 2 (Get started with the SAP Web IDE for SAP HANA). But now we also have a new service, which we can access by appending the following text to the <host><port> part of the URL (in other words, replace /index.xsjs):




You will see the confirmation that the values were written, in JSON format, e.g.


Using the Node.js debugger

Right-click tinyjs/ “> Run > Run Configurations …”, and click the “+” to add a new Node.js application configuration. Name it debug mode, and check the Debug “Enabled” checkbox:


At this point, you should be able to click “Save and Run”, to rerun the application in debug mode.

To open (and close) the debugger control pane, click the debug tool on the right toolbar:


Now set a breakpoint on line 21, where saveCountry is about to be called: click on the left of the line number:


We can now test our code, by switching to another browser tab, and just like before, append the following to the <host><port> of the URL:


You may briefly see a “tinyworld/tinyjs is suspended” popup, indicating that the app is now suspended on the breakpoint we just set. That is as it should be.

Switching back to the Web IDE, you can see the debugger stopped on line 21:


And you can debug your code now, by examining the call stack, the values of parameters and other values. For instance, click on the “Step into” button:


And a few times on the “Step over” button:


To see the values of the local variables in saveCountry:


Click the “Resume” button to complete execution. NOTE that if you take a long time during debugging, the calling browser may have timed out, and will not wait for the response text, but the operation will still have completed.

Summary of part 5

In part 5 of this tutorial we learned how to use Node.js and its XSJS compatibility layer to build SAP HANA-based business logic a, complementing the in-database capabilities, provided by calculation views, SQLScript procedures and more.

We completed the basic tutorial. Congratulations!

We are now ready to explore the more advanced parts of this TinyWorld tutorial, covering things like the use of version control, adding authentication and authorization control to our application, and  how to manage the life cycle of our application, from development to deployment. As before, we strongly recommend that you follow the advanced topics of this tutorial in the following order:

Part 6:   Create Node.js unit tests

Part 7:   Under the hood

Part 8:   Source control

Part 9:   Application life cycle

Part 10: Add authentication

Part 11: Add authorization

Wishing you success!

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      The debug mode checkbox doesn't exist in my install.  The debugger fails to connect to the application, and says to restart in debug mode.

      Author's profile photo Former Member
      Former Member

      Aha.  If I click "Start with application file" instead of the "Start with package.json script" option, it shows an option to enable debugging.

      Author's profile photo Michael Smith
      Michael Smith


      For some reason, I am getting a "Bad Login" error when trying to run the nodejs application in debug mode in HANA 2.0.

      Here is more info from the log:

       "POST /--debugger/login HTTP/1.1" 200 sent 100 in 4 by 00W-9b864226-790c-41f6-8990-bb1193e1cb61
      2/5/18 4:16:49.000 PM [APP/6-0] TRC    /appcontroller.kUoygWccTM/AppController/node_modules/applicationcontroller/controller/proxyRequests.js:15 [] ERROR: Error occurred, Cannot proxy application requests...Error: connect ECONNREFUSED
      Any thoughts as to what could be causing this error?  If I run the normal start script I don't receive this error.
      Author's profile photo xochilpili f
      xochilpili f

      returns : 500 Cannot read property 'getConnection' of undefined.

      Any help ?


      Also, i have another related issue:

      server.js, has this part:

        options = Object.assign(options, xsenv.getService({hana: {tag: 'hana'}});
        console.log(options); // i add this...
        console.log("[WARN] " + err.message);

      and in console always got this: "[WARN] No service matches hana"


      Author's profile photo Inderpreet Singh
      Inderpreet Singh


      I am also facing the same issue in one of my application.
      Could you please let me know how you fixed this issue.

      Thanks in advance!

      Author's profile photo Sujit kumar
      Sujit kumar

      returns : 500 Cannot read property ‘getConnection’ of undefined.


      Was this resolved ?

      Author's profile photo Ravish Singh
      Ravish Singh



      JS module requires HANA module to run.

      Please modify your MTA file, then it will run fine.