Configuring ExpressConnect for SAP HANA Database

Configure ExpressConnect for SAP HANA Database to set up connections between SAP HANA database and Replication Server.

Prerequisites

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

ExpressConnect for SAP HANA Database does not ship with the required SAP HANA database ODBC drivers. Before using ExpressConnect for SAP HANA Database, 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 SAP HANA Database.

Task

Determine the SAP HANA database maintenance user ID and password used to connect from Replication Server. See SAP HANA Database Replicate Database Permissions .

Note: Before you create a connection to SAP HANA database, make sure that this maintenance user ID can log in to SAP HANA database and that the user ID has permission to create tables in SAP HANA database.
Use isql to create a connection to SAP HANA database 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 SAP HANA database data server in your interfaces file (standard connection) or an hdbuserstore key (secure connection).
- hana_db is an identifier for the SAP HANA database instance. This value is used by Replication Server only and is not used for connectivity.
  Note: SAP HANA database 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'