Publishing P6 Data to Extended Schema

To publish P6 data to the extended schema:

Get the p6services.jar file from the P6 build.
Run the following command:
java -jar "Path to p6services.jar"
Select Oracle or Microsoft SQL Server from the Database Type list.
Enter the following database details: database username, publication user username, password, and database service.
Select Next.
In the P6 target database, run the following as ADMUSER:
1. Ensure that last_update_date is null for all projects that are considered for publishing (PX_ENABLE_PUBLICATION_FLAG = 'Y'). If not, update them as follows:
  update project set px_last_update_date = null WHERE PX_ENABLE_PUBLICATION_FLAG = 'Y'; commit;
2. Ensure that setting_value has the maximum Project ID for setting_name= 'ProjectNonDemandStopKey'.
  update SETTINGS set Setting_value = (select max(proj_id) from project) where Namespace = 'PxService.Project.Arbiter' and Setting_name = 'ProjectNonDemandStopKey'; commit;
Ensure that the P6 target database, to which data is synced, is added as a source to the Primavera Data Warehouse.
To enable Publication Services view on Webapp, run the following query in the STAR database as STARUSER:
UPDATE ETL_PARAMETER SET P_1='true' WHERE P_FEATURE='db.pmdb.cloud'; commit;