Running the STARETL Process

Previous TopicNext TopicContents

After you complete the installation and all configuration tasks, execute the staretl.bat (or staretl.sh on a non-Windows system) file by doing the following:

  1. Go to the location where you installed P6 Reporting Database.
  2. Click staretl.bat (or staretl.sh) to execute the file.

Related Topics

Installing and Configuring the Star Database

Running User-defined ETL Scripts

User-defined ETL Script Samples

Installing the Star Database

Configuring the Star Database

Updating the RPD file

Configuring an Oracle Standard Edition Database

Multiple Data Sources in the Star Database

Star Security Configuration

Installing and Configuring Financial Periods

Running User-defined ETL Scripts

P6 Analytics supports adding user defined steps to the ETL process, which can be used to extract, transform, and load additional data into the Star schema. When using this option, user defined scripts will be automatically executed as part of the standard ETL process.

To run user-defined scripts during Star etl, do the following:

  1. Create scripts and keep a copy in a safe place.

    Note: Each script should have an “EXIT” at the end.

  2. Make sure each script runs successfully with good performance in sqlplus.
  3. Copy the scripts to the <install_directory>/scripts/user_scripts. Scripts will be picked up by the Star etl process.
  4. If some of the scripts have to be run in certain order, add the script name to the file <install_directory>/res/priority/user_scripts.txt, one line for each script file name (no folder info needed), and they’ll be scheduled to run in that order. For the scripts not in user_scripts.txt, they’ll be scheduled to run after those in the file list, and in no specific order.
  5. Run staretl.bat or staretl.sh.The user-defined scripts are the last step of the Star etl process.

    Note: Running configStar.cmd/configStar.sh will not override these scripts.



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014