ODI has a feature that allows to read XML data. I really enjoyed working with this feature. It allowed to directly insert values from an XML file into different fields in an Oracle table.
The idea is very simple. One has to set up a technical and logical schema that is based on XML. With the properties of the physical scheme, the XML filename is given:
Here, one may see that the file “maaltijd.xml” is used that is stored in directory “C:\Users\tmaanen\CloudStation\ODImap”.
Subsequently, a model is created whereby the XML dataset is reverse engineered:
One table contains data that are of interest. That table is used in a mapping as an input. As output, we use an Oracle table:
Running this mapping propagates the data from an XML file (“Maaltijd.xml”) to an Oracle table. See below for a screen shot of the Oracle table:
