This section contains details for SAP HANA connections.General information
| Field | Description |
|---|---|
| Data source | SAP HANA |
| Supported versions | 2.9.12 |
| Connection string | jdbc:sap:// |
| Packaged? |
|
| Certified? |
|
| Supported features | |
Estimate job |
|
Analyze data |
|
Schedule |
|
| Processing capabilities | |
Pushdown |
Note Pushdown for SAP HANA is currently available as a public beta. Since this is a beta feature, some capabilities may be limited. For more information on our beta program, refer to Betas at Collibra. |
Spark agent |
|
Yarn agent |
|
Parallel JDBC |
|
| Java Platform version compatibility | |
JDK 8 |
While the SAP HANA driver is compatible with JDK 8, it is not included in the standard package. However, the JDK 8 compatible SAP HANA driver is available for external download from the Maven Repository . After you download the JDK 8-compatible jar, replace the jar in the |
JDK 11 |
|
Yes
Minimum user permissions
In order to bring your SAP HANA data into Collibra Data Quality & Observability, you need the following permissions.
- Read access to your SAP HANA database tables.
- ROLE_ADMIN assigned to your user in Collibra DQ.
- When using Archive Break Records, you need write access to the schema output location in order for Collibra Data Quality & Observability to create tables in your database.
- While SAPHANADB is the default schema, depending on the SAP product and your installation method, your default schema may be one of the following instead:
- SAP<SID>
- SAPSR3
- SAPABAP<#>
- While SAPHANADB is the default schema, depending on the SAP product and your installation method, your default schema may be one of the following instead:
Recommended and required connection properties
| Required | Connection Property | Type | Value |
|---|---|---|---|
| Name | Text | The unique name of your connection. Ensure that there are no spaces in your connection name. |
| Connection URL | String | The connection string path of your SAP HANA connection. When referring to the example below, replace the value between the { } in the Example |
| Driver Name | String | The driver class name of your SAP HANA connection.
|
| Port | Integer | The port number to establish a connection to the datasource. The default port is |
| Source Name | String | N/A |
| Target Agent | Option | The Agent that submits your Spark job for processing. |
| Auth Type | Option | The method to authenticate your connection. Note The configuration requirements are different depending on the Auth Type you select. See Authentication for more details on available authentication types. |
| Driver Properties | String | The configurable driver properties for your connection. Multiple properties must be comma delimited. For example, abc=123,test=true |
No
Authentication
Select an authentication type from the dropdown menu. The options available in the dropdown menu are the currently supported authentication types for this data source.
| Required | Field | Description |
|---|---|---|
| Username | The username of your SAP HANA account. |
| Password | The password of your SAP HANA account. |
| Script | The file path that contains the script file that the password manager uses to interact with and authenticate a user account. Example /tmp/keytab/sap_pwd_mgr.sh |
| Param $1 | Optional. An additional parameter to authenticate your SAP HANA connection. |
| Param $2 | Optional. An additional parameter to authenticate your SAP HANA connection. |
| Param $3 | Optional. An additional parameter to authenticate your SAP HANA connection. |