Schedule data extraction for reporting

Set the interval at which you want yourTeamForge site's data extracted to the datamart from which reports are generated.

Each extract-transform-load (ETL) job consists of extracting the data from the production database, transforming it to support reporting, and loading it into the datamart.

By default, this is done every night at 2:30 a.m., by the host's local clock.

  1. Open the site-options.conf file, the master configuration file that controls your TeamForge site.
    • vi /opt/collabnet/teamforge/etc/site-options.conf
    Note: vi is an example. Any *nix text editor will work.
  2. Set the ETL_JOB_TRIGGER_TIME variable to the interval at which you want ETL jobs to run. For example, a value of 0 0/15 * * * ? will run an ETL job every 15 minutes.
  3. Review the variables you have changed, then save the site-options.conf file.