Troubleshooting guide

Configuring Replication Components

Review the procedures for configuring each of the replication components in the replication

system.

Configuring Replication Server

Review the procedures for configuring Replication Server for Oracle-to-SAP HANA database

replication.

Obtaining the SAP HANA Database ODBC Drivers

Set up ExpressConnect for HANA DB for connections between SAP HANA database and

Replication Server.

You must add the SAP HANA database ODBC driver to the ExpressConnect for HANA DB

installation. Download these libraries from the SAP Service Marketplace and install them

after you have installed Replication Server. See the

Replication Server Release Bulletin >

Special Installation Instructions > Installing ODBC Libraries for ExpressConnect for HANA

Configuring Replication Server for Replication to SAP HANA Database

Create a Replication Server connection to SAP HANA database.

If you are not using the sample Replication Server instance, see the

Replication Server

Configuration Guide

for instructions.

If you are connecting to SAP HANA database with a standard connection and not using

SAP Secure User Store, add an entry to your Replication Server interfaces file identifying

the replicate SAP HANA database, and then stop and start Replication Server:

[dataservername]

master tcp ether hostname port

query tcp ether hostname port

where

hostname

and

port

are the host and port number of the SAP HANA database, and

dataservername

is a label used to identify the host and port number. For information about

stopping and starting Replication Server, see the

Replication Server Administration Guide

Volume 1 > Manage a Replication System

Note: Each SAP HANA database installs with a unique instance number, and the port

number is the instance number prefixed with 3 and suffixed with 15:

3in15

where

is the two-digit instance number. For example, the port number for an SAP

HANA database with instance number 1 is 30115.

If you are using SAP Secure User Store, create a user store of encrypted credentials:

CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup

32 Replication Server