Welcome to All Things Warehouse Builder

  • Press
    November 15, 2013

OWB to ODI Migration Utility released.

Anil Menon
Consulting Technical Manager

The much awaited OWB to ODI Migration utility has been released.

The migration utility is a command-line tool that enables you to migrate design-time metadata from OWB to ODI 12c. The migration utility is provided in patch number 17547241 for your OWB 11gR2 ( installation.

Migration is supported on Linux 64-bit x86 systems only. Before migrating, ensure that the following requirements are met:

  • OWB installed (OWB plus patch number 17547241)

  • ODI installed (ODI plus patch number 17053768)

ODI is Oracle's strategic product for heterogeneous data integration. Because many Oracle Database customers have significant investment in OWB, Oracle supports a phased migration from OWB 11gR2 ( to ODI 12c (12.1.2).

  • ODI 12c supports an easier mapping between OWB 11gR2 concepts and objects and their ODI 12c counterparts. A migration utility is provided that automatically translates many OWB objects and mappings into their ODI equivalents. More information about the migration utility is here


In addition to enabling the migration, the ODI 12c patch also comes

new  components such as Pivot, Unpivot, Subquery filter  and Table

They're documented in the following appendix:

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.