ODI 12c – New Features
The release of Oracle Data Integrator (ODI) 12c has seen a number of changes to this ETL tool from its previous release (11g). Some of the changes include:
These are welcome technical improvements but what effect will these changes have on Business Intelligence and Enterprise Performance Management solutions from the business point of view?
ODI 12c interface showing a sample mapping
One of the biggest improvements to ODI 12c is parallel execution of integration. This means that data load times will reduce (depending on how the integration process is set up) and therefore data will be available quicker and at more frequent intervals. Additionally, this means that mappings and other tools that are used in multiple processes can be used concurrently. This does come with a cost though as CPU and memory usage will increase during the load.
Additional integration features have been developed to allow Oracle Warehouse Builder jobs and processes to be run from ODI 12c. This will allow ODI to become a unified data warehouse and ETL management tool in the future.
Oracle Enterprise Manager, which is used to monitor BI applications such Oracle Business Intelligence EE, Oracle Business Intelligence Applications and Hyperion Planning has now been configured to allow management of ODI 12c. This allows for a single monitoring point to be created across your BI and EPM applications and it will allow for quick identification of any issues that can occur and less time spent troubleshooting ETL environment issues.
Further information on Oracle Data Integrator 12c, click here.