Which stage is better for SAP data extraction: ABAP or BAPI

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
gordonxiao
Participant
Posts: 18
Joined: Sun Sep 12, 2004 9:19 am

Which stage is better for SAP data extraction: ABAP or BAPI

Post by gordonxiao »

Hi All,

I am using the DataStage Extract Pack for SAP R/3. I know from the help document of this pack that there are at least two methods to extract data from SAP: one is ABAP stage, the other is BAPI stage.

I have tested BAPI stage and it works fine. But the performance is not so good. I tested ABAP stage but it didn't work (see my last post). I don't know whose performance is better, ABAP stage or BAPI stage.

If you have any experience on this, please kindly give me some ideas.

Thanks,
Gordon
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

ABAP is simple and straight-forward.

BAPI involves SAP side knowledge and development.
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Apart from that, if you use ABAP stage I believe you can easily pass the job paramaters and debugging the code is also lot transparent.
gordonxiao
Participant
Posts: 18
Joined: Sun Sep 12, 2004 9:19 am

Post by gordonxiao »

vinaymanchinila wrote:Apart from that, if you use ABAP stage I believe you can easily pass the job paramaters and debugging the code is also lot transparent.
Thank you. Your post reminds me another problem, that is how to pass table parameters to BAPI RFC? Can I still use a input file? If yes, what's the proper format for the table parameter in this input file?

Best Regards,
Gordon
gordonxiao
Participant
Posts: 18
Joined: Sun Sep 12, 2004 9:19 am

Post by gordonxiao »

Sainath.Srinivasan wrote:ABAP is simple and straight-forward.

BAPI involves SAP side knowledge and development.
Thank you, but our customer is more concerned with the performance of these two stages. Which one do you think is more faster than another?

Best Regards,
Gordon
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

ABAP must be faster.
Post Reply