Oracle Data Integration (ETL for Huge Data)
September 19, 2019

Oracle Data Integration (ETL for Huge Data)

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Data Integrator

We use many Oracle products and Oracle Data Integrator provides a graphical environment to do an overall process unlike other ETL tools in the market. This is simple to connect with Oracle databases and the inbuilt functions/features is very useful to overcome the common issues.

It handles a large quantity of data with ease and is powerful for processing ETL.
  • It has a graphical environment which is easy to understand
  • Lightweight designer which is very easy to view and edit the objects with ease
  • All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.
  • It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are depreciated simply for commercial reasons, although it looks like the cloud option offers some extra connectors.
  • It is not very good for real time data integrations.
  • This is certainly within the budget and able to handle our ETL operations
  • Most of the errors can be monitored and cleared
  • We don't require real time integration but we always wanted the huge data to be processed which is a very good use for us
  • When we use Oracle JDE, EBS, Hyperion with lot of customizations
  • When huge data integrations are needed but there is no need for real time integration
  • Error monitoring required unlike Flat File Integrations which won't have good error monitoring
  • Complementary products like Hyperion are already in place with ODI licenses included