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 ...

Get Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.