In earlier versions of Primavera Analytics, settings were stored in property files as well as tables within the data warehouse. Those settings are now stored only in the data warehouse tables. ETL_GLOBAL_PARAMETER stores global settings that affect the entire data warehouse. ETL_PARAMETER stores data source-specific settings for each P6 EPPM or Primavera Unifier source. The settings are stored as simple key = value pairs, where p_feature represents the key and p_1 represents the value. For example:
select p_feature, p_1 from etl_global_parameter
where p_feature = 'db.star.version';
This would return the following:
For source-specific parameters, you also need to filter based data source. For example:
select p_feature, p_1 from etl_parameter
where p_feature = 'db.pmdb.application.username' and datasource_id = 1;
This would return the following:
