New Oracle University Course: BI 11g Sys Admin

Oracle University has published a new online Oracle BI EE 11g course, "Oracle BI 11g R1: Introduction to System Administration - Online Course". It is in a self-study format, and is intended to allow users to learn how to manage Oracle BI 11g:

• Fusion Middleware (FMW) Control to monitor manage, and configure Oracle BI system components
• Oracle WebLogic Server (WLS) Administration Console to monitor and manage Oracle BI JEE Java components
• Oracle Process Manager and Notification Server (OPMN) Tool to manage Oracle BI system components
• Oracle BI Administration Tool to perform administrative tasks.

The course topics are:

• Oracle BI System Administration Overview
• Managing Oracle Business Intelligence
• Configuring the Oracle BI SystemStarting and Stopping Oracle BI
• Scaling an Oracle BI Deployment
• Deploying Oracle BI For High Availability
• Managing Performance Tuning and Query Caching
• Diagnosing and Resolving Issues in Oracle BI
• Managing Usage Tracking
• Oracle BI Security

Downloading Discoverer 11g

Go to http://www.oracle.com/technology/software/products/middleware/htdocs/111110_fmw.html and accept the license.

Browse down to the section that says "Portal, Forms, Reports and Discoverer". 
Currently there are downloads available for Windows and Linux:

• Windows x86: Disk1 (File 1) , and Disk1 (File 2)
• Linux: Disk1 (File 1), and Disk1 (File 2)

 As you would expect, this download contains the familiar set of components; I have highlighted in bold the ones that are relevant for Discoverer:

• HTTP Server
• WebCache
• Forms Services
• Forms Builder
• Reports Services
• Report Builder/Compiler
• Discoverer Administrator
• Discoverer Plus
• Discoverer Viewer
• Discoverer Services
• Discoverer Desktop
• Enterprise Manager Fusion Middleware Control

 Now, unlike the previous release of Discoverer, 10g, where you could install the standalone version of Discoverer and be up and running, here you need a few more components in order to be able to install Discoverer, and these need to be installed in a specific order.

• WebLogic Server
• Repository Creation Utility
• Identity Management
• SSO Metadata Repository Creation Assistant
• Identity Management 10gR3
• Oracle Database

WebLogic Server is easy enough to understand: it, or WLS as it is commonly referred to as, is the app server that is front and center in Oracle's middleware suite.
Repository Creation Utility, or RCU as it is sometimes referred to, is used to create your repository on the target database.

SSO Metadata Repository Creation Assistant is optional for Discoverer - if you do not intend configuring Discoverer to run under Single Sign-On, then skip this.

An Oracle Database 11g, Enterprise Edition, is what the last item refers to, and this is where the Discoverer repository is created by the RCU. Similar to the "Infrastructure" database in 10g.

Have fun downloading, and patience too, as these are downloads totaling several gigabytes.

More later.

Discoverer 11g Doc

If you see the Discoverer 11g Documentation library at http://download.oracle.com/docs/cd/E12839_01/pfrd.htm, you will notice the familiar set of docs, with one new addition. There is now a doc for the Discoverer Web Services. The "Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Web Services API", 11g Release 1 (11.1.1), Part Number E10412-01 can be viewed at http://download.oracle.com/docs/cd/E12839_01/bi.1111/e10412/toc.htm, or downloaded as a PDF from http://download.oracle.com/docs/cd/E12839_01/bi.1111/e10412.pdf

As a brief intro, these web services are a layer of SOAP based web services that sit on top of Discoverer, provide access to a variety of functions, and provide a level of abstraction from the underlying implementation of the functionality that these services expose.

The very first instance where these web services were used was in the integration between BI Publisher and Discoverer (see my posts on this topic from 2007), that happened with the BI Publisher 10.1.3.3.0 release and Discoverer 10.1.2.2 release in 2007. Actually, there was a one-off patch that had to be applied on top of Discoverer 10.1.2.2 which contained the web services libraries. However, these web services were not yet meant to be consumed externally by customers for building their custom integrations. The intent was to document these and release them with the Discoverer 11g release. There is a slightly fascinating history behind the evolution of this project that I will try and blog about in a future post.

The other place where these web services shall be used is in the integration of Discoverer with the Oracle Business Intelligence Suite Enterprise Edition Plus, also referred to sometimes as simply OBIEE. Specifically, and since this is about functionality not yet released, please bear in mind that some or all of this could change, so do not take this as official Oracle communication, the intent is to use these Discoverer web services to publish Discoverer worksheets to an OBIEE Dashboard page, and to also use these same web services to allow OBIEE Delivers to run and send Discoverer worksheets on a scheduled basis.

More later.

Oracle FMW 11g

Use this link - http://www.oracle.com/features/hp/oracle-fusion-middleware-11g-launch.html - to register for the event.

Apart from the very important reason that Fusion Middleware is the technology platform and foundation of Fusion Applications, Fusion Middleware 11g is also the vehicle for the release of Discoverer 11g.