|





Comparison - Oracle Discoverer & BI Publisher

r

© 2010 Wipro Ltd - Confidential

Licensing Mechanism

Oracle Discoverer : Server : Server Based Developer : Desktop Based Viewer : Named license.

Oracle BI Publisher Server : Server Based Developer/Viewer : Named license

h

© 2010 Wipro Ltd - Confidential

Oracle Discoverer ² Advantages and Challenges ‡ Oracle Discoverer is an ad-hoc query and analysis tool. ‡ End s can interactively navigate, drill down, slice and dice, aggregate and add calculations ² easy to use. ‡ Work sheets can be customized at portal level for each . ‡ Multi-dimensional view and drill-down analysis through drag-n-drop ‡ Seamless integration with Metadata of Oracle Warehouse Builder ‡ Lack of Distribution Automation, Distribution Security ‡ Limited Formats ed ‡ Oracle native connection, no multiple data sources, other RDBMS via ODBC only ‡ Longevity of the Discover tool since Oracle promotes BI Suite. ‡ Reporting capabilities are limited to single block (only one graph/crosstab/table). ÿ

© 2010 Wipro Ltd - Confidential

Oracle BI Publisher ² Advantages and Challenges ‡ It is a scheduling and Publishing tool for Oracle BI Tools. ‡ Access data from multiple, disparate data sources into a single Data Model. ‡ Seamless integration with Oracle BI Tools. ‡ Integration with Oracle BI, AS, E-business suite, JD Edwards. ‡ s standard report features like drill down, slice and dice.

‡ Can not combine data from multiple data source. ‡ Basically as data presentation tool for analysis. ‡ Not an Ad-hoc reporting tool

å

© 2010 Wipro Ltd - Confidential

Summary & Conclusion

*

X

As per verbal confirmation from Oracle, Oracle Discoverer does not come bundled with Oracle DB 11g.

X

According to the discussions with Oracle, Oracle BI suite would be the preferred reporting/ analytics tool as per the Organization roap.

X

ETL tool (ODI/OWB) required to access multiple data sources for both Oracle Discoverer and BI Publisher.

X

Based on the above Oracle BI publisher would be preferred reporting tool option from Oracle.

© 2010 Wipro Ltd - Confidential

ü