In this chapter we've successfully consumed XML files in our integration activities. Along the way we've explored a number of aspects of working with XML as well as some other extremely useful capabilities of ODI 11g:
- We've seen how XML Data Servers are associated with file references—both for the datafiles and their schema definitions and how, by using ODI Procedures, we can manipulate those files to enable a single data server access to multiple sets of file data.
There are other, more sophisticated ways to achieve this, but at least we've covered enough to "get started".
- We took a look at how the XML driver breaks down a hierarchical tag structure from a file into a number of related in-memory tables and how it adds columns to maintain ...