Skip Headers
Oracle® Health Sciences Clinical Development Analytics Installation and Configuration Guide for Informatica
Release 3.2

E74822-01
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

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

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:

1.1 Technology Stack and System Requirements

The requisite technology stack for OHSCDA configuration consists of the following products:

  • Oracle Database 12.1.0.2.0 with patch 19509982

  • Oracle WebLogic Server 10.3.6

  • Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.9.0

  • Oracle Business Intelligence Data Warehouse Administration Console 11.1.1.6.4

  • Informatica PowerCenter 9.5.0 and 9.6.1

    Note:

    Informatica 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 system onto which you download the media pack for Oracle Health Sciences Clinical Development Analytics.

    Make sure that the domain information of the Informatica repository, where you plan to import OHSCDA related Informatica mappings, is added to domains.infa file of the Informatica client.

Table 1-1 System Requirements References

Product Reference

Oracle Database 12.1.0.2.0 with patch 19509982

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.9.0

System Requirements and Supported Platforms for Oracle Business Intelligence Suite Enterprise Edition

Oracle Business Intelligence Infrastructure Installation and Configuration Guide

Oracle Business Intelligence Data Warehouse Administration Console 11.1.1.6.4

Oracle Business Intelligence Data Warehouse Administration Console Installation, Configuration, and Upgrade Guide

Data Warehouse Administration Console User's Guide

Informatica PowerCenter 9.5.0 and 9.6.1

Informatica PowerCenter Installation Guide


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.

  • You may select to install each product on a different server, if required. The OHSCDA 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 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.

Figure 1-1 Oracle Health Sciences Clinical Development Analytics Technology

Description of Figure 1-1 follows
Description of ''Figure 1-1 Oracle Health Sciences Clinical Development Analytics Technology''

For more information about certifications, see Finding Certification Information.

1.1.1 Supported Web Browsers

OHSCDA supports web browsers that are supported by OBIEE. For the list of the browsers supported by OBIEE, refer to Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition 11g.

Note:

For information on Oracle Software Web Browser Support Policy, see Doc ID 2092205.1 on My Oracle Support (https://support.oracle.com).

1.1.2 Source Systems

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

  • Oracle Clinical (OC) 4.6 or 5.1

  • Siebel Clinical Trial Management System (SC) 8.1.1.15

  • Oracle Health Sciences InForm 4.6, 5.5, 6.0, or 6.1

1.2 Installing the Prerequisite Software

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

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

  • Install Oracle Database 12.1.0.2.0 with patch 19509982. You can download the patch set from My Oracle Support (https://support.oracle.com).

    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.2.0 on the system where you are running the OHSCDA installer. Follow the instructions in Oracle Database Client Installation Guide for <platform>.

  • Install Oracle WebLogic Server 10.3.6

    Follow the instructions in Oracle WebLogic Server Documentation Library.

  • Install Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.9.0 with the following components:

    • Oracle Business Intelligence Server (Supported 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 Business Intelligence Data Warehouse Administration Console (DAC) 11.1.1.6.4

    Follow the instructions in Oracle Business Intelligence Data Warehouse Administration Console Installation, Configuration, and Upgrade Guide.

  • Install Informatica PowerCenter 9.5.0 or 9.6.1

    Oracle recommends that you create Informatica repository for OHSCDA with the following settings:

    Table 1-2 Informatica Repository Settings

    Settings Value

    Character Set

    UTF8

    Versioning

    True

    Global Repository

    False

    Security Audit Trail

    No

    Operating Mode

    Normal


    You must add the AggSupprtWithNoPartLic property in Informatica PowerCenter Administration Console, to use the sorted Aggregator transformation set in Informatica PowerCenter.

    Perform the following steps to add the AggSupprtWithNoPartLic property:

    1. Log on to Informatica PowerCenter Administration Console.

    2. Select the PowerCenter Integration Service.

    3. In Custom Properties, click Edit.

    4. Click Add.

    5. Enter AggSupprtWithNoPartLic in the Name field.

    6. Enter Yes in the Value field.

    7. Click OK to add the property.

    For more information, see Informatica PowerCenter Installation Guide.

  • If you implement multi-byte character support for OHSCDA, set the following:

    • Operating System Level: Ensure that the system that hosts Informatica and Database have the following parameters set:

      • NLS_LANG=AMERICAN_AMERICA.AL32UTF8

      • LANG=en_US.UTF-8

    • Database Level: Ensure that the following parameters are set while creating database:

      • NLS_CHARACTERSET =AL32UTF8

      • NLS_NCHAR_CHARACTER= AL16UTF16

    • Informatica Level: Oracle recommends that you create Informatica integration service for OHSCDA with the following settings:

      Table 1-3 Informatica Integration Service

      Settings Value

      Character Set

      UTF8

      Versioning

      True

      Global Repository

      False

      Security Audit Trail

      No

      Operating Mode

      Normal

      DataMovementMode

      Unicode

      Code Page

      UTF8


  • Informatica Workflow Relational Connection: For all relational connection in Informatica (Datawarehouse, Inform_Source, Oracle_Clinical, and Siebel_Clinical), set:

    • Connection Environment SQL to "alter session set NLS_LENGTH_SEMANTICS = 'CHAR';

    • Code Page to UTF-8 encoding of Unicode