Setting Extractor Option "Initial Load" from Parameter

[uwe_grensing]

Hello,

I'm using an extractor in ECC to feed data via CPI-DS to IBP. In the definition of the data flow, I can set via the "extractor options" if the extractor should do an initial load or not.

Is there a way to influence this option via a parameter or do I always have to copy my task in order to differentiate between Initial Load or not?

Best Regards

Uwe

[jeffrey_kresse · Accepted solution]

You use initial load to establish a delta initialization point, then in the future switch to initial load = no in order to get just the delta data. If you don't care about delta for that extractor, there is no need to change the setting away from initial load = yes.

[uwe_grensing · Accepted solution]

Hello Jeff,

In a productive environment, switching from Initial to Delta would then require to re-promote the task after the change. In order to avoid that maintenance effort, I use a copy of the task from the start - especially since there might be unforeseen cases where you might want to re-run an init run at a later time (for whatever reason). But now you need to make sure, the copy stays in sync once somebody changes something in the task.

So if this could be influenced by a parameter, it would simplify maintenance a lot. If somebody confirms that it doesn't exist, I will open an enhancement request.

Best Regards

Uwe Grensing

[jeffrey_kresse · Accepted solution]

In Data Services we have the function sap_extractor_delta_initialize, this is not documented for CPI-DS so no guarantee it will work.

Otherwise you may consider alternate methods of getting the delta: https://help.sap.com/viewer/dab65b1584e04026a132a06a711e3f5a/Cloud/en-US/d4f0cefcb7834676997ee5ffe81...

To my knowledge there is no single variable that influences delta/full load. I agree with you, it would be a nice enhancement to the product.

[uwe_grensing]

Hello Nazeer,

In the configuration tab for the Extractor Options, I can only put "Yes" or "No" - I can't put a variable there. Is there a fixed variable name?

Best Regards

Uwe Grensing

[former_member423067]

Hello Uwe,

You can set a Global Variable and pass a parameter as "Y" for Initial Load and "N" Delta load.

with regards,

Nazeer