ODI11g: Creating and Connecting to ODI Work Repository

This Article present Creating ODI11G: Work repository, At previous post i mention Master Repository So lets Create Work Repository On it.

         Work Repository: Organization and project Repository. Keeping information about working on server or clients. Also Data project and models keeping here.

Step by step Creating Work Repository 

First create ODIW user and give password (for example: "veysi")

SQL> create user ODIW identified by veysi;

Grant dba privile to user

SQL> grant dba to ODIW;

NOTE:  Now remember ODIM user for Master, ETL for System And ODIW user for Work user.

Open the ODI

Log in with Master Repository

Click New(+) and write requisites informations.

Log in Name: Whatever you want

SUPERVISOR:Supervısor and password did you give

USER:Master User(ODIM)

Drive list: Oracle jdbc Drive 

Drive Name: oracle.jdbc.OracleDriver (Connect Oracle  Host JDBC)

URL: Would you like to connect Database jdbc:oracle:thin:@ 

You can Test Your Connection and Click Ok 

Click Ok

Now its ready for doing Any job. Click Work Repository

You will see the Master Repository connection information. Click Next

Write ID between 1-998 and write name(whatever you want)  Choose Work repository Development and Click Finish

ODI is creating your work

Click Yes

Choose created work click Ok

 It Now Ready you can test it and click ok

Now have a nice work :)