Skip Headers
Oracle® Argus Insight Installation Guide
Release 8.0
E49997-03
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

1 Introduction

Argus Insight is a highly optimized reporting module for querying, case series management and reporting that compliments Argus Safety.

The Argus Insight Extract Transform and Load (ETL) engine extracts data from the Argus Safety database and populates Argus Insight data mart in a format to enable efficient querying. The query, drill-down, and output features of Argus Insight let you analyze your safety data from a scientific angle and produce queries, case series and reports that provide medical and scientific understanding of your aggregated adverse event information.

Argus Insight also supports Argus Mart as an additional data source. If you are using Argus Mart as a data source in a multi-tenant environment, then you may create Argus Mart Advanced Condition that queries Argus Mart database.

This chapter includes the following topics:


Note:

Power Reports has been renamed Argus Insight and the two terms have been used interchangeably in this document.

1.1 Argus Insight Product Overview

In Argus Insight, you can generate a report through a query. The query retrieves a set of specific type of cases (Case Series) from the data mart (Insight Mart/Argus Mart) and then runs the report on only those cases.

Use these Argus Insight components to retrieve the Case Series: Query By Example (QBE), Filters, and Advanced Conditions. Next, run one of these reports on the Case Series: the built-in Standard Reports or the custom reports.

The following flowchart shows the typical workflow for generating a report.

Surrounding text describes flowchart.jpg.

Table 1-1 describes the various features of Argus Insight:

Table 1-1 Argus Insight Features

Features Description

Query by Example (QBE)

Lets you create simple queries by entering specific values in fields on a form that looks substantially like the Argus Safety case form.

Filters

Lets you create queries by selecting a set of predefined fields and specifying multiple values in a field.

Advanced Conditions

Lets you create complex queries by selecting any of the various different fields in the data mart (Insight Mart/Argus Mart) and applying Boolean and Set operations on them. You may use Advanced Conditions to query data on Argus Mart.

Case Series

A list of cases that match the query criteria with revisions (applicable only for Argus Mart).

Standard Reports

Predefined reports built into Argus Insight. These reports are grouped into the General category.

Typically, these reports are run on the Case Series.


1.1.1 Argus Insight Architecture

The following figure illustrates the Argus Insight architecture:

Surrounding text describes arc3.jpg.

1.2 Software and Hardware Requirements

Table 1-2 lists the software and hardware requirements for the following components in an Argus Insight installation:

  • Argus Insight Web Server

  • Database Server

  • BI Publisher, BusinessObjects Server, Cognos, or OBIEE (depending on which Business Intelligence tool you are using with Argus Insight)


    Note:

    Argus Insight can be used together with a reporting tool, which can be BI Publisher, BusinessObjects, Cognos, OBIEE, or any combination of these.

  • Argus Insight Client

Table 1-2 Argus Insight Software and Hardware Requirements

Component Requirements

Argus Insight Web Server

Supported Operating Systems:

  • Windows Server 2012 Standard

  • Windows Server 2012 R2 Standard

  • Windows 2008 R2 SP1 Standard/Enterprise (64 bit)

Note: Make sure that you install the English versions of these operating systems.

Oracle Database Software:

  • Oracle Client 11.2.0.4 (32 bit) (with SQL Plus, SQL Loader, Oracle and OLEDB Objects)

  • Oracle Data Provider 11.2.0.4 for .Net

  • Oracle Client 12c R1 (12.1) (32 bit)

  • Oracle Data Provider 12c R1 (12.1) for .Net

Hardware Requirements:

  • Up to 5000 cases in the system: 2x2.6 GHz processors, 4 GB memory

  • More than 5000 cases in the system: 4x2 GHz processors, 8 GB memory

Additional Software Requirements:

  • Dotnet Framework 3.5 Service Pack 1

  • IIS 7.5 (IIS 6.0 compatibility pack should also be installed)

  • IIS 8.5

  • Microsoft Internet Explorer 9.0 (32 bit, latest version), or 10.0 (32 bit)

  • Microsoft Visual C++ 2010 SP1 Redistributable

  • MSXML 6.0

  • Oracle Access Manager 11.1.1.7 (optional)

  • Webgate 10.1.4.3 (optional)

