By Anil Menon on Nov 15, 2013
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 18.104.22.168 to ODI 12c. The migration utility is provided in patch number 17547241 for your OWB 11gR2 (22.214.171.124) installation.
Migration is supported on Linux 64-bit x86 systems only. Before migrating, ensure that the following requirements are met:
OWB 126.96.36.199 installed (OWB 188.8.131.52 plus patch number 17547241)
ODI 184.108.40.206.0 installed (ODI 220.127.116.11.0 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 (18.104.22.168) 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 Functions.
They're documented in the following appendix: