Using BODS to extract deltas from an ECC LIS datasource

[Former Member]

Hello,

We are trying to use BODS to extract deltas from 2LIS_03_BF. When we run the extraction all we seem to get is the data in the setup tables.

I've read some on using ODP and CDC but am a little confused. In BODS the data store object has an Extraction Method of TRAN. We are clear on how to specify the extractor as a CDC extractor or where this must be done.

Are we off base on the interpretation of this and how it works? Can we use BODS to extract deltas using a LIS extractor?

Any comments or recommendations would be appreciated.

Thank you.

[Former Member · Accepted solution]

Hi Richard

You can definitely use ODP with LIS extractor to fetch delta to BODS.

Delta queue for BODS can be accessed in ECC/R3 using tcode ODQMON.

You can set up a Job to update ODQMON with new records and then subscribe using BODS. I am not sure about the configuration in BODS but i have come across  this service in my project and my client is using various LIS extractor to fetch delta records to BODS using ODP. SO this is very much possible.

[Former Member · Accepted solution]

Hi Nayab,

Do you have any doc or link to look about this functionality?

Regards.

[Former Member · Accepted solution]

Hi Nayab,

Thank you is there documentation on this? It sounds like BODS is using a different delta queue and the delta transactions need to be copied (batch job) to the ODP queue?

Thanks again,

Rick

[Former Member · Accepted solution]

Yes right BODS will use a different delta queue..Tcode ODQMON.

Just as we set up V3 jobs for moving transactions from LBWQ to RSA7 for BW, we need a batch job to update ODQMON also.

i will check if there is any POC available with me.

[Former Member]

Hello Richard,

Please tell me if I'm wrong but since you are posting in BW blog I assume your system target it's BW; it this is the case, Is there any particular reason you don't have a direct RFC connection between BW an ECC? I mean, there is no need to have BODS between BW and ECC.

About your question

Can we use BODS to extract deltas using a LIS extractor? 

I'm not sure if BODS can be connected to ECC extraction structures from where BW gets the data, however you can test it.

Inside each Datasource in ECC an extraction structure is created, IF BODS can reach those structures the only thing you need to solve is get the data and somehow garantee that ECC  knows that DELTA has been send to datatarget. (sounds a little complicated).

can you share what's your actual scenario so we can have some other ideas?

Regards

[Former Member]

Hi Gonzalo,

Thank you for the response. The answer is complicated but the net is to replace the 'normal' RFC connection method with BODS as the mechanism. It is also a POC to determine if it is even feasible to use BODS as a delta extractor.

The BODS datastore or connection from ECC is an ODP datasource and there is an option for CDC or Changed-Data Capture when using BODS as the method. But there does not seem to be a cookbook for its implementation.

Thanks again,

Rick