How to automate selective deletion after successful transfer of data from the info provider

[sengupta13_amartya30]

Hi Guys,

Problem Statement : Let say we wanted to move selective sap bw data to any external data storage. So after successful transfer now that same data remain in our HANA memory too, so how can we delete that particular data. I know about selective deletion but is there any way to make it automatic, meaning if data move successfully to data storage then data in BW(InfoProvider) will delete automatically and if it fails then it will do nothing.

Thank you in advance.

[andrewdiaz2000]

Hi sengupta13_amartya30,

You can delete the requests in ADSO using a program, and upon successful load trigger this program.

Below blog would be very help full for you as it has sample program.

Delete requests from Advanced DSO (ADSO) | SAP Blogs

Regards,

Andrew

[sengupta13_amartya30]

Hi andrew.diaz ,

Thank you for your answer, I even thought of this but the main problem that I am facing is how to know whether my data is moved successfully or not. Can you please give some light to this, i.e. how to know about the successful load?

Regards,

Jishu

[MKreitlein]

Hello Jishu,

one option, which would not fit your needs by 100% but comes near would be the process chain variant "Delete Overlapping Requests from DataStore Object (advanced)":

With that you can load a DTP into the aDSO, then extract the data from new table (or from w/o aDSO) to your external data storage ... and with the next process chain run, this old request is removed when the next load with the same DTP was successful.

The only difficulty is the missing relation between DSO load and data extraction.

If your extraction fails, but the process chain runs the next time, it will delete the old and update the new request anyway.

But this solution comes out of the box 🙂

BR, Martin

[sengupta13_amartya30]

Hello Martin,

Thanks for answering my question I will try to do this.

Regards,

Jishu

[andrewdiaz2000]

Hi sengupta13_amartya30,

You need to give little more detail . I Understand the source is ADSO but what is your Target, is it in SAP Platform or External data source. If within BW then we just create Transformation, but if its external what is the method your using. If its any external Source also there will be a Acknowledgement, when the process is complete.

See if you can give more details to give it a taught.

Thank you .

[sengupta13_amartya30]

Hi andrew.diaz,

Actually we are trying to move our data from a adso to hadoop using SDI, the problem we are facing is that after successful transfer of data we want to delete that data from our bw system automatically. So how to acheive it?

Hope now you can understand our use case now.

Thank you