Providing software solutions since 1976
Third-Party Software for SASŪ 9.1.3 Foundation with Service Pack 1
Java Runtime Environments
The JREs listed below require an update to support new Daylight Saving Time changes beginning March 11, 2007. Please see Effect of changes to Daylight Saving Time (DST) in the USA on Java (with SASŪ 9.1.3) for complete details.
The following versions of the Java Runtime Environment (JRE) are recommended for use with the SAS Foundation and SAS client applications. Application servers and servlet engines require a full Java Software Development Kit (JDK). See the next section for a list of Java Development Kits required by supported application servers.
| Platform | Version | Link | Notes |
|---|---|---|---|
| HP Tru64 UNIX | 1.4.1-1 | Not on vendor website. Available on 3rd party CD | |
| OpenVMS Alpha | 1.4.1-1 | Not on vendor website. Available on 3rd party CD | |
| HP-UX PA-RISC | 1.4.1.02 | Download | Registration is required |
| HP-UX Itanium | 1.4.1.01 | Download | Registration is required |
| z/OS | 1.4.1 | Download | Registration is required. No JRE available, install SDK V1.4. |
| AIX | 1.4.0 | This JRE is not available on the vendor's website. This JRE is installed with Base SAS® and is on the Third Party CD. It is the supported version for the SAS® Foundation Servers running on AIX. | |
| 1.4.1 | Download |
SAS® Management Console, SAS® Enterprise Miner and SAS®Merchandise Intelligence Server on AIX require IBM's 1.4.1 32-bit JRE. Please review SAS Note SN-012999 for more detailed information. |
|
| Solaris on SPARC | 1.4.1 | Download 32-bit JRE | Installation of the 64-bit JRE for Solaris requires installation of
the 32-bit JRE first.
Please review Sun's installation instructions for more detail. |
| Windows (32-bit) |
1.4.1 | Download | |
| Windows 64-bit Itanium |
1.4.2 | Download | Full Java Software Development Kit. A separate Runtime Environment is not available |
| Linux | 1.4.1 | Download | |
| Linux 64-bit Itanium |
1.4.2_04 | Download | 64-bit Linux is supported for SAS 9.1.3 SP1 and higher. |
Java Software Development Kits
The JDKs listed below require an update to support new Daylight Saving Time changes beginning March 11, 2007. Please see Effect of changes to Daylight Saving Time (DST) in the USA on Java (with SASŪ 9.1.3) for complete details.
The following table identifies Java Software Development Kit (JDK) requirments for supported application servers and z/OS. Application servers and servlet engines require the use of a full JDK. For z/OS, there is no separate Java Runtime Environment, and therefore a JDK must be used with the SAS Foundation. For SAS Java clients and other platforms supported by the SAS Foundation, use the JRE recommendations listed above.
| Platform | Version | Link | Notes |
|---|---|---|---|
| Window (32-bit) |
1.4.2_04 | Download |
To download the J2SE SDK, click on the download link in the SDK column. After reviewing the license agreement, select one of the installers under the "Windows Platform" heading. If you have difficulties running the Windows Installer, please download the Windows Offline Installer to your local machine and run that. If you select the Windows Offline Installation, please be sure to run the installer. Please note that the JDK included with WebSphere MUST be installed on the Windows platform when using WebSphere 5.1 Application Server. |
| Solaris on SPARC | 1.4.2_04 | Download | To download the J2SE SDK, click on the download link in the SDK
column.
The application servers supported by SAS require the 32-bit SDK. After reviewing the license agreement, select one of the 32-bit SDK installers under the "Solaris SPARC Platform" heading. |
| AIX | 1.4.1.3 32-bit (a.k.a. 1.4.1 SR1) | Download | Registration is required. This version of the SDK should be downloaded for use with Tomcat and WebLogic. When running Websphere, use the SDK that is installed with the Websphere product.
Install Java Version 1.4.x 32-bit with version code ca1411-20030930. Please carefully review the fix information provided by IBM at their download page for complete information about installing the base SDK and all required PTFs to completely install the required SDK. Please note that the JDK included with WebSphere MUST be installed on the AIX platform when using WebSphere 5.1 Application Server. |
| HP-UX Itanium | 1.4.1.05 | Download | Registration is required |
| z/OS | 1.4.1 | Download | Registration is required. Install SDK for z/OS, V1.4. |
Application Servers
| Product | Platform | Version | Link | Notes |
|---|---|---|---|---|
| Apache Tomcat | Solaris on SPARC,
Windows, IBM AIX, HP-UX IPF |
4.1.18 | Download | Download a binary for tomcat-4.1.18-LE-jdk14 in one of the available formats (zip, tar, or exe) |
| Apache Tomcat Hot Fix |
Solaris on SPARC,
Windows, IBM AIX, HP-UX IPF |
- | Download | Download the hot fix for Tomcat 4.1.18 provided by SAS |
| BEA WebLogic Server | Windows | 8.1 (SP2) | Contact BEA |
The BEA patches below address WebLogic bugs or security advisories. They are required to run SAS applications properly. Contact BEA Support to obtain listed patches and installation instructions.
Security Patches must also be applied to your WebLogic installation. For a guideline on using WebLogic with SAS 9.1.3, see Installing the BEA WebLogic Server and Deploying Web Applications. |
| BEA WebLogic Server | IBM AIX, Solaris on SPARC | 8.1 (SP2) | Contact BEA |
The BEA patches below address WebLogic bugs or security advisories. They are required to run SAS applications properly. Contact BEA Support to obtain listed patches and installation instructions.
Security Patches must also be applied to your WebLogic installation. For a guideline on using WebLogic with SAS 9.1.3, see Installing the BEA WebLogic Server and Deploying Web Applications. |
| BEA WebLogic | HP-UX Itanium | 8.1 (SP1) | Contact BEA |
The BEA patches below address WebLogic bugs or security advisories. They are required to run SAS applications properly. Contact BEA Support to obtain listed patches and installation instructions.
Security Patches must also be applied to your WebLogic installation. For a guideline on using WebLogic with SAS 9.1.3, see Installing the BEA WebLogic Server and Deploying Web Applications. |
| WebSphere | Windows, IBM AIX | 5.1 | Contact IBM | To contact an IBM representative, go to the
WebSphere Software Link
and on the left side of that page, click on "How To Buy" and call the phone number to order WebSphere version 5.1.
Note that WebSphere is packaged with it's own JDK and it can not be swapped out with another JDK. Currently SAS supports WebSphere Application Server 5.1 with:
You must review and follow the instructions for obtaining these required items from IBM. For more information on using WebSphere with SAS 9.1.3, see Installing the IBM WebSphere Application Server and Deploying Web Applications. |
Security Patches for WebLogic Server 8.1 SP2
The following security advisories from BEA contain instructions for applying security patches to your WebLogic Server 8.1 SP2 installation. These patches are required to run SAS applications. Click on the links below for instructions on downloading and installing the patches.
- BEA04 48.01 (CR124746)
- BEA04 53.00 (CR128888)
- BEA04 54.00 (CR129371)
- BEA04 57.00 (CR134122)
- BEA04 58.00 (CR135189)
- BEA04 52.01 (CR107373 and replacement for wlSecurityProviders.jar)
- BEA04 59.00 (CR171885)
- BEA04 60.00 (CR173632)
- BEA05-74.00 (CR184612 - Obtain from BEA support. Not available for download.)
The following BEA security advisories are fixed by the required patch, CR178990, listed in the application server requirements table above. Do not download individual patches for these advisories.
- BEA04 51.00 (CR127930)
- BEA04 55.00 (CR132949)
Additional security advisories may be published by BEA. For any advisory not listed above, installing the associated patch is supported but not required. Upgrading to a later service pack, however, is not supported. We recommend that you review the current list of advisories to determine whether any additional patches are appropriate for your environment. Registration is also available to receive e-mail notification of new security advisories from BEA as they are published.
Security Patches for WebLogic Server 8.1 SP1
The following security advisories from BEA contain instructions for applying security patches to your WebLogic Server 8.1 SP1 installation. These patches are required to run SAS applications. Click on the links below for instructions on downloading and installing the patches.
- BEA04 40.00 (CR107363)
- BEA04 41.00 (CR124344)
- BEA04 42.00 (CR125829)
- BEA05-74.00 (CR184612 - Obtain from BEA support. Not available for download.)
Additional security advisories may be published by BEA. For any advisory not listed above, installing the associated patch is supported but not required. Upgrading to a later service pack, however, is not supported. We recommend that you review the current list of advisories to determine whether any additional patches are appropriate for your environment. Registration is also available to receive e-mail notification of new security advisories from BEA as they are published.
WebSphere 5.1
Currently SAS supports WebSphere Application Server 5.1 with
(1) WebSphere Application Server 5.1 Cumulative Fix 4
(2) V5.1.0 Cumulative Fix for SDKs
These are two separate fix packs that must be installed on WebSphere Application Server 5.1.
You must obtain the WebSphere 5.1.0 Cumulative Fix 4 directly from the IBM support FTP site. First read the Readme for WebSphere Application Server Version 5.1.0 Cumulative Fix 4. It tells you what files to download and how to install the cumulative fix. To obtain the cumulative fix, you will go to the 5.1.0 Cumulative Fix 4 FTP site and download the applicable file for your particular platform. Note that there are separate cumulative fixes for the Base and the ND products, so if you have ND you will also need to install its cumulative fix.
WebSphere Java SDK cumulative fixes are delivered separately. To obtain these cumulative fixes, please see the V5.1.0 Java SDK cumulative fixes page at http://www.ibm.com/support/docview.wss?rs=180&context=SSEQTP&uid=swg24006682
Please note that when you go to these links, you can just download the package(s) for your particular platform. The UpdateInstaller is included in the package so there is no need to download the UpdateInstaller separately. Read the Readme files at the above URLs for fix pack installation instructions. Set your JAVA_HOME to your WAS_HOME/java directory before running the updateWizard program.
Web Browsers
The SASŪ Business Intelligence Platform and any solutions built on that platform only support Microsoft Internet Explorer 5.5 and higher.
The SASŪ 9.1 Foundation was tested using the Web browsers listed below. Higher versions may also be used, but there may be compatibility issues.
For the UNIX and VMS platforms, the SASŪ 9.1 Foundation was developed to support a Mozilla-based browser for Help and Online Documentation display and the viewing of ODS HTML output. SAS recommends the use of the Netscape or Mozilla browser supplied by the operating system vendor.
For the Windows platforms, the SASŪ 9.1 Foundation uses Microsoft Internet Explorer for wbrowse and can use either Microsoft Internet Explorer or an embedded browser to display ODS results.
| Web Browser | Platform | Version | Link | Notes |
|---|---|---|---|---|
| Netscape | HP Tru64 UNIX | 6.2.3 | Download | |
| Mozilla | OpenVMS Alpha | 1.3 | Download from Mozilla | Version 1.3 is no longer available at HP's website, but you can still get it from Mozilla. For HP's recommendations go to HP Browsers |
| Mozilla | HP-UX PA-RISC | 1.4 | Download | HP has stated that Mozilla is now the supported web browser for HP-UX. For more information see HP Recommendations |
| Netscape | HP-UX Itanium | 7.0 | Download | Netscape 7.0 is no longer available from HP's website. Instead HP recommends the use of Mozilla which is available for download from HP's "Mozilla Web browsers for HP-UX" Website |
| Netscape | Linux | 6.2.3 | Download | Netscape 6.2.3 has been moved to the archive section of Netscape's website at Netscape's Archive Website |
| Netscape | AIX | 7.0 | Download | Netscape 7.0 is no longer available from IBM's website. Instead IBM recommends the use of Mozilla which is available for download from IBM's "Web browsers for AIX" Website |
| Netscape | Solaris on SPARC | 6.2.3 | Download | Netscape 6.2.3 is no longer available from Sun's website. Instead, Sun recommends the use of Mozilla which is available for download from the link to the left. |
| Internet Explorer | Windows 2000 SP2 | 5.01 SP2 (5.00.3315.1000) | Download | |
| Internet Explorer | Windows 2000 SP3 | 5.01 SP3 (5.00.3502.1000) | Download | |
| Internet Explorer | Windows XP | 6 (6.00.2600.0000) | Download | |
| Internet Explorer | Windows XP SP1 | 6 SP1 (6.00.2800.1106) | Download | |
| Internet Explorer | Windows XP SP2 | 6 (6.0.2900.2180) and 7 | Download | Please refer to SAS Note 18994 for more information regarding support for Internet Explorer 7 |
| Internet Explorer | Windows Server 2003 (32-bit or 64-bit Itanium) Windows XP (64-Bit Itanium) |
6 (6.00.3790.0000) | Download |
Web (HTTP) Servers
Web (HTTP) servers are frequently configured for use as proxy servers that support load balancing and firewall configurations in front of the Web application servers that host the SAS Web applications. HTTP servers can also be used to serve static content that is associated with Java web applications. Refer to your selected Web application server vendor's configuration requirements for a list of HTTP servers that are supported for use in this manner.
SASŪ Data Surveyor for Clickstream Data Mid-Tier requires the installation of Apache HTTP Server. Apache HTTP Server requirements for use with SAS Data Surveyor for Clickstream Data Mid-tier can be found in the install center.
WebDAV Servers
For specific information regarding SAS®Products/Solutions and WebDAV support, please review the installation instructions for the SAS®Product or Solution you are installing.
| Product | Platform | Version | Link | Notes |
|---|---|---|---|---|
| Xythos WebFile Server | Windows, Solaris on SPARC, IBM AIX, Linux, HP-UX Itanium |
4.0.48.15 | Available on the Xythos WebFile Server CD in the Third Party Media Division of your SAS® Installation Kit. | Xythos WFS requires a database engine to persist system configuration information and metadata and, optionally, to act as a content file system. WFS makes use of independent database modules in order to support a variety of databases. WFS ships with modules that support DB2 version 8.0 or higher, MS SQL Server 2000 or higher, Oracle 8.1.6 or higher, and PostgreSQL 7.2.1 or higher. Click on your database below for more specific database information. As part of the Database server, WFS requires a JDBC driver be installed. All JDBC drivers must support the Java 1.2 version of JDBC. Click on your database below for specific JDBC driver information. |
| Apache HTTP Server | Windows | 2.0.45 or higher | Download | Click on one of the Windows installer files (MSI or EXE) for version 2.0.45 to download. |
| Apache HTTP Server | UNIX | 2.0.45 or higher | Download | Click on one of the UNIX source tar files for version 2.0.45 to download. Follow the instructions inside for building the Apache binaries with mod_dav support. |
Xythos WFS Database Requirements
- DB2
To use the WFS DB2 module, the DB2 database version needs to be 8.0 or higher. During install:- The database must be created with UTF8 for the National character set.
- For the global schema database, administrators must create two tablespaces: one Regular tablespace with a pagesize of at least 32K for tables and indexes and one System Temporary tablespace with a pagesize of at least 32K for system space for joins.
- For each document store, administrators must create three tablespaces: one Regular with a pagesize of at least 32K for tables and indexes, one System Temporary tablespace with a pagesize of at least 32K for system space for joins, and one User Temporary tablespace with a pagesize of at least 4K for declared global temporary tables.
- The administrator should periodically manage data statistics using the statistics utility, RUNSTAT. Specifically, use the command reorgchk update statistics on table all from the command center to manage data statistics.
- The DB2 tablespaces can be system-managed, but if you put the tables and indexes in separate tablespaces, you must define an additional tablespace for the indexes and make them user-managed because DB2 prohibits keeping indexes and tables in separate tablespaces.
- Microsoft SQL Server
- To use the WFS Microsoft SQL Server module, MS SQL Server 2000 or higher is required. As with PostgreSQL, SQL Server uses multiple databases and thus, Xythos WFS requires one database for the Xythos Global Schema and a database for each Xythos Document Store. These databases are created through the SQL Server interface. During install, the database users created must be granted both "db_datareader" and "db_datawriter" rights on the respective database that each user will be accessing.
- Oracle
- To use the WFS Oracle module, the Oracle database version needs to be 8i (8.1.7) or higher. During install:
- The database must be created with UTF8 for the National character set. The Standard database character set can be any value and, in general, should not be UTF8 for maximum performance.
- The database must be created with a block size of 8K or greater.
- If installing Oracle 8, the database must be created with the 8.1.0, as opposed to 8.0.5, compatibility option.
- The database must be created with its "open_cursors" startup parameter equal to the value of 150 or higher. Note that on NT/Windows 2000 installations, the default is 100.
- Because Oracle typically uses only one database instance, Xythos WFS requires schemas, a.k.a. users, to be created. WFS uses one schema for the Xythos Global Schema and at least one other schema for a Xythos Document Store.
- PostgreSQL
- To use the WFS PostgreSQL module, the PostgreSQL database version 7.2.1 or higher is required. Because PostgreSQL uses multiple databases, Xythos WFS requires one database for the Xythos Global Schema and a database for each Xythos Document Store.
Xythos WFS JDBC Driver Requirements
- DB2
If using the DB2 database, WFS requires type 4 of the driver be used. This file should be obtained from IBM to ensure correctness. Visit the IBM Web site to obtain the proper file. - Microsoft SQL
If using an MS SQL Server database, there are several different JDBC drivers from which to choose. The Microsoft SQL Server JDBC Driver (SP2 and higher) can be used. The Xythos-SQL Server module has also been extensively tested using the Sprinta2000 driver. - Oracle
If using the Oracle database, Xythos recommends Oracle's thin JDBC driver be used for better performance. WFS requires version 9.2.0.1 of the driver be used regardless of the version of Oracle used. This file should be obtained from Oracle to ensure correctness. Visit the Oracle Web site to obtain the proper file. - PostgreSQL
If using the PostgreSQL database, WFS requires use of the PostgreSQL 7.4 JDBC driver. Obtain the PostgreSQL JDBC driver version 7.4 from the PostgreSQL web site. (This is true even if using PostgreSQL 8.0)
