XML Easy Connector
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.