How to use nodejs application to query data in SAP HANA Express Edition

In this issue, the editor will bring you about how to use the nodejs application to query the data in SAP HANA Express Edition. The article is rich in content and analyzes and describes it from a professional point of view. I hope you can get something after reading this article.

Premise: 64-bit PHP runtime and 64-bit Apache Web server have been installed.

We need to use SAP HANA ODBC database drivers to connect PHP runtime to SAP HANA Express Editor and download it on SAP's official website.

Click the HANA tab, download SAP HANA Client 2.0 and install:

Open ODBC Data Source administrator:

If you see the HDBODBC driver here, SAP HANA client has been successfully installed:

Specify the SAP HANA Express address that uses the HDBODBC connection here:

Click the Connect button and enter the password of the SYSTEM user:

The ODBC is configured as shown below:

Under the apache web server installation folder, open the htdocs folder, create a new hxe folder, and create an index.php file in it: