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.