Oracle Tax Analytics

Quick Install Guide

Oracle Corporation

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS

Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

This software or hardware and documentation may provide access to or information on content, products and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content, products and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third party content, products or services.

Preface

The Oracle Tax Analytics Installation Guide describes the requirements and steps necessary to install Oracle Tax Analytics.

Audience

Oracle Tax Analytics Installation Guide is intended for system administrators installing Oracle Tax Analytics. To use this document you should have:

- Experience installing and configuring application servers and other software

- Administrative privileges on the host where you are installing the software

Documentation and Related Resources

Oracle Tax Analytics Documentation Set

The Oracle Tax Analytics documentation set includes the following documents:

- Oracle Tax Analytics Release Notes

- Oracle Tax Analytics Quick Install Guide

- Oracle Tax Analytics Installation Guide

- Oracle Tax Analytics Implementation Guide

- Oracle Tax Analytics Reference Guide

Oracle Technology Network

Visit the Oracle Technology Network (OTN) to access demos, whitepapers, Oracle By Example (OBE) tutorials, updated Oracle documentation, and other collateral.

Registering on OTN

You must register online before using OTN, Registration is free and can be done at www.oracle.com/technetwork/index.html

Oracle Documentation on OTN

The Oracle Documentation site on OTN provides access to Oracle documentation. After you have a user name and password for OTN, you can go directly to the documentation section of the OTN Web site at www.oracle.com/technetwork/indexes/documentation/index.html

Oracle Support

Oracle customers have access to electronic support through My Oracle Support.

Document Conventions

The following text conventions are used in this document:

Table 1. Documentation Conventions

Convention

Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.

italic

Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.

monospace

Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

Oracle Tax Analytics Installation Overview

This guide provides a high-level overview of the installation steps for Oracle Tax Analytics version 2.0.0.0.0 and selected additional software. For more information, see the Oracle Tax Analytics Installation Guide.

Contacting Oracle Support

