Overall Satisfaction with Oracle Data Integrator
Oracle Data Integrator (ODI) enabled us to assist our customers loading their data warehouse and get insights from their data both in batch mode or in real-time. We helped customers in various fields: finance, gambling, telecom, transportation, education etc.
- 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.
- Continuous integration is missing and would be a really nice feature to enforce a good development lifecycle.
- Better handling of files and folders, to be able to easily go through all the files of a folder.
- Security setup is not easy to maintain.
- 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.
ODI is the naturel successor of OWB, adopting the same EL-T approach but supporting a lot more technologies as source and target. The overall product is much more stable and not tied to the Oracle Database.
Unlike Informatica, ODI generates all the code in the native underlying technologies used for source or target. This makes it easier to develop and usually faster to load.
Unlike Informatica, ODI generates all the code in the native underlying technologies used for source or target. This makes it easier to develop and usually faster to load.