ODI11g: Creating and Connecting to ODI Master Repository

Today I'll preset ODI Creating Master Repository, During My practice at OraTech i used to ODI

So what does it mean Repository? Repository is data center of ODI that keep all of works. We need a Master repository and "n" Work Repository before we have started.

Master Repository: Keep information of installation and Sources, Targets,Security and version. On every project should be at less one Master repository or sometime more than one.

        ETL: E-LT(Extract-Load & Transform ) Data  transformation and integration . Etl takes  data's from source system to Data warehouse. 

Step by Step creating Master Repository

1. Create prerequisite users..

Create “ETL” user and password. (for example”veysi”)

SQL> create user ETL identified by veysi;

Give ETL user DBA privilege.

SQL> grant dba to ETL;

Create “ODIM” user and password. (for example:”veysi”)

SQL> create user ODIM identified by veysi;

Give ODIM user DBA privilege

SQL> grant dba to ODIM;

So,Lets start. first keep going on path and run ./odi.sh

Its Opening

Click File>New

Choose Master Repository Creation and click OK

Technology: Default Oracle  (Master Repositori host)

JDBC Driver: oracle.jdbc.OracleDriver (Oracle connect to Host JDBC)

JDBC URL: jdbc:oracle:thin:@ (Connection to Oracle  database  Host,post and Sid information)

Note: Host and  sid could known by using V$instance parameter.

USER: ODIM (Master Repository  user)

Password: veysi (ODIM user password)

DBA USER: ETL (system user)

Password: veysi (ETL password)

NOTE: ID should be different with others  Master Repository ID

Click Test Connection and test your connection

So, Mine was successfully :)

Give Supervisor Password and click next

Choose Internal Password Storage and Click finish

Master Repository is creating, wait for a while :)

So that was Successful

Now You can login and create Any work Repository for projects.

Next Post is Work Repository just keep following ;)