By Arthi Subramanian CIS 764 Fall 2008

Зарегистрируйтесь, чтобы просмотреть полный документ!

By: Arthi Subramanian CIS 764 – Fall 2008

Business Intelligence: Business intelligence (BI) is a broad category of applications and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions. Present Day Challenges: Ø Massive amount of data availability. Ø Data spread over multiple resources. Ø Publishing information in a secure, reliable manner.

The solution came from…. In the form of Oracle Reports - Oracle Reports is the enterprise reporting component of Oracle’s BI offering. It enables an organization to convert data into information, and publish the information securely and reliably

Rapid Development n Each major task in report generation – taken care of by a wizard. Eg: Query wizard, report wizard, graph wizard n Customization – report templates and WYSIWUG live previews n Creating complex data models – drag and drop actions n Re-entrant wizard technology

Publish data in a transparent way n Oracle Reports provides an access to multiple data sources. Eg: manufacturing organization n It supports SQL, PL/SQL, XML, JDBC, Oracle OLAP, and text files. JDBC data source can be used to access data from different JDBC-compliant data sources, and JDBC-ODBC bridge can be used to connect to any data that can be exposed as an ODBC data source. n With Oracle Reports, the source of data is transparent, because data coming from any data source is available to you in exactly the same representation.

Publishing the Report n Oracle Reports caters to different audiences usingle report definition. 1) Paper based publishing : § Established way. § O/P can be generated in HTML, PDF, HTMLCSS, Word-compatible, Excel-compatible etc…. § Can be sent to the printer (Post. Script).

2) Publishing as dynamic web pages: No page boundaries. Needs to be dynamic. Adding elements to Web pages -Using custom JSP tags, Java. Beans or regular Java code JSP format -develop once, deploy anywhere principle of Oracle Reports. Why JSP-based Web reports ? i) separation of dynamic and static content. ii) Support of scripting and tags iii) Reuse, portable, easy to use iv) Deployed to produce both paper and Web output.

Deployment n Easy deployment on server. n Paper based reports : Copy definition file to location accessible by the server. n Web-based reports : Copy to J 2 EE Application Server / deploy as part of EAR file.

Security and Reliability Ø Oracle Portal user interface: § Secure reports by registering with Oracle Application Server security framework. § Define which users or groups are authorized to access, view, or manage the resources. ØOracle Application Server High Availability: • Industry’s most reliable, resilient, and fault-tolerant application server platform. • Oracle Reports is integrated with Oracle AS High Availability.

Conclusion Oracle Reports: - the most flexible enterprise-reporting tool in the market today - is reliable - is integrated - is extensible

References n Books: n Oracle Reports - Pinnacle Software Solutions n Oracle Developer Advanced Forms and Reports (Paperback) by Peter Koletzke (Author) and Paul Dorsey (Author) n Web References: n About Oracle Reports: http: //download. oracle. com/docs/html/B 10612_01/toc. htm n Oracle Reports – The basics http: //www. scribd. com/doc/3960412/Basic 2 -Oracle-Reports-10 g-Tutorials

Скачать презентацию By Arthi Subramanian CIS 764 Fall 2008

1df0d0303504a8bcc77db8f064e06295.ppt

Количество слайдов: 12