Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Data Warehouse Administration Console 11g Release 1 (11.1.1) Part Number E14849-06 |
|
|
PDF · Mobi · ePub |
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:
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 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 10, "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.
Revision 1 of Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Data Warehouse Administration Console (11.1.1) contains the following updates:
Support for handling failed tasks while an execution plan is still running. See "Using DAC's Hotfix Capability to Handle Failed Tasks While an Execution Plan Is Still Running".
Support for the parameterization of default values for table columns. See "Managing Data Warehouse Schemas" and "Parameterizing Default Values for Table Columns".
Enhancements to the DAC patching feature that enable you to have subject areas automatically assembled and execution plans automatically rebuilt when these objects are applied to a repository as patch contents. See "Working With DAC Metadata Patches".
Enhancements to the concurrent ETL feature that enable you to define an execution plan prefix in order to run concurrent execution plans that share common tasks. See "Execution Plans That Are Eligible to Run Concurrently".
A new Task by Depth right-click command in the Execution Plans tab of the Execute view, which shows how many tasks in an execution plan are at each depth level. See "Performance Tuning the ETL Process Using Tasks by Depth Command".
Enhancements to performance tuning by creating logical partitions on load tasks. See "Creating Logical Partitions on Load Tasks to Increase Performance".
General quality enhancements throughout the guide.
Revision 2 of Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Data Warehouse Administration Console (11.1.1) contains the following updates:
Support for creating multiple instances of an execution plan that can run concurrently. See "Running Multiple Instances of an Execution Plan".
A new extended property in the Extended Properties subtab of the Physical Data Sources tab in the Setup view called Time Difference Override. This property is used to specify the time difference between the DAC Server machine and the physical data source database machine. See "Physical Data Sources Tab: Extended Properties Subtab".
General quality enhancements throughout the 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:
Support for adding to a patch unique identifiers for objects deleted in the source. The objects that were deleted in the source will be deleted from the target repository when the patch is applied. See "Working With DAC Metadata Patches".
When defining an event delay, you can now choose to begin executing the ETL process even if the condition defined in the Condition SQL property has not occurred. See "Setting Up Event Delays".
Support for adding source and target tables to tasks by reading from external executors. This feature is available from as a right-click command in the Tasks tab of the Execute view. See "Design View Right-Click Menu Commands".
Instructions for setting up deferred ETL processes, which enable you to load a subset of data initially and then incrementally add historical data. See "Setting up and Running Deferred ETL Processes".
Instructions for installing DAC in standalone mode using the Oracle BI Applications Client Installer. See "Installing DAC on Windows in Standalone Mode".
Instructions for installing DAC on UNIX environments in standalone mode. See "Installing DAC on UNIX in Standalone Mode".
General quality enhancements throughout the guide.
Revision 4 of Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Data Warehouse Administration Console (11.1.1) contains the following updates:
A new chapter, Chapter 3, "Upgrading to DAC 11g," which explains how to upgrade the DAC Client and Server from DAC 10g to DAc 11g.
A new appendix, Appendix B, "Oracle TimesTen Database Guidelines," which provides information about using an Oracle TimesTen database for the data warehouse.
Instructions for copying data from a regular data warehouse database to an Oracle TimesTen database. See "Copying Data From a Regular Warehouse to an In-Memory Database".
Revisions to Chapter 10, "Managing Data Warehouse Schemas," to include support for TimesTen databases.
A new topic: "Exporting the Logical Data Model in Text or CSV Formats".
A new topic: "Adding Foreign Key Metadata Into DAC".
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:
http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-requirements-100147.html
The certification document covers supported installation types, platforms, operating systems, databases, JDKs, and third-party products:
http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html