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