Skip Headers
Oracle® Health Sciences Pharmacovigilance Operational Analytics Installation Guide
Release 1.0

E23555-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

1 OPVA Requirements

1.1 Requirements

This section presents an overview of the Oracle Health Sciences Pharmacovigilance Operational Analytics (OPVA) architecture, required hardware and software, and dependencies across the components. Before you begin the installation, confirm that your environment meets hardware and software requirements described in this section.

1.1.1 Technology Stack and System Requirements

The requisite technology stack for OPVA is provided in the media pack, with the exception of Informatica products. It consists of the following products:

1.1.1.1 Server Components

1.1.1.1.1 OPVA Database Server

OPVA is certified for Oracle Database Enterprise Edition 11.2.0.1. It supports Oracle Database Enterprise Edition 11.2.0.2 as well.

Supported Operating System

  • Oracle Enterprise Linux 5 or above (32/64 bit)

  • Oracle Sun Solaris 10 (64 Bit)

  • Microsoft Windows Server 2008 R1 with SP1 or above (32/64 bit)

  • Microsoft Windows Server 2008 R2 (64 bit)

  • Memory: RAM 4-16 GB (based on organization size), HDD – at least 500 GB free space

  • CPU: At least 4 Dual Core CPUs

1.1.1.1.2 OPVA Informatica Server

OPVA is certified against Informatica PowerCenter 9.0.1 with Hotfix2. Refer Informatica PowerCenter installation guide for recommended hardware and supported platforms. OPVA has got certified the following:

  • Operating System: Oracle Enterprise Linux 5 or above (32/64 bit)

  • Memory: RAM at least 8 GB. HDD – at least 250 GB free space

  • CPU: At least 4 Dual Core CPUs

1.1.1.1.3 OPVA OBIEE Server

OPVA is certified against Oracle Business Intelligence Enterprise Edition 11.1.1.5.0. Please refer the installation manual of OBIEE for further hardware and software requirements OPVA would recommend the following:

Operating System

  • Microsoft Windows Server 2008 R1 with SP1 or above (32/64 bit)

  • Microsoft Windows Server 2008 R2 (64 bit)

  • Oracle Enterprise Linux 5 or above (32/64 bit)

  • Oracle Sun Solaris 10 (64 Bit)

    Note:

    If unix based OS is used for the OBIEE server, then the OBIEE Admin tool must be installed separately on a Windows box.
  • Memory: RAM at least 8 GB, HDD – at least 250 GB free space

  • CPU: At least 4 Dual Core CPUs

1.1.1.1.4 OPVA Datawarehouse Administration Console Server

OPVA requires Oracle Datawarehouse Administration Console Server 10.1.3.4 with patch 12381656.

Supported Operating System

  • Oracle Enterprise Linux 5 or above (32/64 bit)

  • Oracle Sun Solaris 10 (64 Bit)

  • Microsoft Windows Server 2008 R1 with SP1 or above (32/64 bit)

  • Microsoft Windows Server 2008 R2 (64 bit)

  • Memory: RAM 4-16 GB (based on organization size), HDD – at least 500 GB free space

  • CPU: At least 2 Dual Core CPUs

1.1.1.2 Client Components

1.1.1.2.1 Oracle Database Client
  • OPVA requires Oracle database client to connect to the database server. The supported client software version is 11.2.0.1.

  • Supported Operating System: Microsoft Windows Server 2008 R1 with SP1 or above (32 bit)

1.1.1.2.2 Oracle Datawarehouse Administration Console Client
  • OPVA requires Oracle Datawarehouse Administration Console Client 10.1.3.4 with patch 12381656.

  • Supported Operating System: Microsoft Windows Server 2008 R1 with SP1 or above (32 bit)

1.1.1.2.3 Informatica PowerCenter Client
  • An Informatica PowerCenter Client 9.0.1 with Hotfix 2 is required to connect to the Informatica Server.

  • Supported Operating System: Microsoft Windows Server 2008 R1 with SP1 or above (32 bit)

1.1.1.2.4 OBIEE Admin Tool
  • OBIEE Admin tool 11.1.1.5.0 must be installed for configuring the repository file (RPD).

  • Supported Operating System: Microsoft Windows Server 2008 R1 with SP1 or above (32/64 bit)

1.1.1.2.5 Optional Security Component

You can also configure Single Sign on Support for your reports and dashboards using Oracle Access Manager 10.1.4. For more information regarding the Oracle Access Manager installation and supported platforms, please refer the Oracle Access Manager Installation Guide.

1.1.1.2.6 Miscellaneous Components
  • For running the reports and dashboards, your machine should have the Adobe Flash Player 10 or above installed.

  • Although OBIEE 11.1.1.5.0 reports are supported in Microsoft Internet Explorer, Firefox and Safari, OPVA is certified only for Microsoft Internet Explorer 7.0 and 8.0 only.

1.1.1.3 Supported Sources

OPVA, by default, supports only Oracle Argus Safety. It supports the following Oracle Argus Safety versions:

  • Oracle Argus Safety 7.0

  • Oracle Argus Safety 6.0.2

Customers can add customer data sources to the application by adding their own ETL. For more information about customizing OPVA, please refer to the Oracle Health Sciences Pharmacovigilance Operational Analytics Administrator and User Guide.

1.1.1.4 Technology Stack Matrix

The following table displays the technology stack matrix diagram of all the components of OPVA.

Specification OBIEE Server Database Informatica Server DAC Server * Install / Admin Machine * Client
Operating System Windows Server 2008 with SP1 or above (32/64 Bit)

Windows Server 2008 R2 (64 Bit)

Oracle Enterprise Linux 5 (32/64 Bit)

Oracle Sun Solaris 10 (64 Bit)

Windows Server 2008 with SP 1 or above (32/64 Bit)

