Configuring Primavera Data Warehouse to Use SSL to run the STARETL Process

The configuration utility does not allow the STARETL properties files to be directly configured for TCPS. After it is initially configured for TCP and after the SSL connection is configured, you must manually configure each data source in Primavera Data Warehouse so that SSL is used to run the STARETL process.

For each data source, complete the following steps:

  1. Sign in to Primavera Data Warehouse database instance as the schema owner. For example, the STARUSER account.
  2. Update the ETL_PARAMETER table setting for the source tns connection information:

    update etl_parameter

    set p_1 = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=<HOST>)(PORT=<SSL_PORT>))(CONNECT_DATA=(SERVICE_NAME=<SERVICE_NAME>)))'

    where p_feature = 'db.pmdb.tns'

    and datasource_id = 1;

    commit;

    where,

  3. <HOST>: P6 EPPM or Primavera Unifier source database server

    <SSL_PORT>: Default SSL port

    <SERVICE_NAME>: Service name for the P6 EPPM or Primavera Unifier source database instance

  4. Update the ETL_PARAMETER table setting for the data warehouse tns connection information:

    update etl_parameter

    set p_1 = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=<HOST>)(PORT=<SSL_PORT>))(CONNECT_DATA=(SERVICE_NAME=<SERVICE_NAME>)))'

    where p_feature = 'db.star.tns'

    and datasource_id = 1;

    commit;

    where,

    <HOST>: Primavera Data Warehouse database server

    <SSL_PORT>: Default SSL port

    <SERVICE_NAME>: Service name for the Primavera Data Warehouse database instance

  5. If you are not using Oracle Data Integrator (ODI), complete the following steps:
    1. Go to <PDW Install Folder>\star\etl_homes\staretl<id>.
    2. Edit staretl.bat (with Windows) or staretl.sh (with UNIX or Linux).
    3. Add the following variable to the first line of the file:

      With Windows:

      SET PRM_SSL_CONNECTION=Y

      With UNIX or Linux:

      EXPORT PRM_SSL_CONNECTION=Y

      Note: If you are using WebLogic and Primavera Analytics Web Administration Application, you can set this as a system variable in WebLogic instead. Oracle recommends this option if using WebLogic. For more details, see WebLogic documentation.


Last Published Friday, December 16, 2022