CODEWITHSUNDEEP
hadooprdbmssqoop
Aj here
Aj here

Reputation: 47

What is the difference between using sqoop & using oraoop in Cloudera Hadoop?

When we have sqoop to import data from any RDBMS, then why oraoop is raised to import data from oracle which is also a RDBMS.

whats is the difference between sqoop and oraoop

Upvotes: 0

Views: 3245

Answers (1)

Jit B
Jit B

Reputation: 1246

sqoop is generic and works with any RDBMS - the only requirement being that you supply it with the particular RDBMS' JDBC driver.

Oraoop is a special plugin for sqoop that provides faster access to Oracle's RDBMS by using custom protocols that are not available publicly. Quest software partnered with Oracle to get those protocols, implemented them and created Oraoop.

You can also make your sqoop work with Oracle without oraoop but it would not be as fast.

Upvotes: 3

Related Questions