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
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 /opt/owl/drivers/sap directory.
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<#>

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 ${value} sections of the connection URL with your actual value. Example jdbc:sap://${host}:${port}/?databaseName=${dbName}
Yes	Driver Name	String	The driver class name of your SAP HANA connection. com.sap.db.jdbc.Driver
Yes	Port	Integer	The port number to establish a connection to the datasource. The default port is 30015
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 .().