> For the complete documentation index, see [llms.txt](https://docs.collibra.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.collibra.com/data-quality-self-hosted/connections/supported-connections/supported-jdbc-data-sources/connecting-to-sap-hana.md). # 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 Data Quality & Observability (self-hosted), 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 Data Quality & Observability (self-hosted) 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\ * 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.

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 | Limit Schemas | Option |

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.

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 Name | String | N/A | | No | Target Agent | Option | The [Agent](/data-quality-self-hosted/installation/agent.md) that submits your Spark job for processing. | | Yes | Auth Type | Option |

The method to authenticate your connection.

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 semicolon-delimited, and each property=value pair, including the last one, must end with a semicolon (;). `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. {% tabs %} {% tab title="Username/Password" %} | Required | Field | Description | | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------- | -------------------------------------- | | Yes | Username | The username of your SAP HANA account. | | Yes | Password | The password of your SAP HANA account. | | {% endtab %} | | | {% tab title="Password Manager" %} | Required | Field | Description | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Yes | Username | The username 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.

:glasses-round: 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. | | {% endtab %} | | | | {% endtabs %} | | | ## 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` {% hint style="success" %} If the SAP HANA reserved word you are using is not listed above, submit an ideation request through the [Ideation Portal](https://ideas.collibra.com/). {% endhint %} ## Known limitations * While SAP HANA does not support parentheses **()** in table names, it does support the **.:$/-;@#%^&\*?!{}\~+=** special characters.