Skip Headers
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Data Warehouse Administration Console
11g Release 1 (11.1.1)

Part Number E14849-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

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

What's New in This Release

This chapter lists the new features in the current release of Oracle Business Intelligence Data Warehouse Administration Console (DAC). It also provides information about hardware and software requirements, platforms, and databases.

The chapter contains the following topics:

What's New in DAC

New DAC features include the following:

Functional Setup for Task Level Parameters

The functional setup of task level parameters is an operation that you now perform using the Oracle Business Intelligence Applications Configuration Manager. For more information, see Oracle Fusion Middleware Installation and Configuration Guide for Oracle Business Intelligence Applications.

DAC Security

See Chapter 1, "About DAC Security," for information about the new DAC security model. For information about the differences between standalone mode and Fusion Middleware mode, see "DAC Authentication in Oracle Fusion Middleware (WebLogic Server) Mode" and "DAC Authentication in Standalone Mode".

Enhancement for Index Creation

DAC now supports the creation of query indexes in parallel immediately following the creation of ETL-related indexes. DAC notifies the successor tasks as soon as the ETL indexes have been created, allowing query indexes and additional unique indexes to be created sooner. See "Managing Indexes" for more information.

Creation of Indexes in Parallel for a Specific Table

DAC now enables you to specify how many indexes can be created in parallel for a specific table or how many indexes can be created in parallel for all tables associated with a specific physical data source connection. See "Specifying How Many Indexes Can Be Created in Parallel" for more information.

Testing an Individual Workflow

You can test an individual workflow before running a full execution plan. See "Unit Testing Execution Plan Tasks" for more information.

Enhancement for Prune Time Property

See "Execution Plans Tab: Connectivity Parameters Subtab" for more information.

Running Execution Plans Concurrently

You can configure DAC to run multiple execution plans concurrently if the execution plans are independent of one another, that is, as long as the execution plans do not load data into the same table on the same physical data source. See "Running Execution Plans Concurrently" for more information.

Looping of Workflows

You can configure the full and incremental load commands for tasks to repeat (or loop) multiple times during the execution of an ETL process. See "Looping of Workflows" for more information.

Event Delays

You can set up event delays to configure the extracts for different data sources to occur independently. See "Setting Up Extract Delays, Event Delays and Data Source Notifications" for more information.

Using Heuristics to Manage Tasks, Tables and Indexes

The DAC heuristics feature enables you to gather intelligence about the amount of incremental data that will be processed during an ETL execution. To optimize performance, you can use this intelligence to decide how to manage the behavior of tasks, tables, and indexes. See "Using Heuristics to Manage Tasks, Tables and Indexes" for more information.

Integrating DAC With Other ETL Tools

The external executor framework enables you to integrate DAC with ETL engines other than Informatica. See "Integrating DAC With Other ETL Tools" for more information.

Working With DAC Metadata Patch Sets

The DAC metadata patch feature enables you to import and export subsets of DAC metadata at a fine grain. See "Working With DAC Metadata Patches" for more information.

Creating and Upgrading the Data Warehouse Schema

DAC provides new functionality to create or upgrade data warehouse schemas. See Chapter 9, "Managing Data Warehouse Schemas," for more information.

EM Beans Implementation

Fusion Middleware Control MBean Browser is an Oracle Web application (based on JMX MBean containers) that you can use to view information about running, failed and queued execution plans and the status of the DAC Server. See "Viewing DAC Metrics Using Fusion Middleware Control MBean Browser" for more information.

Moving a DAC Environment

Oracle Fusion Middleware provides movement scripts that enable you to move components and configurations from a development or test environment to a production environment. When DAC is installed in an Oracle Fusion Middleware environment and you run the movement scripts, DAC components and configurations are moved along with the other Oracle Fusion Middleware components. The section "Moving a DAC Environment Using Oracle Fusion Middleware Movement Scripts" provides information about this process.

Updates to Revision 3 of This Guide

Revision 3 of Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Data Warehouse Administration Console (11.1.1) contains the following updates:

System Requirements and Certification

Refer to the system requirements and certification documentation for information about hardware and software requirements, platforms, databases, and other information. Both of these documents are available on Oracle Technology Network (OTN).

The system requirements document covers information such as hardware and software requirements, minimum disk space and memory requirements, and required system libraries, packages, or patches:

The certification document covers supported installation types, platforms, operating systems, databases, JDKs, and third-party products: