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]

BODS is the SAP recommended toolset to use ECC extractors directly to extract data. You will need to install BODS and setup connectivity using SAP Datasore and import and use the SAP extractors. You can build your job using this extractor to load directly in a DB table like MYSQL DB.