You develop a Node.js application for the SAP HANA platform that executes a SQL statement in the SAP HANA database. Which modules do you use?
There are 2 correct answers to this question.
Correct Answer: B,C
To develop a Node.js application for the SAP HANA platform that executes a SQL statement in the SAP HANA database, you need to use the following modules:
* @sap/xsenv: This module provides functions to load service configuration and credentials from the environment variables of the SAP Cloud Platform or the SAP HANA XS Advanced Model. You can use this module to access the SAP HANA database service information, such as host, port, user, password, and schema.
* @sap/hdbext: This module provides a wrapper for the SAP HANA client for Node.js, which enables you to connect to the SAP HANA database and execute SQL statements. You can use this module to create a database connection pool, execute queries, fetch results, and handle errors.
The other options are not correct because:
* A. @sap/instance-manager: This module provides functions to manage the lifecycle of Node.js applications running on the SAP Cloud Platform or the SAP HANA XS Advanced Model. You can use this module to start, stop, restart, scale, and monitor your applications, but not to execute SQL statements in the SAP HANA database.
* D. @sap/node-vsi: This module provides functions to interact with the SAP HANA Virtual Schema Integrator (VSI), which enables you to access data from remote sources using virtual tables. You can use this module to create, update, delete, and query virtual tables, but not to execute SQL statements in the SAP HANA database.
References:
* SAP HANA Developer Guide for SAP HANA Web IDE, Chapter 5, Section 5.2
* SAP HANA Developer Guide for SAP HANA Web IDE, Chapter 5, Section 5.3
* SAP HANA Developer Guide for SAP HANA Web IDE, Chapter 5, Section 5.4
* SAP HANA Developer Guide for SAP HANA Web IDE, Chapter 5, Section 5.5