Scalable solution for fast data transfer between Oracle and Hadoop
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
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.
Oracle Database 11g Release 2 JDBC driver
- US English