us-analytics.png
Ask an Expert

FDMEE Tutorial: How to Change the ODI SUPERVISOR Password

During the installation and configuration of Financial Data Quality Management Enterprise Edition (FDMEE), the Oracle Data Integrator (ODI) master repository and agent are installed with a default username of SUPERVISOR and SUNOPSIS. Securing the Oracle Hyperion EPM environment by changing the SUPERVISOR password is not a single step but requires changes in three separate interfaces: FDMEE, ODI Studio Console, and WebLogic / Oracle Enterprise Manager.

 

eBook: Top 10 FDMEE & ODI Tutorials

 

This post will proceed with version 11.1.2.4 of Oracle EPM installed on Windows Server 2012 R2. The steps for 11.1.2.3.X of EPM are the same except for Operating System differences.

1. Log into Workspace.

image-2

2. Navigate –> Administer –> Data Management.

image1-1

3. Select the Setup tab and then System Settings.

image3

4. Select ODI from the Profile drop down.

image50

5. Key the new ODI password for User Name SUPERVISOR and then select Save.

image6

6. After a successful Save, the message “Your changes have been saved” will display. 

image_thumb7

7. To verify the ODI SUPERVISOR password has changed, select “Check ODI Connection," which will display an Error. Select OK to close the error.

image8

image9

8. Select ODI Studio from Apps By Name.

image11

9. Key the User “SUPERVISOR” and the Password “SUNOPSIS,” and then select OK.

image12

10. Select View –>  ODI Security Navigator.

image13

11. Select Users –> Supervisor then right click and choose Open.

image14

12. Select Change password.

image15

13. Key the New Password and then select OK.

image_thumb16

14. Select File –> Save.

image17

15. Select View –> ODI Topology Navigator.

image18

16. Select Agents –> OracleDIAgent and then double click OracleDIAgent.

image19

17. Select Test, which will generate an error. This verifies the password has changed. Select OK to close the Error dialog box.

image20

image21

18. Select Start Admin Server for WebLogic Server Domain from Apps By Name.

image_thumb22

19. Once the Admin Server has started, select Admin Server Console from Apps By Name.

image_thumb23

20. Key the WebLogic Username and Password created during installation and then select Login.

image24

21. Select Oracle Enterprise Manager from Helpful Tools.

image25

22. Key the WebLogic User Name and Password created during installation and then select Login.

image26

23. If the Accessibility Preference dialog box appears, update if needed (the default is displayed below) and then select Continue.

image27

24. Select and expand WebLogic Domain.

image28

25. Select EPMSystem –> WebLogic Domain –> Security –> Credentials.

image41

26. Expand and select oracle.odi.credmap –> SUPERVISOR.

image42

27. With SUPERVISOR selected, click Edit.

image43

28. Key the updated password and then select OK.

image32

29. Return to FDMEE –> System Settings –> ODI and select Check ODI Connection, which will display a successful test of the ODI agent.

image33

image34

30. Return to ODI Console and select ODI –> Disconnect “SUPERVISOR.”

image35

31. Select ODI Connect.

image36

32. Key the User “SUPERVISOR” and Password “Updated One,” and then select OK.

image37

33. Select View –> ODI Topology Navigator.

image38

34. Select Agents –> OracleDIAgent and then double click OracleDIAgent.

image39

35. Select Test, which will generate an Agent Test Successful dialog box. Select OK to close the dialog box.

image40

 

 

FREE eBook: The Top 10 FDMEE & ODI Tutorials

 

Ask an EPM/BI Advisor

If you're here, you've got questions — and we've got answers. Book your consultation to ask us about any range of topics, including:

  • Evaluating EPM or BI technologies
  • Comparing on-prem vs. cloud
  • Planning upgrades and migrations
  • Estimating project costs and timeframes
  • And much more — ask us anything!

Let our experts tackle your toughest questions for you.

Let's Talk