You can combine more than one Extended Schema into a single Primavera Data Warehouse database. This enables you to have multiple P6 installations and view the combined data in one Primavera Data Warehouse. You can also set up filters that enable you to view data from just one data source.
Consider the following when using multiple data sources:
- Ensure that the names of resources, projects, or EPSs match across data sources.
- Store the data in the same dimensions and facts for each data source.
- Insert rows with unique row IDs for each data source.
Note: You cannot run the ETLs for the data sources at the same time. Each additional data source requires a unique installation with its own configuration information. Each installation will have its own staretl. The staretl processes cannot run at the same time because the unified Primavera Data Warehouse will still use the same internal staging tables. If multiple ETL processes were running at the same time, they could overwrite each other in the staging tables and cause failures or data corruption.