Oracle Data Integrator 12.1.3 introduces a new wizard to quickly
create Models. This wizard will not only help you create your Models more
easily, if needed it will also create the entire required infrastructure in the
ODI Topology: Data Servers, Physical and Logical Schemas.
In this blog article we will go through an example together
and add a new Model to access the HR sample schema of an Oracle database. You
can follow through this example using the ODI Getting Started VirtualBox image
which is available here: http://www.oracle.com/technetwork/middleware/data-integrator/odi-demo-2032565.html
The ‘New Model and Topology Objects’ wizard can be accessed
from the Models menu as shown below:
The wizard opens up and displays default settings. From
there we can customize our objects before they actually get created in the ODI
In this example we want to access tables stored in the
HR schema of an Oracle database so we name the Model ORACLE_HR. Note that the
Logical Schema as well as the Schema and Work Schema fields in the Physical
Schema section automatically default to the Model name:
Next we will give a new name to our Data Server:
LINUX_LOCAL_ORACLE since we are connecting to a local Oracle database running
on a Linux host.
We then fill in the User, Password and URL fields to reflect
the environment we are in. To access the HR schema we use the ODI Staging area
user which is ODI_STAGING. This is a best practice and it also ensures that the
Work Schema field automatically gets updated with the right value for the
Note that the wizard also allows us to link a new Model to
an existing Data Server.
Finally we click on Test Connection to make sure
the parameters are correct.
Then we update the Schema field using the
drop-down list to point to the HR schema at the database level.
Our Model is now fully set up, we click on OK to have it
created along with its related Topology objects. The Model ORACLE_HR opens up allowing us to reverse-engineer the tables using the Selective Reverse-Engineering tab:
We pick all the tables and click on the Reverse Engineer button
to start this process and save the Model at the same time. A new Model called ORACLE_HR was created as shown below as well as the appropriate objects in the Topology: