Data Lake for Enterprises

Types of Sqoop connectors

Sqoop connectors can be broadly classified as below:

• Built-in connectors: Connectors which ship along with the default Sqoop installation are categorized in this. Built-in connectors can again be sub-categorized as follows:
  • Generic JDBC connector: This connector can be used to connect to any database system complying with JDBC and SQL. Sqoop chooses this connector as a last resort when it is not able to find any other connector (default or manually installed).
  • Specialized connectors: These are connectors included by default along with Sqoop installation for all the popular database management systems. Some of the example connectors falling into this category are Oracle, MySQL, PostgreSQL and so on.
  • Fast-path connectors: ...