Location Connection for SAP HANA - DSS 6 | Data Source Solutions Documentation

Documentation: Location Connection for SAP HANA - DSS 6 | Data Source Solutions Documentation

Location Connection for SAP HANA

This section describes the connection details required for creating SAP HANA location in Data Source Solutions DSS. For information about the pre-requisites, access privileges, and other configuration requirements for creating SAP HANA location, see SAP HANA Requirements.

If the managed secrets feature is enabled, option USE TOKEN INSTEAD is displayed in the fields designated for entering secrets.

Field	Description	Equivalent Location Property
HOST	Hostname or IP-address of the server on which HANA server is running. Example: myhananode	Database_Host
HANA_MODE	The mode for connecting DSS to HANA server. Available options: Single container (default) Multiple containers - Tenant database Multiple containers - System database Manual port selection - This option is used only if database Port needs to be specified manually.
INSTANCE NUMBER	HANA database instance number. This field is not available if the HANA_MODE is Manual port selection. Example: 50
PORT	Port number on which the HANA server is expecting connections. This field is enabled only if the HANA_MODE is Manual port selection. For more information about TCP/IP ports in HANA, refer to SAP Documentation.Example: 35013	Database_Port
DATABASE	Name of the specific database in a multiple-container environment. This field is enabled only if the HANA_MODE is either Multiple containers - Tenant database or Manual port selection.	Database_Name
USER	Username for connecting DSS to the HANA database . Example: dssuser	Database_User
PASSWORD	Password for the USER.	Database_Password

Advanced Settings

Field	Description	Equivalent Location Property
LINUX / UNIX ODBC DRIVER MANAGER LIBRARY PATH	Directory path where the ODBC Driver Manager Library is installed. This field is applicable only for Linux/Unix operating system. For a default installation, the ODBC Driver Manager Library is available at /usr/lib64 and does not need to be specified. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/lib.	ODBC_DM_Lib_Path
ODBCSYSINI	Directory path where the odbc.ini and odbcinst.ini files are located. This field is applicable only for Linux/Unix operating system. For a default installation, these files are available at /etc directory and do not need to be specified using this field. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/etc. The odbcinst.ini file should contain information about the HANA ODBC Driver under heading [HDBODBC] or [HDBODBC32].	ODBC_Sysini
ODBC DRIVER	Name of the user defined (installed) ODBC driver used for connecting DSS to the HANA database. If the ODBC driver is not specified in this field, then DSS will automatically load the appropriate driver for your current platform: HDBODBC (64-bit) or HDBODBC32 (32bit).	ODBC_Driver

Field

Description

Equivalent Location Property

LINUX / UNIX ODBC DRIVER MANAGER LIBRARY PATH

Directory path where the ODBC Driver Manager Library is installed. This field is applicable only for Linux/Unix operating system.

For a default installation, the ODBC Driver Manager Library is available at /usr/lib64 and does not need to be specified. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/lib.

ODBC_DM_Lib_Path

ODBCSYSINI

Directory path where the odbc.ini and odbcinst.ini files are located. This field is applicable only for Linux/Unix operating system.

For a default installation, these files are available at /etc directory and do not need to be specified using this field. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/etc.

The odbcinst.ini file should contain information about the HANA ODBC Driver under heading [HDBODBC] or [HDBODBC32].

ODBC_Sysini

ODBC DRIVER

Name of the user defined (installed) ODBC driver used for connecting DSS to the HANA database. If the ODBC driver is not specified in this field, then DSS will automatically load the appropriate driver for your current platform: HDBODBC (64-bit) or HDBODBC32 (32bit).

ODBC_Driver

Staging

DSS supports staging for SAP HANA location. For information about the location properties for staging, see Staging for SAP HANA.