Managing Connections to Axiom EPM

In this section:

Multiple connections to Axiom EPM data sources are possible from within one server configuration. However, depending on your reporting requirements, it may be optimal to create separate configurations for each data source.

Creating multiple connections using the same server configuration is a good option under the following circumstances:

Create separate configurations instead of using multiple connections in these situations:

The remaining instructions in this topic assume a single configuration directory structure for one or more data source connections.

Top of page
x
Updating an Axiom EPM Connection

How to:

If it becomes necessary to update the connection parameters to an Axiom EPM data source, you can use Administration options to perform these changes.

x
Procedure: How to Edit an Axiom EPM Connection
  1. Click Connections under the Administration group.

    The Administration - Maintain Connections window opens.

  2. Select Update Existing.
  3. Select a connection from the Select Axiom EPM Connection drop-down list.
  4. Click Next.

    The Administration - Update an Axiom EPM Connection window opens. For details, see Administration - Create a New Axiom EPM Connection Window.

  5. Make the necessary modifications, test the connection, and if successful, click Configure. If not successful, edit the information until the test is successful, then click Configure. For more information, see step 4 in How to Add an Axiom EPM Data Source Instance.

    Note: The Configure button becomes available once the connection test to the selected RDBMS is successful.

  6. On the next screen, click Next.
Top of page
x
Adding an Axiom EPM Connection

How to:

After you add your first connection, you can specify additional Axiom EPM connections. Note that during this process, you are not prompted for the DBA information prior to managing metadata and connection information since all additional Axiom EPM data sources must use the same DBA in order for base metadata to function properly.

x
Procedure: How to Add an Axiom EPM Data Source Instance
  1. Click Connections under the Administration group.

    The Administration - Maintain Connections window opens.

  2. Select Add New.

    Note: If there are currently no connections, Add will be the only option.

  3. Click Next.

    The Administration - Create a New Axiom EPM Connection window opens. For details, see Administration - Create a New Axiom EPM Connection Window.

  4. Type the necessary information and click Test Connection. If
    • The connection is successful, the following message will appear in green to the right of the button:
      Connection successful
    • The connection is unsuccessful, the following message will appear in red to the right of the button with the relevant RDBMS return code:
      Connection failed - return code: nnnn

    When the test is successful, the Configure button appears.

  5. Click Configure.
  6. On the next screen, click Next.

When processing finishes, you can manage your synonyms for this connection.

Top of page
x
Removing an Axiom EPM Connection

How to:

The integration with Axiom EPM depends on valid connection information. If a previously created connection is no longer required, you should remove that connection.

x
Procedure: How to Remove an Axiom EPM Connection
x
  1. Click Connections under the Administration group.

    The Administration - Maintain Connections window opens.

  2. Select a connection from the Select Connection drop-down list.
  3. Select Remove Existing.
  4. Click Next.

    The Administration - Remove an Axiom EPM Connection window opens.

    You are prompted to confirm. After confirmation, the system removes the selected Axiom EPM Connection and all of its associated metadata.

WebFOCUS