DOCS

Configuring Connections to Servers and Databases

Metability’s Connection Manager is a tool for managing connections to DI Servers and databases. You can use it to perform these functions:

  • Establish connections
  • Sever connections
  • Edit connections
  • Restore the default settings

To open Metability’s Connection Manager

> Select MetabilityConnection Manager to open the Connection Manager window:

This image shows the Connection Manager window.

The Available connections list displays these details for each connection:

  • The name of the connection.
  • A check box to specify if the connection should be opened automatically when Metability is started.
  • Check boxes that display for which perspective the connection is configured in the Metability dataspace.xml file.
  • To change the perspective assignment you must edit the corresponding SERVER connection tags in the Metability dataspace.xml file. For details, see Adding Additional Server Connections.
  • The current status of the connection if you selected the Display connection state check box.

If the list is empty, no connections have been defined yet. In that case, contact your administrator.

The icon to the left of each connection name characterizes its connection status:

Icon Description

Active connection to server.

No connection to server.

Active connection to server, but database access is not possible (user not recognized as a valid user in the databases).

Unable to connect to server (server not running, wrong password, or no valid user account).

The command buttons on the right side of the window provide access to the functions offered by Metability:

Command Function

Connect

Establishes a connection

Disconnect

Severs a connection

Databases

Opens a dialog for selecting the databases for the connection

Restore Defaults

Restores the default connection settings

The Close button in the lower right corner of the window allows you to confirm the present state of all connections and close the window. Using the Help button, you can access Help information for questions concerning Connection Manager.

To establish a connection

  1. In the Connection Manager window, select the connection you want to open from the Available connections list:
  2. This image shows the Connection Manager window.
  3. Click Connect.
  4. Connection Manager will respond with a login dialog:

    This image shows the Login to Admin connection dialog.
  5. Type your user ID and password (if password-enabled), and click OK.
  6. If you select the Remember user check box, the current value will auto-populate in the User field every time this dialog opens.

To close a connection

  1. In the Available connections list, select the connection you want to close.
  2. Click Disconnect.
  3. A confirmation dialog is displayed.

  4. Click Yes to close the connection.

To select the databases to which you want to connect

  1. In the Available connections list, select the connection for which you want to select the databases.
  2. Click Databases.
  3. The Select Databases for Access page of the Connection Wizard is displayed.

    This image shows the connection wizard dialog.
  4. Select the Select all accessible databases check box to connect to all databases.
  5. Or  

    Clear the check box and then select the databases to which you want to connect.

  6. Click Finish to save your settings.

To restore the default settings

  1. Click Restore Defaults.
  2. A confirmation dialog is displayed.

    This image shows a confirmation dialog to restore connection defaults.
  3. Click Yes to restore the initial configuration
  4. Or  

    Click No to preserve the current configuration.