CHAPTER 12

image

Integrating MongoDB with Oracle Database in Oracle Data Integrator

MongoDB is a BSON (binary JSON) format NoSQL database and the leading NoSQL database. Oracle Database is the leading relational database. The use case could be to load MongoDB data into Oracle Database. Oracle Loader for Hadoop does not support the MongoDB BSON format directly. Oracle Loader for Hadoop supports loading from Hive. A Hive external table may be defined on a MongoDB datastore using the Hive Storage Handler for MongoDB. Oracle Data Integrator automates the use of Oracle Loader for Hadoop with the IKM File-Hive to Oracle knowledge module. In this chapter ...

Get Pro MongoDB™ Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.