on 07-02-2015 8:21 PM
Hi,
Wanted to know the best possible method to pull data from ECC in below scenarios using DS 4.*
Volume of Data
a. Huge
b. Medium
c. Small
Thx,
Debasree
The best possible method is not necessarily related to data volume but rather determined by functionality.
1/. When extracting from a single table, do that in a normal data flow. Note that there is a volume impact here: SAP installations have a time-out set for RFC calls (system-configurable typically 10, 30, 60 minutes); when data extraction takes longer than this limit, the DS job will fail. In that case, use an ABAP data flow.
2/. When extracting from a join of tables, also use an ABAP data flow. Although where-conditions are pushed down to the underlying database from a normal data flow, the joins are not, leading to abominable performance.
3/. If Business Content Extractors are being used in your environment, you can leverage them in DS for initial and incremental load. Use them in a normal data flow when used as such, in an ABAP data flow with additional where-conditions.
4/. You can use existing ECC functions returning tables as data flow sources, as well.
5/. And you can use the IDOC functionality if you're familiar with that technology.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Adding few more to Dirk's suggestions,
Reg Point # 1 , /. When extracting from a single table, do that in a normal data flow. Note that there is a volume impact here: SAP installations have a time-out set for RFC calls (system-configurable typically 10, 30, 60 minutes); when data extraction takes longer than this limit, the DS job will fail. In that case, use an ABAP data flow.
Yes the extraction job will fail on 10,30 or 60 mins when its triggered via front end processing and if we made the setting as " Execute in Background " this time out error on the shorter duration can be avoided.
Thanks
Arun.
Thanks all for your suggestions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you are dealing with small set of data then direct mapping from SAP ECC table to oracle table is best way.
(to set up the datastore connection :
If you are dealing with medium or high data then I would suggest you to go to ABAP dataflows.
Agian in ABAP dataflows there are various transfer methods.
You can check the detail information at below link:
http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_sap_en.pdf
go to page no.83 onwards there you will find information.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.