Appendix: Configuring Remote Data Access

This appendix provides an overview of remote data access and discusses how to:

Click to jump to parent topicUnderstanding 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.

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.

Note. These setup instructions for configuring a JDBC driver on the application and batch servers are needed only if you use remote database sources for the Data Transformer feature of common components. Do not install the driver otherwise.

Click to jump to parent topicConfiguring Application Servers and Process Scheduler Servers for Remote Data Access for Informix

Before you can use remote data access with Informix on UNIX or Windows, the Informix database connectivity software (the supported version of Informix Client) must be installed on the system where the application or Process Scheduler server is running.

You must also install and configure the supported version of IBM Informix JDBC Driver on the same machine. The driver installation program is included as part of your Informix server software distribution — refer to your Informix JDBC Programmers Guide for details.

See PeopleSoft Supported Platforms, PeopleSoft Hardware and Software Requirements, and your PeopleTools installation documentation for Informix for version and installation information

Important! You can install the JDBC driver anywhere. However, for proper remote data access functionality with your PeopleSoft system, you must install it under %INFORMIXDIR%/ifxjava_home.

If you're using the application server, you must edit the application server configuration file, PSAPPSRV.CFG. If you're using the PeopleSoft Process Scheduler (batch server), you must edit the server configuration file, PSPRCS.CFG. These configuration files are located in the PS_CFG_HOME directory within the appropriate domain or database name directory.

Under the line ";JavaVM Shared Library=" in the appropriate configuration file, add the following:

; RDBA Informix 
Add to CLASSPATH=%INFORMIXDIR%/ifxjava_home/lib/ifxjdbc.jar

Click to jump to parent topicConfiguring Application Servers or Process Scheduler Servers for Remote Data Access for Oracle

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPreparing to Configure Oracle Remote Data Access

Before you can use Remote Data Access with Oracle, the appropriate database connectivity software must be installed on the system where the application server or Process Scheduler server is running. The supported version of database connectivity software is determined by your database version.

See PeopleSoft Supported Platforms, PeopleSoft Hardware and Software Requirements, and your PeopleTools installation documentation for Oracle for version and installation information

To connect to a remote Oracle database, you must edit the application server configuration file, PSAPPSRV.CFG. If the Process Scheduler server is being used, you must edit the Process Scheduler server configuration file, PSPRCS.CFG, as well. These configuration files can be found in the PS_CFG_HOME directory within the appropriate domain or database name directory.

From the Remote Database Connection page (PeopleTools, Utilities, Administration, Remote Database Connection), you can specify an Oracle data source as "specific" or with TNSNAMES. "Specific" doesn't require a TNSNAMES entry, and will use the Oracle "thin" JDBC driver. However, if TNSNAMES is configured for the remote database, you can use the TNSNAMES style entry.

Click to jump to top of pageClick to jump to parent topicConfiguring Oracle Connectivity for Remote Data Access on UNIX

Determine the Oracle home directory and specify it in the configuration files by adding the following two lines under the ";JavaVM Shared Library=" section:

; RDBA Oracle JDBC driver
Add to CLASSPATH=%ORACLE_HOME%/jdbc/lib/ojdbc14.jar
Add to CLASSPATH=%ORACLE_HOME%/jdbc/lib/orai18n.jar

Click to jump to top of pageClick to jump to parent topicConfiguring Oracle Connectivity for Remote Data Access on Windows

Determine the Oracle home directory and specify it in the configuration file. For example, if Oracle the home directory is C:\Apps\DB\Oracle901, add the following lines under the ";JavaVM Shared Library=" section:

; RDBA Oracle JDBC driver
Add to CLASSPATH=C:\Apps\DB\Oracle901\jdbc\lib\ojdbc14.jar
Add to CLASSPATH=C:\Apps\DB\Oracle901\jdbc\lib\orai18n.jar

Click to jump to parent topicConfiguring Application Servers or Process Scheduler Servers for Remote Data Access with DB2 UDB

This section discusses how to:

