Property | Description |
|---|---|
Connection Name | Name of the connection. Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -, Maximum length is 255 characters. |
Description | Description of the connection. Maximum length is 4000 characters. |
Type | SAP HANA. |
Use Secret Vault | Stores sensitive credentials for this connection in the secrets manager that is configured for your organization. This property appears only if secrets manager is set up for your organization. This property is not supported by Data Ingestion and Replication. When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured. For information about how to configure and use a secrets manager, see Secrets manager configuration. |
Runtime Environment | The name of the runtime environment where you want to run tasks. Select a Secure Agent or serverless runtime environment. For more information about how to configure a serverless environment, see Use the serverless runtime environment. |
Host | SAP HANA server host name. |
Port | SAP HANA server port number. |
Database Name | Name of the SAP HANA database. |
Current Schema | SAP HANA database schema name. Specify _SYS_BIC when you use SAP HANA database modelling views. |
Code Page | The code page of the database server defined in the connection. Select the UTF-8 code page. |
Username | User name of the SAP HANA account. |
Password | Password of the SAP HANA account. The password can contain alphanumeric characters and the following special characters: ~ ` ! @ # $ % ^ & * ( ) _ - + = { [ } ] | : ; ' < , > . ? / Note: You can't use a semicolon character in combination with a left brace or right brace character. |
Property | Description |
|---|---|
Metadata Advanced Connection Properties | The optional properties for the JDBC driver to fetch the metadata. If you specify more than one property, separate each key-value pair with a semicolon. For example, connectTimeout=180000 For more information, see Downloading and configuring libraries. |
Run-time Advanced Connection Properties | The optional properties for the ODBC driver to run the mappings. If you specify more than one property, separate each key-value pair with a semicolon. For example, charset=sjis;readtimeout=180 For more information, see Adding entries in Linux operating system. |