Data Connector for Oracle and Hadoop

Scalable solution for fast data transfer between Oracle and Hadoop

Quickly transfer data between Oracle and Hadoop with scalability you need.

Get lighting fast, scalable data transfer between Oracle and Hadoop with Data Connector for Oracle and Hadoop. It’s an optimized open-source plug-in to Apache Sqoop and provides highly clustered data transfer at five times the speed of Sqoop alone substantially, reducing your database overhead. With Toad for Cloud Databases’ graphical interface, it’s easy to use this data transfer plug-in.

Data Connector for Oracle and Hadoop, enables you to:

  • Prevent scalability issues that may arise with Sqoop when data is not stored in primary key order or has no primary key
  • Decrease IO time by up to 95 percent and CPU by up to 80 percent
  • Avoid disruption to Oracle workload running simultaneously
  • Execute a Hive query and insert the results into an Oracle table using the free Data Transporter for Hive, a Java command-line utility

Specifications

Hadoop

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 http://archive.cloudera.com for straightforward installation of Hadoop on Linux systems.

Sqoop 1.1.0

Oracle Database 11g Release 2 JDBC driver

Language Supported:

  • US English

Resources