1. Apache Sqoop Connectors

Sqoop uses a connector-based architecture which supports plugins that provide connectivity to various external systems. Connectors are plugin components based on Sqoop’s extension framework and can be added to any existing Sqoop installation. Using specialized connectors, Sqoop can connect with external systems that have optimized import and export facilities, or do not support native JDBC.

A Sqoop connector for SQL Server is available from Microsoft:

  • SQL Server R2 connector: This connector and its documentation can be downloaded from here.