Skip to Content
avatar image
Former Member

Best way to read data from SAP ECC.

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jul 03, 2015 at 01:09 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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,

      .

  • avatar image
    Former Member
    Jul 02, 2015 at 08:55 PM

    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 :

    SAP BODS - SAP ECC Connection Setup & Datastore Creation in Data Services

    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.


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2015 at 03:52 PM

    Thanks all for your suggestions.


    Add comment
    10|10000 characters needed characters exceeded