--- parser: v2 author_name: Thomas Jung author_profile: https://github.com/jung-thomas primary_tag: products>sap-hana tags: [ tutorial>beginner, topic>cloud, products>sap-hana, products>sap-hana\,-express-edition, products>sap-hana-cloud ] time: 30 slug: hxe-node-express canonical_url: https://developers.sap.com/tutorials/hxe-node-express --- # Deploy a Node.js Application for SAP HANA Deploy a sample Node.js application which connects to SAP HANA, express edition or SAP HANA Cloud. ## Prerequisites and Assumptions - User knows how to install packages and develop using Node.js - Setup: `HANA, express edition` or `SAP HANA Cloud` must be running and accessible from your client platform. For instructions on how to setup a `HANA, express edition` see the [HANA Express database deploy tutorial](hxe-database-server). For instructions on starting `SAP HANA Cloud` trial see the [Help Thomas Get Started with SAP HANA](hana-trial-advanced-analytics). - This tutorial assumes that you have a database login that can access the `M_DATABASE` view in the `HANA, express edition` `SystemDB` or in `SAP HANA Cloud`. - **Tutorials:** [Setup Node.js to connect to SAP HANA](hxe-nodejs-setup) ## You will learn This tutorial will guide you through the process to deploy a sample Node.js application which connects to SAP HANA, express edition or SAP HANA Cloud. --- ### Prepare Environment for Node.js Install support package for `Node.js` and Express: Install the Node.js package called `express-generator` globally: ```shell npm install -g express-generator ``` ### Develop Simple Node.js Application Create a simple standalone `node.js` app: ```shell % mkdir hxeapp % cd hxeapp ``` Edit a file named `hxeapp.js` with the following content: ```JavaScript console.log ("Hello Node World!") ``` Test the simple app created in the previous step ```shell cd hxeapp node hxeapp.js ``` Access the HANA content from this Node application. First install HANA database driver to Node. Ignore any warnings that it may produce. ```shell npm install sap-hdbext-promisfied ``` Create a Node application that allows you to access SAP HANA, express edition or HANA Cloud data. Open the `hxeapps.js` file and add the following content: ```JavaScript // Reference HANA driver in the Node app and update the connection details let dbClass = require('sap-hdbext-promisfied') // Modify the host IP and password based on your system information let hanaConfig = { host: '', port: ``, sslValidateCertificate: false, encrypt: true, user: ``, password: '' } // Execute the query and output the results async function intro() { try { let db = new dbClass(await dbClass.createConnection(hanaConfig)) let rows = await db.execSQL("select * from m_database") console.log('Results:', rows) } catch (error) { return console.error(error) } } intro() ``` Replace the `` with the IP address or host name of your HANA Express or HANA Cloud database server. Replace `user` with `SYSTEM` if targeting HANA Express or `DBADMIN` if targeting HANA Cloud. Replace `HANA Port` with the SQL port for your HANA system. Replace the `` with your database system user password. Then save changes. Start your application: ```shell node hxeapp.js ``` The above command should produce results something like the below: ![Results](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-node-express/1.png) ### Extend Simple Node.js Application to Run as a Web Application Modify this app to be a `WebApp`. Install support packages for `Node.js` and Express. ```shell npm install express ``` Execute express to create a template for developing `WebApp` ```shell express ``` Above step will create template files with dependencies. Note: It was installed manually previously. We want to do it automatically along with other packages Modify `package.json` to include `@sap/hdbext` driver. Edit `package.json` and add below line in the dependencies section. ```json "sap-hdbext-promisfied": "latest" ``` After the edits, your `package.json` file would looks something like: ```json { "name": "hxeapp", "version": "0.0.0", "private": true, "scripts": { "start": "node ./bin/www" }, "dependencies": { "cookie-parser": "~1.4.4", "debug": "~2.6.9", "express": "~4.16.1", "http-errors": "~1.6.3", "jade": "~1.11.0", "morgan": "~1.9.1", "sap-hdbext-promisfied": "latest" } } ``` Call `npm` `install` to pull the dependencies ```shell npm install ``` Create an app that does what our `hxeapp.js` does, but now we should modify the template file to do it. Your directory content would look something like: ```shell app.js hxeapp.js public/ views/ bin/ node_modules/ package.json routes/ ``` ```shell $ ls routes/ index.js users.js ``` Modify the `index.js` file to include the following code snippet: ```JavaScript var express = require('express') let dbClass = require('sap-hdbext-promisfied') var router = express.Router() var hanaConfig = { host: '', port: ``, sslValidateCertificate: false, encrypt: true, user: ``, password: '' } /* GET home page. */ router.get('/', async function (req, res, next) { try { let db = new dbClass(await dbClass.createConnection(hanaConfig)) let rows = await db.execSQL("select * from m_database") res.render('index', { title: 'Sample Node.js on HANA ', datarow: rows }) } catch (error) { res.send(error.toString()).status(500) return console.error(error) } }) module.exports = router ``` Replace the `` with the IP address or host name of your SAP HANA, express edition or SAP HANA Cloud database server. Replace `user` with `SYSTEM` if targeting HANA Express or `DBADMIN` if targeting SAP HANA Cloud. Replace `HANA Port` with the SQL port for your SAP HANA system. Replace the `` with your database system user password. Then save changes. Edit the file `views/index.jade` that controls the `WebApp` output layout as follows: ```text extends layout block content h1= title - each v, k in datarow[0] p #{k} : #{v} ``` Start the application ```shell npm start ``` Open a new browser and access `http://localhost:3000/` Notice that the browser displays information like what was displayed in earlier output. --- ### Additional Information - [View similar How-Tos](http://developers.sap.com/tutorials.html) or [View all How-Tos](http://developers.sap.com/tutorials.html) - Go to [SAP HANA](https://developers.sap.com/topics/hana.html) tutorials page