Documentation forDatabase Performance Analyzer

Set up the DPA Integration Module

You need the following information to integrate DPA with the Orion Platform:

  • DPA server host name or IP address
  • DPA port number
  • DPA administrator credentials
  • Orion server host name or IP address
  • DPA server display name

If DPAIM was installed automatically with SAM, it is listed in the Orion Web Console footer only after you complete the integration. If you install DPAIM using the stand-alone installer, it is listed in the Orion Web Console footer immediately after installation.

Set up the Integration Module in Settings

  1. Log in as an administrator. Non-administrator accounts cannot view the Manage DPA Servers page.
  2. Click Settings > All Settings.
  3. Under Product Specific Settings, click Database Performance Analyzer.
  4. Click Manage DPA Servers.
  5. Click Add DPA Server.
  6. Enter the required information, and click Test Connection.

    If the test fails and a new field for the Orion server address displays, enter your Orion server address using the fully qualified domain name or IP address.

  7. Click Integrate.

What happens during the integration setup?

  1. The Orion server tests the connection and credentials to ensure it can communicate with the DPA server.
  2. The Orion server uses the DPA administrator credentials to create service accounts on the DPA server, which are then saved to the Orion server.
  3. The Orion server tests the connection and credentials again, and enables single sign-on.
  4. The Orion server sets up federation so it can retrieve information from the SolarWinds Orion database and the DPA repository database.
  5. The Orion server creates relationships between nodes, applications, and database instances from DPA.

The service account is used when the Orion server queries the DPA server for information.