Azure Data Factory (ADF) is a service that orchestrate data integration using different services available in Azure. Like SSIS, it can move data from one location to another. The main differences are the following:
- SSIS needs a windows machine to run. Even to copy data, the service runs on a windows server. ADF doesn’t needs anything to accomplish copy data tasks since the service runs in Azure
- SSIS has a rich toolset integrated into it to transform data; the dataflow task. ADF has nothing that come close to it built-in.
- ADF relies on compute services like HDInsight clusters that can run Hive and Pig scripts to transform data.
- SSIS can transform data on without leaving the package and, without necessarily staging ...