Before you can use remote data access, you must install the appropriate database connectivity software on the system where the application server or Process Scheduler server is running. In addition, you must edit the PSAPPSRV.CFG and, the PSPRCS.CFG configuration files.

See PeopleSoft Supported Platforms, PeopleSoft Hardware and Software Requirements, and your PeopleTools installation documentation for Oracle for version and installation information

Click to jump to top of pageClick to jump to parent topicConfiguring Remote Data Access for DB2 UDB for Linux, UNIX and Windows

The minimum database connectivity software that needs to be installed is the IBM DB2 Run-Time Client. In addition, the application server configuration file, PSAPPSRV.CFG, must be edited. If the Process Scheduler server is being used, the Process Scheduler server configuration file, PSPRCS.CFG, must be edited as well. These configuration files reside in the PS_CFG_HOME directory within the appropriate domain and database name directory.

To edit the file, determine DB2 UDB's home directory and specify it in the configuration file.

For example, if DB2 UDB's home directory is C:\Apps\DB\DB2ODBC8, you should add the following lines under the ";JavaVM Shared Library=" section:

; RDBA DB2 Add to CLASSPATH=C:\Apps\DB\DB2ODBC8\java1x\db2java.zip

Or, if DB2 UDB's home directory is /mnt/db2/v8.1/java12, you should add the following lines under the ";JavaVM Shared Library=" section:

; RDBA DB2 Add to CLASSPATH= lmnt/db2/v8.1/java1x/db2java.zip

Click to jump to top of pageClick to jump to parent topicConfiguring Remote Data Access for DB2 UDB for z/OS

The database connectivity software that needs to be installed is IBM DB2 Connect. In addition, if the application server is being used, the application server configuration file, PSAPPSRV.CFG, must be edited manually. If the Process Scheduler server is being used, the Process Scheduler server configuration file, PSPRCS.CFG, must be edited as well. These configuration files reside in the PS_CFG_HOME directory within the appropriate domain and database name directory..

Determine DB2 UDB's home directory, and specify it in the appropriate configuration file. For example, if DB2 UDB's home directory is C:\Apps\DB\DB2ODBC8, add the following lines under the ";JavaVM Shared Library=" section:

; RDBA DB2
Add to CLASSPATH=C:\Apps\DB\DB2ODBC8\java1x\db2java.zip

Click to jump to parent topicConfiguring Application or Process Scheduler Servers for Remote Data Access with Sybase

Before you can use remote data access with Sybase on UNIX or Windows, the supported version of Sybase's database connectivity software, Sybase Client, must be installed on the system where the application server or Process Scheduler server is running.

See PeopleSoft Supported Platforms, PeopleSoft Hardware and Software Requirements, and your PeopleTools installation documentation for Oracle for version and installation information

In addition, if the application server is being used, the application server configuration file, PSAPPSRV.CFG, must be edited. If the batch server is being used, the batch server configuration file, PSPRCS.CFG, must be edited as well. These configuration files are located in the PS_CFG_HOME directory within the appropriate domain or database name directory.

Under the ";JavaVM Shared Library=" section add the following lines:

; RDBA Sybase 
Add to CLASSPATH=%SYBASE%/jConnect-5_5/classes/jconn2.jar

Click to jump to parent topicInstalling and Configuring the Microsoft SQL Server JDBC Driver

Microsoft does not allow the redistribution of the JDBC driver for the Structured Query Language (SQL) server by other vendors, such as Oracle. So, you need to download it from the Microsoft website, and install it into the PS_HOME\class directory.

To load and configure the Microsoft SQL Server JDBC Driver:

  1. Download the Microsoft SQL Server Driver for JDBC from Microsoft.

    For example: http://www.microsoft.com/download/en/details.aspx?id=3456

    Note. These drivers are not used by Tuxedo or the web server, so you can ignore any comments on this site about supported versions of various web servers.

  2. Save the program to disk in c:\temp or desktop.

  3. Double-click the sqljdbc_<version>_enu.exe file.

  4. Accept all the defaults.

    The JDBC driver files are installed in C:\program files\microsoft SQL server <ver> JDBC Driver\lib.

  5. Copy these files to PS_HOME\class: