Oracle Data Integrator 11g - Part III (Creating Repositories)

You can find the installation steps of Oracle Data Integrator 11g  in my previous articles. today, I’m going to demonstrate creating repositories , start a new project by using Oracle Data Integrator 11g. 

The first difference is about the user interface. There’s only one interface that you use to connect Topoloy Manager, Designer etc. So when you open the tool, you’ll have to choose the Master Repository. If the repository doesn’t exist, , you’ll have to create the repositories. the first will be “Master Repository”. Just to remind you that all the objects that are created by using Topology Manager Security Manager will be stored in the Master Repository.

When you click the “Master Repository Creation Wizard”, it’s going to ask you to specify the database connection settings in the next 3 pages.

Once the Master Repository is created, you’re going to user Topology Manager to create the Work Repository. Work Repositories should be attached to the Master Repository. So before creating the work repository, you have to connect to Master Repository.

As you’ll see in the previous image, the connection is established. you’ll start to create the work repository from the “Topology Manager”. Again you’ll specify the connection details.

Now you have created both repositories. So you can start using Designer tool in order to start a new project. So you’re going to create the data sources target databases by using “Topology Manager”.

Oracle Data Integrator 11g Installation - Part I (WebLogic Server)

I’m going to demonstrate how to install Oracle Data Integrator 11g in this article. I divided the installation process into 2 parts. First part will be related with Oracle WebLogic Server. I’m going to explain the ODI 11g installation in the second part. So here you are:

You can download the latest version of Oracle WebLogic Server 10.3.3. , start the installation:

, installation wizard will ask you for the Middleware path. So you just specify the installation path. 

Next usual but important question is about your e-mail address for Oracle Support. It’s highly recommended to fill these information in order to receive security updates.

, it’s going to confirm the installation directories.

You’re going to choose the short cut folders for the installation:

you’re going to see the “Installation Summary” page see the details of the installation.  When you click next, installation will start.

You can see the progress of the installation.

After the installation completes, you can trigger the “Configuration Wizard” to create new domain in the WebLogic Server. You don’t have to create a domain in this step. So to skip it, just clear the “Run Quickstart” checkbox.