Integration

Hi!

I hope you could suggest us an appropiated approach to accomplish this request.

We need to process and find some data in XML files (which conform to an XSD schema) and store them in database. There is a huge amount of XML files to process every day and these files are received through some messaging queues and also must be dispatched to different queues.

We are using OSB as integration tool so approach should be OSB centred. I now OSB is capable of processing XML files through XQuery expressions and store data in database (well at least read data, I'm not sure if it is capable of insert data directly). But the problem I see is that we must parse lot of data from each XML file so I think it could be very cunbersome to build every XQuery expressions within an OSB stage.

Another approach I thought of consist of building a MDB which receives XML files, process them using JAXB and stores data in database. OSB would receive XML files from origin queue, dispatch them to target queue and also to MDB to commit processing.

Which approach seems most correct for you?

Thank you.

Daniel.