Determine how many data sources to use before running the staretl. You must edit scripts and rerun the ETL processes for each data source.
Caution: Before editing the scripts, manually backup the history data. When you add more data sources, the staretl.bat "-r" file will rebuild all tables and remove all existing activity level history. If you don't backup your history data, it will be lost.
If you want to manually add more than three data sources, follow the steps below.
Notes:
The instructions assume that you have installed P6 Reporting Database.
Before adding extra data sources, you must run the P6 EPPM Extended Schema services and update these data sources.
Back up your history data.
Note: You can use the Configuration Utility to add data sources.
Run the staretl.bat "-r."
Run all your other data sources. For example:
startetl.bat "-s2"
startetl.bat "-s3"
Run the additional data sources you just created. For example:
startetl.bat "-s4"
startetl.bat "-s5"
Locate the W_PROJECT_D table and verify that there is a datasource_id =4 (as well as additional data sources if you created them) and that the other datasource_id's exist for 1, 2, and 3.