Datamart access using external tools

Use external tools to directly query the PostgreSQL or Oracle datamarts to access more TeamForge data than is available through options on the TeamForge user interface.

Accessing the datamart

You can use OLAP or GUI tools to query your datamart directly to procure all the TeamForge data that is relevant to your analysis.

The external tool must be in the same network as the datamart to ensure fast access with a direct connection to the database. On the TeamForge host machine, you must enable REPORTS_DATABASE_HOST and REPORTS_DATABASE_PORT for remote access.

Note: You only have read access; the datamart does not allow writes.

Enabling the datamart for access

You must enable the datamart for direct queries and re-start the site. Once enabled, all data in the datamart can be queried using external tools.