Notice: will be retired soon. Please visit our new site at
Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »

Data Connector for Oracle and Hadoop

Fast, Scalable Data Transfer Between Oracle and Hadoop

Data Connector for Oracle and Hadoop is the fastest, most scalable way to transfer data between Oracle and Hadoop. This optimized open-source plug-in to Apache Sqoop is more than five times faster than Sqoop alone and significantly reduces database overhead. Toad for Cloud Databases offers a graphical interface that makes it easy to use our data transfer plug-in.

With Data Connector for Oracle and Hadoop, you can:

  • Transfer highly clustered data more than five times faster than with Sqoop alone
  • Avoid scalability issues that can occur with Sqoop when data has no primary key or is not stored in primary key order
  • Reduce CPU by up to 80 percent and IO time by up to 95 percent
  • Prevent disruption to concurrently running Oracle workload
  • Get free use of Data Transporter for Hive, a Java command-line utility that allows you to execute a Hive query and insert the results into an Oracle table

Sys Reqs

Before you can use Quest Data Connector for Hadoop, a release of Hadoop must be installed and configured.
** We recommend that you download Cloudera’s Distribution for Hadoop (CDH3) from the Cloudera Software Archive at for straightforward installation of Hadoop on Linux systems.
Sqoop 1.1.0
Oracle Database 11g Release 2 JDBC driver

Language Supported:

  • US English