Using an Existing Database

Intermapper makes it easy to install and run Intermapper Reports Server using the built-in PostgreSQL database. The database is installed, configured, and registered automatically. To use Intermapper Reports Server, you need only to start the server so that Intermapper reports to it.

If you prefer, you can use another instance of a PostgreSQL database, running on the same machine or on another machine. See Configuring the Database below.

Configuring the Database

Use this section only if you want to use an existing PostgreSQL database, regardless of whether it is running on the same machine as Intermapper or on a different machine.


Use the Intermapper Database section of the Intermapper DataCenter Administration Panel to configure the Intermapper Database used by the Reports Server.

Configuring a New Installation

When configuring a new installation, follow these steps.

  1. Configure database to connect to, or use the default Built-in database.
  2. Register your Intermapper Server with the Intermapper Reports server.

Step 1: Database Configuration

  1. Specify whether to use the Built-in database, or to connect to an existing external (PostgreSQL) database.

  2. If you use the Built-in database, an Intermapper account is created automatically for Intermapper to use, so you can click Continue without adding any additional accounts. You have the option to create one or more user accounts when the database is installed.

    You will need an additional user account if you want to use pgAdmin, Perl, PHP, Crystal Reports, or some other method to retrieve information from Intermapper Reports Server. If you want, you can add them later.

  3. If you choose to use an existing database, enter a Host , Port, Database Name, Database Username, and Database Password in the appropriate boxes and click Continue. You are finished with Step 1.

    NOTE:

    The user you specify must have, at minimum, CREATE, TEMPORARY, and CONNECT privileges in order for Intermapper to log data to the database.

  1. Click Add to add a user. An unnamed user is displayed in the User List at left.
  2. In the Username text box, type a user name.
  3. In the Password and Confirm Password text boxes, type the password.
  4. Select or clear the Write Access check box to specify whether a user can make changes to tables (as through pgAdmin).
  5. By default, users can access the database only from the same host as it is running on. Select or clear the Remote Login check box to choose whether to grant a user access from any machine on the network.
  6. To create more users, repeat steps 4 through 8.

Step 2: Register your Intermapper Server with the Intermapper Database server

    1. If Intermapper Reports detects an Intermapper server running on the same machine, you are given the option to register that server to export data to the Intermapper Reports Server.
      1. Click Register Server. The existing server is registered with Intermapper Reports Server, and you are presented with the option of registering additional servers.
      2. Click Instructions, and follow the instructions for each Intermapper server you want to register.
      3. Click Finish. The Intermapper DataCenter home page appears, showing that the Intermapper Reports Server is running.

      If Intermapper Reports Server is installed on a different machine, you'll need to register your Intermapper server(s) manually. Click Register Server Manually.
    2. In Intermapper, view the Server Configuration > Reports Server pane of the Server Settings panel, click Start. Intermapper begins sending data to Intermapper DataCenter.

Changing Settings After Installation

Intermapper DataCenter is installed automatically when you install Intermapper. Once you have configured Intermapper Database, you can change settings as needed from the Intermapper DataCenter Administration Panel.

To change the settings in the Intermapper Database:

From the Intermapper DataCenter's Home page, click Change Settings in the Intermapper Database box. The Intermapper Database Settings Page appears.

To view the Intermapper Database log:

In the Intermapper Database section of the DataCenter Administration Panel, click the Log tab. The Intermapper Database log page appears.