All geek questions in one place

Is there a way for Oracle Data Integrator to retrieve data from MongoDB

I am trying to transfer data snapshots from our MongoDB to our Oracle BI data warehouse.

The BI team asked me to make the data available for ODI, but I could not find an example of this.

Is this possible and what do I need to implement it?

If there is a more general way to get MongoDB data in Oracle, I am also happy to suggest this.

Versions

  • MongoDB: 2.0.1
  • ODI: 11.1.1.5
  • Oracle: 11.2g

Edit: This is what will be requested once a day, maybe twice, but at this point the granularity of the BI report is daily

+6
source share
2 answers

In ODI on the tab "Topology" and "Substrate of physical architecture" you can see all the technologies that are supported out of the box. MongoDB is not one of them. There are also no knowledge modules for import / export from / to MongoDB.

ODI supports the implementation of proprietary technologies and proprietary knowledge modules. In this guide, you will begin by developing your acquired knowledge module and in one of the other guides , I am sure you can find an explanation of how to implement your own technologies. (Ctrl-F for "Data Integrator")

If you're lucky, you might find someone else who has already implemented it. Your best places to search will be the Oracle Technology Network Technology Forum or the MongoDB-related forum.

Instead of creating a direct link, you can also simplify the workaround. Export data from MongoDB to a format supported by ODI, and MongoDB can extract. CSV or XML maybe? Then upload the data via ODI to the oracle database. I think ... this would be the best option if you don't have to do it often ...

+1
source

Take a look at the blog post below for an option; https://blogs.oracle.com/dataintegration/entry/odi_mongodb_and_a_java

Cheers David

+1
source

Source: https://habr.com/ru/post/915249/

More articles:


All Articles