Working with data in the Reports database

After you collect data using the Reports feature, you can access that data and use it as input to your business intelligence software.

Use the procedures below to connect to the database, then retrieve data using SQL statements. For example, you can use the SELECT statement to query data or the COPY statement to export data.

    Note:
  • You don't have to follow this procedure if you use Data Transmitters.

For more information about working with data in PostgreSQL databases, including the Reports database, see the PostgreSQL tutorial (http://www.postgresqltutorial.com/).

In this section:

  1. Connecting to the Reports database
    You can connect to the Reports database directly by using psql, an interactive terminal program. After you make the connection, you can use SQL statements to extract or query the data without using a business intelligence tool.
  2. Exporting data in the Reports database to a CSV file
    You can export data in the Reports database to a file in comma-separated values (CSV) format.

Related information:

Configuring to extract data to a remote server
Configuring data collectors
Useful PostgreSQL commands
Default tables in the Reports database
Parent topic: Managing system objects