Connecting to SAP HANA

This section contains details for SAP HANA connections.

General information

FieldDescription
Data sourceSAP HANA
Supported versions2.9.12
Connection stringjdbc: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

RequiredConnection PropertyTypeValue

Yes

NameTextThe unique name of your connection. Ensure that there are no spaces in your connection name.

Yes

Connection URLString

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 NameString

The driver class name of your SAP HANA connection.

com.sap.db.jdbc.Driver

Yes

PortInteger

The port number to establish a connection to the datasource.

The default port is 30015

No

Limit SchemasOption

Allows you to manage usage and restrict visibility to only the necessary schemas in the Explorer tree.

See Limiting schemas to learn how to limit schemas from the Connection Management page.

Note When you include a restricted schema in the query of a DQ Job, the query scope may be overwritten when the job runs. While only the schemas you selected when you set up the connection are shown in the Explorer menu, users are not restricted from running SQL queries on any schema from the data source.

No

Source NameStringN/A

No

Target AgentOptionThe Agent that submits your Spark job for processing.

Yes

Auth TypeOption

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

PropertiesString

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.

RequiredFieldDescription

Yes

UsernameThe username of your SAP HANA account.

Yes

PasswordThe 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 $1Optional. An additional parameter to authenticate your SAP HANA connection.

No

Param $2Optional. An additional parameter to authenticate your SAP HANA connection.

No

Param $3Optional. An additional parameter to authenticate your SAP HANA connection.

Supported reserved words in SQL queries

The following SAP HANA reserved words are supported in SQL queries:

  • union
  • all
  • case
  • when
  • then
  • else
  • end
  • in
  • current_date
  • current_timestamp
  • current_time
  • weekday
  • add_days
  • add_months
  • add_years
  • days_between
  • to_timestamp
  • quarter
  • year
  • month
  • to_char

Known limitations

  • While SAP HANA does not support parentheses () in table names, it does support the .:$/-;@#%^&*?!{}~+= special characters.