Al evaluar las dos soluciones, los revisores encontraron que Azure Data Factory es más fácil de usar y hacer negocios en general. Sin embargo, prefirieron la facilidad de configuración con Apache Sqoop, junto con la administración.
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