How do I integrate Data across MongoDB and Oracle Databases?

Data Access Drivers & Connectors Tips, Tricks, and HowTos
, , , ,
1

OPL-round-up-2019-wk3
OPL-round-up-2019-wk3800×418 114 KB

Problem : How can you access MongoDB data from Oracle Server?

You can solve this problem via any of the following solutions:

  1. ODBC or JDBC Drivers and Oracle’s Database Integrator for ODBC
  2. ODBC- and/or JDBC-compliant Data Virtualization Platform.

ODBC Driver and Oracle Data Integration Gateway

  1. Attach MongoDB Driver to Oracle, if the native driver is incompatible you can use an ODBC-JDBC Bridge Driver
  2. Perform you Data Manipulation operations via ODI

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

ODBC_JDBC
ODBC_JDBC2340×1248 201 KB

Data Virtualization Platform Solution

Here’s how it works, bearing in mind that you have ODBC-access available to both Oracle and MySQL Database Management Systems (DBMS):

  1. You attach MongoDB instance to the Data Virtualization Platform
  2. You attach Oracle instance to the Data Virtualization Platform
  3. You can then perform your Data Manipulation (DML) operations on Data managed by either DBMS as though they are 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.

DataVirtualization2
DataVirtualization21340×1054 85.2 KB

Related