1 Before You Begin

This section presents an overview of the Oracle Health Sciences Clinical Development Analytics (OHSCDA) requirements. It also describes the tasks that you must complete before you can install the application.

This chapter includes the following sections:

Section 1.1, "Checking for the Most Recent Information"
Section 1.2, "Technology Stack and System Requirements"
Section 1.3, "Installing the Prerequisite Software"

1.1 Checking for the Most Recent Information

OHSCDA documentation is updated periodically. Therefore, it is critical that you check that you have the most current information before you begin the installation process.

To ensure that you have the most recent version of this Installation and Configuration Guide, and all other OHSCDA user documentation, see Finding Documentation on Oracle Technology Network.

1.2 Technology Stack and System Requirements

The requisite technology stack for OHSCDA configuration is provided in the media pack, with the exception of Oracle Data Integrator (ODI). It consists of the following products:

Oracle Database 12.1.0.1.0
Oracle WebLogic Server 10.3.6
Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.0
Oracle Fusion Middleware 12c (12.1.3.0.0) Infrastructure
Oracle Data Integrator (ODI) 12.1.3

Note:
ODI is not part of the media pack. You need to acquire its license separately.
All references to media pack server in this document refer to the computer onto which you download the media pack for Oracle Health Sciences Clinical Development Analytics (Standard Configuration).
Oracle Healthcare Master Person Index (OHMPI) 2.0.5 (optional)

Table 1-1 System Requirements References

Product	Reference
Oracle Database 12.1.0.1.0	Database Installation Guide for <platform>
Oracle WebLogic Server 10.3.6	Oracle WebLogic Server Documentation Library
Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.0	System Requirements and Supported Platforms for Oracle Business Intelligence Suite Enterprise Edition Oracle Business Intelligence Infrastructure Installation and Configuration Guide
Oracle Fusion Middleware 12c (12.1.3.0.0) Infrastructure	Oracle Fusion Middleware Documentation Library
Oracle Data Integrator 12.1.3	Oracle Data Integrator Documentation Library
Oracle Healthcare Master Person Index 2.0.5	Oracle Healthcare Master Person Index Documentation Library
Other Technology Stack Components	My Oracle Support/Certifications

Note:

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

Installation Considerations

Determine the computer on which you will install each component of OHSCDA (Standard Configuration).
You may select to install each product on a different server, if required. The OHSCDA (Standard Configuration) media pack server does not have to act as server for any of the products, though it may. You may consult Figure 1-1, and the documentation listed in Table 1-1 for information on installing each product.
Determine the databases you need to create.
You must create a database schema to serve as the warehouse for OHSCDA.
It is a good practice to create the schema for the OHSCDA Standard Configuration warehouse in a new database.
You may select to create schemas for repositories for the other OHSCDA components in the same database that will be used for the OHSCDA warehouse. It minimizes the number of databases that you need to maintain for OHSCDA. However, if you will be using the component applications for purposes other than OHSCDA, Oracle recommends that you create their repositories in instances other than the one holding the OHSCDA warehouse.
If you plan to implement deduplication, you may create the schemas for the OHMPI Master Indexes either in the OHSCDA warehouse database, or in a separate database specific to OHMPI Master Indexes. If you are using OHMPI for purposes in addition to OHSCDA, Oracle recommends that the Master Index schemas be created in a database specific to OHMPI.
OHMPI Projects need to be deployed on Oracle WebLogic Server. You may select to deploy the OHMPI projects on the same Oracle WebLogic Server used for OBIEE by creating a new WebLogic domain running on different port (which is not used by any other domains) or you may choose to deploy the projects on a different Oracle WebLogic Server instance.

Figure 1-1 Oracle Health Sciences Clinical Development Analytics Technology for Standard Configuration

Description of "Figure 1-1 Oracle Health Sciences Clinical Development Analytics Technology for Standard Configuration"

For more information about certifications, see Finding Certification Information.

1.2.1 Supported Browsers

OHSCDA supports those Internet browsers supported by OBIEE. For a list of the browsers supported by OBIEE, refer to Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1).

1.2.2 Source Systems

OHSCDA is designed to extract data from the following three systems:

Oracle Clinical (OC) 4.5.3.23 or higher
Siebel Clinical Trial Management System (SC) 8.0.x or 8.1.1
Oracle Health Sciences InForm 4.6 and later

1.3 Installing the Prerequisite Software

Figure 1-2 displays a sample topology of the technology components for OHSCDA.

Figure 1-2 Sample Topology

Description of "Figure 1-2 Sample Topology"

Before you can install the OHSCDA application, you must complete the following pre-installation tasks:

Install Oracle Database 12.1.0.1.0.

Note:
You must set the init parameter processes for the database to a minimum of 500.

Follow the instructions in Oracle Database Installation Guide for <platform>.

Also, install Oracle Database Client for 12.1.0.1.0. Follow the instructions in Oracle Database Client Installation Guide for <platform>.
Install Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.0 with the following components:
- Oracle Business Intelligence Server (Supported only on Windows and Unix)
- Oracle Business Intelligence Presentation Services (Supported on Windows and Unix)
- Oracle Business Intelligence Client Tools (Supported only on Windows)
Follow the instructions in Oracle Business Intelligence Infrastructure Installation and Configuration Guide.
Install Oracle Data Integrator 12.1.3

Note:
Oracle recommends that the Java heap size where you install ODI Studio is 2 GB.

For more information, see Oracle Data Integrator Installation Guide.
Install OHSCDA 3.1 for Standard Configuration before installing the OHSCDA3.1.1 patch
To implement multi-source integration, install Oracle Healthcare Master Person Index 2.0.5 and Oracle WebLogic 10.3.6.

Note:
You cannot use the same WebLogic server for OHMPI and ODI because OHMPI 2.0.5 is not certified on higher version of WebLogic server.

Note:

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