Creating and Connecting to ODI Work Repository

1.	tIf not opened, open SQL Developer. Create the schema/user snpw1 for Work repository by executing the following SQL command: create user snpw1 identified by oracle1 default tablespace users temporary tablespace temp;
2.	Grant connect privileges to the newly created user by executing the SQL command provided below. Verify that user snpw1 was successfully created. Note: You may need to select Other users node and click Refresh icon. grant connect, resource to snpw1;
3.	Now that you created the RDBMS schema/user, use ODI Topology Navigator to create the ODI Work repository. In ODI, click the Topology Navigator tab and then click to the Repositories panel. Right-click the Work Repositories node and select New Work Repository. The Create Work Repository Wizard opens.
4.	In the screen that follows, enter the parameters shown in the following table. Click the Test button. Verify successful connection and click OK. Click Next. Parameter Value Technology Oracle Driver Name oracle.jdbc.driver.OracleDriver JDBC Url jdbc:oracle:thin:@localhost:1521:orcl User snpw1 Password oracle1
1 .	In the Specify Work Repository properties set the ID to “1”. Set the Name to WORKREP1. Enter Password as SUNOPSIS. For Work Repository Type, leave Development. Click Finish.
1 .	In the Create Work Repository Login window, click Yes. Enter the Login name: WORKREP1 as shown on the screenshot. Click OK. Verify that the newly created Work repository is now in the work repositories tree view.
1 .	Now you disconnect from the Master repository and connect to the Work repository. Click ODI menu and select Disconnect "Master Repository".
1 .	Click Connct to Repository. Select “WORKREP1” from the LoginName drop-down list. Enter Password: SUNOPSIS. Click OK. Click the Designer tab. The following ODI Designer screen appears. You have now successfully created and connected to the ODI Work repository.