Search only in titles

---

Configuring Multiple Data Sources

Primavera Data Warehouse supports data being loaded from multiple P6 EPPM databases and/or Primavera Unifier databases. Using multiple data sources enables you to do the following:

• Group matching data (for example, Resources, Codes, and other common attributes) from different data sources into the same Primavera Data Warehouse instance.
• Combine data from P6 EPPM with data from Primavera Unifier for true cross-product analysis.

Each multiple data source table in Primavera Data Warehouse has a datasource_id field, which is used to identify the data source.

Notes:

• See the Primavera Analytics Planning and Sizing Guide for information on managing multiple data sources.
• Before adding any additional data sources, ensure that all P6 EPPM and/or Primavera Unifier Publication Services have been run on each data source. See Configuring and Running P6 EPPM Publication Services and Configuring and Running Primavera Unifier Publication Servicesfor details.
• Oracle Database partitioning mustf be enabled on the Primavera Data Warehouse instance. This requires additional Oracle database licensing. Contact with your Oracle Sales Representative for details on enabling Oracle Database partitioning.

Creating Additional Partitions for Additional Data Sources

If you want to create additional data sources (beyond the default number of data sources):

1. Download Primavera Data Warehouse from the Oracle edelivery website.
2. Extract the zip in the downloaded location.
3. Go to the P_R2412_DW\documentation\PartitioningScripts folder and run the following scripts:
   • PartitionSubPartitions.sql
   • SubPartitionTemplates.sql

Verifying Database Partitioning

To verify that Oracle Database partitioning is enabled on the P6 EPPM instance, complete the following steps:

1. Sign in to the Primavera Data Warehouse instance with administrator privileges. For example, SYSTEM.
2. Run the following command to validate partitioning is running for this instance:

   select * from V$OPTION

3. In the query results, verify that the Partitioning parameter is set to True.

Configuring Multiple Data Sources

To configure one or more data sources for Primavera Data Warehouse, complete the following steps:

1. Go to <PDW Install Folder>\star\config.
2. To launch the Primavera Data Warehouse Configuration Utility:
   • Run configStar.cmd (with Windows) or
   • Run configStar.sh (with UNIX or Linux).
3. On the Welcome screen, click Next.
4. On the DW Reporting Configuration screen, click ETL Management.
5. Click Add to add and manage data sources.
6. Select any of the following products to use as the data source:
   • Primavera P6 EPPM
   • Primavera Unifier
7. In the Custom Name field, enter a name to distinguish this data source.
8. Click Next.

   The configuration utility proceeds to the next step. See Configuring P6 EPPM and/or Primavera Unifier Database Connection for an Oracle Database to continue the configuration process.

   Repeat as need for each required data source.

---

Last Published Thursday, December 12, 2024