Enabling SSL with Oracle Data Relationship Management

Launch IIS on Windows server and and select “Server Certificates”

Select Create Certificate Request

Complete the certificate request with the requested information as indicated in the next two slides

Select appropriate provide from the drop down list

And click next. This will send SSL certificate request to network SSL administrator. Admin needs to create SSL certificate and import the server. 

Select “Default Web Site” and then click on Bindings

Select Site Binding Type and SSL certificate and click ok

After importing select highlighted SSL Settings

Check "Require SSL" and Ignore Client Certificates

Go back to Default Web Site and press Restart.  You are done !!  SSL configuration with DRM is complete. 

Five Easy Steps of Creating Custom Hyperion Stop/Start Script on Windows Server

Enterprise Performance Management (EPM) comes with default start and stop scripts. Stopping and starting services is easy task in single server installation. But this task can be tedious in multi node environment.  System admin needs to go to each server and start/stop services. This may lead a need of master start/stop script which can communicate across servers and start/stop services.

By following this blog you should be able to create your own custom EPM start and stop script. I will also demonstrate the use of variables in batch scripts. 

  Open a notepad (I personally prefer notepad ++ or Ultra edit) start typing

Section #1 (descriptive section):- You may write any instructions about the script. This section does not execute any command

  Section #2 (Variable Section):- This section is being used to define variables. I have defined few variables such as

§  ScriptLogDir=C:\Oracle\AutomationFolder\Logs

§  SET ScriptLogFile="%ScriptLogDir%\StartServices.log"

§  SET HypServer_01= Server 1 name

§  SET HypServer_02= Server 2 name

§  SET HypServer_03 = Server 2 name

 Section #3 (Custom Log Location):- I also like to see the logs of my custom script. This section is being used to defined custom log location and back up with data stamp

 Section #4 (Windows Service Name):- I am using windows sc \\servername start "HyS9CALC_epmsystem1" command execute the Hyperion related service. You may also use “net start <service_name>".  SC can remotely login to another Windows server and execute services

Section #4 The final should look like this

Related helpful Url

https://epmvirtual.com/library/5/Using-Batch-Files-to-Start-and-Stop-Hyperion-Services.html

Required Setting for FDMEE to Work with SSL

• Please note:- Following setting should be applied in OHS/Foundation Server
• Please go to following location

o  E:\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component

o   Make a back copy of ssl.conf file

o   Shut down OHS server using stopOHS.bat

o   Add following lines in ssl.conf file

include "conf/mod_wl_ohs.conf"

include "conf/epm_online_help.conf"

include "conf/epm_rewrite_rules.conf"

include "conf/epm.conf"

        your file should look like below given images