Setting up Multiple ETLs

Previous TopicNext TopicContents

To setup the first ETL:

  1. Install the Reporting Database per instructions in the P6 Analytics and Star Database Installation and Configuration Guide.
  2. Define a filter against Px (see the P6 Analytics and Star Database Installation and Configuration Guide). Set the filter value in your properties file for filter 1. This will be data source 1.
  3. Run the staretl process by running staretl.bat or staretl.sh.
  4. Ensure Star data is using this filter.

To setup the second ETL:

  1. Rename the Reporting Database folder that was installed.

    Note: You can have folders with the same name or you can choose a new name for the folder when you install the second ETL for P6 Reporting Database. Choosing a new name will ensure the installer doesn't try to rename the folder after the install is done.

  2. Install the Reporting Database as you usually would to a new location.
  3. Define a new filter against Px (see the P6 Analytics and Star Database Installation and Configuration Guide). Set the filter value in your properties file for filter 2. This will be data source 2.
  4. Create a second database link for Staruser.
  5. Run the ETL process by executing staretl.bat “-s2” or staretl.sh “-s2”.
  6. Ensure Star data with a data source ID of 2 is using this filter.


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

Last Published Friday, January 31, 2014