Oracle Data Integrator (ODI) Review
With the Knowledge Modules, we're able to create our own reusable integration strategies for connecting to RDBMS, Hadoop, cloud services, etc.
What is most valuable?
The EL-T approach that will first load into the target dataserver before doing the transfer is a great architecture improvement compared to standard ETL tools that use a staging area and usually process the data in Java. With ODI, almost all the job is pushed down on the underlying technology, for instance the Oracle database or the Spark server.
The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance.
ODI is really the tool for any kind of integration because it speaks the language of the technology we connect. We can work with RDBMS but also in Hadoop, cloud services, flat files, web services, etc.
How has it helped my organization?
Thanks to the flexbility of the tool, we could build 3 mappings using variables and the substitution API in replacement of 300 mappings in Oracle Warehouse Builder. It's much easier to maintain!
What needs improvement?
- Development Lifecycle
- native REST integration
- Easier security
For how long have I used the solution?
What do I think about the stability of the solution?
A bit unstable and buggy in the 12.1.2 release, but most of it is fixed in 12.1.3, so I would definitely recommend to jump to that version.
Which solution did I use previously and why did I switch?
I used Oracle Warehouse Builder (OWB) which is now at the end of its life. ODI is much more flexible and has the great advantage to be able to connect to a lot of different source or target technologies.
How was the initial setup?
It was quite straightfoward.
We did a migration for Oracle Warehouse Builder to Oracle Data Integrator 12c using the migration tool provided by Oracle. And I've to say I'm surprised to see a migration tool working so well!
What about the implementation team?