SAP HANA

1. Prerequisites

Extension automatically asks to install the SAP HANA driver (@sap/sap-client)

2. Connections

2.1 SAP HANA Connection

For full reference, see SAP Documentation

{
"name": "<your preferred name>",
"dialect": "SAPHana",
"database": "<the schema you want to connect to>",
"username": "<user-name",
"password": "<pwd>",
"connectionTimeout": 15, //in seconds,0 for disabling,
"hanaOptions": { //optional map that specify additional connection options as specified in the link above
"ENCRYPT": true,
//...
}
}

For connecting HANA as a Service (cloud service), the connection is required to be encrypted. For that you need to add:

"hanaOptions": {
"ENCRYPT": true,
"sslTrustStore": "<path to a trust store>/DigiCertGlobalRootCA.pem"
}

and you need to have a trust-store with DigiCert in it. You may download it from here, and convert it to a trust store by: openssl x509 -inform der -in DigiCertGlobalRootCA.crt -out ~/.ssl/DigiCertGlobalRootCA.pem

2.2 Alternative Connection Strings

ConnectionString maps from connectString property:

{
"name": "<your preferred name>",
"dialect": "SAPHana",
"connectString": "<see docs>" // Example: "connectString": "HOST=myServer;PORT=30015;UID=MyUser;PWD=MyPassword"
}