** Is it possible to create nested XML structure when JDBC is sender ?

[jegathees_waran]

Hi Friends,

We want to upload material master data from Oracle table to SAP. For that, we have written a stored procedure it querys 3 tables and return resultset . Suppose for one item, it will contain 2 line item in subsequent table, oracle will return 2 records (for the same item). (Flat Structure)

To handle this, is it possible to modify the FLAT structure XML to nested structure XML (Header, Item) in the source side. JDBC sender channel will support this ...?

Kindly clarify, friends.

Thanking you.

Kind Regards,

Jeg P.

[jegathees_waran]

Hi VJ,

Thanks for your reply. I also thought it will handle only flat structure. But, just I wanted to find out is there any other was to optimize XML in the sender side.

Thank you

[VijayKonam]

No. JDBC sender supports only flat data structure. You would have to repeat the header data for each line item and then in the mapping, you should change the structure to hierarchical based on the header fields.

VJ