18 Using Discoverer with components of Oracle Application Server

Using Discoverer with Oracle Application Server Control

Oracle Application Server Control provides a common look and feel, behavior and security infrastructure to configure the middle tier web components of Oracle Application Server with a single tool. Using a single tool for all Oracle Application Server components reduces the time spent on administration and configuration. You can use Oracle Application Server Control to configure Discoverer's middle tier web components.

For more information, see:

• Oracle Business Intelligence Discoverer Configuration Guide

• Oracle Application Server Control Discoverer help

Using Discoverer with Oracle Application Server Reports

Discoverer users can share workbooks, export them to Oracle Application Server Reports (V7.0 and later) enabling Reports users to open a Discoverer workbook. The workbook SQL, additional formatting and calculations are passed to Oracle Application Server Reports using an XML based workbook. The workbook is translated into an Oracle Application Server Reports-compatible format that can be modified using Oracle Application Server Reports.

In Oracle Application Server Reports the look and feel of the original Discoverer workbook is retained so that the Oracle Application Server Reports user can continue to work on the Report in a standalone fashion. To further emphasize this point: no further interaction with the Discoverer server is required for the Reports user to enhance the file

For more information, see the Oracle Business Intelligence Discoverer Plus User's Guide.

Using Discoverer with Oracle Application Server Web Cache

Oracle Application Server Web Cache helps e-businesses improve Web site performance issues. Oracle Web Cache is a content-aware server accelerator that improves the performance, scalability and availability of Web sites that run on Oracle Application Server and Oracle8i databases (or later). High accessibility is achieved at high speed by applying the latest caching techniques provided by Oracle Application Server Web Cache.

By storing frequently accessed URLs in memory, Oracle Application Server Web Cache eliminates the need to repeatedly process requests for those URLs on the application Web server. Unlike legacy proxy servers that handle only static documents, Oracle Application Server Web Cache caches both static and dynamically generated content from one or more application Web servers. Because Oracle Application Server Web Cache is able to cache more content than legacy proxy servers, it provides optimal performance by greatly reducing the load on application Web servers.

For more information, see the Oracle Business Intelligence Discoverer Plus User's Guide and Oracle Business Intelligence Discoverer Configuration Guide.

Using Discoverer with Oracle Warehouse Builder

Oracle Warehouse Builder(OWB) can generate Discoverer metadata. You can use OWB and Discoverer Bridge to create a Discoverer EUL in OWB's meta layer, and then create a Discoverer export file (.EEX file). The .EEX file can be imported into a Discoverer EUL using Discoverer Administrator (for more information, see "How to import EUL objects from a file using the Import Wizard"). The Discoverer EUL retains the folder and item lineage from OWB. You can display the folder and item lineage from OWB by using a Discoverer Lineage workbook.

To install the lineage workbook for use with Oracle Warehouse builder:

1. Login to Discoverer Administrator as the Discoverer EUL schema owner.

2. Import the lineage.eex file.

3. Login to SQL*Plus as the Discoverer EUL schema owner.

   For example:

   > SQLPLUS myeul/myeul@myconnection

4. Run the lineage.sql file.

   For example:

   SQL> start d:\<ORACLE_HOME>\discoverer\lineage.sql

   This script will ask you to input and verify the following:

   • the OWB URL Machine Name.Domain Name:Port

     For example, http://myserver.us.mycompany.com:7777

   • the OWB Virtual path to mod_plsql (the default is pls)

     For example, pls

   • the OWB Database Access Descriptor DAD (the default is portal30)

     For example, portal30

   • the OWB Browser schema

     For example, myowbinstall

   • the OWB Host name (that is, the name of the machine that runs the OWB repository)

     For example, myserver

     Note that the name must be exactly the same as used in the OWB browser registration.

   • the OWB SID (that is, the database instance name)

     For example, ASdB

   • the OWB Schema where the OWB repository resides

     For example, owbrep

5. Login to OracleBI Discoverer Plus, OracleBI Discoverer Viewer, or OracleBI Discoverer Desktop as the EUL schema owner and open the Lineage workbook.

If you export and re-import the EUL, you will need to re-run lineage.sql.

If you have previously imported EUL5.eex, you will already have the Lineage workbook saved in the database. If this is the case, all you need to do is run lineage.sql.

Using Discoverer with Oracle Application Server Login Server

The Oracle Application Server Login Server provides a framework which allows any web-based client, inside or outside of Oracle Application Server Portal, to use Oracle's Single Sign On (SSO) services. Oracle Application Server Login Server is intended for use with an LDAP server which provides the means for storing and managing all the user credentials.

Using Discoverer with Oracle Application Server Portal

You can publish Discoverer workbooks and worksheets to Oracle Application Server Portal quickly and easily. Oracle Application Server Portal's intuitive user interface guides you through the publishing process step by step, enabling you to create powerful business intelligence portals with ease.

For more information about publishing to Oracle Application Server Portal, see the Oracle Business Intelligence Discoverer Plus User's Guide.