cancel
Showing results for 
Search instead for 
Did you mean: 

How to achieve 1:N replication with SAP SLT?

seasonfan
Explorer
0 Kudos

Hi Everyone,

In our system we need to set up 1:N replication through SLT from our S4/HANA to another HANA database.

There is only one source S4/HANA system (S), but 2 target HANA databases (A and B). And in these target systems, we want the tables reside in schemas with same name: schema S4_PCDW in A and S4_PCDW in B.

Do we need to have two SLT installation to replicate to the two targets separately?

Or shall we achieve this 1:N replication with a single SLT? If one SLT is enough, could the target schemas have the same name?

And do we need to have two RFC set up on the source S4/HANA system?

Please share your opinions, many thanks in advance.

Accepted Solutions (0)

Answers (3)

Answers (3)

sherryharminder
Participant
0 Kudos

you can achieve it by creating connection with allow multiple usage, that will let you use the same logging table on the source.

sherryharminder
Participant
0 Kudos

you can achieve it by creating connection with allow multiple usage, that will let you use the same logging table on the source.

Cocquerel
Active Contributor
0 Kudos

Hello,

One SLT server is enough.

The target schema name is corresponding to the SLT configuration name. So, to have the same schema name on the 2 targets, create the 2 configurations with the same name (S4_PCDW).

You may use the same RFC but I would recommend to use dedicated RFC for each configuration with different users. Indeed, in case of dumps in the source system, it makes easier to identify the configuration causing the issue.

To allow "1:N" replication, you have to check the box "Allow Multiple Usage"

Regards,

Michael