Access External Data Sources from Oracle Database

September 4, 2017

Links to Oracle Big Data Connector Technology Blogs

Bob Hanckel

The following links discuss OHSH (Oracle Shell for Hadoop Loaders) , which is a CLI used for loading Oracle tables from content living in HDFS or Hive tables, and for loading Hive tables from content living in Oracle tables.

How to Load Oracle and Hive Tables using OHSH (Part 1 - Introduction)
How to Load Oracle and Hive Tables using OHSH (Part 2 - Configuration and CLI Usage)
How to Load Oracle and Hive Tables with OHSH (Part 3 - Loading Oracle Tables)
How to Load Oracle and Hive Tables Using OHSH (Part 4 - Loading Hive Tables)
How to Load Oracle and Hive tables using OHSH (Part 5 - Using "loadermap" when loading Oracle tables)
How to Load Oracle and Hive tables using OHSH (Part 6 - Using the "etl" method for loading Oracle tables)

The following links discuss two Oracle Connectors for Hadoop: Oracle Loader for Hadoop (OLH) and Oracle SQL Connector to HDFS (OSCH). These are two of the underlying technologies that OHSH uses which can also be directly used by power users. They also provide better insight on what exactly is happening under-the-covers when using the parallelism of Oracle external tables or Hadoop Map/Reduce to load Oracle tables.

Be the first to comment

Comments ( 0 )

Recent Content

Oracle

Access External Data Sources from Oracle Database

Links to Oracle Big Data Connector Technology Blogs

Be the first to comment

Recent Content

Oracle SQL Access to Kafka at Oracle Groundbreakers Yatra!

Integrating Data-in-Motion with Data-at-Rest using Oracle SQL Access to Kafka Views

Uploading Your Data from Oracle Database On-Premise to HDFS in Oracle Cloud