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

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

Note. These setup instructions for installing 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 Informix Application or Batch Servers for Remote Data Access

Before you can use remote data access with Informix on UNIX or Windows, Informix's database connectivity software (Informix Client 2.70 SDK) must be installed on the system where the application or batch server is running.

You must also install and configure the IBM Informix JDBC Driver, Version 2.21 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.

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 manually edit the application server configuration file, psappsrv.cfg. If you're using the batch server, you must manually edit the batch server configuration file, psprps.cfg. These configuration files are located in PS_HOME\appserv\domain_name\.

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 Oracle Application or Batch Servers for Remote Data Access

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPreparing to Configure Oracle

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 batch server is running. The minimum database connectivity that needs to be installed is Oracle Client Net9i 9.2.0.2.0 Connectivity Package.

To connect to a remote Oracle database, you must manually edit the application server configuration file, psappsrv.cfg, as described below. If the batch server is being used, you must manually edit the batch server configuration file, psprps.cfg, as well. (These configuration files can be found in PS_HOME\appserv\domain_name).

From the Remote Database Connection page (PeopleTools, Utilities, Administration, Remote Database Connection), you can specify an Oracle datasource 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 9i or Oracle 10g 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 9i or 10g 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 DB2 UDB Application or Batch Servers for Remote Data Access

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 batch server is running. In addition, you must modify the psappsrv.cfg and, if needed, the psprps.cfg configuration files.

Click to jump to top of pageClick to jump to parent topicConfiguring 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 manually edited. If the batch server is being used, the batch server configuration file, psprps.cfg, must be manually edited as well. (These configuration files reside in PS_HOME\appserv\domain\ .)

To manually 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\java12\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/java12/db2java.zip

Click to jump to top of pageClick to jump to parent topicConfiguring 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 manually edited. If the batch server is being used, the batch server configuration file, psprps.cfg, must be manually edited as well. (These configuration files live in PS_HOME/appserv/domain.)

To manually 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, add the following lines under the ";JavaVM Shared Library=" section: 

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

Click to jump to parent topicConfiguring Sybase Application or Batch Servers for Remote Data Access

Before you can use remote data access with Sybase on UNIX or Windows 2000, Sybase's database connectivity software (Sybase 12.5 Client with Patch SWR 9988) must be installed on the system where the application server or batch server is running. In addition, if the application server is being used, the application server configuration file, psappsrv.cfg, must be manually edited. If the batch server is being used, the batch server configuration file, psprps.cfg, must be manually edited as well. (These configuration files live inPS_HOME/appserv/domain/, if you're on UNIX, or PS_HOME\appserv\domain\ if you're on Windows.)

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. Customers must 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 2000 Driver for JDBC from http://www.microsoft.com/sql/downloads.

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

  2. Click on the link Windows(English)(2,096,944 bytes).

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

  4. Double-click the setup.exe file.

  5. Accept all the defaults.

    The JDBC driver files are located in C:\program files\microsoft SQL server 2000 for JDBC\lib.

  6. Copy all three files—mssbase.jar, mssqlserver.jar,msutil.jar—to PS_HOME\class.