how to integrate Oracle and MongoDB.

marrowyung
marrowyung used Ask the Experts™
on
hi,

what is the solution to integrate Oracle with Mongo DB? data flow between them ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Geert GOracle dba
Top Expert 2009
Commented:
depends which direction
for oracle to mongodb, setup a gateway
https://www.cdata.com/kb/tech/mongodb-odbc-oracle-hs.rst

the sample shows you can then query a mongo db table from inside oracle
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Looks like Goldengate replicates between Oracle and MongoDB:
https://blogs.oracle.com/dataintegration/oracle-goldengate-adapter-for-mongodb
marrowyungSenior Technical architecture (Data)

Author

Commented:
Geert G,

gateway is a separate license and allow oracle to read and write from and to  other DB source ? it can support mongo DB too ?

"Goldengate replicates between Oracle and MongoDB:"

that one also allow multi master between Oracle and MongoDB? shouldn't be, right?
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
>>that one also allow multi master between Oracle and MongoDB? shouldn't be, right?

I cannot say for sure.  From the link I provided it does appear that way but I've not personally done it.
marrowyungSenior Technical architecture (Data)

Author

Commented:
ok . tks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial