1. Apache Sqoop Connectors

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

Hortonworks provides the following connectors for Sqoop:

  • MySQL connector: This connector is included in the HDP distribution; the instructions on configuring this connector are available here.

  • Netezza connector: This connector is included in the HDP distribution and installs with Sqoop; see below for more information.

  • Oracle JDBC connector: The instructions on configuring this connector are available here.

  • Hortonworks Connector for Teradata: This connector, based on the Teradata Connector for Hadoop, can be downloaded from here.

A Sqoop connector for SQL Server is available from Microsoft:

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