ODI snippets: Converting a temp interface to a regular interface

October 31, 2010

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes
Amongst other things, temp interfaces in ODI are a great way of prototyping data flows.
However, what if you want to convert a temp interface from a prototyping exercise to something more permanent? This is actually quite easy, just follow the steps below.
1. Create a temp interface by dragging and dropping columns from your source datastore to the target. Execute this interface to physically create the table in your target technology.
2. Reverse engineer the target datastore from your target technology.
3. Drag and drop the datastore reverse engineered in step two into the target area of the temp interface. Your temp interface now will become a regular interface.
As easy as pie