To add activity, project and resource codes from multiple data sources into one Star database:
Install the Star database for Data Source 1.
Note: You may have already added the Data Sources when you installed P6 Reporting Database.
In the Configuration Utility:
Enter the Pxrptuser for Data Source 1.
Select project, activity, and resource codes to add to the Star database.
Go to star_home\star\scripts and run staretl.bat (or staretl.sh).
Add a database link for Staruser to Data Source 2.
Rename the Star home folder for data source 1.
Install the Star database for Data Source 2.
In the Configuration Utility.
Enter the Pxrptuser for Data Source 2.
Select project, activity, and resource codes to add to the Star database.
Go to star_home>\star\res and open the staretl.properties file in a text editor.
Organize the codes in the staretl.properties file for Data Source 2 to include codes from both data sources:
Add the codes from Data Source 1 staretl.properties file to Data Source 2 staretl.properties file.
Add the codes specific to Data Source 2 to the list of codes just added.
The staretl.properties should include the codes from Data Source 1 (which is comprised of codes with the same name in each data source and codes unique to Data Source 1) followed by the codes unique to Data Source 2.
Below is an example from the staretl.properties file showing the format for the codes:
code.actv.1.descr=ActGlobal1 Description
code.actv.1.name=ActGlobal1
code.actv.1.regx=ActGlobal1
code.actv.1.scope=Global,Project,EPS
code.proj.1.descr=ProjCode1 Description
code.proj.1.name=ProjCode1
code.proj.1.regx=ProjCode1
code.rsrc.1.descr=ResCode1 Description
code.rsrc.1.name=ResCode1
code.rsrc.1.regx=ResCode1
Go to star_home>\star\etl\common and run runSubstitution.cmd (or runSubstitution.sh). RunSubstitution will rebuild the script that extracts and populates codes, so the codes stated in the above example will be used when you run staretl.
Run Staretl.bat "-s2".
Note: Running the configuration utility after manually editing the staretl.properties file will overwrite the existing staretl.properties file. See the Tips section below.
Tips
If you return to an individual data source and run the Configuration Utility, you will lose the changes made in this section.
If you need to run the Configuration Utility after making changes to the codes list:
Create a backup of the staretl.properties file before running the Configuration Utility again.
After running the Configuration Utility, copy the codes list from the staretl.properties backup file and paste it in the current staretl.properties file. This will overwrite the codes list that was created after re-running the Configuration Utility.