Author: - Sanjay Purohit
Audience: Hyperion Solution
Architects and Hyperion Techno-functional
Oracle acquired Sunopsis in October 2006 and is improving the product (ODI) day by
day; however, the foundation of the product remains the same. The one
surprising fact is the default login name and password of ODI. The default login name
is SUPERVISOR and password is SUNOPSIS. Oracle engineering could not change it
and I really don’t understand the logic as to why. Now the ODI is integrated,
or you could say, it is a part of FDMEE on EPM 11.1.2.3 suites. Oracle
engineering has done a tremendous amount of work to build a bridge between ODI
and FDMEE. The configuration process of FDMEE creates master and work
repositories and deploys an agent to web logic domain. The process of creating
master/work repositories and web-logic agent is pretty simple. The EPM configuration process also creates a
default login name and password and guess what?!! The default login name is
SUPERVISOR and password is SUNOPSIS. The purpose of this document is to change
the default password of ODI configured with FDMEE. Changing the password is a two-step
process.
- The first step is to change the password from ODI console.
- The second step is to change the password from Enterprise Manager.
We will cover both of these areas in this post. The First Step is:-
1. Changing the
default password from ODI console:
i.
Login to ODI console by
Program>Oracle Data Integrator>ODI Studio
ii.
Click on Connect to Repository and login with Default login name
and password
iii.
Default login name = SUPERVISOR and password is SUNOPSIS
iv.
Go to Security Tab>Double click on users “SUPERVISOR”
v.
Click “Change Password
“
vi.
Enter new password and Click on “OK”
Step-By-Step instructions to change password from ODI studio:
i.
Login to ODI console by
Program>Oracle Data Integrator>ODI Studio
Click on Connect to Repository and login with
Default login name and password
Go to Security Tab>Double click on users “SUPERVISOR”
Click “
Change Password “
Enter new password and click Okay.
1. Changing password
from Web-logic/Enterprise Manager:
i. Login to Enterprise Manager by URL http://ServerName:7001/em/
ii. Click on Farm_EPMSystem>WebLogic Domain>EPMSystem.
iii. You must highlight EPMSystem>Right click and
then>Security>Credentials.
iv. Highlight SUPERVISIOR>click on Edit and enter your new
password.
v. Enter new password and save.
vi. Log to Hyperion Workspace and click on “Check ODI Connection”
·
Step-By-Step instructions to change password from Enterprise
Manager:
Click on Farm_EPMSystem>WebLogic Domain>EPMSystem.
You must highlight EPMSystem>Right click and
then>Security>Credentials
Highlight SUPERVISIOR>click on Edit and enter your new
password.
Enter new password and save and you are DONE
Log to Hyperion Workspace and click on “Check ODI Connection”