Bulk data transfer using SOAP Vs JDBC/File

[Former Member]

Hi All,

We have a requirement wherein bulk data needs to be transferred in an Asynch manner between ECC 6.0 and Legacy system.

The legacy system supports both File and SQL Server database to store data.

If this data needs to be transfered to and fro with ECC what is a good approcah:

1) Use the File Adapter to read/write the data.

2) Use the JDBC Adapter to read/write the data.

3) Build a SOAP Service on the Legacy System and the use the SOAP Adapter. Not sure if SOAP is recommended for bulk data transfer

Please suggest keeping in mind that the amount of data transfer is huge.

regards,

Piyush

Edited by: Piyush Mathur SAP on Oct 26, 2009 9:36 AM

[former_member187339]

Hi Piyush,

ECC Side I will propose ABAP Proxies

and Legacy side the preference will be Java proxies.

As far as the adapters which you have mentioned i will say:

1. SOAP Adapter (Is there a url where some service is waiting to get this response?)

2. File Adapter

3. JDBC Adapter

Regards

Suraj

[Former Member]

Hi Suraj,

Thanks for the quick response.

I understand that proxy is preferred and we will be definitely using ABAP proxies on the SAP Side.

As far the interface on the legacy side, we can request the team to buld a SOAP Service layer over the existing File/SQL Server. It woule be an Asynch serviice as mentioned in my question.

regards,

Piyush

[Former Member]

Piyush ,

SAP side Proxies are best while at receiver side I would have gone for File/JDBC .

Regards ,

[rajasekhar_reddy14]

Hi,

My Advice is to go for File Adapter,But if you want to prosess bulk data try to split the data at source level,File adapter provind some standard options to read the data single record , number of records depeds on your requirement.

If you want to process 10mb files at a time then think about the design,PI will support to process the messages but there is chances to JAVA stack.

Recorset per message option really helpfull in file adapter.

Regards,

Raj

[Former Member]

Hi All,

Is the SOAP Adapter not recommended for Bulk data transfer at all ?

regards,

Piyush

[former_member187339]

Hi Piyush,

All adapters in J2EE stack are capable of sending bulk messages provide the memory is available. Before deciding on which adapter to use I would suggest you to read the following notes

Note 862405 - XI Configuration Options for Lowering Memory Requirements

Note 1037176 - XI Runtime: Message Packaging

Note 821267 - FAQ: XI 3.0 / PI 7.0/ PI 7.1 File Adapter (Point 14)

Also java proxy will always be my choice if you look for an adapter less communication

Regards

Suraj

[Former Member]

Hi Suraj,

It does not talk about the perofrmance of SOAP Services for bulk data transfer.

Please suggest.

regards,

Piyush