INSTALLATION DOCUMENTS BY RAVI

Sunday, April 16, 2017

Step by step installing fusion middleware infrastructure , odi 12c and creating master and work repositories and setting up topology on windows system

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
Select the Driver and click OK















Specify the JDBC Url





























Click ‘Test connection’ to test the connection








































































No comments:

Post a Comment

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...