3.1.3.4 Properties for SAP HANA
- Jenni Wallin
- Former user (Deleted)
- Chooi San Chong
When you are using a SAP HANA database, set the following properties in install.xml. SAP recommends that SAP HANA be set up with TLS/SSL encryption enabled. For one way TLS/SSL, you only need to configure the install.sap.ssl.encrypt, install.sap.ssl.truststore, install.sap.ssl.truststorepassword, and install.sap.ssl.hostnameincertificate properties. For mutual authentication, you will have to configure all the TLS/SSL properties.
For information on how to generate the certificate for SAP HANA, refer to: https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.04/en-US/02f21560bbc1495483373d266f7e1fc7.html
| Property | Description |
|---|---|
| install.sap.jdbc.user | Default value: This property specifies the username of the database that the Platform uses during runtime. Note! The installation will fail if the same username is configured for both the database owner, install.sap.owner, and the runtime (jdbc) user. |
install.sap.jdbc.password | Example value: This property specifies the password for the jdbc user, previously described. |
| install.sap.jdbc.driverdir | Default value: "" This property specifies the location and filename of the SAP HANA JDBC driver. This is a mandatory field, and the value doesn't accept "$MZ_HOME/3pp". Note! The driver name must be ngdbc.jar |
install.sap.owner | Default value: SYSTEM This property specifies the SAP HANA username for the database owner. The user will own all the data definitions in the SAP HANA instance to be created. Note! The installation will fail if the same username is configured for both the database owner and the runtime (jdbc) user, mz.jdbc.user . |
install.sap.password | Default value: This property specifies the password for the database owner, defined with the install.sap.owner variable described above. |
install.sap.host | Default value: This property specifies IP address or hostname for the database instance. |
install.sap.db.name | Default value: MZ This property specifies the name of the SAP HANA database. |
install.sap.port.hdbsql | Default value: This property specifies the port that will be used for hdbsql client while provisioning the SAP HANA database. |
| install.sap.port.jdbc | Default value: This property specifies the port that will be used during runtime for jdbc connections towards the SAP HANA database. |
| install.sap.instance.number | Default value: This property specifies the SAP HANA instance number. |
| install.sap.systemdb.name | Default value: SYSTEMDB This property specifies the SAP HANA System Database name. |
| install.sap.ssl.encrypt | Default value: true This property enables TLS/SSL encryption for SAP HANA. , if this is set to true at least need to configure for install.sap.ssl.truststore, install.sap.ssl.truststorepassword, and install.sap.ssl.hostnameincertificate. |
| install.sap.ssl.truststore | Default value: "" This property specifies the location and filename of the java keystore format truststore file. This property needs to be configured for both one way or mutual authentication. |
| install.sap.ssl.truststorepassword | Default value: "" This property specifies the truststore password. If no password is configure, you can put empty string "" as the value. This property needs to be configured for both one way or mutual authentication. |
| install.sap.ssl.hostnameincertificate | Default value: * This property specifies the hostname in the truststore certificate. You can use "*" as the value if there is no hostname configured. This property needs to be configured for both one way or mutual authentication. |
| install.sap.ssl.keystore | Default value: "" This property specifies the location and filename of the keystore file. This property is only used when enabling mutual authentication. |
| install.sap.ssl.keystoretype | Default value: "" This property specifies the keystore type, it can be JKS or PKCS12. This property is only used when enabling mutual authentication. |
| install.sap.ssl.keystorepassword | Default value: "" This property specifies the password for the keystore. This property is only used when enabling mutual authentication. |
| install.sap.ssl.sslcryptoprovider | Default value: "" This property specifies the TLS/SSL provider for keystore such as OpenSSL. This property is only used when enabling mutual authentication. |