cancel
Showing results for 
Search instead for 
Did you mean: 

Best way to read data from SAP ECC.

former_member187310
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member187605
Active Contributor
0 Kudos

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.

severin_thelen
Contributor
0 Kudos

In addition, but maybe not the best way, you could connect to the database instead of ECC. Then you could read tables like in every other relational database.

I personal would only do would this, if you are reading data.

Regards

Severin

Former Member
0 Kudos

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.

0 Kudos

Hi Dirk,


Currently we are working on SAP table extraction into Flat File and we would like to know the  steps for configuring CDC in this context.

Please reply us at the earliest.

Thanks  & Regards,

.

Answers (2)

Answers (2)

former_member187310
Participant
0 Kudos

Thanks all for your suggestions.


Former Member
0 Kudos

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.