Windows Server 2008 R2 (64 Bit)

Oracle Enterprise Linux 5 (32/64 Bit)

Oracle Sun Solaris 10 (64 Bit)

Windows Server 2008 with SP1 or above (32/64 Bit)

Windows Server 2008 R2 (64 Bit)

Oracle Enterprise Linux 5 (32/64 Bit)

Oracle Sun Solaris 10 (64 Bit)

Windows Server 2008 with SP1 or above (32 Bit) Windows 32 bit Windows XP Pro SP3

Windows 7

Oracle Database   11.2.0.1.0 (Enterprise)- AL32UTF8 char set 11.2.0.1 Client   11.2.0.1 Client  
OBIEE Server OBIEE 11.1.1.5.0          
OBIEE Admin Tool OBIEE 11.1.1.5 Admin Tool*       OBIEE 11.1.1.5 Admin Tool  
Informatica     Informatica Server 9.0.1 + HF2 Informatica Client 9.0.1 + HF2 Informatica Client 9.0.1 + HF2  
DAC     DAC Server 10.1.3.4.1 + Patch 12381656 DAC Server & Client 10.1.3.4.1 + Patch 12381656 DAC Client 10.1.3.4.1 + Patch 12381656  
Browser           IE 7.0 (latest) or

IE 8.0 (latest)

Adobe Flash Player           Flash Player 10 or above

* DAC DAC Server needs to be installed on a machine where Informatica home is present. DAC Server can be installed on the same machine where Informatica Server is located; there is no need that it should be a stand-alone server.

* OBIEE OBIEE Admin tool can be installed along with the OBIEE Server, provided the Operating System is Microsoft Windows.

1.1.1.4.1 Supported Security Configuration

OPVA supports the following optional security configurations:

  • LDAP/LDAPS 3.0

  • Single Sign On Solution through Oracle Access Manager 10.1.4

    Note:

    If OAM is used, then the OBIEE Server must have Oracle Enterprise WebGate 10.1.4.3 and Oracle Web Tier 11g installed.

1.1.1.5 Typical Hardware Architecture

A typical OPVA installation contains the following hardware architecture:

  • Servers:

    • An Oracle Database server with Oracle Database 11.2.0.1

    • An Informatica PowerCenter 9.0.1 with Hotfix 2 Server + DAC Server 10.1.3.4 with patch 12381656

    • An OBIEE 11.1.1.5 Server

      Note:

      The above three boxes can run on any of the supported platforms: Linux/Solaris/Windows.
  • Clients:

    • An Informatica PowerCenter Client 9.0.1 + Hotfix 2

    • Oracle Database Client 11.2.0.1

    • DAC Client 10.1.3.4 with patch 12381656

    • OBIEE Admin tool

      Note:

      All tools can be installed in a single Microsoft Windows 32 bit box.

      If the OBIEE server mentioned under the "Servers" section is a Windows 32 bit server, then all the clients can be installed in the same box itself.

      If the OBIEE Server is installed on a Windows 64 bit machine, then the OBIEE Admin tool can also be installed along with the server itself.

      Informatica PowerCenter and Oracle Database Client should be available in the same machine for OPVA installer to run.

      Note:

      It is important to get the technology stack products from the OPVA media pack because newer versions of the technology stack products may have become available but may not be compatible with OPVA.

      Figure 1-1 Oracle Health Sciences Pharmacovigilance Operational Analytics Technology

      Surrounding text describes Figure 1-1 .

1.1.1.6 Installation Process Overview

The following steps describes the overview of the installation process:

  • Follow the steps described in Section 1.1.2, "Prerequisites".

  • Execute the installer – to create the datamart and Informatica ETLs.

  • Follow the post installation steps to configure DAC and OBIEE

For more information about certifications, refer to "Finding Certification Information".

1.1.2 Prerequisites

Before proceeding with the installation, ensure the following software is available.

  • An Oracle Database Server – An Oracle 11.2.0.1 database server should be created before OPVA installation. Follow the platform specific Database Installation Guide for installing this server.

    Note:

    The database server should be configured with AL32UTF8 charset.
  • An Informatica PowerCenter Server – An Informatica PowerCenter 9.0.1 + HF2 should be created before running the OPVA Installer. Follow platform specific Informatica PowerCenter Installation.

    Note:

    • Informatica Server needs a repository database. Customer can either use the database created in previous step or can create a new database for holding the repository. A PowerCenter repository should be created upon the installation of PowerCenter. This repository information along with the admin user credentials will be needed during OPVA installation.

    • An Oracle 11.2.0.1 Client should be available in the Informatica server.

  • A OBIEE Server - An Oracle Business Intelligence Enterprise Edition 11.1.1.5.0 Server must be installed before the OPVA Installation. Follow platform specific OBIEE Installation Guide for installation instructions.

  • A DAC Server – An Oracle Datawarehouse Administration Console Server of version 10.1.3.4 with patch 12381656 needs to be installed on the same machine where Informatica client is loaded. Follow platform specific ODAC Installation Guide for installation instructions.

1.1.2.1 Client Tools

  • An Informatica PowerCenter Client - An Informatica PowerCenter Client 9.0.1 with Hotfix 2 must be present. Supported only on a Microsoft Windows 32 bit machine.

  • An Oracle Database client - An Oracle 11.2.0.1 database client should be present. This should be present in the same machine where the Informatica PowerCenter client is loaded.

  • A DAC Client - A DAC Client 10.1.3.4.1 with patch 12381656 needs to be present. Supported only on a Microsoft Windows Server 2008 with SP1 or above (32 bit).

    Note:

    • Oracle recommends that you enable HTTPS on the middle-tier computer that is hosting the BIEE Web services, since otherwise the trusted user name and password that are passed can be intercepted.