Enable TeamForge (Oracle datamart) for queries from external tools

You must enable, then re-startTeamForge so that you can use an external tool to query the datamart directly.

You can use external reporting tools to connect directly to a datamart only if you do not have a single-box installation using HOST_localhost.

  1. In site-options.conf, set REPORTS_DATABASE_READ_ONLY_USER and REPORTS_DATABASE_READ_ONLY_PASSWORD with your user and password.
  2. On the TeamForge host machine, enable REPORTS_DATABASE_HOST and REPORTS_DATABASE_PORT for remote access.
  3. Re-create the runtime environment.
    • sudo ./install.sh -r -n -V
  4. Start the site.
    • /etc/init.d/httpd start
    • sudo /etc/init.d/collabnet start

    You can now enable trusted users to establish connections by providing them with values of options REPORTS_DATABASE_HOST, REPORTS_DATABASE_PORT, REPORTS_DATABASE_READ_ONLY_USER, and REPORTS_DATABASE_READ_ONLY_PASSWORD.