Fill and Sign the Authorization Letter for Psa Marriage Contract Form

System Requirements and Supported Platforms for Oracle® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O February 2012 System Requirements and Supported Platforms for Oracle Business Intelligence Suite Enterprise Edition E10417-17 Copyright © 2003, 2012, Oracle and/or its affiliates. All rights reserved. This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be errorfree. If you find any errors, please report them to us in writing. If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065. This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services. Contents System Requirements and Supported Platforms for Oracle® Business Intelligence Suite Enterprise Edition 1 Chapter 1: Introduction Oracle Business Intelligence Suite Enterprise Edition Documentation Certification and Support for Third-Party Products Documented Changes Chapter 2: 6 6 6 Platform Requirements for Oracle Business Intelligence Hardware Requirements 10 Hardware Requirements for Oracle Business Intelligence Platform 10 Hardware Requirements for Cluster Server 11 Hardware Requirements for Oracle Business Intelligence Disconnected Analytics Server Environment Requirements 15 16 Supported Server Operating Systems 17 Supported Web And Application Servers 18 Oracle Business Intelligence Delivers Support for SMTP Support for ODBC and JDBC Client Interfaces 21 21 Products Supported as Clients to Oracle Business Intelligence Server Oracle Enterprise Performance Management Integration Supported Data Sources 22 22 22 Supported Data Sources for Oracle Business Intelligence Enterprise Edition Support for Multidimensional Data Sources 29 Support for Oracle Real Applications Clusters (RAC) 29 Support for ODBC Data Sources 30 SSL Compatibility 23 30 Support for Virtualization and Virtual Machines Client Environment Requirements 31 Supported Web Browsers 31 Supported Client Operating Systems Globalization Requirements 30 33 35 Overview of Supported Environments 37 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 3 Contents n Chapter 3: Supported Software and Ancillary Programs Supported Software Ancillary Programs License Agreements 39 40 45 Chapter 4: Product and Platform Availability Updates Chapter 5: Planned Certification 4 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 1 Introduction This book contains the definitive list of system requirements and supported platforms for Release 10.1.3.3 and 10.1.3.4 of Oracle Business Intelligence Enterprise Edition. Unless otherwise noted herein, the requirements covered in this document apply to all platform and related end-user applications within the Oracle Business Intelligence product line. For more information about Oracle Business Intelligence, see Oracle Business Intelligence Infrastructure Installation and Configuration Guide. This guide contains the following chapters: • Chapter 1, “Introduction” (this chapter) includes the following topics: • Oracle Business Intelligence Suite Enterprise Edition Documentation • Certification and Support for Third-Party Products • Documented Changes • Chapter 2, “Platform Requirements for Oracle Business Intelligence,” describes platform and hardware requirements for Oracle Business Intelligence. • Chapter 3, “Supported Software and Ancillary Programs,” provides a comprehensive listing of software developed by third-party vendors that is supported by, embedded in, or distributed with Oracle Business Intelligence applications. • Chapter 4, “Product and Platform Availability Updates,” provides a list of product availability exceptions for Oracle Business Intelligence. • Chapter 5, “Planned Certification,” lists certifications planned for future product releases. System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 5 Introduction n Oracle Business Intelligence Suite Enterprise Edition Documentation Oracle Business Intelligence Suite Enterprise Edition Documentation Documentation for Oracle Business Intelligence Suite Enterprise Edition is available on Oracle Technology Network (OTN). To access Oracle Business Intelligence Suite Enterprise Documentation on Oracle Technology Network Go to the Oracle Business Intelligence Suite Enterprise Edition Documentation Library: http://www.oracle.com/technology/documentation/bi_ee.html Certification and Support for Third-Party Products Oracle certifies and supports Oracle Business Intelligence Enterprise Edition against a wide range of technology standards and third-party products. A certified third-party product is one that has been tested by Oracle as part of the standard release process. While Oracle makes every effort to certify commonly used third-party products, not all thirdparty products or all possible configurations are certified. Oracle also focuses on performing standards-based testing for third-party product compatibility and integration with Oracle Business Intelligence Enterprise Edition. Any third-party product that complies with a standard that is supported by Oracle BI EE is supported for use with Oracle BI EE. For supported third-party products, Oracle Customer Support will accept service requests for Oracle BI EE configurations that include these third-party components. Certified third party products are documented in this guide. The standards or protocols that are supported for Oracle BI EE are also provided. This will help determine whether a particular thirdparty product that is not specifically listed as certified is supported or not. Documented Changes Oracle Business Intelligence Enterprise Edition 10.1.3.4.2 – Release August 2011 Rev. M Certifications added: • Microsoft Windows 7 and Windows 2008 Server R2 • Microsoft Office 2010 for BI Office Add-in and BI Publisher Desktop • Microsoft Internet Expolerer 9 • Mozilla Firefox 3.5 • IBM Websphere Application Server 7.0.0.x Item of Note with Update M: 6 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Introduction n Documented Changes Several Operating Systems, Application Servers, and datasources listed in this document that were supported have reached their supported end of life and are no longer supported by the software vendors. Oracle Business Intelligence Enterprise Edition 10.1.3.4.1 – Release October 2009 Rev. L Certifications added: • Oracle Database 11gR2 • Microsoft SSAS 2008 • SAP BW 3.5 SP 20 or higher, SAP BW 7.0 SP 17 or higher • Netezza 4.6.2 • Teradata 13 Item of Note with Update L: Several of the Teradata database versions are no longer Supported by Teradata. Oracle Business Intelligence Enterprise Edition 10.1.3.4.1 – Release April 2009 Rev. K Certifications added: • IBM DB2 for UDB 9.5 • MS SQL Server 2008 64-bit • Netezza 4.5 • Firefox 3.0 • IBM DB2 9 on z/OS • JDK 1.6 • Oracle Application Server 10.1.3.4 • Oracle WebLogic Server 10.3 • Siebel CRM 8.1.1 Integration Items of Note: At the time of this release • JDK1.4 EOL reached October 30th, 2008 • JDK1.5 is planned for EOL October 30th, 2009 • Websphere 5.1 End of Support date September 2008 NOTE: Always check vendors’ Web Sites for end-of-life (EOL) policies and announcements. System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 7 Introduction n Documented Changes 8 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n 2 Platform Requirements for Oracle Business Intelligence This chapter includes the following topics: • Hardware Requirements • Server Environment Requirements • Oracle Business Intelligence Delivers Support for SMTP • Support for ODBC and JDBC Client Interfaces • Products Supported as Clients to Oracle Business Intelligence Server • Oracle Enterprise Performance Management Integration • Supported Data Sources • SSL Compatibility • Support for Virtualization and Virtual Machines • Client Environment Requirements • Globalization Requirements • Overview of Supported Environments System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 9 Platform Requirements for Oracle Business Intelligence n Hardware Requirements Hardware Requirements This section describes the hardware and network requirements for Oracle Business Intelligence Enterprise Edition 10.1.3.3 and 10.1.3.4. Oracle has certified acceptable performance in these environments; however, performance is improved by using faster processors and additional memory. NOTE: The hardware requirements listed in Table 1, Table 2, Table 3, and Table 4 are minimum requirements for the C++ components of Oracle BI EE, and should be used only as a guideline, as they do not take into consideration various factors that affect scalability. Please consult your hardware vendor or Oracle Consultancy for capacity planning or sizing assistance. Hardware Requirements for Oracle Business Intelligence Platform Hardware requirements for Oracle Business Intelligence C++ components are described in Table 1 and in Table 2 on page 11. Table 1. Minimum Requirements for Oracle Business Intelligence on Windows Description Requirement Oracle Business Intelligence Server components: CPU and RAM: Oracle Business Intelligence Server Oracle Business Intelligence Administration Tool Oracle Business Intelligence Scheduler 1 GHz, 2 GB RAM Disk Space: 2 GB of hard disk space, plus appropriate disk space for cache storage and Scheduler results sets (see Temporary Disk Space). Temporary Disk Space: 2 GB Oracle Business Intelligence Presentation Services CPU and RAM: 1 GHz, 2 GB RAM Disk Space: 2 GB of hard disk space, plus appropriate disk space for cache storage and log files (see Temporary Disk Space). Temporary Disk Space: 2 GB 10 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Hardware Requirements Hardware Requirements for Cluster Server Table 2. Minimum Requirements for Oracle Business Intelligence on Linux and UNIX Description Requirement Oracle Business Intelligence Server components: CPU and RAM: Oracle Business Intelligence Server Oracle Business Intelligence Scheduler 1 GHz, 2GB RAM Disk Space: 2GB, plus appropriate disk space for cache storage and Scheduler results sets (see Temporary Disk Space). Temporary Disk Space: 2 GB Oracle Business Intelligence Presentation Services CPU and RAM: 1 GHz, 2 GB RAM RAM: 2 GB or better Disk Space: 2GB, plus appropriate disk space for cache storage and log files (see Temporary Disk Space). Temporary Disk Space: 2 GB Requirements for Cluster Server are described in Table 3 and Table 4 on page 13. System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 11 Platform Requirements for Oracle Business Intelligence n Hardware Requirements Table 3. Requirements for Cluster Server on Windows Description Requirement A machine hosting a clustered Oracle Business Intelligence Server or a machine hosting an Oracle Business Intelligence Server, an Oracle Business Intelligence Scheduler, and a Cluster Controller Processor and RAM: A machine hosting a Cluster Controller or an Oracle Business Intelligence Scheduler Processor and RAM: 1 GHz; 2 GB RAM Disk Space: 1 GB 500 MHz, 1 GB Disk Space: Approximately 100 MB of hard disk space Shared File System for use as Repository Publishing Directory When a repository is updated in online mode, it is published to a repository publishing directory that all clustered servers examine upon startup for any repository changes. The location of the repository publishing directory is specified in the “REPOSITORY_PUBLISHING_DIRECTORY” parameter in the NQSConfig.ini file. Characteristics: The repository publishing directory needs to be in a valid location visible to all servers in the cluster. All Oracle Business Intelligence Servers in the cluster (from the parameters “SERVERS” in the NQClusterConfig.ini file) need to have read and write access to this directory.1 Disk Space: Approximately 200 MB of hard disk space. Note that the I/O load imposed on the shared file system by clustering is minimal. There is no recommendation for the type of file system used, other than that it needs to be a sufficiently reliable file system for successful cluster operations. 12 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Hardware Requirements Table 3. Requirements for Cluster Server on Windows Description Requirement Shared File System for use with Cluster-Aware Cache When query cache is shared across a cluster, cache seeding requests (from iBots or ODBC procedure calls) in a queue of activities are managed in a shared directory. All Oracle Business Intelligence Servers must have read and write access to this directory.1 Disk Space: Appropriate disk space for cache storage depending on your deployment. Shared File System for use with Presentation Catalog2 Characteristics: All Oracle Business Intelligence Presentation Services servers must have read and write access to this directory.1 Disk Space: Appropriate disk space for the Presentation Catalog depending on your deployment. 1. Oracle Business Intelligence services must be run as a domain user with access to the network share. Microsoft Windows does not allow the “system” account to read or write from network shares. 2. Storage devices such Network Attached Storage (NAS) or Storage Area Networks (SAN) may be used for the shared file system. The Presentation Catalog was tested on Oracle Cluster File System (OCFS2) on SAN and NFS on NAS. Table 4. Requirements for Cluster Server on Linux and UNIX Description Requirement A machine hosting a clustered Oracle Business Intelligence Server or a machine hosting an Oracle Business Intelligence Server, and Oracle Business Intelligence Scheduler, and a Cluster Controller CPU: 1 GHz A machine hosting a Cluster Controller or an Oracle Business Intelligence Scheduler CPU: 500 MHz RAM: 2 GB Disk Space: 2GB RAM: 1 GB Disk Space: 2GB System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 13 Platform Requirements for Oracle Business Intelligence n Hardware Requirements Table 4. Requirements for Cluster Server on Linux and UNIX Description Requirement Shared File System for use as Repository Publishing Directory When a repository is updated in online mode, it is published to a repository publishing directory that all clustered servers examine upon startup for any repository changes. The location of the repository publishing directory is specified in the “REPOSITORY_PUBLISHING_DIRECTORY” parameter in the NQSConfig.ini file. Characteristics: The repository publishing directory needs to be in a valid location visible to all servers in the cluster. All Oracle Business Intelligence Servers in the cluster (from the parameters “SERVERS” in the NQClusterConfig.ini file) need to have read and write access to this directory. Disk Space: Approximately 200 MB of hard disk space Note that the I/O load imposed on the shared file system by clustering is minimal. There is no recommendation for the type of file system used, only that it be a sufficiently reliable file system for successful cluster operations. Shared File System for use with Cluster-Aware Cache When query cache is shared across a cluster, cache seeding requests (from iBots or ODBC procedure calls) in a queue of activities are managed in a shared directory. Disk Space: Appropriate disk space for cache storage depending on your deployment. Shared File System for use with Presentation Catalog Characteristics: All Oracle Business Intelligence Presentation Services Instances must have read and write access to this directory. Disk Space: Appropriate disk space for the Presentation Catalog depending on your deployment. 14 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Hardware Requirements Hardware Requirements for Oracle Business Intelligence Disconnected Analytics Requirements for Oracle Business Intelligence Disconnected Analytics are described in Table 5. Table 5. Requirements for Oracle Business Intelligence Disconnected Analytics on Microsoft Windows/Windows XP Requirement Description Processor Disk Space Available RAM Minimum A modern processor (at least 800 MHz) 1 GB 512 MB Recommended alongside MS Office applications A modern processor (at least 800 MHz) 1 GB 512 MB Recommended alongside Siebel Remote applications A modern processor (at least 800 MHz) 2 GB 512 MB System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 15 Platform Requirements for Oracle Business Intelligence n Server Environment Requirements Server Environment Requirements This section includes the following topics: • Supported Server Operating Systems • Supported Web And Application Servers • Oracle Business Intelligence Delivers Support for SMTP • Support for ODBC and JDBC Client Interfaces 16 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Server Environment Requirements Supported Server Operating Systems Oracle Business Intelligence supports the server operating systems listed in Table 6 and the supported server operating systems patch levels listed in Table 7. Table 6. Supported Server Operating Systems Client Type Operating System1 Oracle Business Intelligence Server Microsoft Windows 2000/2003 Server Oracle Business Intelligence Presentation Services Microsoft Windows Server 2008 Enterprise Edition x86 32 bit2 Oracle Business Intelligence Publisher Microsoft Windows Server 2008 R23,4 Red Hat Enterprise Linux AS 4.x Red Hat Enterprise Linux Server/Advanced Platform 5.x Novell SUSE 9.x Oracle Enterprise Linux 4.x Oracle Enterprise Linux 5.x Sun Solaris 9 SPARC 32 bit Sun Solaris 9 SPARC 64 bit Sun Solaris 10 SPARC 32 bit Sun Solaris 10 SPARC 64 bit AIX 5.2 PowerPC 32 bit AIX 5.2 PowerPC 64 bit AIX 5.3 PowerPC 32 bit AIX 5.3 PowerPC 64 bit AIX 6.1 PowerPC 32 bit2 AIX 6.1 PowerPC 64 bit2 HP-UX 11.11 PA-RISC 64 bit4 HP-UX 11.23 PA-RISC 64 bit4 HP-UX 11.23 Itanium 64 bit HP-UX 11.31 Itanium 64 bit2, 1. Windows and Linux 64-bit support: For the Windows and Linux releases, the Oracle BI EE software is 32-bit. The software can run on 64-bit processors that support 32-bit emulation. The supported processors are AMD64 and EM64T. NOTE: Revisions A and B of this guide incorrectly listed Itanium2 as a supported processor. 2. Supported for Oracle Business Intelligence Enterprise Edition 10.1.3.4. System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 17 Platform Requirements for Oracle Business Intelligence n Server Environment Requirements 3. Supported with Oracle Business Intelligence Enterprise Edition 10.1.3.4.2 4. Oracle Business Intelligence Enterprise Edition binaries are 32-bit. Table 7. Supported Server Operating Systems Patch Levels Server Operating System Patch Levels Microsoft Windows 2000 Server/Advanced Server Service Pack 4 (5.0.2.195)1 or higher Microsoft Windows 2003 SP 1 or higher Microsoft Windows 2003 R2 Not applicable IBM AIX 5.32 Recommended: AIX 5.3. ML05 or higher HP-UX 11.23 Itanium 64 bit Recommended: Quality Pack Bundle for HP-UX 11i v2, March 2007 and pthread library cumulative patch PHCO-34944 1. Service Pack 4 (5.0.2.195) requires KERNEL32.DLL 5.0.2195.6897 or higher. Apply Windows HotFix KB835732 or higher. 2. IBM AIX requires C++ runtime version xlC.aix50.rte 9.0.0.3 or higher. With 10.1.3.4.1 and 10.1.3.4.2 IBM AIX requires C++ runtime xlC.aix50.rte 10.1.0.3 or higher Supported Web And Application Servers Any J2EE-based Application Server that supports Servlet Specification version 2.3 or above is supported for use with Oracle Business Intelligence Enterprise Edition. The Application Server must also support SOAP 1.1 Client, Axis 1.2-1.4, JWSDP 2.0 (Sun/Jdeveloper SOAP client), and .NET 2.0. 18 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Server Environment Requirements The Web Servers and Application Servers listed in Table 8 have been certified for use with Oracle Business Intelligence Enterprise Edition. Table 8. Certified Web Servers and Application Servers Server Operating System Web Server/Application Server and Patch Level Linux and UNIX (See Table 6 on page 17) Oracle Application Server versions 10.1.3.1, 10.1.3.3, 10.1.3.4+1 Oracle Weblogic 9.x, 10.02, 10.31, 10.3.x+3 IBM WebSphere Application Server versions 5.1, 6.0, 6.1, 7.0.0.x3 Sun Java System Web Server 6.1, 7.0 Apache Tomcat 5.5.x JBoss Application Server 4.02 Microsoft Windows (See Table 6 on page 17) Oracle Application Server versions 10.1.3.1, 10.1.3.3, 10.1.3.4+1 Oracle Weblogic 9.x, 10.02, 10.31, 10.3.x+3 Microsoft IIS 5.0 on Windows 2000 and IIS 6.0 on Windows 20034 Microsoft IIS 7.03,4 IBM WebSphere Application Server versions 5.1, 6.0, 6.1, 7.0.0.x3 Sun Java System Web Server 6.1, 7.0 Apache Tomcat 5.5.x JBoss Application Server 4.02 1. Certification of Oracle Application Server 10.1.3.4 and Oracle Weblogic 10.3 was performed for Oracle Business Intelligence Enterprise Edition 10.1.3.4.1 2. Certification of Oracle Weblogic 10.0 and JBoss Application Server 4.0 were performed for Oracle Business Intelligence Enterprise Edition 10.1.3.4. 3. Supported with Oracle Business Intelligence Enterprise Edition version 10.1.3.4.2 4. Microsoft IIS is supported as an HTTP server for Oracle Business Intelligence Publisher and Oracle Business Intelligence Office Server via the Oracle Application Server Proxy Plug-in. Oracle Business Intelligence Publisher and Oracle Business Intelligence Office Server require a J2EE Application server NOTE: 1. Oracle Business Intelligence Enterprise Edition requires Java 2 Platform Standard Edition 1.5.x. On IBM AIX, the version of JDK must be J2RE 1.5.0 IBM AIX build pap32devifx-20060310 (SR1) or higher (1.5.x+) for Oracle Business Intelligence 10.1.3.4.1 and higher. NOTE: 2. JDK 1.6.x has been certified for use with Oracle Business Intelligence Enterprise Edition 10.1.3.4.1. System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 19 Platform Requirements for Oracle Business Intelligence n Server Environment Requirements Web Portal Support JSR-168 compliant portals XSLT v2 and WSRP 2 are supported for use with Oracle Business Intelligence Enterprise Edition. CAUTION: Due to differences in the implementation of JSR-168 standards by portal vendors, the use of the Portal products that are listed in Table 9 is strongly recommended. The Web Portals listed in Table 9 have been certified for use with Oracle Business Intelligence Enterprise Edition. Table 9. Certified Web Portals Portal Version Oracle Portal 10.1.4.x Oracle WebCenter 10.1.3.2 IBM WebSphere Portal Server 5.1, 6.0 Single Sign-On (SSO) Server Support Oracle Business Intelligence Enterprise Edition has a pluggable SSO architecture that allows the integration of any SSO product that propagates SSO authentication tokens across HTTP or HTTPS. See the Oracle Business Intelligence Enterprise Edition Deployment Guide Version 10.1.3.2 for more information on the SSO system prerequisites. The SSO Servers listed in Table 10 have been certified with Oracle Business Intelligence Suite Enterprise Edition. Table 10. Certified SSO Servers SSO Server1 Version Oracle SSO 10g 10.1.2.0.2, 10.1.4.x IBM Tivoli 6.0 CA eTrust Siteminder 6.0 1. Oracle Business Intelligence Publisher 10.1.3.4 and prior releases supports the use of only Oracle SSO. With the Business Intelligence Publisher 10.1.3.4.1 release and higher the above SSO servers are also supported. Oracle Business Intelligence is supported with Oracle Access Manager 10g (10.1.4.x) and 11g (11.1.1.x). Identity Management Support LDAP Certified Product Standard V2 or V3 is supported for use with Oracle Business Intelligence Enterprise Edition. Refer to http://www.opengroup.org/openbrand/register/dkm0.htm. 20 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Oracle Business Intelligence Delivers Support for SMTP The Identity Management applications listed in Table 11 have been certified with Oracle Business Intelligence Enterprise Edition. Table 11. Certified Identity Management Applications Identity Management System Version Oracle Identity Management 10g,11g 10.1.2.0.2, 10.1.4.x,11.1.1.x IBM LDAP Server 5.x Windows ADSI 2000, 2003 Windows Native Authentication (Kerberos) Not applicable Novell Identity Manager 3.0.1 IBM Tivoli Identity Management 6.0 Sun Java System Identity Server 5.x Oracle Business Intelligence Delivers Support for SMTP Oracle Business Intelligence Delivers generates MIME content with aggregate HTML encapsulation in accordance with MIME RFC 2110 and delivers it to SMTP servers through the SMTP protocol. Content rendering is, however, dependent on the customer's implementation of the email client. Support for ODBC and JDBC Client Interfaces Oracle provides ODBC and JDBC client drivers so that third-party software products can connect as SQL clients to the Oracle Business Intelligence Server. Although many clients such as Microsoft Access and Business Objects can be used, Oracle has not explicitly certified particular clients. Client interfaces ODBC 2.0 and 3.5 and JDBC 2.0 and 2.1 that use SQL92 or higher are supported for this purpose. The Oracle Business Intelligence Server ODBC driver supports ODBC 3.5 applications for UTF-16 character set for read-only access. Oracle Business Intelligence Server JDBC driver supports JDBC 2.0/2.1 API clients or applications for read-only access. System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 21 Platform Requirements for Oracle Business Intelligence n Products Supported as Clients to Oracle Business Intelligence Server Products Supported as Clients to Oracle Business Intelligence Server Table 12 lists products that are supported as clients to the Oracle Business Intelligence Server. Table 12. Products Supported as Clients to Oracle Business Intelligence Server Product and Version Oracle Essbase 11.1.1, 11.1.2.x Oracle Smart View for Office Fusion Edition 11.1.1 Oracle’s Hyperion Interactive Reporting 9.3.1, 11.1.1 Business Objects: Enterprise XI 3.0 on Windows Oracle Enterprise Performance Management Integration Table 13 lists the Oracle Enterprise Performance Management products that integrate with Oracle Business Intelligence Enterprise Edition 10.1.3.4. See the Oracle Business Intelligence New Features Guide Release 10.1.3.4. for details of the integration. Table 13. Oracle Enterprise Performance Management Products Integrated with Oracle Business Intelligence Enterprise Edition Product and Version Oracle EPM Workspace Fusion Edition 11.1.1 Oracle Smart Space Fusion Edition 11.1.1 Supported Data Sources NOTE: Oracle Business Intelligence creates database-specific code to help optimize performance for different databases. Due to changes introduced in different database versions, only explicitly tested versions of database client and server software are listed below. In instances where alternative service pack or patch levels have been tested and certified, these will also be indicated. If a customer running on a higher patch level finds a problem in the use of their Oracle Business Intelligence software, then Global Technical Support will investigate it as normal. If a defect is found in the Oracle Business Intelligence software, the normal support process will be followed to determine if and when the defect will be rectified. In such a case, that defect identified will be considered to be in the higher version of database software, not the Oracle Business Intelligence software. It may be possible for Oracle to produce a patch to work around this defect, but this cannot be guaranteed and indeed may not even be technically possible. In this situation, the customer should contact the database vendor to obtain a patch to their database software that rectifies the problem, or should regress their database software back down to a version that does not exhibit this problem when running with Oracle Business Intelligence software. 22 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Supported Data Sources Customers’ regression and acceptance tests that will be run after the database upgrades are performed should fully test the range of features and functionality that are expected to be seen in the production environment, to ensure that they are confident there are no significant problems introduced by the upgrade of the database software. This section includes the following topics: • Supported Data Sources for Oracle Business Intelligence Enterprise Edition • Support for Multidimensional Data Sources • Support for Oracle Real Applications Clusters (RAC) • Support for ODBC Data Sources Supported Data Sources for Oracle Business Intelligence Enterprise Edition Oracle Business Intelligence Server supports the data sources listed below in Table 14 for queries. In addition, Oracle Business Intelligence offers connectivity to multidimensional data sources, as detailed in Table 18 on page 29, and ODBC data sources, as detailed in “Support for ODBC Data Sources” on page 30. Oracle Business Intelligence Publisher provides reports against data in the data sources listed in Table 14 through JDBC access to the Oracle Business Intelligence Server. For information on the data sources and connectivity software directly supported by Oracle Business Intelligence Publisher, see the Oracle® Business Intelligence Publisher Certification Information guide. Guides for Oracle Business Intelligence Publisher versions 10.1.3.3 and 10.1.3.4 are available as part of the respective Documentation Libraries for these releases. The Oracle Business Intelligence Documentation Libraries are available on Oracle Technology Network at the following location (copy and paste the URL into your browser, if required): http://www.oracle.com/technology/documentation/bi_pub.html The databases supported for the Oracle Business Intelligence Delivers Scheduler are listed in Table 16. The databases supported for the Oracle Business Intelligence Publisher Scheduler are listed in Table 17. System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 23 Platform Requirements for Oracle Business Intelligence n Supported Data Sources Supported Data Sources for Oracle Business Intelligence Server Oracle Business Intelligence Server supports the data sources listed below in Table 14 for queries. NOTE: 64-bit versions of the databases documented in Table 14 are supported. Table 14. Supported Data Sources for the Oracle Business Intelligence Server Vendor and Product Version Connectivity Software Microsoft SQL Server 2000 2000 Service Pack 3 or higher SQL Server ODBC Driver/ Microsoft Data Access Components (MDAC) 2.7 or higher DataDirect ODBC driver version 5.1 or higher1(For Oracle Business Intelligence Servers on non-Windows systems) Microsoft SQL Server 2005 2005, 2005 SP1 +.NET Vulnerability fix or higher SQL Server Native Client 200599-1355-00/ SQL Server ODBC Driver version 3.70.08.202 Microsoft Data Access Components (MDAC) 2.8 DataDirect ODBC driver version 5.1 or higher1 (For Oracle Business Intelligence Servers on non-Windows systems) Microsoft SQL Server 2008 20083 Microsoft SQL Server ODBC Driver v03.86.1830 DataDirect v05.30.0052 Oracle’s Hyperion Essbase 7.1.6.1, 9.2.0.3, 9.3.1.0 Essbase Client 9.3.1 Oracle Essbase 11.1.1 Essbase Client 9.3.1, 11.1.1 11.1.2+3 Essbase Client 9.3.1, 11.1.13 IBM DB2 Universal Database (UDB) Enterprise Edition/ Workgroup Edition for Windows and UNIX and Linux on IA-32 8.2 with FixPak 5s or higher DB2 SDK 8.2.x client IBM DB2 Universal Database (UDB) Enterprise Edition 9.1, 9.53 IBM DB2 UDB Admin Client DB2 v8.1 FP12s or higher 24 9.74 DB2 Client Connectivity Driver v9.01.200.983 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Supported Data Sources Table 14. Supported Data Sources for the Oracle Business Intelligence Server Vendor and Product Version Connectivity Software IBM DB2 Universal Database (UDB) for OS/390 and z/OS (NFM mode only) 8, 9.13 IBM DB2 UDB Admin Client DB2 v8.1 FP12s or higher IBM Informix5 10.0 DataDirect ODBC driver version 5.1 or higher1 Oracle Database 9i6 9.2.0.7 or higher Oracle native client 9.2.0.7 or 10.1.0.5 or higher Oracle Database 10g5 10gR1: 10.1.0.5 or higher (Enterprise Edition, Standard Edition, Standard Edition One) Oracle native client 10.1.0.5/ native clients OCI 10g2 10gR2: 10.2.0.2.0 or higher Oracle native client 10.2.0.1.0 or higher/native clients OCI 10g2 Oracle Database 11g3 11.1.0.6.0 or higher (Enterprise Edition, Standard Edition, Standard Edition One) 11.2.0.1 or higher Oracle native client OCI 11g/ Oracle native client 11g HP Oracle Database Machine7 11.1.0.7 or higher Oracle native client OCI 11g/ Oracle native client 11g Oracle Exadata Database Machine3 11.2.0.1 or higher Oracle native client OCI 11g/ Oracle native client 11g HP Neoview6 2.3 Transporter SP1 HP Neoview ODBC Driver Release 2.3 Update 2 Teradata V2R5.1.x, V2R6.0, V2R6.1, V2R6.2 ODBC Driver for Teradata 3.6.0.0 (03.06.00.00) or higher8 12.09, 13.03, 13.103 Teradata 12.00.00.01 Client8 DB2 Connect 9 (Enterprise Edition, Standard Edition) HP Oracle Exadata Storage Server Teradata 13.0.0.0 Client3 Teradata 13.10.0.0 Client3 Netezza 3.1 Netezza native ODBC driver version 3.1 4.0, 4.53 Netezza native ODBC driver version 3.1 4.6.23 5,03 Netezza Driver 4.5.2 P4 Netezza Driver 4.6.2 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 25 Platform Requirements for Oracle Business Intelligence n Supported Data Sources Table 14. Supported Data Sources for the Oracle Business Intelligence Server Vendor and Product Version Connectivity Software Sybase Adaptive Server Enterprise (ASE) 15.0 DataDirect ODBC driver version 5.1 or higher1 Sybase IQ 12.7 Sybase native ODBC driver version 12.7 Sybase SQL Anywhere10 9.0 Corresponding SQL Anywhere ODBC driver Oracle’s Retek RPAS11 12.1.x Windows: DataDirect OpenAcces ODBC Client version 5.6 AIX: DataDirect OpenAccess ODBC driver version 5.6 TimesTen 7.2 TimesTen native ODBC driver version 7.212 1. For Oracle Business Intelligence Servers on non-Windows operating systems, see section DataDirect Connect ODBC Drivers Version 5.3 Bundled with Oracle BI EE 10.1.3.3.1 and higher on page 26. 2. Microsoft recommends using SQL Server Native Client with Microsoft SQL Server 2005. 3. Certified with Oracle Business Intelligence Enterprise Edition 10.1.3.4.1 4. Certified with Oracle Business Intelligence Enterprise Edition 10.1.3.4.2 5. IBM Informix has been certified on AIX platform only. 6. For Oracle 9i and 10g databases, native client OCI 10g2 is recommended. 7. Certified with Oracle Business Intelligence Enterprise Edition 10.1.3.4. 8. The exact version of the Teradata ODBC driver that is required depends on the operating system and processor (32 bit or 64 bit). Refer to the Drivers and Connectivity Software download page on the Teradata website for information on the exact 3.6.0.0x version that is supported for a given operating system. 9. Teradata 12.0 is supported with Oracle Business Intelligence Enterprise Edition 10.1.3.4. It is supported with Oracle Business Intelligence Enterprise Edition 10.1.3.3.3 with the Oracle Business Intelligence Server on Windows. NOTE: Revision H of this guide incorrectly listed 12.00.01.10 as the supported version of the Teradata Client. Revision I corrects this version to 12.00.00.01. 10.1.3.4.1 used Teradata client 12.0 on HP-UX. 10. Sybase SQL Anywhere is only supported for the Oracle Business Intelligence Disconnected Analytics Client. 11. Oracle Business Intelligence supports Retek RPAS on Windows and AIX 5.3 platforms only. 12. Oracle Business Intelligence Server supports the ODBC 2.0 interface with ASCII for the TimesTen database. UTF-8 and UTF-16 are not supported. DataDirect Connect ODBC Drivers Version 5.3 Bundled with Oracle BI EE 10.1.3.3.1 and higher Oracle Business Intelligence Enterprise Edition version 10.1.3.3.1 and higher provides DataDirect Connect ODBC drivers version 5.3 for Linux and UNIX operating systems for connectivity to MS SQL Server, Informix and Sybase ASE databases. See the Oracle Business Intelligence New Features Guide for information on installation and usage of the DataDirect Connect ODBC drivers provided with Oracle BI EE 10.1.3.3.1 and higher. 26 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Supported Data Sources 32-bit and 64-bit DataDirect 5.3 drivers are available for AIX, Solaris and HP-UX Itanium. 32-bit drivers are available for Linux and HP-UX PA-RISC. Table 15. DataDirect Connect ODBC Drivers version 5.3 Bundled with Oracle Business Intelligence Enterprise Edition DataDirect Driver Version DataDirect Connect Driver version 5.3 (32-bit and 64-bit) Supported Operating System1 AIX 32-bit, AIX 64-bit Solaris 32-bit, Solaris 64-bit Database Connectivity To2 MS SQL Server, Informix, Sybase ASE, 32-bit and 64-bit HP-UX Itanium DataDirect Connect Driver version 5.3 (32-bit) Red Hat Enterprise Linux, Oracle Enterprise Linux) MS SQL Server, Informix, Sybase ASE, 32-bit and 64-bit HP-UX PA-RISC 1. For supported Operating System versions, see Operating System versions supported for the Oracle Business Intelligence Server in Table 6. 2. For supported Database versions, see Table 14 above. Supported Databases for Oracle Business Intelligence Delivers Scheduler The Oracle Business Intelligence Delivers Scheduler supports the databases listed in Table 16. Table 16. Supported Databases for Oracle Business Intelligence Delivers Scheduler Vendor, Product and Version Connectivity Software Microsoft SQL Server 2000 SQL Server ODBC Driver/ Microsoft Data Access Components (MDAC) 2.7 or higher 2000 Service Pack 3 or higher DataDirect ODBC driver version 5.1 or higher1(For Oracle Business Intelligence Delivers Scheduler on non-Windows systems) Microsoft SQL Server 2005 2005, 2005 Service Pack 1 or higher SQL Server Native Client 2005-99-1355-00/ SQL Server ODBC Driver version 3.70.08.202 Microsoft Data Access Components (MDAC) 2.8 DataDirect ODBC driver version 5.1 or higher1 (For Oracle Business Intelligence Delivers Scheduler on non-Windows systems) Microsoft SQL Server 20083 Microsoft SQL Server 2008 Native Client IBM DB2 UDB 8.2 Fix Pack 5s or higher DB2 SDK 8.2.x client System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 27 Platform Requirements for Oracle Business Intelligence n Supported Data Sources Table 16. Supported Databases for Oracle Business Intelligence Delivers Scheduler Vendor, Product and Version Connectivity Software IBM DB2 UDB IBM DB2 UDB Admin Client DB2 v8.1 FP12s or higher 9.1, 9.53, 9.7 IBM Data Server Runtime Client 9.5 Oracle Database 9i4 Oracle native client 9.2.0.7 or 10.1.0.5 or higher 9.2.0.7 or higher Oracle Database 10g4 10gR1: 10.1.0.5 or higher 10gR2: 10.2.0.2.0 or higher Oracle Database 11g5 11gR1: 11.1.0.6.0 or higher Oracle native client 10.1.0.5/native clients OCI 10g2 Oracle native client 10.2.0.1.0 or higher/native clients OCI 10g2 Oracle native client OCI 11g/Oracle native client 11g 11gR2: 11.2.0.1.0 or higher3 1. DataDirect Connect ODBC Driver version 5.3 for Linux and UNIX are provided with Oracle Business Intelligence Enterprise Edition 10.1.3.3.1 and higher. See section DataDirect Connect ODBC Drivers Version 5.3 Bundled with Oracle BI EE 10.1.3.3.1 and higher. 2. Microsoft recommends using SQL Server Native Client with Microsoft SQL Server 2005. 3. Certified with Oracle Business Intelligence Enterprise Edition 10.1.3.4.1. 4. For Oracle 9i and 10g databases, native client OCI 10g2 is recommended. 5. Update in Revision H of this guide: Oracle Database 11g is supported as a database for the Oracle Business Intelligence Delivers Scheduler in Oracle Business Intelligence Enterprise Edition 10.1.3.3 and 10.1.3.4. Supported Databases for Oracle Business Intelligence Publisher Scheduler The Oracle Business Intelligence Publisher Scheduler supports the databases listed in Table 17. Table 17. Supported Databases for Oracle Business Intelligence Publisher Vendor, Product and Version Connectivity Software Oracle 9i, 10g Oracle Native JDBC Driver Oracle 11g1 Oracle Native JDBC Driver IBM DB2 Universal Database (UDB) EE 8.2 DataDirect JDBC Driver IBM DB2 V9, 9.52, 9.73 DataDirect JDBC Driver Microsoft SQL Server 2000 DataDirect JDBC Driver Microsoft SQL Server 2005 DataDirect JDBC Driver Microsoft SQL Server 20082 DataDirect JDBC Driver 28 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Supported Data Sources Table 17. Supported Databases for Oracle Business Intelligence Publisher Vendor, Product and Version Connectivity Software Sybase Adaptive Server Enterprise 151 DataDirect JDBC Driver MySQL 4.1, 5.0 MySQL Native JDBC Driver 1. Supported for the Oracle Business Intelligence Publisher Scheduler in Oracle Business Intelligence Enterprise Edition 10.1.3.4. 2. Supported for the Oracle Business Intelligence Publisher Scheduler in Oracle Business Intelligence Enterprise Edition 10.1.3.4.1. 3. Supported for the Oracle Business Intelligence Publisher Scheduler in Oracle Business Intelligence Enterprise Edition 10.1.3.4.2. Support for Multidimensional Data Sources Oracle Business Intelligence supports the multidimensional data source listed in Table 18. Table 18. Certified Multidimensional Data Source Vendor and Product Version Microsoft SQL Server Analysis Services 2000 Service Pack 3, 2005, 2008 SAP BW1 3.5 (Patch1 level 152), 7.0 (Patch level 063) Oracle OLAP 10.2.0.2.0 Oracle’s Hyperion Essbase 7.1.6.1, 9.2.0.3, 9.3.1.0 Oracle Essbase 11.1.1 11.1.2+ 1. Oracle BI EE 10.1.3.4.1 is certified with SAP BW 3.5 SP 20 or higher and SAP BW 7.0 SP 17 or higher 2. Versions of this guide prior to Revision J incorrectly listed the supported patch level as “Patch level 15 or higher”. 3. Versions of this guide prior to Revision J incorrectly listed the supported patch level as “Patch level 06 or higher” Support for Oracle Real Applications Clusters (RAC) Table 19 lists support for Oracle RAC. Table 19. Support for Oracle RAC Oracle Server Version Certified Oracle Version Oracle Database 9i Enterprise Edition 9.2.0.7 or higher System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 29 Platform Requirements for Oracle Business Intelligence n SSL Compatibility Table 19. Support for Oracle RAC Oracle Server Version Certified Oracle Version Oracle Database 10g Enterprise Edition 10.2.0.3 or higher Oracle Database 11g Enterprise Edition 11.1.0.6 and 11.2.0.1 or higher Support for ODBC Data Sources Oracle Business Intelligence support for ODBC allows the Oracle Business Intelligence Server to query any relational database management system—either as a data warehouse, an operational data store or as a transactional system—that supports the ODBC 2.0, 2.1 or 3.5 standards. The Oracle Business Intelligence Server supports accessing ODBC 2.0 and 2.1 compliant databases/ data sources for 8-bit ASCII character sets. The Oracle Business Intelligence Server supports accessing ODBC 3.5 compliant databases/data sources for UTF-16 (unicode) character sets. SSL Compatibility SSL 1996 Secure Sockets Layer (SSL V3.0) Protocol and SASL Specification JSR 28 are supported for use with Oracle Business Intelligence Enterprise Edition. Support for Virtualization and Virtual Machines Oracle Business Intelligence Enterprise Edition is certified on Oracle VM on Linux x86 and Linux x8664 operating systems as outlined in Table 20. For more information on Oracle VM, see Metalink Notes 464756.1 and 464754.1 available on Oracle Metalink (http://metalink.oracle.com). Table 20. Linux Operating Systems certified for Oracle Business Intelligence running on Oracle VM Operating System1 Red Hat Enterprise Linux AS 4.x Red Hat Enterprise Linux Server/Advanced Platform 5.x Oracle Enterprise Linux 4.x Oracle Enterprise Linux 5.x 1. Linux 64-bit support: Oracle BI EE software is 32-bit. The software can run on 64-bit processors that support 32-bit emulation. The supported processors are AMD64 and EM64T Sun Solaris Containers and Zones are supported with Solaris 10 on hardware platforms that are supported for Oracle Business Intelligence Enterprise Edition. For a list of supported hardware platforms for Solaris 10, see Table 6. 30 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Client Environment Requirements Oracle Business Intelligence Enterprise Edition may be used with VMware virtualized environments consistent with the policy for other Oracle products as stated in Metalink Note 249212.1 available on Oracle Metalink (http://metalink.oracle.com). Client Environment Requirements This section includes the following topics: • Supported Web Browsers • Supported Client Operating Systems Supported Web Browsers Oracle Business Intelligence Enterprise Edition supports the Web browsers listed in Table 21. System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 31 Platform Requirements for Oracle Business Intelligence n Client Environment Requirements Table 21. Supported Web Browsers Client Operating System Supported Web Browsers Microsoft Windows Microsoft Internet Explorer 6.x1 Microsoft Windows Vista Microsoft Internet Explorer 7.01 Microsoft Windows 7 Microsoft Internet Explorer 8.02,3 Microsoft Internet Explorer 9.0+2 Firefox 1.5.x Firefox 2.0 Firefox 3.03 Firefox 3.52 Microsoft Windows Vista Microsoft Internet Explorer 7.01 Linux Firefox 1.5.x Firefox 2.0 Sun Solaris Firefox 2.0 Apple Mac OS 10.x Firefox 2.0 1. The Hebrew locale (HEB) is only available with Microsoft Internet Explorer. Does not apply to the Oracle Business Intelligence Publisher component. 2. Certified with Oracle Business Intelligence Enterprise Edition 10.1.3.4.2 3. Certified with Oracle Business Intelligence Enterprise Edition 10.1.3.4.1 32 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Client Environment Requirements Supported Client Operating Systems Oracle Business Intelligence supports the client operating systems listed in Table 22. Table 22. Supported Client Operating Systems Client Type Operating System and Patch Level Oracle Business Intelligence Administration Tool Microsoft Windows 2000 Oracle Business Intelligence Catalog Manager Microsoft Windows 2003 SP1 or higher (32bit only) Oracle Business Intelligence Disconnected Analytics Client Microsoft Windows XP SP2 or higher Oracle Business Intelligence Briefing Book Reader Microsoft Windows Vista Oracle Business Intelligence Job Manager Microsoft Windows 73 Oracle Business Intelligence Publisher Desktop1 Microsoft Windows 2008 Server R23 Oracle Business Intelligence Add-in for Microsoft Office2 Microsoft Windows 2003 SP1 or higher (32 bit only) Microsoft Windows XP SP2 or higher Microsoft Windows Vista Microsoft Windows 73 Microsoft Windows 2008 Server R23 1. Oracle Business Intelligence Publisher Desktop Template Builder Add-in for Microsoft Word in Oracle Business Intelligence Enterprise Edition 10.1.3.3.x requires JRE version 1.4 or higher and Microsoft .Net Framework 2.0. Oracle Business Intelligence Publisher Desktop Template Builder Add-in for Microsoft Word in Oracle Business Intelligence Enterprise Edition 10.1.3.4 requires JRE version 1.5 or higher and Microsoft .Net Framework 2.0. 2. Oracle Business Intelligence Add-in for Microsoft Office and Oracle Business Intelligence Publisher Desktop Excel Analyzer Add-in for Microsoft Excel require Microsoft .Net Framework 2.0. 3. Certified with Oracle Business Intelligence Enterprise Edition 10.1.3.4.2 Note: It is recommeded to use the most up to date Microsoft patchsets. As an example, Microsoft Windows XP SP3 is recommended. Oracle Business Intelligence for Microsoft Office supports the Microsoft Office versions and applications listed in Table 23. Table 23. Supported Microsoft Office Applications for Oracle Business Intelligence for Microsoft Office Microsoft Office Application Version Excel 2003, 2007, 2010 PowerPoint 2003, 2007, 2010 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 33 Platform Requirements for Oracle Business Intelligence n Client Environment Requirements Oracle Business Intelligence Publisher Desktop supports the Microsoft Office Applications listed in Table 24. Table 24. Supported Microsoft Office Applications for Oracle Business Intelligence Publisher Desktop Oracle Business Intelligence Publisher Desktop Component Microsoft Office Application and Version Template Builder Add-in for Microsoft Word Word 2000, 2002, 2003, 2007, 2010 Excel Analyzer Add-in for Microsoft Excel Excel 2000, 2002, 2003, 2007, 2010 Oracle Business Intelligence Publisher supports Microsoft PowerPoint output for PowerPoint 2003 and PowerPoint 2007. 34 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Globalization Requirements Globalization Requirements Oracle Business Intelligence supports internationalization and localization for specific languages based on customer demand. Oracle Business Intelligence 10.1.3.3 and 10.1.3.4 are available in the languages listed in Table 25. Please contact your Oracle representative for updates on supported languages. Table 25. Available Languages for Oracle Business Intelligence 10.1.3.3 and 10.1.3.4 Language Language Code/Oracle Business Intelligence Language Code Supported Database Code Pages Arabic1 ARA/l_ar Traditional/Unicode Chinese (Simplified) CHS/l_zh Unicode Chinese (Traditional) CHT/l_zh-tw Unicode Croatian2 HRV/l_hr Traditional/Unicode Czech CSY/l_cs Unicode Danish DAN/l_da Traditional/ Unicode Dutch NLD/l_nl Traditional/ Unicode English ENU/l_en Traditional/ Unicode Finnish FIN/l_fi Traditional/ Unicode French FRA/l_fr Traditional/ Unicode German DEU/l_de Traditional/ Unicode Greek3 ELL/l_el Traditional/ Unicode Hebrew HEB/l_iw Traditional/ Unicode Hungarian HUN/l_hu Traditional/ Unicode Italian ITA/l_it Traditional/ Unicode Japanese JPN/l_ja Traditional/ Unicode Korean KOR/l_ko Unicode Norwegian NOR/l_no Traditional/ Unicode Polish POL/l_pl Traditional/ Unicode Portuguese (Brazilian) PTB/l_pt-br Traditional/ Unicode Portuguese (European) PTG/l_pt Traditional/ Unicode Romanian ROM/l_ro Traditional/ Unicode Russian RUS/l_ru Traditional/ Unicode Slovak SKY/l_sk Traditional/ Unicode System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 35 Platform Requirements for Oracle Business Intelligence n Globalization Requirements Table 25. Available Languages for Oracle Business Intelligence 10.1.3.3 and 10.1.3.4 Language Language Code/Oracle Business Intelligence Language Code Supported Database Code Pages Spanish ESN/l_es Traditional/ Unicode Swedish SVE/l_sv Traditional/ Unicode Thai1 THA/l_th Traditional/Unicode Turkish TRK/l_tr Traditional/ Unicode 1. Available with the release of Oracle Business Intelligence Enterprise Edition 10.1.3.3.1. The Oracle Business Intelligence charting engine (Corda) does not support Arabic and Thai. For an alternate solution to enable charting, use Oracle Business Intelligence Publisher reports containing charts. For further details see Table 30 on page 50. 2. Available with the release of Oracle Business Intelligence Enterprise Edition 10.1.3.3.2. NOTE: Oracle Business Intelligence Addin for Microsoft Office is available in Croatian in Oracle Business Intelligence Enterprise Edition version 10.1.3.3.3. 3. Revisions F and previous versions of this guide had incorrect entries for the three-letters Language code. Corrections have been provided with Revision G of this guide. 36 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Platform Requirements for Oracle Business Intelligence n Overview of Supported Environments Overview of Supported Environments Homogeneous and Heterogeneous Environments Oracle Business Intelligence Suite Enterprise Edition Infrastructure components are supported in various homogeneous and heterogeneous server environments, as illustrated in the example defined in Table 26. In homogeneous environments, the Database, the Oracle Business Intelligence Server and the Oracle Business Intelligence Presentation Services are all deployed on the same platform. In heterogeneous environments, these servers can be deployed on different supported platforms. Table 26. Example of Supported Homogeneous and Heterogeneous Environments for Oracle Business Intelligence Applications Database IBM DB2 UDB IBM DB2 ESE IBM DB2 UDB for OS/390 and z/OS Oracle Database 9i Oracle Database 10g Oracle Database 11g Microsoft SQL Server 2000 Microsoft SQL Server 2003 Microsoft SQL Server 2005 NCR Teradata Oracle Business Intelligence Server Oracle Business Intelligence Presentation Services Oracle Business Intelligence Web Server Microsoft Windows 2000/2003 Linux (See Table 6 on page 17) Linux (See Table 6 on page 17) Microsoft Windows 2000/2003 Microsoft IIS Web Server running on Microsoft Windows 2003 Server or Oracle Application Server OC4J/HTTP version 10.1.3.1 on Red Hat 4.x (See Table 8 on page 19 for Web server certifications) Apache Tomcat on Microsoft Windows 2000/2003 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 37 Platform Requirements for Oracle Business Intelligence n Overview of Supported Environments 38 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 3 Supported Software and Ancillary Programs This chapter includes the following topics: • Supported Software • Ancillary Programs • License Agreements Supported Software Oracle Business Intelligence Enterprise Edition 10.1.3.3 and 10.1.3.4 support the third-party software products listed in Table 27. These products must be obtained directly from the vendors that sell them. Table 27. Supported Software Vendor and Product Version Associated Module Function Adobe Acrobat Reader1 6.0, 7.0+ Oracle Business Intelligence Used for viewing portable document format (PDF) documents. Adobe Flash Player 8,9 Oracle Business Intelligence Presentation Services Used in the Web client browser to display charts. 9+ Oracle Business Intelligence Publisher Used to view report outputs from Flash Templates. Adobe Flex Builder IDE 2.0.1 Oracle Business Intelligence Publisher Used to build Flash Templates. IBM DB2 Cube Views DB2 UDB 8.2 Oracle Business Intelligence Used to integrate Oracle Business Intelligence metadata into DB2 and to accelerate multidimensional analysis. IBM Directory Server 5.1 or above Oracle Business Intelligence (LDAP Security Adapter) LDAP Support (LDAP Security Adapter). 1. Later versions of Adobe Acrobat Reader and Adobe Flash Player comply with a standard that is supported by Oracle BI EE and is supported for use with Oracle BI EE see Page6 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 39 Supported Software and Ancillary Programs n Ancillary Programs Ancillary Programs The ancillary programs listed in Table 28 are provided with Oracle Business Intelligence Enterprise Edition 10.1.3.3 and 10.1.3.4 through licensing agreements with the vendors that own the programs. The use of all ancillary programs is governed by the terms of the Software License and Services Agreement (SLSA) between your company and Oracle. Instructions for installing ancillary programs where needed are provided in the server installation guide for your platform, and in other installation information in the Oracle Business Intelligence documentation set. Your Oracle Business Intelligence software may include some or all of the ancillary programs listed in Table 28. Table 28. Ancillary Programs Associated Oracle Business Intelligence Module Distribution Method and Description Vendor and Product Version Apache Software Foundation Xerces - C++ 2.6.0, 2.7, and 1.6.0 Oracle Business Intelligence Server Embedded. XML Parser. Apache Software Foundation Xerces - Java 1.4.4 Oracle Business Intelligence (Installer) Embedded. XML Parser. Apache Software Foundation 1.0 Oracle Business Intelligence Publisher Embedded. 1.6 Oracle Business Intelligence Publisher Embedded. 1.2.1 Oracle Business Intelligence Publisher Embedded. 1.2.1 Oracle Business Intelligence Publisher Embedded. 1.7 Oracle Business Intelligence Publisher Embedded. 1.2 Oracle Business Intelligence Publisher Embedded. Apache file upload Apache Software Foundation Apache Commons BeanUtil Apache Software Foundation Apache Commons Discovery Apache Software Foundation Apache Commons DBCP Apache Software Foundation Apache Commons Digester Apache Software Foundation Apache Commons Pool 40 System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O Supported Software and Ancillary Programs n Ancillary Programs Table 28. Ancillary Programs Associated Oracle Business Intelligence Module Distribution Method and Description Vendor and Product Version Apache Software Foundation 3.1 Oracle Business Intelligence Publisher Embedded. 1.4.8 Oracle Business Intelligence Publisher Embedded. Oracle Business Intelligence Publisher Embedded. 1.04 Oracle Business Intelligence Publisher Embedded. 1.04 Oracle Business Intelligence Publisher Embedded. 2.4.0 Oracle Business Intelligence Presentation Services Embedded. 1.2.1 Oracle Business Intelligence Presentation Services Embedded. Corda PopCharts 5.1 Oracle Business Intelligence Presentation Services Embedded (UNIX). Distributed (Windows). Charting Engine. Crypto++ 5.4 Oracle Business Intelligence Server Embedded. Used for password encryption. 5.1, 5.31 Oracle Business Intelligence Server Embedded. Loads Oracle Business Intelligence ODBC driver on supported UNIX platforms. Apache Commons Collections v3.1 Apache Software Foundation Log4j Apache Software Foundation Apache Commons El Apache Software Foundation Apache Commons Logging Apache Software Foundation Apache Commons Logging-api Apache Software Foundation Xerces C++ Apache Software Foundation Axis - Java 3DES algorithm DataDirect Connect ODBC Driver Manager System Requirements and Supported Platforms for Oracle ® Business Intelligence Suite Enterprise Edition Version 10.1.3.3, 10.1.3.4, Rev. O 41 Supported Software and Ancillary Programs n Ancillary Programs Table 28. Ancillary Programs Associated Oracle Business Intelligence Module Distribution Method and Description Vendor and Product Version DataDirect Connect ODBC Drivers1 5.3 Oracle Business Intelligence Server Distributed. Provides connectivity for Oracle BI Servers on UNIX platforms to MS SQL Server, Informix and Sybase ASE databases. IBM Directory Server component of the Tivol