SLT Replication Server Overview
for
SAP HANA
7/14/16
By VLS Ramesh
SLT Environment Flow
Test Data Migration Server
7/14/16
By VLS Ramesh
The Set-up of LT Replication Server
7/14/16
By VLS Ramesh
Key Benefits of LT Replication Server for SAP HANA
.. Allows real-time (and scheduled) data replication, replicating only relevant
data into HANA
.. Ability to transform data into HANA format while replicating data in real-time
.. Wide release coverage (SAP R/3 4.6C onwards) sourcing data from
SAP ERP (and other ABAP based SAP applications)
.. Simple and fast set-up of LT replicator (initial installation and
configuration in less than 1day) and fully integrated with HANA
7/14/16
By VLS Ramesh
SAP TDMS Technology: Architecture
7/14/16
By VLS Ramesh
SLT Replication Key Building Blocks
7/14/16
By VLS Ramesh
Technical Requirements and System Set-Up Information
7/14/16
By VLS Ramesh
System Set-Up Effort for LT Replication Server
7/14/16
By VLS Ramesh
SLT Replicator Config. Step 1
7/14/16
By VLS Ramesh
SLT Replicator Config. Step 2
7/14/16
By VLS Ramesh
10
SLT Replicator Config. Step 3
7/14/16
By VLS Ramesh
11
SLT Replicator Config. Step 4
7/14/16
By VLS Ramesh
12
SLT Replicator Config. Step 5
7/14/16
By VLS Ramesh
13
Now lets understand 2 Project examples-Industry-wise
7/14/16
By VLS Ramesh
14
Electronics Manufacturer
7/14/16
By VLS Ramesh
15
Large Utility company
7/14/16
By VLS Ramesh
16
Transformation Capabilities
7/14/16
By VLS Ramesh
17
Details on Transformation Capabilities
The main purpose of SAP HANA is reporting of data.
Generally this will be done by a one-to-one replication of tables
Because of the customer specific requirement, its necessary sometimes to
filter, change/transform or extend the original data within the load process into
HANA.
7/14/16
By VLS Ramesh
18
7/14/16
By VLS Ramesh
19
Data Processing
7/14/16
By VLS Ramesh
20
Transformation Steps
7/14/16
By VLS Ramesh
21
Fields of IUUC_ASS_RUL_MAP
Fields of Table IUUC_ASS_RULE_MAP (LT-Replication Server)
MT_ID
TABNAME
BASISVERSION
EVENT
(not used for parameter rules)
FIELDNAME
IMP_PARAM_1..3 (not used for event based rules)
INCLUDE
*** Remember INCLUDE program to be created in SE38 before assigning it to the Mapping Table
7/14/16
By VLS Ramesh
22
We understand,
There are two types of transformations rules
1. Event based rules
2. Parameter based rules
7/14/16
By VLS Ramesh
23
Events based Rules
7/14/16
By VLS Ramesh
24
Parameter based Rules
7/14/16
By VLS Ramesh
25
Defining Include Program
Goto: TA SE38
Enter program name and press create
7/14/16
By VLS Ramesh
26
Event based rule:
7/14/16
By VLS Ramesh
27
Parameter rule:
7/14/16
By VLS Ramesh
28
Extension of Tablestructures
(Maintaining table IUUC_REPL_TABSTG)
7/14/16
By VLS Ramesh
29
Extension of Tablestructures Steps
Step 1: Create table of target structure
7/14/16
By VLS Ramesh
30
Step 2: Arrange for another ABAP program to populate your new Table
Step 3: Maintain the REPL Table structure
7/14/16
By VLS Ramesh
31
Step 4: Provide your INCLUDE program in IUUC_ASS_RUL_MAP (EVENT BASED)
7/14/16
By VLS Ramesh
32
Step 5: Provide your INCLUDE program in IUUC_ASS_RUL_MAP (PARAM BASED
7/14/16
By VLS Ramesh
33
Result Data in HANA:
7/14/16
By VLS Ramesh
34
Filtering records in Replication
7/14/16
By VLS Ramesh
35
Filtering records in Replication Steps
Step 1: Filter to be defined in table IUUC_SPC_PROCOPT (TRIGGER
TABLE)
Fields
MT_ID
TABNAME
DBSYS (Eg.DB2, DB6, MSSQL, ORACLE)
EVENT
LINE_NO
LINE
Ideal Filter Criteria: Only Activated Objects
7/14/16
By VLS Ramesh
36
Step 2:Check Cluster Table
7/14/16
By VLS Ramesh
37
Step 3:Check Mapping table
7/14/16
By VLS Ramesh
38
Whats new with SP03 ?
7/14/16
By VLS Ramesh
39
With SPS03, in the HANA modeler, it will be possible to suspend a table
from the replication process and to resume it a later point in time.
7/14/16
By VLS Ramesh
40
Extra Info.
*** With SPS03, LT replication server also supports real-time
replication for non-SAP sources ***
LT replication server transfers in a first step all metadata table
definitions from the non-SAP source system to the HANA system into
the tables DD02L and DD02T.
The connection from LT replication server to the non-SAP source
system is established by means of a database connection.
7/14/16
By VLS Ramesh
41
Configuration for non-SAP source systems within the LT replication server
7/14/16
By VLS Ramesh
42
More Additional Info.
DB Supportability Matrix:
Loading Data via SLT Replication into HANA
7/14/16
By VLS Ramesh
43
THANK YOU
7/14/16
By VLS Ramesh
44
