Extraction from legacy system

[Former Member]

Hello Gurus,

My client wants me to load data from mainframe system to BW in near real time. They want me to use some ETL tool like Datastage, Infomatica... for doing that. Since I will have to use staging BAPI for doing extraction, I will have to handle delta at ODS object level( If I am not wrong only service API support queue delta extraction). But is delta handling at ODS object level effective in a near real time scenario?

I do not have any prior experience in staging BAPI.

If I use staging BAPI for data loading, will I have to write

function module for each info-object that I define Or are they already built in to staging BAPI?

Any help will be appreciated.

Thanks

Anand

[Former Member]

Hi Anand,

As far as my knowledge Datastage is better option as it is well supported by SAP BW for your case. I don't think you would need to write any BAPIs. You would only do the mapping. I have not worked on Datastage so I cannot be totally right here. May be have a look at the Ascential site. Also look at this document:

http://ibm.ascential.com/litlib/files.html/download/360

Bye

Dinesh

[Former Member]

Hi Dinesh,

Thanks for your reply.

But can you clarify this portion.

Since I will have to use staging BAPI for doing extraction, I will have to handle delta at ODS object level( If I am not wrong only service API support queue delta extraction). But is delta handling at ODS object level effective in a near real time scenario?

Regards

Anand