Starting with ODI 11g
Installation of ODI consist of two parts
a) Creating repository with RCU
b) Installing ODI software
So to let us finish the first part.
To get some hands on experience on ODI11g, it is better to start install, configure and practice with examples.
1) Download the ODI 11g here
2) Download RCU( Repository Creation Utility) also.
3) Once after the downloading complete, extract the zip files.
4) The first step in the ODI installation is creating repository with RCU.
5) Go to RCU home and then bin folder and run "rcu.bat" file.
6) Welcome window will appear
7) Click next button.
8) Select "Create" radion button and click on "Next" button.
9) Enter the below details.
Database Type: Oracle Database
Host Name : Host name where the database installed.( In my case, oracle database is installed in my local machine. So gave it as "localhost")
Port number : Port number of the database ( generally 1521 )
Note:- Basically you can all these details by running the following command in the command prompt.
cmd> tnsping databasename
Ex:- tnsping mvcdb
Ex:- tnsping mvcdb
Username: User with SYSDBA privileges
Password: Enter the password for the SYS user.
Then click on "Next" button. you will see the below window for checking prerequisites
10) New window will appear to enter prefix for the ODI repository schema. Click "Next".
11) Give the password the newly create schema. Ex:- Admin$1234
12) Give supervisor, work repository password and leave rest of them to default values.
13) It will warn you that while creating seperate tablespace in your database. Click on "Ok" to proceed further.
14) Finally Click on "Create" button to start creating repository.
15) Once after the completion of the repository, Click on close button to exit from RCU.
Note:- Repository is nothing but, a schema with collection of tables to store the metadata.
No comments:
Post a Comment