I have a transformation requirement where source XML document in an ADLS Gen 2 storage container needs to be transformed and stored as a separate XML document in another ADLS Gen 2 storage container. The following link suggests that Synapse Pipeline supports XML as a source but not a sink:
https://learn.microsoft.com/en-us/azure/data-factory/format-xml
Just wondering if this is possible or not? Effective want to use Synapse Pipeline to do the equivalent of a XSL-T transformation.
Thanks and regards, Andrew
It seems that copying in binary format works fine, but if you are attempting to have Azure Data Factory (ADF) generate XML as Sink, that might not be achievable.
As per the Troubleshoot the XML format connector in Azure Data Factory and Azure Synapse