How to use node JS access data in SAP Hana cloud database

Sign in SAP Business Technology Platform, find space Create it yourself HANA Cloud example , Right click on the menu to select Copy SQL Endpoint, take HANA Cloud Example of endpoint Copy it ：

25eeba68-24ce-4b2d-aaa5-ee8d599ff4a0.hana.trial-eu10.hanacloud.ondemand.com:443

We'll be in Node.js In the code , Will use .

Create a new one Node.js application , install hana client Development Library ：

npm install --save @sap/hana-client

Complete source code ：

var hana = require("@sap/hana-client");var connOptions = {  serverNode: "25eeba68-24ce-4b2d-aaa5-ee8d599ff4a0.hana.trial-eu10.hanacloud.ondemand.com:443",  encrypt: "true",  sslValidateCertificate: "false",  uid: "DBADMIN",  pwd: "Sgd",};var dbConnection = hana.createConnection();dbConnection.connect(connOptions, function (err) {  if (err) throw err;  dbConnection.exec(    `SELECT TOP 1000 "REGION", "DESCRIPTION"FROM "PLAIN"."REGIONS"`,    function (err, result) {      if (err) throw err;      for( var i = 0; i < result.length; i++)        console.log(result[i]);      dbConnection.disconnect();    }  );});

Execution results ：

Node.js The database table printed in the code REGIONS, come from PLAIN schema：

Be careful , Use DBADMIN This user , You can only access the user owned access right Database table of .

For example, we replace it Node.js The name of the accessed database table is DB1.COMMUNITY:

here ,Node.js Application error ：

Error: insufficient privilege: Detailed info for this error can be found with guid ‘6F6F68ED5F58804CB8C7B25D7559D0E0’