Connecting to XML files

Contents[Hide]

1. Overview

This article describes how to create a new data connector for connecting to an XML file, and the different options that are available for this data connector.

2. Drag an XML file

To upload an XML file to Dundas BI and connect to it automatically with default options, you can simply drag the file onto a new metric set, or onto a view such as a dashboard when editing.

The file's data will be visualized automatically. A new data connector will also be added automatically that you can use.

Drag an XML file
Drag an XML file

3. Create a data connector

You can create a data connector for an XML file yourself or edit one to access more options.

To create one, click New in the main menu on the left, and select Data Connector.

Selecting the XML File data provider
Selecting the XML File data provider

In the New Data Connector dialog, set a Name for your connector, and set the Data Provider dropdown to XML File.

There are two options for connecting to an XML file:

  • Upload a file – Click Choose File and browse to find the XML file to upload.
  • Define the XML file path – Alternatively, set XML File to either a URL (e.g., https://www.w3schools.com/xml/books.xml) or a UNC path (e.g., \\FileServer\Xml\books.xml) pointing to the file.

Upload or connect to the file
Upload or connect to the file

If you enter an XML File path, you can use wildcard characters * or ? to refer to multiple files with the same structure, similar to the example shown for Excel files.

When connecting directly to an XML File path (not when uploading a file), you can set the Authentication method Dundas BI will use to access the file. For more information, see the article Authentication methods.

4. Settings

4.1. XML namespace

If the XML document you are using has an XML namespace defined, you should enter that value in the XML Namespace field.

XML Namespace field.
XML Namespace field.

4.2. Schema location

Set Schema Location to Inline Schema when the XML schema is stored in the XML file.

If there is no schema, set it to No Schema and the data will be automatically discovered. Optionally, select the Infer Schema option to generate a schema automatically from the content first and load the data according to that schema.

Options with no schema
Options with no schema

If you have the schema in a separate file, set Schema Location to External Schema and either upload it or set the XSD File field to the path like when setting the XML File field.

External schema options
External schema options

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri