How to Create new configuration for SLT server

Task 1: New configuration of SLT

Use transaction SU01 to check if the users have the necessary roles assigned.
Use transaction PFCG to check if the roles are properly generated.
Use transaction LTR to start the Configuration and Monitoring Dashboard.

Use transaction IUUC_REPL_CONTENT to set up the transformation.

Use the SAP HANA Studio to trigger the replication of a table.

Task 2:  Replication of table after structure change

Go on folder IUUC REPL TABSTG
Push the “PLUS” button.
On the new row of the list push the button “Edit Table Structure”
Push the “PLUS” button
Field Name xxxx
Data Type xxxx
Length xxxx
Push the button “Update Position”
Push the button “OK”

On SAP HANA trigger the replication for table T005N

Solution:

Task 1:

1. Check if the users have the proper roles assigned (transaction SU01)

Check if your user xxxx has the role SAP_IUUC_REMOTE.
Check if the user SLTREPUSER has the role SAP_IUUC_REPL_REMOTE

Check if both of the roles are properly generated Transaction PFCG

2. Create a new configuration by using the following parameters:

Parameter                                       Values
Transaction                                      LTR
Schema Name                                 xxxx
Number of Replay Jobs                   03
Connection to Source System         SAP
RFC Destination                              xxxx
Username                                       SYSTEM
Password                                         xxxx
Hostname                                       xxxx

Instance                                         00

3. Click on xxxx in the WebDynpro to display the details of the new configuration. Go to label Settings and set the number of jobs for initial load to 2

4. Please add the following roles for your user in SAP HANA Studio
<Replication Schema >_DATA_PROV
<Replication Schema >_POWER_USER
<Replication Schema >_SELECT_USER
<Replication Schema >_USER_ADMIN

5. Check the loading status of DD02L and DD02T in HANA in the new schema
→ Tables in schema xxxx are in replication mode
On SAP HANA Studio –>Window –>-Open Perspective->-Modeler–> choose Data Provisioning

Preview the data of these tables in HANA → Tables should contain data

a) Schema xxxx –>right click on table DD02L –> Open content

6. Start the replication for table T005N
a) On Data Provisioning – Push the button “Replicate” – Select table T005N
Add the table to the right side –> Push the button “Finish”

7. Delete the configuration
a) Transaction LTR –> button “delete”

8. Create a new configuration by using the following parameters:

Parameter                                       Values
Transaction                                      LTR
Schema Name                                 xxxx
Number of Replay Jobs                   03
Connection to Source System         SAP
RFC Destination                              xxxx

Allow Multiple                                Usage leave it empty
Read from Single client                  tick it
Username                                       SYSTEM
Password                                         xxxx
Hostname                                       xxxx

Instance                                           00

9. Set up a transformation in order to add one field at the table T005N on SAP HANA and to fill it with the SID of the sender system
a) On SLT system: Transaction IUUC_REPL_CONTENT Select the configuration and push the button “Select Configuration”

Add the table T005N – select it – push the button “Edit Settings for Selected Tables

Task 2:
Go on folder IUUC REPL TABSTG

Push the “PLUS” button.
On the new row of the list push the button “Edit Table Structure”
Push the “PLUS” button
Field Name xxxx
Data Type xxxx
Length xxxx
Push the button “Update Position”
Push the button “OK”

On SAP HANA trigger the replication for table T005N