Understanding Remote Data Access

Remote Data Access is a feature used in your PeopleSoft environment if you use the Data Transformer feature available with many PeopleSoft applications, as part of Enterprise Components.

To use remote data access:

1. Install the supported connectivity software for your database platform on the system where the application server or Process Scheduler is running.

   The supported version of database connectivity software (JDBC driver) is determined by your database version.

   See PeopleSoft supported database platforms, Certifications tab on My Oracle Support, and your PeopleSoft 9.2 Application Installation for Oracle for version and installation information.

2. Specify the information for the JDBC driver in the configuration file for the application server (PSAPPSRV.CFG) or Process Scheduler (PSPRCS.CFG).

   Configuring Application Servers or Process Scheduler Servers for Remote Data Access for Oracle

   Configuring Application Servers or Process Scheduler Servers for Remote Data Access with Db2 for z/OS

   Installing and Configuring the Microsoft SQL Server JDBC Driver

3. Set up the remote database connection.

   See Defining Remote Database Connections.

Oracle develops, certifies, and tests remote data access using the drivers provided by the supported DBMS vendors. JDBC drivers are either supplied with the database product that you already have, or can be obtained separately from your database vendor. Using these drivers ensures a predictable and well supported environment, with less potential for interoperability issues.