SLT ODP – Real-Time Data Replication from SAP source to BW (ADSO)

[former_member364613]

Hi All,

In this blog we are going to discuss how to replicate real-time data from SAP Source --> BW ( ADSO ) via SAP ODP Framework.

Below are my system configuration:

ECC system: ERP 6.0
SLT Replication server:  SLT 2.0 (DMIS 2011_1_731 SP13)
BW system : BW 7.5 SP 5

What is ODP Framework?

ODP supports extraction and replication of data to several Target systems and support delta queue mechanism in real-time mode. The Target system receives the data from delta queue and continue the data processing.

In my scenario, I have implemented replication on EKKO table from SAP ECC to BW (ADSO) via SLT-ODP replication server.

Step-by-step guide to replicate real-time data from SAP ECC     --> SLT Replication Server --> BW ( ADSO )

1. Firstly in SLT server, goto LTRC tcode and make sure Basis team configure the connection in SLT server.

2. Also make sure the Source and Target systems are correct in the configuration.

Source: ECC

Target: ODP



3. Make sure Basis team created Sourcesystem in BW.

Goto RSA1 -> Sourcesystems-> ODP –SLT Queue.



4. Goto DataSources -> Select the SLT sourcesystem-> Rightclick and click Create DataSource.



5. In this scenario, we are creating DataSource for table EKKO.



6. Give the Descriptions and Activate the DataSource.



7. Make sure all the Fields from Table EKKO are present in DataSource.



 

8. Developing ADSO in Hana Studio :

Goto HanaStudio -> Windows -> Perspective -> other Perspective-> Others -> select BW Modeling.

Goto Infoarea  -> Rightclick on DataStoreObject (Advance) and create New ADSO.

 



9. Give all the Information to create ADSO and Click on Finish.



10 Select the required fields. If some of the objects are not needed in ADSO and click on Delete.



 

11. Activate the ADSO.



12. In BW, the newly created ADSO will be shown under respective Infoarea.



13. Create Transformation for ADSO – ZEKKO_A01



14. Make sure all the required field mapping are done and Activate the Transformation.



15. Create a new DTP and Activate.



16. Always the First/Initial Dataload is checked as Delta Init. And then the next loads will be deltas.



17. Once the Data loaded successfully. Click on Manage and Click on Activate button to activate the Data. Activation will be very quick and you can see Activation request. 

 

18. After you start dataload, you can goto SLT server ( LTRC ) and click on the connection to check if the replication job is running for EKKO table.



19. After starting the DTP to load data into ADSO, you can see the replication job just started.

Here you can see the logging table & Triggers will be active to capture the Delta changes on EKKO table.





20. Also In Tcode – ODQMON, you can see how many records are replicated into SLT server from ECC – EKKO table.

Testing the Real-Time replication:

21. For testing purpose, Now Iam going to change a Purchase order in ECC via ME22N tcode, this will change the entry in EKKO table.

Before Making the change in ECC



After Making the change in ECC , the Purc.Grp is changed from 125 -> 124 in EKKO table.



22. Now Goto SLT server -> ODQMON tcode.

Here you can see the changed record will be updated in the Delta Queue.

Record type : C ( New record)

Record type : U (Updated Rec)



23. Execute the DTP again and you can see 1 record loaded which is updated in ECC. Activate the ADSO



24. In ADSO, the Purch Grp is updated to 124.



 

Process Chain In Real-Time Mode:

25. Create ProcessChain in RSPC.

1)     Start Variant

2)     DTP Load

3)     Activation of ADSO

 Activate the Processchain.



26. Start Variant -> immediate schedule and SAVE.



27. Click on the “Streaming” and check “Process Chain Run in Streaming Mode”.



28. Activate the Processchain & execute.

Now you can see the Streaming is “Green” and it will automatically run the processchain whenever there is a change in EKKO table



29. Now the Processchain is ready to run in Real-time mode.



After the streaming mode is Active in BW Processchain.

Make sure the below Job is Actively running in SM37 for every 15 mins in SLT server.

JobName: ODQ_DAEMON_CLIENT_100  

This Job will send an event to trigger the Processchain automatically when there is change in the SLT delta queue for particular table.



 

After all the above steps are done, the data will be loaded to ADSO automatically by processchain in real-time.