0

We are using Oracle server and we need to fetch data from MongoDB. As RHEL 7 is supported for installing MongoDB drivers, and the one we use is RHEL 6.9. So drivers are not installed and dblink was not created. We are looking for other options to access this MongoDB server from Oracle server.

Please need help here.

Improve this question
0

2 Answers 2

Reset to default
1

This will be a challenge because Oracle is a relational database whereas MongoDB is "NoSQL". A native connection is not possible.

Look for a MongoDB ODBC Driver, e.g.

Once you installed one of them, use the Oracle Database Gateway for ODBC to access the MongoDB via the ODBC driver.

The configuration of this can be tricky, but it should be possible.

Almost any popular programming language is able to connect to an Oracle database as well to connect to MongoDB. So, you can write a program/script which copies data from one database to the other. However, if you like to use direct connection (i.e. database link in Oracle) the you have to use one of these ODBC driver.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

The Oracle DB people would probably point out all the non-relational features it supports such as its document access SODA and also its JSON datatype support both of which are great for JSON storage.
@ChristopherJones, JSON is not BSON and I thing the Aggregation Framework is much more powerful than what you can get in Oracle (in terms of JSON/BSON operation). Neither Oracle nor MongoDB is the "better" one, they just have different approach and I think both have their rights to exist.
0

In combination with the Oracle Gateway for ODBC, you solve this problem via any of the following solutions:

  1. ODBC or JDBC (via ODBC-to-JDBC Bridge) Drivers and Oracle's Database Integrator for ODBC
  2. ODBC- and/or JDBC-compliant Data Virtualization Platform

ODBC Driver and Oracle Data Integration (ODI) Gateway

  1. Attach Oracle to MongoDB Driver. You can use a native JDBC driver, or a JDBC-to-ODBC Bridge Driver plus a native ODBC driver

  2. Perform your Data Manipulation operations via ODI

OpenLink JDBC-to-ODBC Bridge Drivers provide enhanced DBMS virtualization that increases compatibility between JDBC client apps and 3rd party ODBC Drivers.

Data Virtualization Platform Solution

Here's how it works, given that you have ODBC access to each of Oracle and MySQL Database Management Systems (DBMS), using either a native ODBC Driver or a native JDBC Driver with an OBDC-to-JDBC Bridge:

  1. Attach the Data Virtualization Platform to the MongoDB instance
  2. Attach the Data Virtualization Platform to the Oracle instance
  3. Perform your Data Manipulation (DML) operations on Data managed by either DBMS, as though they were in local tables in the Data Virtualization Layer

Our Virtuoso Multi-Model Database Management and Virtualization Platform is an example of a Data Virtualization solution that operates in the manner described above.

Related

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.