Configuring Star to Use SSL to Run the ETL Process

Previous TopicNext TopicContents

"" Currently, the P6 Reporting Database Configuration Utility does not allow the staretl.properties file to be directly configured for TCPS. After it is initially configured for TCP, and after the SSL connection is configured, you must manually configure the P6 Reporting Database so that SSL is used to run the ETL process.

  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.txt -keystore "C:\Program Files\Java\jre1.7.0_XX\lib\security\cacerts"

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

  3. Edit the staretl 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 ERDB_HOME\scripts directory.
  6. Edit the staretl.bat (or staretl.sh)
  7. Add the following variable to the first line of the file:

    For Windows:

    SET PRM_SSL_CONNECTION=Y

    For Linux:

    EXPORT PRM_SSL_CONNECTION=Y

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