Installing Infra Structure for odi 12c 12.1.3.0.0
click next
specify the path for oracle home and click next
click next
click next
uncheck and click next
click install
click next
click finish
Installing ODI 12c
click next
click next
select enterprise installation and click next
click next
click install
click next
click finish
Creating Master and Work Repositories schemas Manually
Creating Repositories in ODI
Creating Master Repository
Start ODI Studio
click on file and click on new
select create a new master repository and click ok
Provide the database and schema details and click on test connection
click ok
click next
Provide the password for supervisor user and click next
click finish
click ok
Connecting to Master Repository
select create a new odi repository login and click ok
provide all the details and click test
click ok
click ok
If you want to store the password in secure wallet select option store password in secure wallet and provide a password for the wallet and click ok
otherwise select store passwords without secure wallet and click ok
Enter the login details and click ok
Creating Work Repository
In the technology tab under repositories section right click on work repository and click new work repository
give the database and work repository details and click test connection
click ok
click next
click finish
click no
Connecting to Work Repository
give all the details
select work repository and click on search
select odi work repo and click ok
click test
click ok
click ok
click ok
Setting Topology In ODI
Go
to Topology> Context
Click
New to create a new context
Specify
the Name of the context
Example:
DEV
Go
to TOPOLOGY > TECHNOLOGIES > ORACLE
Create
a New Data Server
Specify
the Data server Name and connection details in definition tab
In JDBC
tab Click on 
icon
icon
Select
the Driver and click OK
Specify
the JDBC Url
Click
‘Test connection’ to test the
connection
No comments:
Post a Comment