Rename the folders for the first data source back to the original name.
Run the ETL from that folder by running staretl.bat “-s1” or the staretl.sh “-s1”.
Determine how long each ETL process takes. If the first ETL takes 4 hours and the second takes 6 hours, you need to set the jobs to run at separate times and allow extra time if one ETL run goes longer than usual. You should monitor this as ETL runtimes and Star history fact tables can grow as data grows in P6.
Run the ETL for the second data source as staretl.bat “-s2” or the staretl.sh “-s2”.
Tips
When running the ETL, always use the parameters you have set for your data sources.
In P6 Analytics this data will combine as if it were one Star until a filter is applied. Under Project – General and Resource – General there is a field for data source id that can be used to filter on either data source 1 or data source 2.
If adding more than three data sources, you will need to manually alter the scripts (See the P6 Analytics and Star Database Installation and Configuration Guide). Post Analytics 3.1 release, unlimited data sources are supported.