Note: The Argus Insight Web Server should be configured for Simple Mail Transfer Protocol (SMTP) for email support.

Database Server

Supported Operating Systems:

  • Oracle Enterprise Linux X86 (Version: 5.5.0.0.0 and 5.7.0.0)

  • Oracle Enterprise Linux X86-64 (Version: 5.5.0.0.0 and 5.7.0.0)

  • Solaris 10

  • Solaris 11

  • Oracle Enterprise Linux 6.1 UEK

  • Oracle Enterprise Linux 6.2 UEK

  • Oracle Enterprise Linux 6.4 UEK

  • Windows Server 2012 Standard

  • Windows Server 2012 R2 Standard

  • Windows 2008 R2 SP1 Enterprise (64 bit)

  • Windows 2008 R2 SP1 Standard (64 bit)

Note: Make sure that you install the English versions of these operating systems.

Oracle Database Software:

  • Oracle Database Server (Standard/Enterprise - AL32UTF8 character set) - Version 11.2.0.4 (32/64 bit)

    Oracle Advanced Security Transparent Data Encryption* (Optional)

    Oracle Advanced Security Network Encryption (Optional)

    *Note: Oracle Database TDE feature is part of the Oracle Advanced Security option available for Oracle Database Enterprise Edition 11g (http://www.oracle.com/technetwork/database/options/advanced-security/index.html). TDE provides the capability to encrypt sensitive data in the Oracle Database in a manner that is transparent to applications.Argus Insight product has been functionally certified with tablespace level encryption using the Oracle Database TDE feature.

  • Oracle Database Server (Standard/Enterprise) 12c R1 (12.1)

  • Oracle RAC 11g R2

  • Exadata 11g R2

Note: Oracle database standard edition is supported for single tenant deployment only.

Hardware Requirements:

  • Up to 5000 cases in the system: 2x2 GHz processors, 4 GB memory

  • More than 5000 cases in the system: 4x2 GHz processors, 16 GB memory

BI Publisher (BIP)

Supported Operating Systems:

  • Oracle Virtual Machine 2.2.1

  • Oracle Virtual Machine 2.2.2

  • Solaris 10

  • Solaris 11

  • Oracle Enterprise Linux 6.2 UEK

  • Oracle Enterprise Linux 6.4 UEK

  • Windows Server 2012 Standard

  • Windows Server 2012 R2 Standard

  • Windows 2008 R2 SP1 Enterprise (64 bit)

  • Windows 2008 R2 SP1 Standard (64 bit)

Note: Make sure that you install the English versions of these operating systems.

Oracle Database Software:

  • Same as Database Server.

Tool Version:

  • BIP 11.1.1.7.1

Additional Software Requirements:

  • Dotnet Framework 3.5 Service Pack 1

  • Oracle Access Manager 11.1.1.7 (optional)

  • Webgate 10.1.4.3 (optional)

BusinessObjects Server

Supported Operating Systems:

  • Windows 2008 R2 SP1 Enterprise (64 bit)

  • Windows 2008 R2 SP1 Standard (64 bit)

  • Windows 2008 SP2 Enterprise (32 bit)

  • Windows 2008 SP2 Standard (32 bit)

Note: Make sure that you install the English versions of these operating systems.

Oracle Database Software: Oracle Client 11.2.0.4 (32 bit and 64 bit) (with SQL Plus, SQL Loader, Oracle and OLEDB Objects)

Hardware Requirements: Same as the Argus Insight Web Server

Reporting Tool:

  • BusinessObjects XI Release 4.0 Service Pack 6

Cognos Server

Supported Operating Systems:

  • Windows 2008 R2 SP1 Enterprise (64 bit)

  • Windows 2008 R2 SP1 Standard (64 bit)

  • Windows 2008 SP2 Enterprise (32 bit)

  • Windows 2008 SP2 Standard (32 bit)

Note: Make sure that you install the English versions of these operating systems.

Oracle Database Software: Oracle Client 11.2.0.4 (with SQL Plus, SQL Loader, Oracle and OLEDB Objects)

Hardware Requirements: Same as the Argus Insight Web Server

Reporting Tool:

  • Cognos 10.2.x BI Server (default installation with all components except Cognos Content Database)

  • Cognos 10.2 BI Modeling (default installation with all components)

Additional Software Requirements:

  • Oracle Access Manager 11.1.1.7 (optional)

  • Webgate 10.1.4.3 (optional)

Oracle Business Intelligence Enterprise Edition (OBIEE)

Supported Operating Systems:

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

Note: Make sure that you install the English versions of these operating systems.

Additional Software Requirements:

  • OBIEE Administrator Tool 11.1.1.7.1 must be installed for configuring the repository file (RPD).

    Refer to the Oracle OBIEE Installation Manual for further hardware and software requirements.

Argus Insight Client

Supported Operating Systems:

  • Windows 7 (32/64 bit), (English version)

  • Windows 8 (32/64 bit), (English version)

Hardware Requirements:

  • 2.0 GHz Minimum, 1 GB Memory

Additional Software Requirements:

  • Adobe Acrobat Reader 11

  • Microsoft Excel 2007, 2010, or 2013

  • Microsoft Internet Explorer 9.0 (32 bit, latest version), or 10.0 (32 bit)


1.3 Important Installation Information

Before installing Argus Insight, review the information in this section carefully. You may need to modify several settings or install required software before you install the Argus Insight application.

1.3.1 Installation Requirements for the Servers

For the Argus Insight Web Server, BI Publisher, BusinessObjects Server, or Cognos Server:

  • Installation Language — You must install all software with the language setting configured to English. For example, if Oracle is installed in a language other than English, the registry entries are created with different names. Therefore, to avoid errors, install all software in English.

  • Oracle Client — You must install the Oracle client with the default ORACLE_HOME name, provided by the Oracle Universal Installer. Failure to do so will display an error message, stating that the Oracle OLE DB provider was not found during installation.

  • Time Zone — You must set all servers to the same time zone.

  • Default Language Setting — All the servers must have the default language setting enabled for US English.

    To enable US English as the default language setting:

    1. Open the Microsoft System Registry Editor.

      1. Click Start.

      2. Select Run.

      3. Enter regedit, and then click OK.

    2. Navigate to the following folder:

      HKEY_USERS\.DEFAULT\Control Panel\International

    3. Double-click the sCountry key in the right pane.

      1. In the Value data field, enter United States.

      2. Click OK to save changes.

    4. Exit from the Registry Editor.

    5. Restart the server to reflect the changes.

Additional Notes:

  • For Argus Insight Web Server:

    • Install the Oracle client after you install the Dotnet Framework.

    • Ensure that either you have disabled the firewall or you have added the Argus Insight port number in the Windows Firewall Exception list. The default port number for Argus Insight is 8084.

  • For BI Publisher:

    • Ensure that you have disabled the firewall. Alternatively, if the firewall is enabled, ensure that BI Publisher is accessible from other machines on the network.

  • For BusinessObjects Server:

    • Ensure that you have disabled the firewall. Alternatively, if the firewall is enabled, ensure that BusinessObjects is accessible from other machines on the network.

  • For Cognos Server:

    • Ensure that you have disabled the firewall. Alternatively, if the firewall is enabled, ensure that Cognos is accessible from other machines on the network.

1.3.2 Installation Requirements for the Argus Insight Client

To run the Argus Insight application, you must configure the following settings on the Argus Insight client machine:

  • Add the Argus Insight URL to the trusted sites.

  • Enable Cookies to the lowest possible security level.

  • Enable Javascript.

  • Enable the Allow script-initiated windows without size or position constraints setting in Internet Explorer.

    To enable this setting:

    1. Start Internet Explorer.

    2. Open the Tools menu, and select Internet Options.

    3. Select the Security tab.

    4. Click Custom level.

    5. Scroll to the Miscellaneous settings.

    6. Enable the Allow script-initiated windows without size or position constraints setting.

    7. Click OK to save changes.

1.3.3 General Installation Notes and Information

  • All the information about LDAP, Single Sign-On Header, and SMTP configuration will be synchronized in real-time and also by ETL.

  • Ensure that you have configured the Argus Safety URL in the Argus Safety Load Balancer Server.

    To do so:

    1. Navigate to Argus Console, System Management (Common Profile Switches), and select Network Settings.

    2. In the Argus Safety Load Balancer Server text box, enter either the Argus Safety URL or the Argus Safety Load Balancer URL.