Adding Node.js Module to Existing SAP HANA Project

In part 2 of this series we continue to look at the idea of adding a service layer to an existing SAP HANA project in the era of SAP HANA Cloud and Business Application Studio. In Part 1 we saw how you can convert an SAP HANA Project to an SAP Cloud Application Programming Model project. In this video we want to explore an alternative approach by manually adding just a Node.js module to our SAP HANA project.

I want to stress that SAP Cloud Application Programming Model is the recommended and preferred choice in standard CRUD service options. However this approach with a standalone Node.js service can be useful when you need more control, a custom response body or a non REST or OData service.

Part 1 that covered the SAP Cloud Application Programming Model can be found here: https://www.youtube.com/watch?v=CrhIfKvI1bs

The source code can be found here:
The starting HANA only project: https://github.com/SAP-samples/sap-tech-bytes/tree/2021-05-03-hana-existing-starting
The completed example with the Node.js service: https://github.com/SAP-samples/sap-tech-bytes/tree/2021-05-03-hana-existing-nodejs

You can find more information about SAP HANA Cloud at the SAP Developer Center: http://sap.to/6059HCITT

0:00 Introduction
3:36 Copy project
6:25 Adjust mta.yaml
8:30 npm init to create srv module
10:00 Addition Node.js modules
11:42 index.js entry point
12:39 expres-server.js to initialize express
15:03 express.js to add middleware to express
17:05 expressSecurity.js for security setup
18:26 healthCheck.js for external health monitoring
19:40 overloadProtection.js
20:30 swagger.js add SwaggerUI
21:06 Test the basic service framework
22:01 Add service specific routes
23:54 Get all route
24:24 Get single record route
25:16 Controller with DB queries
27:49 Swagger from JSDoc
30:44 Testing via SwaggerUI
32:57 Closing