Visit My Oracle Support (http://support.oracle.com) for the most recent service packs and patches for this release.

Refer to Oracle Patch 14637277 for any updates to this document.

Media Pack Contents

The Oracle Tax Analytics Media Pack contains the following documents:

- Oracle Tax Analytics Release 2.0.0 Release Notes

- Oracle Tax Analytics Release 2.0.0 Quick Install Guide

- Oracle Tax Analytics Release 2.0.0 Installation Guide

- Oracle Tax Analytics Release 2.0.0 Reference Guide

- Oracle Tax Analytics Release 2.0.0 Implementation Guide

- Oracle Tax Analytics V2.0.0.0.0 Installation Package

Visit My Oracle Support (http://support.oracle.com) for updates to the above guides. For the Oracle Tax Analytics Reference Guide and Oracle Tax Analytics Implementation Guide, use Patch Number 14659344. For the Oracle Tax Analytics Installation Guide and Oracle Tax Analytics Quick Install Guide, use Patch Number 14637277.

Additional Software Requirements

The following software products are required to run Oracle Tax Analytics, but are not included in the media pack:

- Oracle Business Intelligence Enterprise Edition 11.1.1.6.0

- Oracle Data Integrator 11.1.1.6.0

- Oracle Database Server Enterprise Edition 11.2.0.2

You must separately license and install the software listed above. For more information on the content of each licensed Oracle Tax Analytics product, see the Licensing and Packaging Guide section of the Oracle Tax Analytics Release Notes.

Components for Oracle Tax Analytics

The Oracle Tax Analytics V2.0.0.0.0 Installation Package includes the following components:

- Oracle Data Integrator master repository

- Oracle Data Integrator work repository

- Foundation schema

- Star Schema

- Data Mining schema

- System data

- OBIEE RPD file

- OBIEE Web catalog

- OBIEE Writeback file

- Documentation

Architecture Overview

This section describes the recommended architecture of an Oracle Tax Analytics environment.

Tier 1: Browser-Based Client/Oracle Data Integrator Java-Based Client

Oracle Tax Analytics has a Web browser-based client and standalone Java client. The client that you choose depends on the user role or activity.

Business users can use a browser-based client to access Oracle Tax Analytics. Oracle Tax Analytics is deployed on Oracle Business Intelligence Enterprise Edition 11g, which supports various operating system and Web browser combinations.

Administrators and developers can use the browser-based client for managing Oracle Business Intelligence Enterprise Edition. To manage the Oracle Data Integrator, a standalone Java client is available in addition to the browser-based client.

Oracle Business Intelligence Enterprise Edition and Oracle Data Integrator support various operating systems and Java Development Kit combinations.

Note: For complete and up-to-date information on Oracle Business Intelligence Enterprise Edition 11g and Oracle Data Integrator 11g supported platforms, visit the Oracle Technology Network at http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Tier 2: Middle Tier/Application Server

Oracle Tax Analytics uses Oracle Data Integrator for EL-T and to build facts and dimensions. Please refer to Oracle Data Integrator 11g documentation for additional details.

Oracle Tax Analytics uses Oracle Business Intelligence Enterprise Edition for dashboards and reports. Please refer to Oracle Business Intelligence Enterprise Edition 11g documentation for additional details.

Tier 3: Database Server

Oracle Tax Analytics uses Oracle Database to store the Analytics Data. It supports Oracle Database Server Enterprise Edition 11gR2 (11.2.0.2).

Recommended Architecture for Oracle Tax Analytics

Per the Oracle Data Integrator recommendation, the ODI Master and Work repositories to be created in the same database as Oracle Tax Analytics warehouse.

The following diagram shows the recommended architecture for Oracle Tax Analytics:

Supported Platforms

This section describes the supported environments under which Oracle Tax Analytics operates, as well as information about hardware and software requirements.

Oracle Business Intelligence Enterprise Edition Requirements

Oracle Tax Analytics supports Oracle Business Intelligence Enterprise Edition version 11.1.1.6.0. It supports the operating systems on which Oracle Business Intelligence Enterprise Edition is certified.

For complete and up-to-date information on Oracle Business Intelligence Enterprise Edition 11g supported platforms, visit the Oracle Technology Network at http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Oracle Data Integrator Requirements

Oracle Tax Analytics supports Oracle Data Integrator 11.1.1.6.0. It supports the operating systems on which Oracle Data Integrator is certified.

For complete and up-to-date information on Oracle Data Integrator 11g supported platforms, visit the Oracle Technology Network at http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Oracle Database Requirements

Oracle Tax Analytics supports Oracle Database Server Enterprise Edition 11gR2 (11.2.0.2). It supports the operating systems on which Oracle Database is certified.

For complete and up-to-date information on Oracle Database11g supported platforms, visit the Oracle Support website at https://support.oracle.com/ and click the Certifications tab.

Oracle Tax Analytics Installer Requirements

The Oracle Tax Analytics installer will run on any platform which is certified to run Java Runtime Environment (JRE) 1.6 or above. The JRE 1.6 or above must be installed on the same machine where the installer will be running. The installer also requires Oracle Data Integrator 11.1.1.6.0 Software Development Kit (SDK), which must be installed on the same machine where installer will be running.

Hardware Requirements

This section describes minimum Oracle Tax Analytics hardware requirements.

Description

Requirements

Oracle Tax Analytics Installer

- 1 or more 2GHZ CPUs

- 1 GB of RAM

- 500 MB of disk space

Oracle Data Integrator Java-Based Client

- 1 or more 2GHZ CPUs

- 1 GB or RAM

- 300 MB of disk space

Oracle Data Integrator Agent

- 2 or more 2GHZ CPUs

- 4 GB of RAM

- 300 MB disk space

Oracle Business Intelligence EE

- 2 or more 2GHZ CPUs

- 4 GB of RAM

- 10 GB disk space

Oracle Database Enterprise Edition

- 2 or more 2GHZ CPUs

- 4 GB of RAM

- 10 GB disk space

See the Oracle Database Enterprise Edition, Oracle Data Integrator and OBIEE documentation for detailed hardware requirements.

Client Requirements

Oracle Tax Analytics administrators and developers must have either a Windows or Linux machine to run the Oracle Data Integrator Java client and a browser-based client for managing Oracle Business Intelligence Enterprise Edition environments. Though it is not mandatory to have Oracle client connectivity software for administrators and developers, Oracle 11g Client is the minimum required version to connect to the databases.

Business analysts accessing the Oracle Tax Analytics presentation layer must have a browser-based client. This is typically a Windows XP or higher machine with a supported Web browser. Please refer to the following table for details:

Client Type

Requirement

Oracle Tax Analytics Installer

Windows or Linux/Unix OS with JRE 1.6 or above and ODI 11.1.1.6.0 SDK installed

Oracle Data Integrator Java-based client

Refer to Oracle support site for complete list of supported platforms*

Oracle Data Integrator Meta Data Navigator

Refer to Oracle support site for complete list of supported platforms*

Oracle Business Intelligence Enterprise Edition

Refer to Oracle support site for complete list of supported platforms*

Oracle Client Software (optional)

Oracle 11g Client

* http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Support for Virtualization and Virtual Machines

Oracle Tax Analytics may be used with VMware virtualized environments consistent with the policy for other Oracle products as stated in Support Note 475484.1 available on My Oracle Support (http://support.oracle.com). For information on Oracle VM, see Support Notes 464756.1 and 464754.1 on My Oracle Support.

Supported Databases for Oracle Tax Analytics

Oracle Tax Analytics supports only Oracle Database Enterprise Edition 11.2.0.2. The database may be hosted on any platform on which it is certified. For more detail on Oracle Database Enterprise Edition, visit the Oracle Technology Network at http://www.oracle.com/technetwork/database/enterprise-edition/ downloads/index.html

The supported database character set is AL32UTF8.

Supported Databases for Oracle Data Integrator Repositories

Oracle Tax Analytics supports ODI repositories on Oracle Database Enterprise Edition 11.2.0.2. For more detail on Oracle Data Integrator supported platforms, visit the Oracle Technology Network at http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

The supported database character set is AL32UTF8.

Installing Oracle Tax Analytics

This section provides high level steps for installing Oracle Tax Analytics. For detailed installation information, see the Oracle Tax Analytics Installation Guide.

To install Oracle Tax Analytics V2.0.0.0.0:

1. Install database server software.

2. Create a database for Oracle Tax Data Model Schema, Data Mining Schema and Oracle Data Integrator repositories.

3. Setup database users for Oracle Tax Data Model Schema, Data Mining Schema and Oracle Data Integrator repositories.

4. Create Oracle Data Integrator Master Repository using Oracle Tax Analytics Installer.

5. Import the Oracle Data Integrator Work repository using the Oracle Tax Analytics installer.

6. Install Oracle Tax Data Model and Data Mining schema objects using the Oracle Tax Analytics installer.

7. Install System data using the Oracle Tax Analytics installer.

8. Install Oracle Business Intelligence Enterprise Edition software.

9. Deploy OBIEE RPD into OBIEE environment.

10. Deploy OBIEE Web catalog into OBIEE environment.

11. Deploy Oracle Tax Analytics Writeback file into OBIEE environment.

12. Setup OBIEE users.

13. Configure Map Viewer to support map views in OBIEE.

14. Install Oracle Data Integrator software on the ODI Agent server.

15. Configure agent.

The following diagram provides an overview of the steps that need to be taken to install and configure Oracle Tax Analytics:

Table of Contents

Cover Page

Legal Notices

Preface

Oracle Tax Analytics Installation Overview

Media Pack Contents

Additional Software Requirements

Components for Oracle Tax Analytics

Architecture Overview

Supported Platforms

Installing Oracle Tax Analytics