I have recently had a play around with the new Oracle Data Integrator 12c using a pre-developed Oracle VM. I have previously spent two years on a project using ODI 11g, so was more than curious to try out the much hyped 12c, which admittedly has been out for a year now.
The first thing that stood out was the name changes for a large number of tabs and functions. For those of you familiar with ODI 11g, interfaces have now become mappings, and within the new mapping, there is only an overview, logical and physical tab. This is far more self-explanatory and simpler than before.
The whole design, albeit very similar to its predecessor, seems a lot cleaner. However, I always feel that to use ODI efficiently, I need at least a 27inch monitor. There is often so much happening on the screen at once, with various tabs and windows, that it can be painstakingly frustrating to get anything done.
The most striking new feature is the ability to have in and out flows through a mapping. Previously ODI was very linear in design, not allowing splits, joins, sorts, pivots etc. within an interface.
Now each mapping has a component window, allowing many of these features, all of which are available in many other products, including some of Oracle’s own. A very welcome addition, and perhaps the final nail in Oracle Data Warehouse.
It is still a very drag and drop type of tool, but it all seems far more efficient in its design. Whilst I have no doubt there would be some annoyances if I had to use it for the next two years, my initial thoughts are very positive towards this release. I certainly would not have any objections to using this in any data warehouse project.
If you’re interested in having a play with ODI 12c, visit the Oracle website
and follow the download instructions.