Skip to Content

N:1 replication from multiple ERP source systems on different EHP levels

Hello,

The situation is that the customer has multiple ERP systems on different EHP levels. Therefore, in newer EHP systems, some tables will have different structure (additional columns). The intention is to setup N:1 replication into one target DB schema

Would this be possible to support/setup in SLT ? How would the different table structure be handled?

Thanks and best regards,

Cosmin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 06, 2014 at 07:54 AM

    Hi Cosmin,

    I think this can be achieved. First of all you have to investigate which structures are available for the different releases. At the and the target structure has to consist of all available fields with the same name.

    Before oyu start with the replication you have to specify the same target structure for all configuration.

    What SLT is doing during the mapping from the source structure to the target structure is a "move-corresponding" command. So it is important that the names of the fields are the same. At the end you will have sometimes fields filled, sometimes not (depending if this field is in the source filled).

    Let me know if you need further input.

    Best,

    Tobias


    Add comment
    10|10000 characters needed characters exceeded

  • Nov 05, 2014 at 04:59 PM

    Hi,

    Yes, it is possible to setup N:1 replication into one target Database schema,

    Here is the excellent blog by Tobias, please refer the link below for more info.

    How to setup a N:1 replication

    Add comment
    10|10000 characters needed characters exceeded