ODI Master and Work Repository Creation Using RCU (OBIEE 11g)

Oracle Data Integrator (ODI) Installation steps are now more easy with Repository Creation Utility (RCU). Double click RCU.bat from the downloaded and unzipped RCU Folder.

Step1:

Oracle Universal Installer checks prerequisites and system requirements and will load the first step of the installation. Just click 'Next' with the Below Screen

Step2:
Select 'Create' and click 'Next' with this screen.

Step3:
In this step, type all the necessary details in the required fields and click 'Next' with this step

Database Type: Oracle Database
Host Name: Bose-PC
Port: 1521
Service Name: ORCL
UserName: sys
Password: Password1
Role: SYSDBA

This step will check the prerequisites. Just click 'OK' once the prerequisites passes

Step4:
In this step check 'Oracle Data Integrator' Component. Type if you want to change the prefix and repository name.

Once we clicked 'Next' with the above screen It will check prerequisites and click 'OK' with the below screen

Step5:
Give the password which you want to give for ODI Work and Master repositories. If you want to give different password, select the appropriate option and click 'Next'

Step6:
This step is an important step so Please keep in your mind or store somewhere all the credentials and details in a file which you are entering here and then click 'Next'

Master Repository ID(001): 001
Supervisor Password: Admin123
Confirm Supervisor Password: Admin123
Work Repository Type: D
Work Repository ID: 101
Work Repository Name: WORKREP01
Work Repository Password: Admin123
Confirm Work Repository Password: Admin123

Step7:
This step will gives the information of ODI Schema name, schema owner and temporary tablespace name. Just Click 'Next' with this step

In this confirmation pop-up, Just click 'OK'

This will create the tablespace and click 'OK' once the steps passes

Step8:
In this step, click 'Create'

Step9:
so ODI Schema creation is completed with the above step. Just click 'Close' to complete the repository creation.

In the next coming post, we will continue to the ODI Installation using this ODI repositories.

Cheers!
Bose