Configuring ODI

Oracle Data Integrator provides a new declarative design approach to defining data transformation and integration processes, resulting in faster and simpler development and maintenance. Based on a unique “E-LT” architecture

Figure 1(a): ODI Components Structure
After installation ODI you will find the following components Start->All programs->Oracle->

Oracle Data Integrator

Figure 3: ODI components

Step1: We have to create Repository by using Master Repository Creation (Start Menu->Oracle->ODI->Repository Management->Master Repository Creation)

Figure 4: Master Repository creation

Now have our Master repository created so we can move on into the topology manager

Step 2:

The topology manager lets you manage all your technologies such as Oracle, Essbase.In ODI terms we will call it as Data Server. When you start up the topology manager you have to connect to a Master Repository;

Click the new button when the security repository connection window opens

Figure 5: Topology Manger Configuration

Step 3:

Next, we need to set up the work repository and you guessed it yet more entering of the connection details. There is a tab at the bottom of the topology manager with “AB” on it that means repositories.

Figure 6: Inserting Work Repository

Step 4: Click on Insert work Repository and give your data base credentials

Figure 7: Inserting new Data server

Figure 8: Work Repository Definition

Step 5: To connect to a work repository, launch the Designer module by directly clicking on Topology Manger->Windows->Open Module->Designer or else you can directly get from installation Components (Start Menu)

Figure 9: Configuring Designer to our work repository