Sqoop is an open source Apache project, which facilitates data exchange between Hadoop and any traditional Relational Database Management System (RDBMS). It uses the MapReduce framework under the hood to perform the import/export operations and often is a common choice for integrating data from relational and non-relational data stores.
Microsoft SQL Server Connector for Apache Hadoop (SQL Server-Hadoop Connector) is a Sqoop-based connector that is specifically designed for efficient data transfer between SQL Server and Hadoop. This connector is optimized for bulk transfer of the data bi-directionally, it does not support extensive formatting or transformation on the data while being imported or exported on the fly. After reading this chapter, you will be able to:
Install and configure the Sqoop connector
Import data from SQL Server to Hadoop
Export data from Hadoop to SQL Server