ODI11G:Creating and Connecting to ODI Master Repository


1. Start the SQL Developer by selecting Start > Programs > Oracle-OraDb11g_home1 > Application Development > SQL Developer. When SQL Developer started, close the Logging Page – Log tab.

Screenshot for Step
Screenshot for Step
2 . In SQL Developer, create a new connection.

Screenshot for Step




3. Name this new connection: Administrator. Enter SYSTEM for Username. Enter oracle1 for Password. For SID, enter: ORCL. Clisk Test, and then click Connect. Click “+” to expand connection Administrator.
Screenshot for Step
Screenshot for Step

Screenshot for Step
4. You have to create the RDBMS schema/user (Oracle 11g) for the Master repository. The schemas can be created by executing the following SQL commands:
create user <MY_SCHEMA> identified by <MY_PASS>
default tablespace <MY_TBS> temporary tablespace <MY_TEMP>;
grant connect, resource to <MY_SCHEMA>;


Where:
<MY_SCHEMA> corresponds to the name of the schema that you want to create
<MY_PASS> corresponds to the password that you gave
<MY_TBS> corresponds to the Oracle tablespace where the data will be stored
<MY_TEMP> corresponds to the temporary default tablespace
To create the user snpm1 for master repository, enter the following command. Click Execute statement icon .
create user snpm1 identified by oracle1
default tablespace users temporary tablespace temp;
Screenshot for Step
Note: In this command, oracle1 is the value of password to connect to user snpm1.
5. Grant connect privileges to the newly created user by executing the SQL command provided below. Expand Other Users node to verify that the user snpm1 was successfully created.
grant connect, resource to snpm1;
 
Screenshot for Step

6. In the next few steps you create the ODI Master repository. Start Oracle Data Integrator: Start > Programs > Oracle ODI 11g-Home> Oracle Data Integrator > ODI Studio
Screenshot for Step
7. Open the New Gallery by choosing File > New. In the New Gallery, in the Categories tree, select ODI. Select from the Items list the Master Repository Creation Wizard. Click OK. The Master Repository Creation Wizard appears.
Screenshot for Step
Screenshot for Step

8 . Open the New Gallery by choosing File > New. In the New Gallery, in the Categories tree, select ODI. Select from the Items list the Master Repository Creation Wizard. Click OK. The Master Repository Creation Wizard appears.
Screenshot for Step
Screenshot for Step
9 . In the Master Repository Creation Wizard, select the browse icon of the JDBC Driver and then select Oracle JDBC Driver. Click OK. Edit the JDBC URL to read:
jdbc:oracle:thin: localhost:1521:orcl
Enter the User as snpm1 and the Password as oracle1 . Click the Test Connection button and verify successful connection. Click OK. Click Next on the Master Repository Creation Wizard screen.


Screenshot for Step

Screenshot for Step
10 . In the Authentication window, enter Supervisor Password as SUNOPSIS. Enter SUNOPSIS again to confirm the password. Click Next.
Note: User names and passwords are case-sensitive in ODI.

Screenshot for Step
11 . In the Password Storage window, select Internal password Storage, and then click Finish. When Master Repository is successfully created, you will see the Oracle Data Integrator Information message. Click OK. The ODI Master repository is now created.

Screenshot for Step
Screenshot for Step

12 . You connect to the ODI Master repository by creating a new ODI Master Login. Open the New Gallery by choosing File > New. In the New Gallery, in the Categories tree, select ODI. From the Items list select Create a New ODI Repository login.

Screenshot for Step



13 . Configure Repository Connections with the parameters from the tables provided below. To enter the JDBC URL, click the button next to JDBC URL field and select jdbc:oracle:thin:@<host>:<port>:<sid> as shown in the screenshot, then edit the URL. Select Master Repository only button. Click Test button. Verify successful connection and click OK. Click OK to save the connection.
Oracle Data Integrator Connection
Parameter Value
Login Name Master Repository
User SUPERVISOR
Password SUNOPSIS
Database Connection (Master Repository)
Parameter Value
User snpm1
Password oracle1
Driver List Oracle JDBC Driver
Driver Name oracle.jdbc.OracleDriver
Url jdbc:oracle:thin:@localhost:1521:orcl
Note: Do not copy and paste in the JDBC URL field. This may cause problems with entering a valid URL string. Instead, open the drop-down menu and select the correct driver from the list. Type the correct URL in the URL field.

Screenshot for Step
Screenshot for Step


14 . Click Connect to Repository. Select the newly created repository connection Master Repository from the drop-down list. ClickOK. The ODI Topology Manager starts. You are now successfully logged in to the ODI Topology Manager.

Screenshot for Step
Screenshot for Step
Screenshot for Step

No comments:

Post a Comment