Skip to Content

Push the data from one BW Datastore object to another BW Datastore Object

Hi Team,

1. We have two BW system A and B. We have to push all the records from one datastore object to another BW DataStoreObject(A system to B system).

How can I do this?

2. Could you please help me how to achieve above steps by automate.

Ex. whenever a recorded added to A system and same has to be update to B system as well.

Thanks in advacne!!

Regards,

Siva M

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 11, 2018 at 07:22 AM

    Hi Siva,

    Hope you are done with developments in both source and target BW systems. If not, follow the below steps.

    1. Create source DSO in source BW system and target DSO in target BW system.

    2. Create RFC between both BW system with the help of BASIS team.

    3. Replicate the export data source (8*source DSO) into the target system and create the transformation from this data source to target DSO in the target BW system.

    4. Create a process chain in the target BW system for target DSO data loading and make a note of the process chain technical name.

    5. You might have already create process chain for source DSO loading. At the end of the source DSO loading, create "Remote Process Chain" process type and give the technical name of the process chain created in the target BW system and also the target BW system details here.

    Regards,

    Satya.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 10, 2018 at 05:58 AM

    Hi Siva,

    You can try Event trigger OR Remote Trigger option using process chain.

    1> Schedule process chain in source system A for the DSO.

    2> At the end of process chain add event based trigger for system B.

    3> Using above event schedule process chain in system B for the dependent DSO.

    Please refer these blogs written by Marcelo Berger,

    https://blogs.sap.com/2015/04/17/triggering-remote-process-chains-from-ecc/

    https://blogs.sap.com/2015/04/01/triggering-bw-process-chains-from-ecc/

    You can choose either approach as mentioned in above blogs in detail.

    Hope it helps!

    Thanks,

    Bhavin Vyas

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 09, 2018 at 03:41 PM

    Hi Siva,

    check out the Data Mart Interface and if Export DataSource would help for your requirement:

    Data Mart Interface between Several Systems

    Cheers,

    Nora

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 10, 2018 at 03:07 PM

    Hi,

    You can use REMOTE PROCESS CHAIN. That is the easiest way.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded