1 Oracle Argus Analytics Requirements

1.1 Requirements

This section presents an overview of the Oracle Argus Analytics 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 Oracle Argus Analytics 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 Oracle Argus Analytics Database Server

Oracle Argus Analytics is certified for Oracle Database Enterprise Edition and Standard Edition 12.1.0.2.

Supported Operating System

Oracle Enterprise Linux 6.7, or Linux 7.1
Oracle Solaris 10 (64 Bit)
Oracle Solaris 11
Microsoft Windows Server 2012 Standard (64 bit)
Microsoft Windows Server 2012 R2 Standard (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 Oracle Argus Analytics ETL Server

This section comprises the following sub-sections:

1.1.1.1.3 Oracle Argus Analytics Informatica Server

Oracle Argus Analytics is certified against Informatica PowerCenter 9.0.1 with Hotfix2 and PowerCenter 9.6.1. Refer to the Informatica PowerCenter Installation Guide for recommended hardware and supported platforms.

Oracle Argus Analytics has got certified with the following:

Operating System: Oracle Enterprise Linux 5 or above (32/64 bit)
Memory: At least 8 GB RAM. HDD – at least 250 GB free space
CPU: At least 4 Dual Core CPUs

1.1.1.1.4 Oracle Data Integrator (ODI) Server

Oracle Argus Analytics is certified against Oracle Data Integrator 12.1.3 or 12.2.1. Refer to the ODI Installation Guide for recommended hardware and supported platforms.

Oracle Argus Analytics has got certified with the following:

Operating System: Microsoft Windows Server 2012 Standard (64 bit), Windows Server 2012 R2 Standard (64 bit), and Linux 6.6/6.7/7.1 (64 bit)
Memory: At least 8 GB RAM. HDD – at least 250 GB free space
CPU: At least 4 Dual Core CPUs

1.1.1.1.5 Oracle Argus Analytics OBIEE Server

Oracle Argus Analytics is certified against Oracle Business Intelligence Enterprise Edition 12.2.1 with latest patch set (The following patch has been verified with AN 8.1: 12.2.1.160419 at the time of the release).

Refer to the installation manual of OBIEE for further hardware and software requirements Oracle Argus Analytics would recommend the following:

Operating System

Microsoft Windows Server 2012 R2 Standard (64 bit)
Oracle Enterprise Linux 6.6/6.7/7.1 (64 bit)
Memory: RAM at least 16 GB, HDD – at least 250 GB free space
CPU: At least 4 Dual Core CPUs

Note:

If Unix-based OS is used for the OBIEE server, then the Oracle Business Intelligence Developer Client Tool must be installed separately on a Microsoft Windows box.

Please refer to the version-specific certification matrix for detailed information on OS certification.

1.1.1.1.6 Oracle Argus Analytics Data Warehouse Administration Console Server

Oracle Argus Analytics requires Oracle Data Warehouse Administration Console Server 11.1.1.6.4.

Supported Operating System

Oracle Enterprise Linux 5 or above (32/64 bit)
Oracle Solaris 10 and 11 (64 bit)
Microsoft Windows Server 2008 or above (32/64 bit)
Microsoft Windows Server 2012 or above (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

Oracle Argus Analytics requires Oracle database client to connect to the database server. The supported client software version is 12.1.0.2.
Supported Operating System:
- Microsoft Windows Server 2012 Standard (64 bit)
- Microsoft Windows Server 2012 R2 Standard (64 bit)

1.1.1.2.2 Oracle Data Warehouse Administration Console Client

Oracle Data Warehouse Administration Console Client is required only when Informatica PowerCenter is used as an ETL Tool
Oracle Argus Analytics requires Oracle Data Warehouse Administration Console Client 11.1.1.6.4
Supported Operating System: Microsoft Windows Server 2012 or above (64 bit)

1.1.1.2.3 ETL Client

This section comprises the following sub-sections:

1.1.1.2.4 Informatica PowerCenter Client

An Informatica PowerCenter Client 9.0.1 with Hotfix 2 or PowerCenter Client 9.6.1 is required to connect to the Informatica Server.
Supported Operating System: Microsoft Windows Server 2008 or above (32/64 bit), Microsoft Windows Server 2012 or above (64 bit)

1.1.1.2.5 ODI Studio

An ODI Studio 12.1.3 or 12.2.1 is required to connect to the ODI Repository.
Supported Operating System:
- Microsoft Windows Server 2012 Standard (64 bit)
- Microsoft Windows Server 2012 R2 Standard (64 bit)
- Linux 6.6/6.7/7.1
You can also refer to this link for supported platforms:

ODI 12.2.1:

http://www.oracle.com/technetwork/middleware/fusion-middleware/documentation/fmw-1221certmatrix-2739738.xlsx

ODI 12.1.3:

http://www.oracle.com/technetwork/middleware/fusion-middleware/documentation/fmw-1213certmatrix-2226694.xls

1.1.1.2.6 Oracle Business Intelligence Developer Client Tool

Oracle Business Intelligence Developer Client Tool 12.2.1 must be installed for configuring the repository file (RPD).
Supported Operating System:
- Microsoft Windows Server 2012 Standard (64 bit)
- Microsoft Windows Server 2012 R2 Standard (64 bit)

1.1.1.2.7 Optional Security Component

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

1.1.1.2.8 Miscellaneous Components

For running the reports and dashboards, your machine should have the Adobe Flash Player 10 or above installed.
Although OBIEE 12.2.1 reports are supported on Microsoft Internet Explorer, Mozilla Firefox, Chrome, and Safari, Oracle Argus Analytics is certified only for Microsoft Internet Explorer 11, or above.

1.1.1.3 Supported Sources

Oracle Argus Analytics, by default, supports only Oracle Argus Safety. It supports Oracle Argus Safety 8.1

1.1.1.4 Technology Stack Matrix

The following table displays the technology stack matrix diagram of all the components of Oracle Argus Analytics.

Specification	OBIEE Server	Database	Informatica Server	Oracle Data Integrator (ODI)	Client
Operating System	Windows Server 2012 Standard (64 Bit) Windows Server 2012 R2 Standard (64 Bit) Oracle Enterprise Linux 6.6 Oracle Enterprise Linux 6.7 Oracle Enterprise Linux 7.1	Windows Server 2012 R2 Standard (64 Bit) Oracle Enterprise Linux 6.7 Oracle Enterprise Linux 7.1	Windows Server 2008 or above (32/64 Bit) Windows Server 2012 or above (64 Bit) Oracle Enterprise Linux X86 Version 5 or above (32/64 Bit) Oracle Solaris 10 (64 Bit)	Windows Server 2012 Standard (64 Bit) Windows Server 2012 R2 Standard (64 Bit) Oracle Enterprise Linux 6.6 Oracle Enterprise Linux 6.7 Oracle Enterprise Linux 7.1	Windows Server 2012 Standard (64 Bit) Windows Server 2012 R2 Standard (64 Bit)
Oracle Database	12.1.0.2 Client	12.1.0.2 (Enterprise) - AL32UTF8 character set (Supports both CDB-PDB/Non CDB)
OBIEE	OBIEE 12.2.1 (With the latest patch set)
Informatica	Informatica Server 9.0.1 HF2 or Informatica Server 9.6.1		Informatica Server 9.0.1 HF2 or Informatica Server 9.6.1
DAC	DAC Server 11.1.1.6.4		DAC Server 11.1.1.6.4
Browser	IE 11.0				IE 11.0
Adobe Reader	Acrobat Reader DC Acrobat Reader XI				Acrobat Reader DC Acrobat Reader XI
Single Sign On Solution (Optional)	Oracle Access Manager 11g
Resolution					Minimal Resolution 1280x1024

Note:

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.

Oracle Business Intelligence Developer Client Tool can be installed along with the OBIEE Server, provided the Operating System is Microsoft Windows.

*Note 1:

Oracle Client Patch required for the SQL Loader

Download the patch 19720843: WINDOWS DB BUNDLE PATCH 12.1.0.2.1 from the Oracle Support.
Install the patch, and apply the following workaround:

a. Set the oracle_home as your client home location. For example:

SET ORACLE_HOME=C:\app\client32\product\12.1.0\client_1

i. On the client machine, go to %oracle_home%\bin\

ii. From \p19720843_121020_WINNT\19720843\files\bin\, copy the file oranfsodm12.dll, and paste it under %oracle_home%\bin

b. Run sqlldr help=y or sqlldr.exe.

1.1.1.4.1 Supported Security Configuration

Oracle Argus Analytics supports the following optional security configurations:

LDAP/LDAPS 3.0
Single Sign On Solution through Oracle Access Manager 11g

Note:
If OAM is used, then the OBIEE Server must have Oracle Web Tier 12c with in-built WebGate.

1.1.1.5 Typical Hardware Architecture

A typical Oracle Argus Analytics installation contains the following hardware architecture:

Servers:
- An Oracle Database Server with Oracle Database 12.1.0.2
- An OBIEE 12.2.1 Server with latest patch set
- ETL Server
  * Informatica: Informatica PowerCenter 9.0.1 with Hotfix 2 or PowerCenter 9.6.1 Server + DAC Server 11.1.1.6.4
  
  OR
  
  * ODI Studio 12.1.3 or 12.2.1
  
  Note:
  The above three boxes can run on any of the supported platforms: Linux/Solaris/Windows.

Clients:

ETL Clients
* Informatica PowerCenter Client 9.0.1 + Hotfix 2 or Informatica PowerCenter Client 9.6.1

OR

* ODI Studio 12.1.3 or 12.2.1
Oracle Database Client 12.1.0.2
DAC Client 11.1.1.6.4

Oracle Business Intelligence Developer Client Tool (12.2.1.0.0)

Note:

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

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

Informatica PowerCenter and Oracle Database Client should be available in the same machine for Oracle Argus Analytics installer to run, if installation choice for ETL server is chosen as Informatica.

Note:

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

Figure 1-1 Oracle Argus Analytics Technology

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, "Pre-requisites".
Execute the installer – to create the data mart and Informatica ETLs.
Follow the post-installation steps to configure DAC/ODI and OBIEE

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

1.1.2 Pre-requisites

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

Oracle Database Server – An Oracle 12.1.0.2 database server should be created before Oracle Argus Analytics installation. Follow the platform-specific Database Installation Guide for installing this server.

Note:
The database server should be configured with AL32UTF8 character set.
ETL Server Choice

Informatica PowerCenter Server – An Informatica PowerCenter 9.0.1 + HF2 or PowerCenter 9.6.1 should be created before running the Oracle Argus Analytics Installer. Follow platform-specific Informatica PowerCenter Installation.

Note:

Informatica Server needs a repository database. Customers can either use the database created in the previous step or can create a new database for holding the repository.
A Versioned PowerCenter Repository should be created upon the installation of PowerCenter. This versioned repository information will be needed during Oracle Argus Analytics installation along with the admin user credentials.
An Oracle 12.1.0.2 Client should be available in the Informatica Server.

DAC Server (Required only for Informatica ETL Server) – An Oracle Data Warehouse Administration Console Server of version 11.1.1.6.4 needs to be installed on the same machine where Informatica client is loaded. Follow platform-specific ODAC Installation Guide for installation instructions.

OR
Oracle Data Integrator - ODI Studio 12.1.3 or 12.2.1 should be installed on the server machine where ETLs have to be configured.

Note:
ODI Server needs Master and Work Repository Database, which can be created on the same DWH DB Server created above.
OBIEE Server - An Oracle Business Intelligence Enterprise Edition 12.2.1 Server must be installed before the Oracle Argus Analytics Installation. Follow platform-specific OBIEE Installation Guide for installation instructions.

1.1.2.1 Client Tools

ETL Client Tools
Informatica PowerCenter Client - An Informatica PowerCenter Client 9.0.1 with Hotfix 2 or PowerCenter Client 9.6.1 must be present. Supported only on a Microsoft Windows 32-bit machine.
DAC Client - A DAC Client 11.1.1.6.4 needs to be present. Supported only on a Microsoft Windows Server 2008 with SP1 or above (32 bit).

OR
ODI Studio installation mentioned in the sever section above can be used as an ETL client to administer/manage ETL metadata.

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

Note:

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