This is a very good article.
I'd be interested in your view of Azure Data Factory overall maturity and utility, compared to, say, other ETL tools.
My shop has had a mixed experience with it. The very first time I tried to create an ADF pipeline came in response to a need for a very simple exchange of information with an outside vendor. All they wanted was for us to upload a CSV file with "people" data in it, generated off of one of our administrative systems, to an Amazon S3 bucket. Anyone working in a modern, multi-cloud shop is familiar with this sort of integration.
Normally I'd have used on-prem SSIS (+CozyRoc) or Jitterbit for this. But to expand my horizons, I tried, in turn, an Azure Logic App and ADF.
Shockingly, neither the logic app nor ADF could copy data into an S3 bucket.
It was hard, after that, for me to think of ADF as anything but a toy - or a tool for people who live in a fairly monolithic shop.
Have things changed recently? Can ADF connect to a broader set of tools and services that in the past? Is it yet possible to do simple things like drop a CSV file into an S3 bucket, without going on some sort of coding adventure or buying a third-party plug-in?