At the time of creation of this document there was no official SAP documentation available explaining details of SLT replication. This document is based on author's experience gained through working with SLT replication. Author was forced to make conclusions based on observing normal behavior of SAP system during SLT replication, based on studying SLT source code and based on experimenting with SLT configuration and replication.
The author therefore does not accept responsibility for potential damage done by applying information gained by reading this document. If you are not sure about result of your actions please contact SAP for further assistance.
The goal of this document is to extend SAP documentation and to provide new information about SLT replication.
The reader is expected to download and read at least following SAP guide before reading this document.
SAP HANA 1.0 Installation Guide - Trigger-based Replication
https://service.sap.com/~sapidb/011000358700000604912011
SLT can be installed either as a standalone component running on NetWeaver platform or inside an existing SAP system in case that the system is meeting specified criteria (see installation guide).
Note: Pictures above are taken from “SAP HANA Installation Guide – Trigger Based Replication” - pages 9 and 10 created by SAP.
SAP guide does not mention which option is preferred so here are some arguments supporting both options:
Unless very specific cases I would suggest to install SLT as separate system. Benefits from standalone configuration are significantly outweighing increased costs of ownership.
See SAP guide for instructions. If required update SAP kernel.
Be sure to review also SAP note 1597627 - HANA connection for additional requirements including HANA client and DBSL installation.
Comment about creation of secondary database connection into HANA (SAP note 1597627):
During SLT configuration following database connections will be automatically created so there is no need to manually create additional database connection.
<hana hostname>:<source system>:<target schema user>
<hana hostname>:<source system>:<replication control user>
Additional database connections might be needed for example for central monitoring using Solution Manager (then you should configure HANA connection in Solution Manager).
Complete SLT installation process is described in SAP guide and corresponding SAP notes. It can be summarized into following roadmap:
Note:
At the time of creation of this document the latest available support package was SP04. You should always install latest available support package because there are many critical fixes delivered.
Note:
In the installation guide is written that a special support package for HANA should be installed. This information is no longer valid because regular SP04 is already available which replaces this special support package. See SAP note 1602938 -DMIS_2010_1_700: Special Support Package for HANA 1.0 for more details.
see SAP note 1597627 for instructions how to add a connection via transaction SM30 (maintenance of DB table DBCON)
/sap/bc/webdynpro/sap node - activate service iuuc_replication_config
see next blog for detailed explanation
Second part (covering Post-Installation activities - applying SAP corrections, creating connection between source system and SAP HANA database, adjusting security and data provisioning) can be found here:
SAP SLT (Trigger Based) Replication Made Easy - part 2: Post-Installation
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |