Solved: Re: Delta Extractor for data extraction from non S...

Former Member · ‎2012 Apr 27

Hello,

I want to write an ABAP program for purpose mentioned above.

Prerequisites :

* I don´t want to use a prepared ETL tool as Informatica or so.

* non-SAP source system has a Oracle database as basis for storage.

* I don´t want to realize that with DSO and change - log in BW because

this always make necassary a full upload to BW.

* extraction should be done via "DB-Connect" or "UDI connect"

and appropriate "Select ... " statements

Questions :

a) What could I use as a metadata info for realizing delta in "select ... " , ex. time

stamp, info about modification ?

b) Where could I extract that metadata info for realizing "Select .." as delta ?

Has anyone experience with realizing such a scenario and could give

me practical advice ?

Thanks in advance for your advice

Regards,

Oskar

ananya_bhattacharya · ‎2012 Apr 27

Please check the following link - there is a detailed documrnt shared

Regards Ananya..

ananya_bhattacharya · ‎2012 Apr 27

Please check the following link - there is a detailed documrnt shared

Regards Ananya..

ananya_bhattacharya · ‎2012 Apr 27

Also,

Regards Ananya..

Former Member · ‎2012 Apr 27

Ananya,

thanks a lot. I think that was what I was looking

for.

Regards,

Oskar

Delta Extractor for data extraction from non SAP systems as ABAP function module