Extraction process

[Former Member]

If you had to explain the extraction process say from R3 to an IT Manager, how would you do this simply to include a level of technicality? Thanks

[Former Member · Accepted solution]

Hello Niten,

You can touch on few points like:

1>Possible Source sytems involved: Flat files, R/3, XML, Legacy applications, Applications like People soft etc.

2> Extractors: Standard extractors for R/3, Procedure of XML extraction, Tools like DBconnect for databases like SQL, Oracle, tools like Ascential datastage for applications like peoplesoft etc.

3>Steps involved in extraction, terminologies like datasource, Update modes, Record modes, Infosources, Transfer Rules, Update rules, PSA, Master data, Data targets like Cubes, ODS, difference between them.

4>Different scenarios with examples. Granularity of data, History of data to be covered, Application components within R/3 those are involved and the respective approaches for the same. for eg: LO for logistics, Co-pa, FI-SL, Generic extractions.

5> Features like Monitoring, Scheduling of data loads.

Hope this helps..

thanks,

[Former Member]

Niten

First you need to explain different types of extraction methods like

LO Extraction

LIS Extraction

CO-PA Extraction

FI-SL Extraction and

Third party Stystems

Depends on your question you explain in detail of each extraction for example LO extraction please see the step by step method in Weblogs

/people/sap.user72/blog/2004/12/23/logistic-cockpit-delta-mechanism--episode-two-v3-update-when-some-problems-can-occur

/people/sap.user72/blog/2005/01/19/logistic-cockpit-delta-mechanism--episode-three-the-new-update-methods

/people/sap.user72/blog/2005/02/14/logistic-cockpit--when-you-need-more--first-option-enhance-it

/people/sap.user72/blog/2005/04/19/logistic-cockpit-a-new-deal-overshadowed-by-the-old-fashioned-lis

Hope this helps

Thnaks

sat

[Former Member]

Thanks for that. I am aware of the postings, I have a meeting with an IT Business Manager who would like to know just specifically a general description of the extraction process