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.
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.
The Administration - Maintain Connections window opens.
The Administration - Update an Axiom EPM Connection window opens. For details, see Administration - Create a New Axiom EPM Connection Window.
Note: The Configure button becomes available once the connection test to the selected RDBMS is successful.
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.
The Administration - Maintain Connections window opens.
Note: If there are currently no connections, Add will be the only option.
The Administration - Create a New Axiom EPM Connection window opens. For details, see Administration - Create a New Axiom EPM Connection Window.
Connection successful
Connection failed - return code: nnnn
When the test is successful, the Configure button appears.
When processing finishes, you can manage your synonyms for this 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.
The Administration - Maintain Connections window opens.
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 |