Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MongoDB To Oracle Using Java

 
yogesh dhende
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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


Thanks,
Yogesh.
 
Kapish M Joshi
Greenhorn
Posts: 10
Flex Hibernate Java
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Mark
 
Kapish M Joshi
Greenhorn
Posts: 10
Flex Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Mark - ooh yeah, sorry for that..
 
Pradeep bhatt
Ranch Hand
Posts: 8933
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
how is mongodb pronuced like monday ?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic