Oracle Warehouse Builder on an Oracle 12c Database

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 11.2.0.3 can be used on Oracle 12c databases. However, earlier releases of OWB must be upgraded to 11.2.0.3 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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s