XML (source ETL/ELT)

(1) The path and name of the source file. Paths below the installation directory of the Integration Server can be specified relatively with ./ Note: You can use variables, see (3), and placeholders, see tooltip.

You can also specify a URL. Example: https://example.com/myfile.xml

You can also specify file archives (ZIP, TAR, RAR) with multiple files if (10) is set. The task is then executed for each file in the archive (implicit loop).

(2) Displays the source file.

(3) Selection of ETL/ELT variables.

(4) The source file is deleted after processing.

(5) The XPath expression to be used. See also section Test XPath. The elements found are the 'rows'. Important note: The subtree read in via (5) is available internally in memory, i.e. further XPath expressions can be applied to it in the destination data. Simple expressions are automatically available there as ETL/ELT fields (leaf nodes can be addressed with $xnode). If you want to use more complicated expressions, please create custom ETL/ELT fields.

(6) Extracts the names of the ETL/ELT source fields (the subelements of the elements found by the XPath expression).

(7) Selection of ETL/ELT variables.

(8) Here you can test your XPath expression using test XML data. See also section Test XPath.

(9) This is an expert setting (Scriptella) and can be ignored.

(10) See (1).