Creating an XML, XSLT, or Streaming Transformation

The steps you follow to create an XML to tabular, XSLT, or streaming transformation include:

Adding a New Transformation (XML, XSLT, or Streaming)
Adding an XSLT Transformation for a Table, a View, or a Function
Mapping Source Data to Target Output Columns (XSLT or Streaming) (XSLT and streaming only)
Adding Target Columns through the Outputs Panel (XSLT) (XSLT only)

Adding target output columns is optional.

XSLT Transformation Limitation

The Data Map panel of the XSLT transformation does not display input fields for tables, views, and functions. Because the XSLT transform requires that the object being transformed has a Schema to generate Input Fields for the object.

TDV automatically generates a schema for XML-File data sources and WSDL data sources.

XML to Tabular Mapping

This transformation accepts an XML or WSDL source as input, and generates a tabular mapping to the elements in the source schema.

The mapping can be thought of as producing a set of rows, each of which represents a node in the original XML document. The XML document is converted into a table that represents the document’s data and nodes, as described in the following table.

Column Name

Column Type

Description

id

INTEGER

Unique identifier for an element or attribute value.

parent_id

INTEGER

Unique identifier for the parent of this element.

depth

INTEGER

Number of elements in the path.

name

VARCHAR

Local name of the element or attribute.

xpath

VARCHAR

Xpath expression that fully describes the location of the element or attribute.

path

VARCHAR

Path to the element or attribute. The path consists of a forward-slash-separated list of enclosing element names, ending with the local name of the element or attribute.

position

INTEGER

Position of this element relative to the path attribute.

value

VARCHAR

Value of the element or attribute.