Preparing to Install Analytics Link

In This Section:

About Analytics Link

Analytics Link System Requirements

Analytics Link Prerequisites

Supported Upgrade Paths

Upgrading Analytics Link

Oracle Product Dependencies

Release Compatibility

Ports

HFS_HOME Environment Variable

About Analytics Link

Analytics Link consists of these components:

  • Analytics Link Server—A Web server that integrates Oracle Hyperion Financial Management applications with Oracle Essbase databases and manages all operations of Analytics Link.

  • Analytics Link Repository—A relational database user/schema in which Analytics Link Server stores its internal data.

  • Analytics Link Data Synchronization Server—Creates a database based on the data and metadata extracted from the Financial Management application. This database is a replica of the Financial Management application. As an aggregation engine, Data Synchronization Server performs data aggregation on demand.

  • Analytics Link Administration Services Console Plug-in—The Analytics Link Server client, which provides the user interface for defining and managing Analytics Link Servers and bridges.

  • Analytics Link Financial Management Connector—Enables Analytics Link Server to extract Financial Management application metadata.

Analytics Link System Requirements

Make sure that each computer on which you plan to install Analytics Link meets the system requirements in Table 2.

Table 2. System Requirements

Category

Requirements

Operating System

(Windows: 32-bit or 64-bit; Linux: 64-bit only)

  • Microsoft Windows 2008 Server

  • Microsoft Windows 2003 Standard Edition, SP 1 and SP 2

  • Microsoft Windows 2000 Server, SP 4 or later

  • Microsoft Windows 2000 Professional, SP 4 or later

  • Microsoft Windows XP Professional, SP 1a or later

  • Red Hat Enterprise Linux Release 5.3

Disk Space (Minimum)

217 MB required (which includes 71 MB for temporary files)

RDBMS

(32-bit or 64-bit)

  • Oracle RDBMS 11g

  • Oracle RDBMS 10g

  • Microsoft SQL Server 2008[1]

  • Microsoft SQL Server 2005[1]

Web Application Server

  • WebLogic Server 11g (10.3.2 or higher) (32-bit or 64-bit)[2]

  • Apache Tomcat (32-bit)[3]

1 When using Microsoft SQL Server as the Analytics Link repository and the Analytics Link Server is deployed on Apache Tomcat (which is the internal Web Application Server container), Microsoft SQL Server JDBC driver 2.0 (Type 4) must be installed on the computer where Analytics Link Server is installed. You must obtain the SQL Server JDBC driver from Microsoft.

2 You must use WebLogic Server if you are using Analytics Link with 11.1.2.0 or later releases of EPM System.

3 You must use Apache Tomcat if you are using Analytics Link with pre-11.1.2.0 releases of EPM System. Analytics Link automatically installs Apache Tomcat (32-bit).

Analytics Link Prerequisites

  Before you install Analytics Link:

  1. Identify the computers on which you plan to install and configure Analytics Link components.

  2. Verify that the computer on which you install Analytics Link meets the prerequisites for each component, as listed in Table 3:

    Table 3. Analytics Link Component Prerequisites

    Analytics Link ComponentPrerequisites

    Analytics Link Server

    • WebLogic Server

      If you are using Analytics Link with 11.1.2.0 or later releases of EPM System, only WebLogic Server is supported.

      Analytics Link Server must be installed on the same computer on which WebLogic Server runs.

      When using the Red Hat Enterprise Linux (64-bit) operating system, Analytics Link Server can only be deployed on WebLogic Server (64-bit).

      During the configuration process, deploy Analytics Link Server to the WebLogic Server EPMSystem domain.

      Analytics Link deploys Analytics Link Server based on the bitness (32-bit or 64-bit) of WebLogic Server.

      See Oracle Hyperion Foundation Services prerequisites in this table.

    • Apache Tomcat

      If you are using pre-11.1.2.0 releases of EPM System, only Apache Tomcat is supported. Analytics Link automatically installs Apache Tomcat (32-bit).

      During the configuration process, Analytics Link Server is deployed to Apache Tomcat in 32-bit mode.

    Analytics Link Repository

    • Oracle RDBMS

      Create a user using the following statements:

      create user <EAL_user> identified by <password>;
      grant CREATE SESSION, CREATE VIEW, RESOURCE to <EAL_user>;
      ALTER USER <EAL_user> DEFAULT ROLE "RESOURCE";
    • Microsoft SQL Server

      Create a new database for the Analytics Link repository, and define a user (new or existing) as the owner of this database.

      If you plan to use Microsoft SQL Server as the Analytics Link repository and the Analytics Link Server is deployed on Apache Tomcat (which is the internal Web Application Server container), Microsoft SQL Server JDBC driver 2.0 (Type 4) must be installed on the computer where Analytics Link Server is installed. You must obtain the SQL Server JDBC driver from Microsoft.

    Caution!

    If you are installing this release of Analytics Link over a previous release of Analytics Link, you must clear the Analytics Link repository. See Upgrading Analytics Link.

    Foundation Services

    When Analytics Link Server is integrated with Foundation Services 11.1.2.0 or later releases, the EPM Oracle Instance in which the Foundation Services database is configured must exist on the computer where Analytics Link Server will be deployed. See Configure Foundation Services.

    • To configure Foundation Services in Analytics Link when using 11.1.2.0 or later releases of EPM System, you must know the name and password of a Foundation Services administrative user, EPM Instance Home, and, for the Foundation Services repository, the RDBMS type, host, port, user and password.

    • To configure Foundation Services in Analytics Link when using pre-11.1.2.0 releases of EPM System, you must know the name of the computer on which Shared Services Server runs, the port number, and the name and password of a Oracle Hyperion Shared Services administrative user.

    Analytics Link Data Synchronization Server

    Verify that the store directory for Data Synchronization Server has enough available disk space for the Financial Management applications that you plan to use with Analytics Link.

    Analytics Link Financial Management Connector

    Install Analytics Link and configure Analytics Link Financial Management Connector on the computer on which the Financial Management Web Application is configured.

    Analytics Link Administration Services Console Plug-in

    Install Analytics Link and enable the Analytics Link Administration Services Console plug-in on each computer with an Oracle Essbase Administration Services client that you plan to use with Analytics Link.

Supported Upgrade Paths

Analytics Link requires a fresh installation.

See Upgrading Analytics Link.

Upgrading Analytics Link

  To upgrade your installation of Analytics Link:

  1. Shut down the following service instances:

    • Administration Services Console

    • Data Synchronization Server

    • Analytics Link Server

  2. Uninstall Analytics Link using the version of the Oracle Universal Installer that was used to install the Analytics Link release you are uninstalling.

    See Uninstalling Analytics Link.

  3. Install the newer version of Analytics Link.

    See Installing Analytics Link.

Caution!

When upgrading Analytics Link from a previous release, you must clear the Analytics Link repository when you configure the Analytics Link repository, unregister Analytics Link Server from Shared Services when you configure Foundation Services, and reset Data Synchronization Server when you configure Data Synchronization Server.

Oracle Product Dependencies

Analytics Link requires the following Oracle products:

  • Shared Services

  • Financial Management

  • Essbase

  • Oracle Hyperion Provider Services (starting with Analytics Link release 11.1.1.3, using Provider Services to integrate Essbase and Financial Management through Analytics Link is optional)

  • Administration Services

You can find EPM System installation documentation on the Oracle Documentation Library (http://www.oracle.com/technology/documentation/epm.html) on Oracle® Technology Network.

To install these EPM System products, see the following documentation:

Release Compatibility

Analytics Link is compatible with the following EPM System products (see Table 4).

Table 4. Release Compatibility for Analytics Link

Compatible EPM System ProductsRelease

Shared Services

Releases:

  • 11.1.2.1

  • 11.1.2.0

  • 11.1.1.3

  • 9.3.1.x

Financial Management

Releases:

  • 11.1.2.1

  • 11.1.2.0

  • 11.1.1.3

  • 9.3.1.x

Essbase

Releases:

  • 11.1.2.1

  • 11.1.2.0

  • 11.1.1.3

  • 9.3.1.x

Provider Services[1]

Releases:

  • 11.1.2.1

  • 11.1.2.0

  • 11.1.1.3

  • 9.3.1.x

Administration Services

Releases:

  • 11.1.2.1

  • 11.1.2.0

  • 11.1.1.3

  • 9.3.1.x

1 Starting with Analytics Link release 11.1.1.3, using Provider Services to integrate Essbase and Financial Management through Analytics Link is optional.

For Analytics Link, Oracle recommends using products from the same release; however, to use Analytics Link in a mixed-release environment, follow these guidelines:

  • Essbase, Administration Services, and Provider Services (which is optional) must be from the same release.

  • If Essbase and Financial Management are from different releases, Oracle recommends using separate installations of Shared Services: one for Essbase and one for Financial Management. For information on using Shared Services in a mixed-release environment, see the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.

Ports

For each Oracle product installed on a computer, the port number must be unique. (The same product on different computers can have the same port number.) If the default port is already in use on the computer, or if there is a port number conflict, resolve the issue before configuring Analytics Link.

With the exception of the Shared Services listen port, the ports listed in Table 5 are configured using Analytics Link Configuration Tool.

Table 5. Ports

Port TypeDefault Port Number

Analytics Link Server listen port

5423

Analytics Link Server shutdown port

This port is used when deploying Analytics Link Server to the internal Web server container (Apache Tomcat).

5422

WebLogic EPMSystem domain Admin Server port

This port is used when deploying Analytics Link Server on WebLogic Server.

7001

Analytics Link Repository listen port

  • Oracle—1521

  • Microsoft SQL Server—1433

Analytics Link Data Synchronization Server listen port

5024

Port Data Synchronization Server uses to simulate the Essbase Server port

5025

Shared Services listen port

This port is used when configuring Analytics Link Server.

  • 11.1.1.3 and later—28080

  • 9.3.1.x—58080

HFS_HOME Environment Variable

Analytics Link creates the HFS_HOME environment variable, which points to the directory where Analytics Link is installed.