Skip to Content
author's profile photo Former Member
0
Former Member

Using BODS to extract deltas from an ECC LIS datasource

Posted on Aug 12, 2016 at 01:15 PM 256 Views

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2016 at 04:49 PM
    4

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Aug 23, 2016 at 12:08 PM

      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.

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2016 at 02:41 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 12, 2016 at 03:17 PM

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.