Configuring ODS to Use SSL to Run the ETL Process

Previous TopicNext TopicContents

To configure ODS to use SSL:

  1. Using the wallet manager or OraclePKI:
    1. Export the trusted certificate that is on the server.
    2. Copy it to the client where you installed P6 Reporting Database.
  2. On the client machine, import the certificate using the keytool. For example:

    C:\Program Files\Java\jre1.7.0_XX\bin>keytool -importcert -file C:\wallets\server_wallet\cert -keystore "C:\Program Files\Java\jre1.7.0_XX\lib\security\cacerts"

    where XX is the version of JRE that is supported in this release. See the Tested Configurations document.

    Note: The default password for the Java default keystore file JAVA_HOME/lib/security/cacerts is changeit.

  3. Edit the odsetl properties file as follows:
    1. Replace all occurrences of the default port number with the number of the SSL port.
    2. Replace all occurrences of PROTOCOL = TCP with PROTOCOL = TCPS.
  4. Go to the installation directory \etl\common\ folder and run the runSubstitution.cmd file to update all files with the new port number and TCPS setting.
  5. Go to the installation directory \scripts folder.
  6. Edit the odsetl.bat (or odsetl.sh).
  7. Add the following variable to the first line of the file:

Related Topics

Configuring the Secure Sockets Layer

Configuring the SSL Connection



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014