XML via SQL Data Provider loads hierarchical XML data into a relational schema. You can use SQL to query the schema like a relational database.
Figure 6-1: XML via SQL Data Provider
Use the SQL-based XML Port Manager component to define one or more output data streams. You can provide either an XML Schema file or DTD to validate the XML source.
You do not need to understand XML in detail to use this component. It is useful for data-centric XML documents (such as, sales order, stock quotes, scientific data) that are characterized by a regular hierarchical structure. Use this component to represent the data from the XML document in a relational table structure for further data transformation.
