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]

I am facing a similar problem - had the theory to somehow make use of the extractors in ECC so that the 3rd party MSSQL-based data warehouse could then connect to them to pull the data. I've heard that might be challenging because there are BLOB columns that I'd assume we would not be able to work with.

I posted this as well -