Configuring ETL Settings

To configure the STARETL process settings for the Primavera Data Warehouse database connection, complete the following steps on the ETL Settings screen:

Note: You can use the default values for most or all of these settings.

  1. In the JRE Location field, enter or verify the path to the Java Runtime Environment (JRE).
    • You must have the appropriate version of JRE installed on the machine where the STARETL process will run. For information on the specific JRE versions and supported operating system configurations, see the Tested Configurations document.
    • The path must refer to a location on the local machine where you are installing the Primavera Data Warehouse Configuration Utility. /
  2. In the Logging Location field, enter the folder location to store the STARETL process logs.
  3. In the Max Java Heap Size (MB) field, enter a value for the Java Heap Size. This value maps to the JVM –Xmx setting in the Java Runtime Environment. The default value (and recommended value) is 1,024 MB.
    • The minimum value is 512 MB.
    • When changing the Maximum Java Heap Size setting, the values must be in increments of 512 MB.
  4. In the General Thread Count field, choose the number of threads the STARETL process will run concurrently. The STARETL extraction and load processes are multi-threaded.

    Oracle recommends keeping the default (5) for this setting.

  5. In the Index Building Thread Count field, choose the number of threads to run concurrently for building the Primavera Data Warehouse schema indexes.

    Oracle recommends keeping the default (5) for this setting.

  6. In the Partitioning section:

    Database partitioning is a powerful functionality that allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity.

    1. Select the Enable Partitioning option to use partitioning.

      Notes:

      • While Oracle recommends a partitioned environment, Primavera Data Warehouse also supports non-partitioned environments with Oracle Database Standard Edition or Enterprise Edition. If you choose not to enable partitioning, Oracle recommends that you NOT use activity or WBS level history gathering. Furthermore, by not enabling partitioning, you are unable to have multiple P6 EPPM and/or Primavera Unifier instances (multiple data sources) as the source of data for a single Primavera Data Warehouse instance. For more information on database requirements and partitioning, see the Primavera Analytics Planning and Sizing Guide.
      • The use of Oracle Database partitioning requires an additional license. Please contact your Oracle account representative to ensure that proper licensing is in place prior to implementing partitioning.
    2. In the Datasource ID field, enter the number of data sources that you will use in the Primavera Data Warehouse environment.

      Data sources refer to the database(s) (P6 EPPM and/or Primavera Unifier) that will be used as the source of data for Primavera Data Warehouse. The maximum value for this setting is 99. Set this value to your anticipated number of data sources, since once this value is set it is difficult to increase in the future. However, it is not recommended that set this value to 99, if you do not anticipate having 99 unique data sources, as this can negatively impact performance and configuration in the future. The default value is 10. This means that you can have up to 10 data sources (P6 EPPM and/or Primavera Unifier) by default.

      Note: Oracle recommends changing this setting to at least 10, which is the lowest recommended value.

    3. In the Months per Partition field, enter the number of months for which data will be accumulated in a single partition before a new partition is used.

      For example, if the Months per Partition value is 3, data will accumulate in a single Primavera Data Warehouse partition for three months before the next partition is used. Having a smaller value in this setting means you will have more partitions, but data access and STARETL performance will be faster. The default value is 1. Oracle recommends the default value for a fast growing history partition.

  7. In the Action Links section:
    1. In the P6 URL field, enter the URL of the P6 application in the format: http://<host name:port>/p6
    2. In the UNIFIER URL field, enter the URL of the Unifier application in the format: http://<host name:port>/unifier
  8. Click Next.

Legal Notices | Your Privacy Rights
Copyright © 1999, 2021

Last Published Monday, December 13, 2021