Configuring ExpressConnect for HANA DB

Configure ExpressConnect for HANA DB to set up connections between HANA DB and Replication Server.

Prerequisites

On UNIX and Linux systems, make sure the ODBC driver for HANA DB has write permission in the directory referenced by the $HOME environment variable.

ExpressConnect for HANA DB does not ship with the required HANA DB ODBC drivers. Before using ExpressConnect for HANA DB, download these libraries from the SAP Support MarketPlace, and install them after installing Replication Server. See the Replication Server Release Bulletin > Special Installation Instructions > Installing ODBC Libraries for ExpressConnect for HANA DB.

Task

Determine the HANA DB maintenance user ID and password used to connect from Replication Server. See HANA DB Replicate Database Permissions in the Replication Server Heterogeneous Replication Guide.

Note: Before you create a connection to HANA DB, make sure that this maintenance user ID can log in to HANA DB and that the user ID has permission to create tables in HANA DB.
Use isql to create a connection to HANA DB from within Replication Server using the maintenance user ID and password combination. For example, for a standard connection and an Oracle primary database:
```
create connection to
<hana_server>.<hana_db>
using profile rs_oracle_to_hana;ech
set username <userid>
set password <password>
```
where:
- hana_server is the case-sensitive name identifying the replicate HANA DB data server in your interfaces file (standard connection) or an hdbuserstore key (secure connection).
- hana_db is an identifier for the HANA DB instance. This value is used by Replication Server only and is not used for connectivity.
  Note: HANA DB does not support multiple databases like Adaptive Server.
For a secure connection and an Oracle primary database:
```
create connection to
<hana_server>.<hana_db>
using profile rs_oracle_to_hana;ech
set username <userid>
set password <password>
set dsi_connector_sec_mech to "hdbuserstore"
```
where dsi_connector_sec_mech specifies the DSI connector security mechanism.
See create connection in the Replication Server Reference Manual.

Update the rs_info table, if necessary:

update rs_info 
set rsval = 'utf8'
where rskey = 'charset_name'
set rsval = 'bin_utf8'
where rskey = 'sortorder_name'