ETL using Azure Data Factory v2

Question

I just want to know what the best method and sample components to use when conducting an ETL and using Azure Data Factory v2 would be. Will there still be a need to use SSIS or will Azure Data Factory be able to manage all the processes in the pipelines for an ETL solution?

Answer 1

Your response will be unique to your circumstances. Azure Data Factory lets you create data-driven cloud workflows to orchestrate and automate data movement and data transformation. If you are already familiar with SSIS / have existing SSIS ETL packages, in ADF (Azure-SSIS Integration Runtime), you can simply lift and pass them to SSIS. If you don't want to use SSIS, ADF ETL / data flow will be introduced in the future and is currently available

You can enroll for Azure Data Factory Certification from Intellipaat