CREATING AND CONNECTING TO ODI MASTER AND WORK REPOSITORIES (Manually) Part II
Use case Scenario:
Om works as a database administrator for Demo Solutions. In
Demo Solutions, Om is responsible for performing database management and
integration tasks on various resources within the organization. In particular,
Om is responsible for data loading, transformation, and validation. To set his
ODI environment, he needs to set up the security with his OD and create Master
and Work repositories.
Background:
The first steps to setting up Oracle Data Integrator are to
create database users for the Master and Work repositories, then create the
Master repository, connect to the Master repository, create the work
repository, and then connect to the Work repository.
In this practice, you first use SQL Developer to create the
database users for the Master and Work repositories. Then, in ODI you create
and connect to the ODI Master Repository and the Work Repository.
Note: These are
practice repositories. In later lessons, you use other Master and Work
repositories that are partially predefined with source and target objects.
 |
 |
YOUR TASKS:
1)
The RDBMS (Database) used in this practice is
Oracle 11g. To connect to your RDBMS, perform the following steps:
Step
|
Screen/Page
Description
|
Choices &
Values
|
a.
|
MS Windows
|
Start the SQL Developer by selecting Start >
Programs > Oracle-OraDb11g_home1 > SQL Developer.
|
b.
|
Oracle SQL Developer
|
In SQL Developer, click "+"
to expand the connection Administrator. In the window that follows, enter system in the Username field, password
in Password field, and then click OK.
|
Step a.
Step b.
Username: system
Password:
password
2)
Create the RDBMS schema or user (Oracle 11g) for
the Master Repository.
Step
|
Screen/Page
Description
|
Choices or Values
|
a.
|
Oracle SQL Developer
|
1. Click on right
pane and enter the command ending with semicolon: without the quotes " create user snpm1 identified by password
default tablespace users temporary tablespace temp; "
Note: find this command in text file named Lesson1.txt located
at: C:\CLASSFILES\Text folder
2. Enter this command
and then click the Run button.
Note: In this command "password" is the value of password
to connect to user snpm1.
|
b.
|
Oracle SQL Developer
|
Grant connect privileges to the newly
create user by executing the following SQL command:
Grant connect, resource to snpm1;
|
c.
|
Oracle SQL Developer
|
Expand the Other
Users node to verify that user snpm1 was successfully created.
|
Step a.
Step b.
Step c.
3)
Create the ODI Master Repository:
Step
|
Screen/Page Description
|
Choices & Values
|
a.
|
MS Windows
|
Start Oracle Data
Integrator: Start > Programs >
Oracle > Oracle Data Integrator > ODI Studio.
|
b.
|
Oracle Data Integrator
|
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.
|
c.
|
Master Repository
Creation Wizard
|
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:@odi:1521:orcl
Enter the User as
snpm1 and Password as password. Click Test
Connection button and verify successful connection. Click OK. Click Next on the Master
Repository Creation Wizard screen.
|
d.
|
Master Repository Creation Wizard
|
In the Authentication window, enter
the Supervisor Password as password.
Enter password again to confirm the
Password.
Click Next.
Note:
User names and passwords are case-sensitive in ODI. Provide DBA User : system
with Password as password if required.
|
e.
|
Password Storage
|
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.
|
f.
|
Message
|
Verify that ODI Master Repository was
created successfully, and then click OK.
|
Step
a.
Step
b.
Step
c.
Step
d.
Step e.
Step f.
4) Connect
to the Master Repository by creating a new ODI Master Login:
Step
|
Screen/Page Description
|
Choices or Values
|
||||||||||||||||||||||||||
a.
|
Oracle
Data Integrator
|
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.
|
||||||||||||||||||||||||||
b.
|
Repository
Connections
|
Configure the
repository connections with the parameters from the following tables. To
enter the JDBC URL, click the button next to the JDBC URL field and select jdbc:oracle:thin:@<host>:<port>:<sid>,
as shown in the screen, then edit the URL.
Select the Master Repository only button. Click
the Test button. Verify successful
connection and click OK. Click OK to save the connection.
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.
Note: The ODI user name (SUPERVISOR)
is case sensitive.
|
||||||||||||||||||||||||||
c.
|
Oracle
Data Integrator
|
Click
Connect to Repository. Select the
newly created repository connection, Master,
from the drop-down list. Click OK.
The ODI Topology Manager starts. You are now successfully logged in to the
ODI Topology Manager
|
||||||||||||||||||||||||||
d.
|
Import-Service Description
|
Click the Topology tab. Click the Repositories tab in the left panel of
the Topology Manager. Verify that your newly created Master repository is in
the Repositories window.
|
||||||||||||||||||||||||||
Step a.
Step b.
Step c.
Step d.
5) Use
SQL Developer to create RDBMS schema/user for the Work repository
Step
|
Screen/Page
Description
|
Choices or Values
|
a.
|
Oracle SQL Developer
|
1. Click on right
pane and enter the command ending with semicolon: without the quotes " create user snpw1 identified by password
default tablespace users temporary tablespace temp; "
Note: find this command in text file named Lesson1.txt located
at: C:\CLASSFILES\Text folder
2. Enter this command
and then click the Run button.
Note: In this command "password" is the value of
password to connect to user snpw1.
|
b.
|
Oracle SQL Developer
|
Grant connect privileges to the newly
create user by executing the following SQL command:
Grant dba, connect, resource to snpw1;
|
c.
|
Oracle SQL Developer
|
Expand the Other Users
node to verify that user snpw1 was successfully created.
|
Step a.
Step b.
Step c.
6)
Now that you created the RDBMS schema/user, use
ODI Topology Navigator to create the ODI Work repository:
Step
|
Screen/Page
Description
|
Choices &
Values
|
||||||||||
a.
|
Oracle Data
Integrator
|
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
|
||||||||||
b.
|
Specify ODI Work Repository Connection
Properties
|
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.
|
||||||||||
c.
|
Specify Work
Repository properties
|
In the Specify Work
Repository properties panel, set
Click Finish. Verify that the newly created
Work repository is now in the work repositories tree view.
Note: The Development
type of repository enables management of design-time objects such as data
models and projects (including interfaces, procedures, and so on).
A development repository includes also the
run-time objects (scenarios and sessions). This type of repository is
suitable for development environments.
|
||||||||||
d.
|
Create Work Repository Login
|
In the Create Work Repository Login window,
click Yes. Enter the Login name: Work
Repository, as shown in the screen. Click OK
|
||||||||||
e.
|
Oracle Data
Integrator
|
Verify that Work
repository WORKREP1 was created
and is shown under the Work Repositories node.
|
Step
a.
Step
b.
Step
c.
Step
d.
Step e.
7)
Disconnect from the Master repository and
connect to the Work repository:
Step
|
Screen/Page
Description
|
Choices &
Values
|
a.
|
Oracle Data
Integrator
|
Click the ODI menu
and select Disconnect “Master”.
|
b.
|
Oracle Data Integrator
|
Click “Connect To Repository”.
|
c.
|
Oracle Data
Integrator Login
|
Select “Work Repository” from the Login Name
drop-down list. In the Password field, enter password. Click OK. Click the Designer tab. The following ODI
Designer screen appears. You have now successfully created and connected to
the ODI Work repository.
|
d.
|
Create Work Repository Login
|
In the Create Work Repository Login window,
click Yes. Enter the Login name:
Work Repository, as shown in the screen. Click OK
|
e.
|
Create Work
Repository Login
|
Click ODI menu and
select “Disconnect Work Repository"
|
Step
a.
Step
b.
Step
c.
Step
d.
