Apache Sqoop Connectors
Sqoop uses a connector-based architecture which supports plugins that provide connectivity to external systems. Using specialized connectors that work with JDBC drivers, Sqoop connects with external systems that have optimized import and export facilities. Connectors also enable Sqoop to connect with external systems that do not support native JDBC. Connectors are plugin components based on the Sqoop extension framework and can be added to any existing Sqoop installation.
It might be necessary to download and install JDBC drivers for some connectors to function correctly. You can obtain JDBC drivers from
the client distribution for your external system's operating system or from the manufacturer of your external system. To install, copy the JDBC driver
to the $SQOOP_HOME/lib
directory of your Sqoop installation.
Hortonworks provides the following connectors for Sqoop in the HDP 2 distribution:
MySQL connector: Instructions for using this connector are available in the Apache Sqoop documentation for MySQL JDBC Connector.
Netezza connector: See the section called “Netezza Connector” and the Apache Sqoop documentation for Netezza Connector for more information.
Oracle JDBC connector: Instructions for using this connector are available in the Apache Sqoop documentation for Data Connector for Oracle and Hadoop.
PostgreSQL connector: Instructions for using this connector are in the Apache Sqoop documentation for PostgreSQL Connector.
Microsoft SQL Server connector: Instructions for using this connector are in the Apache Sqoop documentation for Microsoft SQL Connector.
A Sqoop connector for Teradata is available from the Hortonworks Add-ons page:
Teradata connector: The connector and its documentation can be downloaded from the Hortonworks Downloads page. Search the page for "Teradata".