Using SAP Extractors in the Data Flow

[Former Member]

Hi DS Experts,

I am Planning to Use SAP Extractors in the Data flow of the Data services and I have some questions about this option.

1. if we include SAP Extractor in the normal data flow, will the Extracted data first writes to Temporary file in Shared directory  like ABAP flow or it directly  writes to the  target in the Data Flow Packet by  Packet

2. If I want to transfer 2 million rows from an SAP ECC table(RSEG)  which approach is recommended

  a.  ABAP Data flow.

  b. Using SAP Extractor ( Custom Extractor on RSEG table )in the Normal Data flow.

  c. Using Direct Connection ( Underlying Database.)

Thanks

Bhnau

[Former Member · Accepted solution]

Hi Bhanu,

Below link would help you understand the usage of extractors:

http://wiki.sdn.sap.com/wiki/display/EIM/Using+Extractors+as+Source+%28Data+Services+4.0%29

And when you use extractors, there is no abap flow required. You can simply import the extractor and map it to target table.

On which method to go for, using abap flow or extractor - performance would not differ much. Honestly speaking, i did not understand what do you mean by "Using Direct Connection ( Underlying Database.)".

Thanks, Arun J.

[tomas_jahn]

Hi Bhanu,

for your second point this page gives a good overview of the different ways to connect to SAP ECC:

http://wiki.sdn.sap.com/wiki/display/EIM/Overview+SAP+Interfaces

I guess by "Using Direct Connection" you mean importing the table directly to DS. Even though it is the easiest way I would not recommend this for big data.

But It really depends on your requirements, which way is the best to connect to your SAP system.

Thanks! Tomas

[Former Member]

may i know , why it is not recommended using direct Connection( Underlying Database)

[Former Member]

This link should help you.

http://wiki.sdn.sap.com/wiki/display/EIM/Reading+via+ABAP

Arun