Geek Answers Handbook

How to extract data from the SAP ABAP system?

I need to extract data from an SAP ABAP system in a format that can then be loaded into an Oracle database (xlsx, csv, dmp, etc.)

Once the data is retrieved, I will use Pentaho to load it into the Oracle database.

Is there a way to extract data from SAP? I will also need to automate it (extraction), but right now this is not too big a problem, I can think about it later.

If this is not possible, explain why it would be useful!

+5
source share
3 answers

You have several options for this.

If you use SAP BW, there are many standard tools available to help you perform extraction and automate processes.

ABAP ( 1), .

(RFC) SAP RFC.

RFC - SOAP/HTTP.

, , script, .

- :

report ZEXTRACT_EXAMPLE.

data: lt_t001 type table of t001.
data: ls_t001 type t001.
data: lv_filename type string value '/tmp/outfile.txt'.

select * from t001 into table lt_t001.

open dataset lv_filename for output in text mode encoding default.

loop at lt_t001 into ls_t001.
  transfer ls_t001-bukrs to lv_filename.
endloop.

close dataset lv_filename.

, . ( ) /tmp/outfile.txt , . ( ).

SM36 .

+6

"RFC_READ_TABLE", , , .

+2

- JDBC SAP ERP, , SAP.

JDBC, Pentaho.

JDBC SAP ERP- Talend, .

RFC_READ_TABLE, , , , .

-1

More articles:


All Articles