OBIEE

• It is a query tool
• It has far more rich features than Discoverer
• It is completely web based design
• It came with Siebel acquisition, Siebel got it from nQuire Software in 2001, it was
designed to be database/Applications vendor independent

Design
• Clients
• Oracle BI Presentation Services
• Oracle BI Server
• Data Sources
• Clients
– Oracle BI Answers to build Requests (Reports)
– BI Dashboards to Display results of the Answers Requests
– BI Administration Tool to build repository
• Oracle BI Presentation Services
– Renders pages
– Extension to Web Server
– Users a catalog folder to store user content
– Acts as an intermediary, receives data from Oracle BI server and provides it to the client.
• Oracle BI Server
– Uses the RPD file (metadata) to form dynamic SQL
– It can connect natively (Oracle OCI) or through ODBC to the RDBMS
– It Structures the results set
• Data Sources
– Relational Database, OLAP databases, Flat Files, Spreadsheets, XML files
Components:
• Oracle BI Scheduler
– Just like Concurrent Manager, it schedules Answers Requests, Scripts,Alerts
• Oracle BI Delivers
– Few Web pages that allows us create alerts based on Answers Requests
– IBOTS (OBIEE provides few web pages that allows us to create alert setups)
– It works with the Scheduled
• BI Administration tool to manage Analytics Metadata RPD files
– (Windows Based only)