Oracle Data Integrator-Installation

Oracle Data Integrator 11.1.1.7.0 (ODI) RCU

Installation

Installing a Database

Oracle Data Integrator stores information in a repository that is stored in a database schema. The Repository Creation Utility (RCU) is able to create the schema and the repository in the database. RCU supports Oracle, Microsoft SQL Server and IBM DB2 databases and supports the installation of a Master Repository and Work Repositories into a single schema.

Before we starting the installation of RCU, we need to choose that which database we are going to use in our application. Here I am giving how to run RCU in Oracle database on our local machine. It is good to install Oracle Database Enterprise Edition to take full advantage of database for data types like spatial data or features like OLAP.

Prerequisites:

Here I am giving the installation steps that how I have installed RCU in my windows 32bit Operating system. If you have 64 bit OS, no worry the steps are same.

    Minimum of 4GB RAM required, 3 GB RAM would work but, system would be slow.

    Minimum of 10GB hard disk memory required.

    Do not use any directory name with space while installing/working with Oracle DB and OBIEE 11g.

Using RCU to Create the Database Schema

Oracle Data Integration 11g (11.1.1.7.0) is now standardized with Oracle Fusion Middleware and hence leverage database for metadata storage just like any other middleware product. So here we are going to install ODI 11g metadata schema on oracle database you just installed and configured. Same process can be leveraged to install metadata schema on other supported databases as well.
If you have not done already, please download RCU installation files from below URL:

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1923016.html

Locate Required Additional Software's:

Please make sure all the zipped files have downloaded correctly and unzipped into a single folder and no any spaces in the folder path where setup files are located..

Now we will start the installation of metadata schema using Repository Creation Utility (RCU).

From unzipped folder for RCU, run rcu.bat file to start the Repository Creation Utility: 

For this practice, rcu.bat file is located under E:\Softwares\ODI\rcuHome\BIN directory.

Step 1. RCU utility will launch the GUI based wizard to guide you through the steps. Click Next to continue.

Step 2. Select Create from the below screen and click Next.

Step 3. In the below step Make sure database type is Oracle Database and enter following information to continue.

Step 3.1. Since we are using oracle database, RCU will show a warning message that you can just ignore and can continue the installation.

Step 3.2. Click OK to continue once RCU validates and initializes database configuration.

Step 4. In the next step it will ask for the prefix to create the metadata schema. By default, it is showing 'DEV'. If we want to change the prefix we can  change it. From the below window select appropriate schema which we need to install. I have selected only two which is showing in the screenshot.

Step 5. Click 'Next' from the above screen to create schema and the click 'OK' once RCU shows schema creation prerequisites check completed.

Step 6. In the next step, Enter password for both the schema as you like with the password conditions (such as alphabet, numeric and with special character) and click 'Next' to continue.

Step 7. On the Custom Variables screen, provide the following information as described as follows,

Master Repository ID: A specific ID for the new Master Repository. Master Repository ID values must be between 0 and 899. Default value is 001.

Supervisor Password: Password of the Supervisor user. You must confirm this password on the following line.

Work Repository Type:

Specify how the Work Repository will be used:

·                     Use Development (D) for creating a development repository. This type of repository allows management of design-time objects such as data models and projects (including interfaces, procedures, etc.) A development repository also includes the run-time objects (scenarios and sessions). This type of repository is suitable for development environments.

D is the default work repository type.

·                     Use Execution (E) for creating an execution repository: This type of repository only includes run-time objects (scenarios, schedules and sessions). It allows launching and monitoring of data integration jobs in Operator Navigator. Such a repository cannot contain any design-time artifacts. Designer Navigator cannot be used with it. An execution repository is suitable for production environments. 

Work Repository ID: A specific ID for the new Work Repository. Default value is 001.

Work Repository Name: A unique name for the Work Repository. Default is WORKREP.

Work Repository Password: Provide a password for the Work Repository.

Step 8. Click 'Next' with the above step to have RCU create the selected schema.

Step 8.1. Click 'OK' to continue creation of tablespace.

Step 8.2. Once tablespace created, click 'OK' to continue.

Step 9. Now RCU will create required schema objects within the tablespace just created. So Click 'Create' with next step and continue.

Step 10. Click 'Close' to finish RCU wizard once schema are created successfully.

 With the above step the installation of RCU is completed.

Note:
Remember the password which we have given for all the users/schema so far and we will continue to use the same password. We will need this password for ODI installation as well to let ODI installer knows where the metadata schema located and what is the password to connect to the schema. Now we can log-in to the oracle database and can whether this schema (DEV_ODI_REPO) is available.

ODI 11g Step by Step Installation

Prior to the installation of ODI, It is necessary to Install Java JDK1.6 or above.

Unzip the downloaded software and double click one setup.exe. In Universal Installer screen, It may prompted for Java location to continue the installation. So copy Java path and right click on this window bar -> mark ->paste to paste the path

Step1:

Just click 'Next' with the below step

Step2:
If you have valid oracle support id then select second option with this step and enter the details so that the latest updates would be updated automatically. otherwise select 'Skip Software Updates' and click 'Next'

Step3:
If you are installed 'OBIEE 11g' in the machine then select all the components with this step so one of step you will be prompted to select middleware home. but here I have just installing ODI without Middleware path

Step4:
Once the prerequisites passed with this step click 'Next'

Step5:
In this step, we could see the default path where ODI will be installed. If we want to change, we could do where we could install ODI

Step6:
We have already created Repository using OBIEE 11g RCU. so select 'Skip Repository Configuration' and then click 'Next'

Step7:
In this step select database type, connection string, db user name and password and then click 'Next'

Step8:
In this step enter SUPERVISOR passoword 'Admin123' and then click 'Next'

Step9:
In this step, work repository which we have created using RCU would be selected. If not select in this step and click 'Next'

Step10:
Give the Agent Name that you want to create with this installation and then click 'Next'
Agent Name: ODIAgent
Agent Port: 20910

Step11:
In this step uncheck receiving my oracle support and click 'Next'

Just click 'Yes' with this popup window

Step12:
This step save ODI path details if you want or just click Install

Installation Progress

After configuration progess reached 100% click 'Next'

Just click 'Finish' the complete ODI Installation

Now go to All Programs -> Oracle -> Oracle Data Integrator -> ODI Studio and click 'Connect Respository' and enter details like below screen

We have connected with ODI Repository in ODI Studio