SAP HANA Plug-in
Connection Settings
| Property | Description |
|---|---|
| Name | Any name under which this database server appears in the connection project. Choose a name that is unique to you during connection projecting. |
| Host/IP/File | Address of the SAP Hana server |
| Port | Selection of the port for the database connection. The port can be changed if necessary. |
| Data source | Name of the database to be used |
| Schema | Schema |
| User | User name for logging on to the SAP Hana server |
| Password | Password for logging on to the SAP Hana server |
Advanced connection parameters
| Property | Description |
|---|---|
| Command Timeout | Time (seconds) that the router waits for an SQL command to complete. For long-running queries, it may be necessary to increase this value. Please note that you must also increase this value for individual connections that trigger long queries. |
| Connection Timeout | Time (seconds) that a connection to the database may take. |
| Simultaneous Connections | Number of connections that the router may establish in parallel. The more connections, the faster the router, but the slower the database may be. Ask your database administrator how many connections he allows the router to make. This depends, of course, on the scope of the project. |
| Polling Interval | Interval at which the database is queried. |
Advanced Settings
| Property | Description |
|---|---|
| BracketsEncloseBehaviour | This property determines when and how quotation marks are used in your SAP HANA plugin. Here is more information |
BracketsEncloseBehaviour
- Enclose if dot present: This mode is intended for backward compatibility. If a period (.) is included in an identifier, quotation marks are added. This is useful if you have database objects with periods in their names, such as
database.schema."table.name". - Disable: In this mode, no quotation marks are added, regardless of the identifier. This can be useful if you are sure that your identifiers do not contain any special characters or spaces and you want to improve the readability of the generated SQL.
- Always: In this mode, quotation marks are always added. This is useful if your identifiers might contain special characters, spaces, or reserved words.
note
Please note that in SAP HANA, quotation marks are used to escape identifiers that would otherwise be interpreted as reserved words. It also allows the use of special characters and spaces in identifiers.