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

[former_member502934]

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

[former_member586947 · Accepted solution]

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.

[bhavinvyas]

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 celoberger

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

[Loed]

Hi,

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

Regards,

Loed

[nora_roch]

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

[former_member502934]

Hi Nora,

Thank you for your response.

Do we have any other option to push the data from source system and not from target?

Regards,

Siva M