Example: Working with XML files
In this example we're going to be reading simple XML files with ODI. Along the way we're also going to introduce ODI Procedures and build a couple of examples.
Requirements and background
The examples in this chapter build on the expertise gained in previous chapters.
Our overall sample scenario covers a Purchase Order (PO) processing environment and here we're going to be dealing with handling Purchase Order data. So what we'll focus on in this section is how ODI can integrate incoming Purchase Order data into the data mart from which those other PO processing elements could retrieve the purchase orders for further sequential processing.
The PO data we must handle is provided in the following format:
We have an online order capture system that outputs each order as an XML message as they are placed. These messages are stored as individual XML files. The files that we receive from the online system are always for orders placed today.
Scope
As we've noted earlier...
