Thank you for your feedback. We will evaluate this ask as part of product roadmap.Brent Leslie supported this idea ·Brent Leslie commented
Not cool being unable to handle XML data. Pretty common activity for ETL. Until Data Factory supports common data formats and at least basic transformations, I can't large scale uptake.
Thanks all for the overwhelming feedback for adding SFTP as sink as a native capability. We are actively planning for this and will keep you updated in upcoming months!Brent Leslie commented
Terrible that this is not supported as a sink yet. Come on guys, you can get data from SFTP but not write to it?
Thank you for your suggestion. We understand it is super important to whitelist specific IP list for ADF as part of firewall rules and avoid opening network access to all. We are working on this with high priority. Once this is ready, we will also add ADF to the list of “Trusted Azure service” for Azure Storage and Azure SQL DB/DW.