Previous Topic  Next Topic

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:

• How Designer Gets Data from XML Data Sources
• Working with XML Connections in a Catalog

Previous Topic  Next Topic