File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes MongoDB and the fly likes MongoDB To Oracle Using Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » MongoDB
Bookmark "MongoDB To Oracle Using Java" Watch "MongoDB To Oracle Using Java" New topic

MongoDB To Oracle Using Java

yogesh dhende

Joined: Sep 14, 2012
Posts: 1

How to write java code to extract data from MongoDB and put it into oracle tables.

Kapish M Joshi

Joined: Sep 12, 2012
Posts: 10

The paradigm of MangoDB and Oracle are totally different. The only similarity is both are databases.
MangoDB stored data in key - value form, while Oracle can have full fledged schema/table structure. For migrating data from MangoDB to Oracle you need to design the schema in Oracle DB taking RDBMS concepts into mind. Then you can write a java program which can be something like:
1. One component of your application will connect to MangoDB and will fetch the data from there.
2. Second component will parse the data and convert it into objects or appropriate form so that it can be added to Oracle.
3. Third component will insert the validated data into Oracle database tables.

If you need help designing & coding then you can contact me.

Kapish M Joshi| | InfoCepts
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

Um Kapish. He is talking about MongoDB, not MangoDB.

mOOOOOngo, not mAAAAAAngo.

MongoDB is a Document database not a Key-Value store database. Which is different.


Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
Kapish M Joshi

Joined: Sep 12, 2012
Posts: 10

Mark - ooh yeah, sorry for that..
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8927

how is mongodb pronuced like monday ?

I agree. Here's the link:
subject: MongoDB To Oracle Using Java
It's not a secret anymore!