Saturday, February 14, 2009

Tryst with OBIEE

OBIEE.. My understanding of OBIEE was that it was an extension of BIPublisher with the abilities to create, share, distribute reports in a much easier way. Well, Oracle Business Intelligence Standard Edition was but not OBIEE. And I realized it only after I had installed OBIEE on my laptop.

Installing OBIEE on my machine was a cakewalk. It was not all that complex. I downloaded OBIEE Enterprise Edition v10. from Oracle. I also went through Abhinav's post on installation steps. After the installations completed, I was able to login into OBIEE using Administrator/Administrator user name/password. 

The following services get  installed with OBIEE.

  • Oracle BI Server
    Connects to a wide range of relational and OLAP datasources and provides access, via a business metadata layer, to an integrated data set including calculations, aggregations, and KPIs. The default port where this service runs is 9703. 

  • Oracle BI Presentation Server
    Connects via ODBC to Oracle BI Server and provides interactive dashboards, reports, and data visualizations through a consistent, dynamic HTML interface. This default port for this service is 9704. The link used to access OBIEE will refer to this port.

  • Oracle BI Scheduler (Oracle BI Delivers)
    Works alongside Oracle BI Presentation Server to schedule reports and create workflows that perform actions based on alerts and thresholds defined by users. The default port for this is 

  • Oracle BI Java Host
    This service provides presentation services for charts, PDFs and Guages. 

  • Oracle BI Publisher
    This is not a service but a product.  This Provides "boardroom-quality" reports using data sourced from relational databases, Oracle BI Answers requests, Oracle BI Discoverer workbooks, and the Oracle Business Intelligence Enterprise Edition metadata layer
I'll post more articles on OBIEE as I learn more...


  1. Hi Murukku,

    Keep up the good work!



  2. excellent piece of information, I had come to know about your website from my friend kishore, pune,i have read atleast 8 posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a lot once again, Regards, obiee training in hyderabad