Sqoop enables us to transfer data between any relational database and Hadoop. You can import data from any relational database that has a JDBC adaptor such as SQL Server, MySQL, Oracle, Teradata, and others, to HDInsight.
The major benefits of using Sqoop to move data are as follows:
Leverages RDBMS metadata to get the column data types
It is simple to script and uses SQL
It can be used to handle change data capture by importing daily transactional data to HDInsight
It uses MapReduce for export and import that enables parallel and efficient data movement
