Originally posted by: cemeinz

Hello!

Maybe someone has some knowledge of the following issue.

We want to load about 20 Gigs of data into the SAP BW. This amount of data should be loaded into SAP during every night. The IBM WebSphere Transformation Extender Pack for SAP R/3 V8.2 is installed and gives us especially two options to do this:

BAPI Adapter
BW Staging BAPI

Which is the best way to do this? Which of the above mentioned components fits our needs best?

I know, it is an open question, do not hesitate to ask for more details, which will be delivered asap.

Thanks in advance.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: thorstenhirsch

Don't know about the adapter (we use our own adapter), but you might need both of them. With the bapi importer you can build a typetree that is needed to communicate with the correct data structure. It creates a typetree for you.
And the bapi adapter is needed so that the mapping engine can communicate with the bapi at runtime at all.

So basically speaking, you need to do the following steps:

1. import bapi structure => typetree
2. create mapping
3. use the typetree for some output card
4. configure this output card to use the bapi adapter

However, you might need some more advanced techniques for 20 gigs. You should split your data into packets of about 50.000 or 100.000 data sets in a seperate map and then call the map that transfers the data to the bapi for each of the packets. You need to enumerate the packets and tag the last packet with LASTPACKET="X".

If you haven't read the bapi documentation, here it is: http://www.sap.com/turkey/partners/icc/scenarios/pdf/bw_sta_12.pdf (that's version 1.2, there's also a version 2.0)

Look for TD_T_SEND (transactional data) or MD_T_SEND (master data).
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender