SAP HANA
SAP HANA is an in-memory database and application platform designed for real-time processing of high-volume data. It combines transactional and analytical workloads, enabling fast queries, advanced analytics, and complex data processing. It also supports modern applications, including predictive, spatial, and machine learning scenarios.
Prerequisites
The following prerequisites must be met for a user to create and test a successful connection.
- SAP HANA server must be accessible from the iceDQ server.
- Valid credentials to access the database.
- SAP HANA JDBC version 2.2 or above.
Authentication Mechanism
The following authentication mechanism is supported.
- Username and Password
Connection Properties
Use one or more properties from the table below to create a valid connection. Properties marked with an asterisk (*) are required.
| Name | Description | Example Values |
|---|---|---|
| Connection Name * | Name that uniquely identifies the connection. | Prod_sales_conn |
| Driver * | Driver used to establish the connection. By default, one driver is available. | SAP HANA Native JDBC |
| Custom JDBC URL | Standardized string used to define the connection details. Use this format supported by the driver: jdbc:sap://[host]:[port]/[database] | jdbc:sap://hana-prod.acme.com:30015/salesdb |
| Host * | IP address or hostname of the database server. | hana-prod.acme.com |
| Port * | Port is the address on which the server listens. Default value is 30015 for SAP HANA. | 30015 |
| Database * | Name of the target database. | salesdb |
| Type * | The connection type – either System Connection or User Connection. Refer Connections for more details. | System or User |
| Username * | Database login username with necessary privileges. | john_doe |
| Password * | Password associated with the specified username. | Admin@123 |
Custom Properties
The following optional connection properties can be configured based on user requirements.
| Property | Default Value | Possible Values | Description |
|---|---|---|---|
| proxyHTTP | False | TRUE, FALSE | Enables HTTP proxy authentication and implies that ENCRYPT=TRUE. |
| proxyHostName | String | Host name of the SOCKS5 proxy server for TCP/TLS connections or an HTTP proxy server for TCP/TLS/WebSocket connections. | |
| proxyUserName | String | Username for proxy authentication. | |
| proxyPassword | String | Password for proxy authentication. | |
| proxyPort | 1080 (TCP), 80 (WebSocket) | Integer | Port of the SOCKS5 proxy server or HTTP proxy server. |
Unsupported Datatypes
The following datatypes are not supported.
- ST_POINT
- ST_LINESTRING
- ST_POLYGON
- ST_MULTIPOLYGON
- ST_GEOMETRY
- ST_GEOMETRYCOLLECTION