List of Sqoop Connector

[Selvam Raman <se...@gmail.com>]

Hi ,

can you please share list of available sqoop connector. (To, FROM)

-- 
Selvam Raman
"லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"

Re: List of Sqoop Connector

[Attila Szabo <as...@cloudera.com>]

Hi Selvam,

In connection with the current trunk version:

AFAIK (but the community could correct me if I would miss anything) SQOOP
should work together with any RDBMS system which does have SQL92
compatibility + a working JDBC driver.

Although as it's not too surprising there could be small changes between
the execution of the standard Metadata queries/insert/update/select
statements, thus we do have a few specific DB related connectors.

You can easily find them like checking the type hierarchy of the
org.apache.sqoop.ConnManager class, but here would be a list:
PostgreSQL
Oracle (in case of this one we also have something called OraOOP, which
provides different functionalities like direct inserts, partitioned based
solutions, etc.)
MySQL (and thus MariaDB as it's a fork of MySQL, but there could be
differences between them, especially because of the JDBC driver. Here we
also have a direct solution as well.)
DB2
MsSQLServer
HSqlDB

but of course because of the reasons I've mentioned above it could work
together for example with any other server where the implementation is
fitting the GenericJDBCManager implementation.

Specific Hadoop vendors could also have custom proprietary connectors for
different DBs like Terradata/Netezza/etc.

I hope I was able to give a clear explanation here, but please raise your
followup questions if something needs more clarification.

Cheers,
Maugli


2016-08-05 0:13 GMT-07:00 Selvam Raman <se...@gmail.com>:

> Hi ,
>
> can you please share list of available sqoop connector. (To, FROM)
>
> --
> Selvam Raman
> "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"
>



-- 
Best regards,

Attila Szabo
Sotware Engineer

<http://www.cloudera.com>