XmlTree Load

image_pdfimage_print

This load is used to write a tree-based data source to an XML file. The source may be a dimension extract containing an OLAP dimension, any tree-based transform, or an XMLTree extract. This load is useful for duplicating XML data for which optionally an XSL transformation can applied that is defined in the XMLFile connection.

The tag names of the XML elements is taken from the tree nodes; the attributes and parent-child-relations are also transferred.

Main settings

Mode

In all modes except “create”, an XML element from the generated (source) document is matched to an already existing (target) document. If the XML file does not yet exist, it is created in all modes.

 

add:

Finds all elements in source document and in target element matching XPath root expression (root). Adds all children of all source elements as new children for all target elements

 

create:

Creates a new XML file and deletes an existing XML file.

 

delete:

Finds all elements matching root in source document and in target element. Remove children of all target elements if they match a child of any source element.

 

insert:

Finds all elements matching root in source document and in target element. Adds children of all source elements as new children for all target elements (if they do not having at least one matching child yet).

 

update:

Finds all elements matching root in source document and in target element. Removes all children of all target elements. Adds all children of all source elements as new children for all target elements.

The following settings are necessary due to differences in the tree representation between an XML document and a Jedox Integrator tree. They allow the transfer of a tree-based source to an XML document. See XmlTree Extract for details.

Advanced settings

XPath root expression

This is an absolute XPath expression that specifies the root nodes under which the source data is updated for the update of an existing XML file. Only simple XPath expressions with element names concatenated with “/” are supported.

Example: /project/connections

XML element from tree attribute

Specifies the attribute of the tree node from which the tag name of the resulting XML element is taken. If necessary, ETL tries to make the tag name of the XML element valid by removing all special characters from it. If not set, tree attribute “_OrigName” is used as default.

Special value:
element: The tag name is taken from the tree element name.

XML content from tree attribute

Specifies the attribute of the tree node from which the element content of the resulting XML element is taken. If not set, the attribute “_OrigName” is used as default if the tree source contains such an attribute.

Special value:
:element: The content is taken from the tree element name.

 Tree element to XML attribute

If set, the element name of the source tree is written to the specified XML attribute. As XML tag names cannot contain all characters (e.g. a space is not allowed), this option allows the tree element name to be loaded in all cases.

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...