Database Reference
In-Depth Information
Sqoop Connectors
Sqoop has an extension framework that makes it possible to import data from — and ex-
port data to — any external storage system that has bulk data transfer capabilities. A Sqoop
connector
is a modular component that uses this framework to enable Sqoop imports and
exports. Sqoop ships with connectors for working with a range of popular databases, in-
cluding MySQL, PostgreSQL, Oracle, SQL Server, DB2, and Netezza. There is also a gen-
eric JDBC connector for connecting to any database that supports Java's JDBC protocol.
Sqoop provides optimized MySQL, PostgreSQL, Oracle, and Netezza connectors that use
database-specific APIs to perform bulk transfers more efficiently (this is discussed more in
As well as the built-in Sqoop connectors, various third-party connectors are available for
data stores, ranging from enterprise data warehouses (such as Teradata) to NoSQL stores
(such as Couchbase). These connectors must be downloaded separately and can be added to
an existing Sqoop installation by following the instructions that come with the connector.
