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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.