Configuring ETL Settings for Star

Previous TopicNext TopicContents

On the ETL Settings screen:

  1. In the JVM Location field, enter or verify the path to the Java Virtual Machine (JRE path).
  2. In the Log Detail Level field, choose the level of logging detail that you want to use. The following are the logging detail levels you can choose:
  3. In the Max Java Heap Size (MB) field, enter parameter for the Java Heap Size. This value maps to the JVM –Xmx setting in the Java Runtime Environment settings. The default value (and recommended value) is 1,024 MB.
  4. In the General Thread Count field, choose the number of threads the ETL process will run. 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 that will build the index. It specifies how many threads to run for building indexes for the ODS or Star database.

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

  6. In the Partitioning section:
    1. Select the Enable Partitioning option to use partitioning.

      Notes:

      • While Oracle recommends that you use a partitioned environment, P6 Reporting Database also supports non-partitioned environments with Oracle Database Standard Edition or the Enterprise Edition. If you choose not to use partitioning, Oracle recommends that you not use activity and WBS-level history gathering. Multiple P6 instances for Star are not supported without partitioning. For more information on database requirements, see the P6 Analytics and P6 Reporting Database Planning and Sizing Guide.
      • If you implement partitioning, you must license the Oracle Database partitioning option. Your Oracle account representative is always your best source for licensing details.
    2. In the Datasource ID field, enter the number of data sources that you will use in the Star environment.
    3. In the Months per Partition field, enter the number of months between partition ranges. If you have a smaller range of partitions, the data between partitions will move faster.
  7. Click Next.

Related Topics

Configuring the Star Database

Configuring the P6 EPPM Database Connection on an Oracle Instance

Configuring the P6 EPPM Database Connection on a Microsoft SQL Server Database

Configuring the Star Database Connection

Configuring Codes for Star

Configuring User Defined Fields for Star

Finishing the Configuration Wizard



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

Last Published Friday, January 31, 2014