CODEWITHSUNDEEP
azure-data-factory
Randy Minder
Randy Minder

Reputation: 48402

Can XML be mapped to a SQL Server table in ADF?

We would like to use Azure Data Factory to read an XML document and be able to map the columns in the document to a SQL Server table so we can move the data contained in the document to a SQL table. Is this possible in ADF?

Upvotes: 1

Views: 568

Answers (2)

KarthikBhyresh-MT
KarthikBhyresh-MT

Reputation: 5034

Azure Data factory now supports XML format in both copy activity and mapping data flow.

Learn more from https://techcommunity.microsoft.com/t5/azure-data-factory/azure-data-factory-adds-support-for-xml-format/ba-p/1529012.

Upvotes: 0

Jay Gong
Jay Gong

Reputation: 23782

Please note that XML file type in copy activity is not supported based on the document.

I suggest you voting up an idea submitted by another Azure customer.

All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

As workarounds,maybe you could get some clues from this link.

Upvotes: 1

Related Questions