XMLFile Connection

Access level: read, write

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

With Jedox 24.2, PGP decryption is supported for file-based connections, such as XML. PGP decryption must be configured in the Cloud Console for your Jedox environment. See Keys and Secrets for more information.

Connection settings

Type The following file locations are supported:

File name Name of the file in XML format. The syntax of the file name is location-specific.
Encryption method For PGP decryption, enter the passkey that was set during key creation.

Directory connections will only work if the same passphrase can be used for all files (either the files use keys without passphrase, or the keys for the files have the same passphrase).

Encoding The most common 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/8/docs/technotes/guides/intl/encoding.doc.html
From this list you can also enter manually a character code into the field ‘Encoding’. Note that this connection only supports file encodings as provided by the Java Runtime Environment.
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 December 18, 2024