When is the scripts directory updated?

Each time the configuration utility is run to completion the runsubstitution.cmd or .sh is run. This action takes the scripts in the \etl\oracle\templates folder and populates the \scripts directory with updated versions based on these templates. At this time variables are replaced in the template scripts and added to the \scripts directory.

If there are any files in the \scripts directory that have been updated that you wish to keep as part of the ETL process the best way to do so is replace the template file to ensure those changes are not overwritten. Whenever replacing or updating a template always make sure to create a copy of the original file outside of the \etl folder. \scripts is an active, live directory. \etl\oracle\templates is the archived version of what is to be used in any further ETL processes if there are any configuration updates.

Also as of P6 Reporting Database 3.0 there is a directory called 'user_scripts' in the \scripts folder which is used for executing custom ETL additions.  See P6 Reporting Database 3.0 Installation and Configuration guide for more information.  


Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Provide new information on Primavera Analytics and Data Warehouse

Search

Categories
Archives
« April 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  
       
Today