ODI – cost effective tool for integration purposes
October 11, 2016

ODI – cost effective tool for integration purposes

Federico Shortrede | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Data Integrator

We’re currently using Oracle Data Integrator for integration purposes between legacy systems and eBS, and also to populate a couple of data marts from information in Oracle.
  • For us, it is particularly good for batch loading processes, because it is quite easy to connect different sources.
  • Great for ETL processes, since it allows you to extract data from very different sources, perform some transformation, and load it to your final system.
  • It was not difficult for our technical team to learn and adopt the tool.
  • The main problem for us is that, from time to time, and for reasons we still were unable to discover, ODI loses the connection, and integration processes fail.
  • I think there’s some room to improve the controlling of this process, but I don’t think they will perfect ODI in this way because Oracle has other licensed tools.
  • It quickened our development of interfaces.
  • Allow us to replace some interfaces based on TXT files with direct connection, and thus turning our environment more safe and SOX compliant.
We thought IBM was too expensive and more difficult to use. With Microsoft, since we have our main application running with Oracle DB, we understood it’d be easier for us to work with ODI.

Oracle Data Integrator (ODI) is great for integration between different Oracle data bases, and it also works well taking data from sources like Excel or SQL Server.

We’re not so sure about ODI’s performance when origins are “very far away”, for instance, in different servers connected through an MPLS, or between one “on premise” server with another “cloud server”. But perhaps it is due to lack of knowledge.

Oracle Data Integrator (ODI) Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Data model creation
Not Rated
Metadata management
Business rules and workflow
Not Rated
Testing and debugging
Integration with data quality tools
Integration with MDM tools
Not Rated