Comparison of File and IDOC Adapters in case of huge amount of data

[santosh_k3]

Hi all,

I have scenario where i need to send around 40,000 Customer records from R/3 to Third party using XI

If i send this data using IDOC adapter, all the IDOCs at once is there any performance issue

or it would be better to use File Adapter.

can any one suggest which would be the better option.

thanks in advance.

thanks

sai.

[Former Member · Accepted solution]

hi

I think file adapter is more fast than idoc adapter.

so, idoc has own protcol and has a lot of structure (almost you don't use.)

you can design file structure freely in file adapter.

if you can use file adapter in pi 7.11, you can use Advanced Adapter Engine.

(idoc adapter is out of Advanced Adapter Engine)

AAE is much fast !

Naoki

[rajasekhar_reddy14]

it depends ion how you send data to PI from ECC any processing 40k IDoc's as a single message not a good design.

see my replay to other thread what you have posted

[baskar_gopalakrishnan2]

I dont know what version pI you are using...

Pi 7.1 gives optimum performance when the message size is upto 5mb.

Though IDOC is slightly overhead in comparing with FIle, still we need to evaluate size of the data too.

Recommendation:

a) For idoc design: You can do multimapping sending idocs few at a time or idoc packaging ... if that is feasible.

b) For file design: You can use fcc flat file structure and use recordset per message parameter to control the flow from sap to third party by specifying say 25 records or so per message. In this way if the message size is even big, we can just change the configuration parameters and no need to change the design objects.

I would recommend file in your case considering 40000 records than IDOC.

Note: If you are looking for idoc design with some good design ways to improve performance please refer michal blog related to idoc.

Refer this [link|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/14425] [original link is broken] [original link is broken] [original link is broken];

If your version is pi 7.1 then refer this [link2 |http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17573] [original link is broken] [original link is broken] [original link is broken];for idoc packaging

For FCC refer SDN for sap help link and this [link3|http://www.riyaz.net/blog/xipi-file-content-conversion-for-complex-structures/technology/sap/79/]

Hope that helps.