Splitting XML

[Former Member]

Hi,

I have this peculiar scenario where i need to split xml file to process in pi,as the source xml file

is too big to process efficiently.

THIRD PARTY XML>PI----->SAP

[former_member200962 · Accepted solution]

THIRD PARTY --XML---->PI------->SAP

use multi-mapping for RFC....for IDOC you can change the occurence of the IDOC and then generate the idoc based on some condition...like split the file at every 100 records

[Former Member · Accepted solution]

Thanks for ur valued input.

but i need to split the xml file before PI recieves the file

[former_member200962 · Accepted solution]

then you need to tell what protocol you would be using (FILE/ JMS etc).

If File, then there is an option available in the channel for PI7.11....i remember seeing that in a blog...will post if i get hold of it.

[Former Member · Accepted solution]

Hi,

You can think of the below approach.

Since it is an XML file, you can create a similar structure on the source side. Map it again to the same structure on the target side but split it based on each node.

Now, you would have a structure, where the parent nodes are split as messages. For this, you have to change the occurences of the target structure and use enhanced interface determination.

Then, create a JMS receiver channel to read each split message and map it to the Idoc.

This can be done in two mapping steps:

1st mapping: XML File -- > JMS split message

2nd mapping: JMS split message -- > IDOC

Thank you.

Regards,

Subbu

[Former Member · Accepted solution]

Thanks A lot Subbu it would be very helpful for me if u can elaborte step by step.