Can Azure Data Factory ingest an XML file stored in Azure Data Lake Store? RRS feed

  • Question

  • I’ve provisioned both Azure Data Lake Analytics AND Azure Data Lake Store Gen1.  In the Azure Data Lake Store Gen1 I’ve been able to create a folder structure and successfully upload an XML to that folder.  What I would then like to do is demonstrate the capability of being able to load an Azure SQL Database table using a Azure Data Factory pipeline.  I first have to create something in Data Factory called a DataSet which I must first select the type of DataSet, Azure Data Lake Store Gen1, because that is the only way I can access the folder structure and XML file in the Azure Data Lake Store.
     Next, I have to select a format.  Notice that CSV and JSON formats are present, but XML is not present.  Not sure what Microsoft was thinking here.  This is the limitation that I’m running into.  I need to be able to select an XML format so that I can load the XML file into the Azure SQL Database.

    Friday, July 19, 2019 7:40 PM

All replies