XMLFile Connection

With XMLFile connection, an XML-structured file can be specified.

Settings

Location See Locations for File-based Connections.
File name Name of the file in XML format.
The syntax of the file name is location-specific. More info in article Locations for File-based Connections.
Encoding The most prevalent character encodings are UTF-8 (default), ASCII, and latin1 (Windows standard).
A list of all character codes can be found at: http://docs.oracle.com/javase/6/docs/technotes/guides/intl/encoding.doc.html.
From this list you can also manually enter a character code into the field "Encoding".
XSD schema file If set, the XML file is validated against the XSD Schema. For extracts, this is done for the existing XML file; for loads, this is done against the created XML file.

The XSD file is taken from either

  • "FileSystem", when a full path is entered (e.g. "C:\myfolder\my.xsd")
  • the same location as the XML file itself, from the same folder. No folder has to be indicated in this case, just e.g. "my.xsd".
XSD validation Defines the behavior in case of a validation error against the XSD Schema:
  • none: no reaction
  • info: an info message appears
  • warning: a warning Message appears
  • error: an error message appears

Updated June 5, 2023