Troubleshooting guide
Configuring Replication Server
Review the procedures for configuring Replication Server for ASE-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
DB
.
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.
1.
If you are using SAP Secure User Store, create a user store of encrypted credentials:
hdbuserstore set rds myhost:xxxxx my_securestore_user
my_securestore_pwd
where
•
rds
is the key for the secure store entry
•
myhost
:
xxxxx
is the connection environment host name and port number
•
my_securestore_user
and
my_securestore_pwd
are SAP Secure User Store credentials
2.
On SAP HANA database, create a maintenance user:
a) As the SAP HANA database admin user, create a user ID with a temporary password:
CREATE USER muser PASSWORD mpwd_temp
b) Log in to SAP HANA database with the temporary password, and then update the
password:
ALTER USER muser PASSWORD mpwd_new
c) Log out of SAP HANA database, and log in again with the new password.
3.
Log in to SAP HANA database:
./hdbsql -u user -p password -i id
where
user
is the SAP HANA database user,
password
is the user password, and
id
is the
instance number.
4.
On SAP HANA database, grant these authorities to the maintenance user:
GRANT CREATE ANY, DELETE, DROP, EXECUTE,
INDEX, SELECT, UPDATE ON SCHEMA myschema TO muser
CHAPTER 3: ASE-to-SAP HANA Database Replication Setup
14 Replication Server