Can we use ODP extractor from ECC for two delta target in BODS

[former_member383304]

I am using SAP ECC ODP extractor in BODS for delta load for one of the project which has scheduled on every Sunday night, now i got new requirement to pull the delta data from the same extractor on every Friday night, is it possible to pull the delta data at two different Projects at different time without losing any delta data?

[former_member187605 · Accepted solution]

Yes, of course. RT*M.

https://help.sap.com/viewer/df959412681b4619a38f03ff90207e6b/4.2.11/en-US/577669b06d6d1014b3fc9283b0...:

"

For each consumer that you create, you have the option of creating several independent subscriptions. For example, you might want to access the same DataSource in full or changed-data capture (delta) mode with different selection criteria. Therefore, enter a unique project name for Name of project to identify the applicable subscription. Example For the Name of consumer , “Data Services” and for the Name of project , “Extraction for Data Warehouse 1”, you create initial (full) and CDC data flows for a customer dimension table. Both data flows use the same instance (subscription) of the ODP source.

Then, for a second project that loads another data warehouse, import the same ODP source a second time. Use the same consumer name of “Data Services”, but use a different project such as “Extraction for Data Warehouse 2” so that the two subscriptions are independent.

"

[former_member383304]

Thanks Dirk for reply!

I have already given two different Project name for both projects, however i can't see any name of these project in TCODE ODQMON to identify which request belong to which project, kindly see below two entries from two projects where i have loaded delta load for their respective projects.

[former_member187605]

You specify the project when importing the ODP object:

[former_member383304]

Thanks a lot Dirk,

The above solution is working fine for my Project, I have one query how to identify the request in ODQMON which request belong to which project. There is no option where i can see the name of the project in the ODQMON.

Please help!