Oracle Loader for Hadoop & Oracle SQL Connector for HDFS



Oracle Loader for Hadoop


Hadoop Loader DiagramOracle Loader for Hadoop (OLH), part of Oracle Big Data Connectors, is a MapReduce utility to optimize data loading from Hadoop into Oracle Database. OLH sorts, partitions, and converts data into Oracle Database formats on Hadoop, and loads the converted data into the database. By preprocessing the data to be loaded as a Hadoop job on a Hadoop cluster, Oracle Loader for Hadoop reduces the CPU and IO utilization on the database.

Oracle Loader for Hadoop has online and offline options.  Both load the sorted and transformed data in parallel into the correct partition in the database.


Oracle SQL Connector for Hadoop Distributed File System (HDFS)


Hadoop Loader DiagramOracle SQL Connector for HDFS, part of Oracle Big Data Connectors, is a high speed connector for accessing data on HDFS directly from Oracle Database.  Oracle SQL Connector for HDFS gives users the flexibility of accessing and importing data from HDFS at any time, as needed by their application.

The connector for HDFS enables the creation of an external table in Oracle Database, enabling direct SQL access on data stored in HDFS. The data can be in delimited files or in Oracle data pump files created by Oracle Loader for Hadoop.



What's New


  • Intel Certifies Intel's Distribution of Apache Hadoop with Oracle Big Data Connectors—Apache Hadoop paired with the Oracle Big Data Connectors software suite helps IT provide users with a unified, seamless data resource and high-performing analytics platform….Intel has developed the Intel® Distribution for Apache Hadoop (IDH) software, which is now certified to work with Oracle Big Data Connectors. This enables IT to fully integrate data stored in existing infrastructure with data stored in the Hadoop Distributed File System.


Presentations and White Papers


  • Programming with Oracle Big Data Connectors—In this session, learn how to work with input formats supported by Oracle Loader for Hadoop for loading data from HIVE, HBASE, and NoSQL databases. Hear about best practices for high-performance connectivity between Hadoop and Oracle Database. And learn how to use the greatly simplified Oracle SQL Connector for Hadoop Distributed File System to access data on Hadoop from Oracle Database applications. Robert Abbott - Consulting Engineer, Oracle and Melliyal Annamalai - Senior Principal Product Manager, Oracle Oracle OpenWorld Presentation (October 2013)
  • High Performance Connectors for Load and Access of Data from Hadoop to Oracle Database Oracle White Paper (June 2012)


Related Products