It's useful tool to transform structured database data into unstructured dba data. Easy to maintain data transfer jobs.
Sqoop uses JDBC connection to connect to RDBMS which is inefficient
The most important thing with Data Factory is the ease of creating new pipelines. The pipelines are structures which you define to move data from Cloud to On-prem Sql Server. These pipelines can then be run at a particular time of day/week.
interface is not clean when using code free data movement
It's useful tool to transform structured database data into unstructured dba data. Easy to maintain data transfer jobs.
The most important thing with Data Factory is the ease of creating new pipelines. The pipelines are structures which you define to move data from Cloud to On-prem Sql Server. These pipelines can then be run at a particular time of day/week.
Sqoop uses JDBC connection to connect to RDBMS which is inefficient
interface is not clean when using code free data movement