Troubleshooting guide
where
myschema
is your SAP HANA database schema, and
muser
is the maintenance user
you just created.
5.
Log in to Replication Server:
isql –Usa –Psa_pass –SSAMPLE_RS
If you have not set up the sample Replication Server instance, enter your Replication
Server instance name in place of SAMPLE_RS.
6.
Create a connection to the replicate SAP HANA database instance using ExpressConnect
for HANA DB.
For a standard connection:
create connection to rds.rdb
using profile rs_ase_to_hanadb;ech
set username muser
set password mpwd
go
For SAP Secure User Store:
create connection to rds.rdb
using profile rs_ase_to_hanadb;ech
set username auser
set password apwd
set dsi_connector_sec_mech to "hdbuserstore"
go
where:
•
rds
is the replicate SAP HANA database. For a standard connection, this must match
the data server name in the Replication Server interfaces file entry. See the
Adaptive
Server Enterprise Configuration Guide for UNIX > Set Up Communications Across
the Network > Contents of the interfaces File
and the
Adaptive Server Enterprise
Configuration Guide for Windows > Network Communications Using sql.ini
. For an
SAP Secure User Store connection, this must match what you used as the key to create
a user store of encrypted credentials with the hdbuserstore utility.
•
rdb
is placeholder: You must provide a value, but it is not used..
•
muser
is the maintenance user for the replicate SAP HANA database instance that you
created in a previous step.
•
mpwd
is the replicate SAP HANA database maintenance user password.
•
auser
and
apwd
are unused values supplied only to satisfy the syntax of the create
connection command.
Note: For an SAP Secure User Store connection, the same user who ran the hdbuserstore
utility must run the create connection command.
If you have trouble connecting to the replicate SAP HANA database instance using
ExpressConnect for HANA DB, see the
Replication Server Troubleshooting Guide >
Common Error Messages > Connector Error Messages
.
7.
Use admin show_connections, 'replicate' to display the replicate connection you created.
CHAPTER 3: ASE-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 15