HANA Sandbox Backend
Uses @sap/hana-client
to run HANA Statements to HANA backend. Returns JSON meant for a Vue frontend like https://github.com/entmike/hana-sql-sandbox-frontend.
Docker Installation
Easy-mode here:
https://hub.docker.com/r/entmike/hana-sql-sandbox
Installation
npm i hana-sql-sandbox-backendcd hana-sql-sandbox-backendnpm config set @sap:registry https://npm.sap.comnpm install
Environment Config
(Windows)
set HANA_USER=SYSTEMset HANA_PW=HXEHana1set HANA_SERVER=hxehostset HANA_PORT=39017
(Mac/Linux)
export HANA_USER=SYSTEMexport HANA_PW=HXEHana1export HANA_SERVER=hxehostexport HANA_PORT=39017
Run
3 different ways to run, depending if you are tinkering/developing/etc...
Debug Mode
npm run debug
Development Mode
npm run dev
Production Mode
npm run prod
Results
> backend@1.0.0 dev C:\code\backend
> nodemon server.js
[nodemon] 1.18.11
[nodemon] to restart at any time, enter `rs`
[nodemon] watching: *.*
[nodemon] starting `node server.js`
Testing HANA Connection to hxehost:39017...
Connection test successful. Disconnecting for now.
Server started on port 9999