XmlTree Load

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.

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.

Settings

Data source	The component that provides the data to the load.
Target connection	The connection details of the target system.
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.
	create Creates a new XML file and deletes an existing XML file. 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. 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. 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). delete Finds all elements matching root in source document and in target element. Removes children of all target elements if they match a child of any source element.
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.
Do not generate empty file	If checked, rows that do not contain data will not generate an element. If not checked, such rows will generate an element with null value.

Updated January 29, 2024