Accessing Data via XML Connections
By setting up XML connections in a catalog, you can connect to and transform XML hierarchical data sources to relational data sources. This topic introduces the workflow for Designer to get data from XML data sources, and how you can set up XML connections in a catalog and work with the connections to retrieve data.
Designer can parse schemas from XML instances or import schemas from an XSD file, and then transform them to relational schemas. During the transformation, Designer transforms elements in the XML schemas to either tables or columns in tables. You can access the transformed tables in the same way as with JDBC supplied tables.
Select the following links to view the topics: