Connection to XMLFile

image_pdfimage_print

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

Main settings

Location

The location of the file with following options:

  • File System
  • URL
  • Report Designer

File name

File system location:

  • filename with an absolute path on the File system of the Server.
    Example: C:\Users\xyz\Sample.xml
  • A filename with relative path to the “data” directory of the Jedox Integrator Installation (default: .\tomcat\webapps\etlserver\data\files)
    Example: BikerProducts.xml
  • A file residing on a network drive (see instructions in article “Accessing network files“)
    Example: //net1/Sample.xml

URL location*:

Report Designer location:

  • A filename with path in Report Designer.
    Example: //Default/Public Files/sample.xml
    Note: In case of access to a remote Report Manager the following syntax is used:
    <remote_ip>:<port>//<path>
    Example:
    12.34.56.78:80//Default/Public Files/sample.xml
Advanced settings

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”.

SSL Mode

Off: SSL is not used. For Report Designer files this option has to be used if Jedox Web uses HTTP protocol.

Trust: The SSL certificate is imported to the keystore if not yet available. For Report Designer files, this option has to be used at least once if Jedox Web uses HTTPS protocol to import the certificate.

Verify: The SSL certificate is verified. For Report Designer files, this option should be used if Jedox Web uses HTTPS protocol and the certificate is already imported.
Note: If the certificate has not been imported correctly, the following error message occurs: “Unable to find valid certification path to requested target”.

 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.

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

XSLT File

XSLT is a standard language for transforming XML documents. If set, the XSL Transformation defined in this XML file is performed.
In case of an extract, this is done for the existing XML file; in case of a load, this is done against the created XML file.

*If location is URL, there are 2 additional fields for HTTP Basic Authentication:

Username

The username for HTTP Basic authentication

Password

The password for HTTP Basic authentication

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