Defining Remote Database Connections
Use the Remote Database Access Management page to set up remote databases for use with the Remote Data Access (RDA) feature. Select to access the Remote Database Access Management page. Browse for an existing Remote Database Connection or add a new name.
The fields on the page may change depending upon the database platform and your selections.
You can find additional information about Remote Database Connections in the Enterprise Components portion of the online help for your PeopleSoft application.
|
Field or Control |
Description |
|---|---|
|
Name |
Displays the name of the remote database connection you specified. |
|
DB Type |
Displays the database type being used. Available types are Microsoft (for Microsoft SQL Server), Db2 z/OS, and Oracle. |
|
Description |
Enter a description of the remote database. |
|
Server |
Enter the server name where the remote database resides. You see this when you select Connection Type Specific for Oracle databases. |
|
Database |
Enter the remote database name. |
|
Local Connect |
One connection must be defined as the Local Connect for the current PeopleSoft instance (the local database). Check this when entering information for the local database. |
|
DB Server Port |
This value is automatically populated with a default value that is based on the database type. You may need to change this value depending upon the database server configuration. |
|
User ID |
Enter the user ID that is needed to connect to the remote database. |
|
Password |
Enter the password that is associated with the user ID. |
|
Test Connection |
Click to test the remote database connection. |
|
Connection Type |
For Oracle database type only. Select TNSNames or Specific. TNSNames represents a preconfigured file (tnsnames.ora) that consists of previously defined database connection information. Select Specific if you want to set up a database that does not already have a TNS entry defined. |
|
TNS Entry |
For Oracle database type only. You see this when you select Connection Type TNSNames. |
|
Remote DB Parameters |
For Microsoft SQL Server database type only. This is optional. Enter any extra parameters needed to complete the connection. For example, use this field to supply parameters for SSL configuration. Use semicolons (;) to separate multiple values. If the Microsoft SQL Server database is set up for encrypted connections, the Remote DB Parameters field should contain the following data: encrypt=true;trustServerCertificate=false. |
Security in Remote Databases
To ensure security and limit the risk of unauthorized access to databases, follow these recommendations:
The remote system's database administrator should create a user with read-only access to the tables that may be accessed by other systems using PeopleSoft's RDA.
Use this restricted user ID and password in configuring a source RDA node.
The local system's database administrator should create a user with insert/update access to the RDA destination tables only.
Use this restricted user ID and password in configuring the target RDA node.