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 - Part II

After a long time, I realized that I don’t write any articles in blogs. :) Ok let’s say it was just a break now I’m back. Actually I wasn’t in holiday. Just completely busy days which is about delivering trainings in somewhere Europe also in my home country Turkey.

So I’m going to continue for the installation of Oracle Data Integrator 11g. After you download the the insallation files, as usual you just run setup.exe file. At that time you’ll see welcome page: 

, you’ll have to select the installation type by choosing components: 

After the prerequisite checks, you specify the installation location:

The next page is about the repositories. I’m going to discuss them in my next article. But repositories will be needed to develop a ETL project. So you may create a new master work repository or you may use the existing repositories. In my scenario, I’m going to skip the repository configuration I’m going to configure both just after the installation.

So I select the skip option the summary page comes up.

At the end, you’ll see the “Installation Completed” page. 

the first screen of Oracle Data Integrator 11g. The next coming step will be about creating master work repositories.