The concept of data integration often sparks a lengthy and convoluted debate as to the best approach and technology for the given sources and destinations. In addition to the out-the-box products such as SQL Server Integration Services (SSIS), there is also a wealth of open source tools to consider, not forgetting the third-party connectors and bespoke, source system–specific integration tools that all help to muddy the water.
When operating on the Azure platform, the established convention is to use Azure Data Factory (ADF) V2. This is the primary integration and orchestration engine for any data movement ...
