This article is contributed. See the original author and article here.

We are glad to announce that now in Azure Data Factory, you can extract data from XML files by using copy activity and mapping data flow. With such capability, you can either directly load XML data to another data store/file format, or transform your XML data and then store the results in the lake or database.

 

XML format is supported on all the file-based connectors as source. You can find the new “XML” option in the available format list:

Linda_Wang_0-1594989922662.png

 

When reading data from XML files, you have the flexibility to define whether to apply schema validation, to specify how to handle namespaces, and to map selective fields or reshape the hierarchy to match downstream data need.

 

Copy activity source example:

Linda_Wang_1-1594989936019.png

 

In mapping data flow, you can use XML as source either via an XML dataset or via inline dataset.

Data flow source example with XML dataset:

Linda_Wang_2-1594989956975.png

 

To learn more about XML support in Azure Data Factory, visit XML format in the documentation site.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.