Connecting to SAP HANA
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? | Yes |
Certified? | Yes |
Supported features | |
Estimate job | Yes |
Analyze data | Yes |
Schedule | Yes |
Processing capabilities | |
Pushdown | Yes 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 | Yes |
Yarn agent | Yes |
Parallel JDBC | Yes |
Java Platform version compatibility | |
JDK 8 | Yes 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 |
---|---|---|---|
Yes | Name | Text | The unique name of your connection. Ensure that there are no spaces in your connection name. |
Yes | Connection URL | String | The connection string path of your SAP HANA connection. When referring to the example below, replace the Example |
Yes | Driver Name | String | The driver class name of your SAP HANA connection.
|
Yes | Port | Integer | The port number to establish a connection to the datasource. The default port is |
No | Source Name | String | N/A |
No | Target Agent | Option | The Agent that submits your Spark job for processing. |
Yes | 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. |
No | Properties | String | The configurable driver properties for your connection. Multiple properties must be comma delimited. For example, abc=123,test=true |
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 |
---|---|---|
Yes | Username | The username of your SAP HANA account. |
Yes | Password | The password of your SAP HANA account. |
Yes | 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 |
No | Param $1 | Optional. An additional parameter to authenticate your SAP HANA connection. |
No | Param $2 | Optional. An additional parameter to authenticate your SAP HANA connection. |
No | Param $3 | Optional. An additional parameter to authenticate your SAP HANA connection. |
Known limitations
- While SAP HANA supports the special characters ::$/-;@#%^&*?!{}~+= in table names, it does not support .().