Splitting in JMS Adaptor

[Former Member]

Hi @,

I have a scenario where i have to split an XML file conatining 10000 records into 1000 records per message .Is it possible to do without BPM ?

If not then how to use BPM to split count into 1000 each records?

Thanx to all in advance

[prabhu_s2 · Accepted solution]

yep...it is possible using context handling

[Former Member · Accepted solution]

Hi prabhu,

this means that we ahve to use BPM and then use context handling ,right or something else

Regards,

[prabhu_s2 · Accepted solution]

withut BPM u can acheive this....just play with context in graphical mapping. this shud do

[Former Member · Accepted solution]

hi prabhu,

but how to do this could u please help in this some more

Regards,

[Former Member]

Hi Priya,

Correct me if I am wrong. As per the scenario your source will have an occurance of 1:1 containing 10000 records. Which you have to split into a target message which would be having 1:unbound occurance and should containing multiple 1000 records in it.

In this scenario, we can use the graphical mapping to get it done. For the root element in the target message we would require an UDF to be created using Queue mapping. In the user defined function we need to check the value to 1000 and do the need full.

The second thing should be taken care in this context. We can implement this by using multi mapping without using BPM, if the integration server and the adapter engine is on the same host.

Hope this helps your cause.

Indranil

[Former Member]

Hi Indranil,

Thnx a lot the method suggested seems to be good.Could u provide some more light on the code part or can provide any refenece to help some more in this direction

Regards

[Former Member]

Priya,

While reading you always read 1000 records at a time. Check this document for help on this.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f02d12a7-0201-0010-5780-8bfc7d12...

See in section 3.2 Module configuration table. It says:

Plain2XML xml.recordsetStructure NameA,1,NameB,*,NameC,1

So here for structure A only one record will be there, for B multiple and for C one record.

Instead you put 1000 and read it into XI.

---Satish

[prabhu_s2]

say if ur file contains 5 records do u want to have 5 messages...i.e. 1 record 1 message ? or 5 records in 1 messsage and again 5 records in second message?

Message was edited by:

Prabhu S

[Former Member]

Its like whatever be the number of records i have to break them into multiple messages consisting up of my count like 5 then if it has 13 records then i should get 5,5,3 ( 3 messages ) like this .If it is less than 5 then 1 mesage but if it exceeds tht then each message must contain not more than above mentioned numer