Connecting via XML Connections
By setting up XML connections in catalogs, 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 supports parsing schemas from XML instances or importing schemas from an XSD file, and then transforming them to relational schemas. In the transformation process, 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: