ECC Data extraction

[Former Member]

Hello All,

I have a situation in my department where I need to extract the ECC data to third party database (MS SQL). Initially we were thinking of using SAP BW extractors for extraction through SAP PI to push the data out but this doesn't seem to be feasible. Is this a fair assessment of the situation?

What other methods we can use for data extraction? We are evaluating options for ABAP programs, SAP Queries and BAPIs. Is there any other way we can extract this data set. The data set is required for sd,fi-ar/ap,mm,pp.

We donot need data fro real time time basis, but on the same lines of a data warehouse extraction like SAP BW.

Appreciate your help.

Thanks

[Former Member]

hi Shikher,

Everythiing is based on your requirement, you could use BW extractor to bring the data to BW and use open hub to delivery to another MS sql. The pros here is that you could use the BW extractor functionality which is called delta. This is very beneficial since only delta is being delivered to the end system. But again if the requirement is one time, then I would go with other options like SAP query or some ABAP program.

thanks.

Wond