Oracle Database 12c Release 1 is available since a few hours. One important question for many data warehouse and ETL developers is: What happens to Oracle Warehouse Builder (OWB)?
As mentioned earlier in this blog and described in Oracle’s Statement of Direction, no major enhancements are planned for OWB after release 11.2, but Oracle Warehouse Builder will be supported with Oracle 12c. What does this mean now?
The brand new Oracle 12c documentation contains more precise information now: Oracle Warehouse Builder is not installed as part of the database software in 12c, but OWB 220.127.116.11 can be used on Oracle 12c databases. However, earlier releases of OWB must be upgraded to 18.104.22.168 to run in an Oracle 12c environment. Further details are explained in the Oracle Database Upgrade Guide 12c Release 1.
In the Statement of Direction, Oracle recommends to existing OWB users: “…continue to invest in OWB until the release of ODI 12c.” Oracle Data Integrator (ODI) 12c is not yet available, but I guess there must be several enhancements (and a feasible migration path) to make OWB developers happy. I’m looking forward to the new version of ODI, but in the meantime, there is no hurry to migrate from OWB to ODI.