Skip to main content
waffle.svg
Domo Knowledge Base

XML Easy Connector

  1. Last updated
  2. Save as PDF
Version 10

 

Intro

Extensible Markup Language (XML) is a simple, very flexible text format. The Domo XML Easy Connector allows you to cut and paste from your XML file into a text box and import your XML data as a new Domo DataSet. More advanced XML uploads can be made using the Domo XML Advanced Connector. For more information about XML, see https://www.w3.org/TR/REC-xml/ .

You connect to your XML account in the Data Center. This topic discusses the fields and menus that are specific to the XML connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Primary Use Cases

Pulling XML data formatted as rows and columns into Domo.

Primary Metrics

N/A

Primary Company Roles

IT

Average Implementation Time

2 hours

Ease of Use (on a 1-to-10 scale with 1 being easiest)

3

Best Practices

Make sure the XML is valid before using the connector.

Prerequisites

To connect to your XML account and create a DataSet, you must have credentials for the server in which the XML file is found.

You must also whitelist a number of IP addresses on your database server on the port you want to connect to. For the full list of IP addresses, see Whitelisting IP Addresses.

Connecting to Your XML Account

This section enumerates the options in the  Credentials and Details  panes in the XML Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to your XML account. The following table describes what is needed for each field:  

Field

Description
Username Enter the username for the server where the XML file is located.
Password Enter the password for the server where the XML file is located.

Once you have entered valid XML credentials, you can use the same account any time you go to create a new XML DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

In this pane you specify the server/SFTP site to connect to, the name of the XML file, and other configuration settings.

Menu

Description
Paste Your XML Text Here

Paste the XML text you want to you want to bring into Domo as a new DataSet.

Do You Require Advanced Options?

Select Yes if you need to specify root tags, exclude fields, or use XPath.
Enter Your Data Tag Enter the data tag in the XML text you copied into the above text field.
Do You Want Attribute Values as a Part of Data? Select Yes if attribute values should be part of the XML data.

Fields to Exclude (Optional)

Provide a comma-separated list of fields to exclude from the XML import.
Enter XPath Expression (Optional) Enter your XPath query using standard XPath syntax as defined by the World Wide Web Consortium. (http://www.w3.org/TR/2014/REC-xpath-30-20140408/)

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

Troubleshooting

  • Make sure the XML data is valid and that the credentials are up-to-date.

  • Whitelist necessary IP addresses.