In this section: |
Multiple connections to PeopleSoft 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: Reference: |
If it becomes necessary to update the connection parameters to a PeopleSoft data source, you can use Administration options to perform the following functions:
The Administration - Maintain Connections window opens.
The Administration - Update a PeopleSoft Connection window opens. For details, see Administration - Create a New PeopleSoft Connection Window.
Note: The Configure button becomes available once the connection test to the selected RDBMS is successful.
When you change the Specify Security Access By setting, you must re-synchronize security before changes will take effect. We suggest that you remove all currently configured users before you make this change, and re-add them after security settings have been modified.
As when you modify authentication information, you must be careful to manage changes to data source connectivity correctly. Always modify your settings in the PeopleSoft Connection first, then change them at the data source. Where possible, keep both access options in place during a configuration conversion process until tests have verified a successful switch.
How to: |
After you add your first connection, you can specify additional PeopleSoft connections. Note that during this process, you are not prompted for the DBA information prior to managing metadata and connection information since all additional PeopleSoft 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 PeopleSoft Connection window opens. For details, see Administration - Create a New PeopleSoft 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 and security for this connection.
How to: |
The integration with PeopleSoft 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 a PeopleSoft Connection window opens.
You are prompted to confirm. After confirmation, the system removes the selected PeopleSoft Connection and all of its associated metadata.
WebFOCUS |