1 / 53

Everbody Needs Publishing Oracle Reports is what you need!

Session id: 40157. Everbody Needs Publishing Oracle Reports is what you need!. Philipp Weckerle Principal Product Manager Oracle Corporation. Publishing Through the Ages …. Monthly Employee Report. EMPNO ENAME JOB MGR HIREDATE SAL 7369 SMITH CLERK 7902 17-DEC-80 800

marsden-emerson
Download Presentation

Everbody Needs Publishing Oracle Reports is what you need!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Session id: 40157 Everbody Needs PublishingOracleReports is what you need! Philipp WeckerlePrincipal Product Manager Oracle Corporation

  2. Publishing Through the Ages …

  3. Monthly Employee Report EMPNOENAMEJOBMGRHIREDATESAL 7369 SMITH CLERK 7902 17-DEC-80 800 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 7521 WARD SALESMAN 7698 22-FEB-81 1250 Fast-forwarding a little … !

  4. Challenge - Data Sources Oracle OLAP JDBC Text Files Web Services

  5. Challenge - Output Formats

  6. Challenge - Output Destinations

  7. ReportingEngine Lineage OLAPEngine TransformationEngine Name/Address Scrubbing Database Portal ETL Tool Analytic Apps Clickstream Tool MiningEngine Query & Analysis Enterprise Reporting TransformationEngine A broader view of the Business Intelligence Market…… • Protracted and complex implementation • Escalating maintenance costs • Poor and incomplete BI solution

  8. Oracle Business IntelligenceSingle Vendor e-Business Intelligence

  9. Oracle9i Reports – What is it? A powerful enterprise reporting RAD tool that allows developers to publishany data, in any format, anywhere

  10. OracleReportsany datalany formatlanywhere

  11. Publishing ALL the RIGHT data • Out-of-the-box : • Oracle Database • PL/SQL Ref-Cursor • JDBC • XML • Oracle Express • Oracle OLAP • Text Files • Open Java-API to add new data sources • Parameter support for queries • Unlimited # queries • Link queries

  12. XML SQL SQL XML Pluggable Data Sources - Design time

  13. Pluggable Data Sources - Runtime XML SQL

  14. Any Data • Unlimited queries • Multiple concurrent connections • Join data from different sources • Re-entrant wizards • Bind- and lexical parameters

  15. OracleReportsany datalany formatlanywhere

  16. GIF89a hyperlinks JavaScript Paper v’s Web Publishing X” Y”

  17. GIF89a hyperlinks JavaScript Paper v’s Web Publishing

  18. Single Definition Publish to Paper Publish to Web

  19. FlexibleFormatting Excel RTF Web PDF & Printer XML

  20. PCL, Postscript, PDF, RTF Delimited, Text HTML, XML Any tagged format Any Format • Unlimited formatting – full control over layout & formats • Exception formatting, Personalization via XML • Multi-byte character support for PDF, HTML, RTF…

  21. PDF 1.4 Support • Compression • Multi-byte fonts • Font Embedding& Subsetting • Accessibility • PDF Taxonomy

  22. Java Importer • PL/SQL wrappers generated for Middle Tier Java • Interface between Reports and Java • Use Java as an integration layer: • Web Services • SOAP • CORBA

  23. Any Format • Specialized technologies for paper and web publishing • Various output-formats • High-fidelity graphing • Access for middle-tier Java

  24. Oracle Reportsany datalany formatlanywhere

  25. Anywhere • Standards-based deployment – JSP and Servlet • Open Java-API to add your own destinations and notifications • Out-of-the-box: Printer, File, Browser, E-Mail, Oracle9iAS Portal, WebDAV, FTP • OTN : OracleAS Wireless

  26. Report Bursting • Different Layouts • Different Destinations • Email • Different Recipients • Printer • File • … • Different Output Formats • HTML, HTMLCSS, PDF,Text, RTF, XML, delimited, PostScript, PCL

  27. Destination: Email From: “Sys Admin” <reports@oracle.com> To: “Random, Joe” <joe.random@oracle.com> CC: “Accounts” <accounts@oracle.com> Bcc: “ceo_account” <ceo@oracle.com> Subject: August Monthly Sales Figures Reply-to: <accounts@oracle.com> Importance: High Return Receipt: No • Internet standard SMTP • Static or dynamic values for ALL settings • specify report as body or attachment

  28. Anywhere • Open Java-API for creating your own destination • Powerful distribution facilities • Bursting of Report Sections to different destinations • Enhanced email support

  29. Declarative RAD environment for creating Web and paper reports in Oracle9i Developer Suite High-Fidelity Enterprise Publishing for the Web and paper in Oracle9i Application Server Oracle Reports at a glance… DEVELOPMENT Oracle Reports Developer DEVELOPMENT Oracle Application Server Reports Services

  30. Management &Security e-Business Integration Portals J2EE & Internet Apps Wireless BusinessIntelligence Caching

  31. Rapid Development with Wizards • Data modeling, paper and web layouts, graphs

  32. Standards Based • JSP’s used as the underlying technology • Separate out dynamic and static parts of a web page • Compiled for fast execution • Java and any markup language (typically HTML) … Your hostname: <%= request.getRemoteHost() %>. <LI><B>Declaration (plus expression).</B><BR> <%! private int accessCount = 0; %> Accesses to page since server reboot: <%= ++accessCount %>

  33. Internet Architecture – A Closer Look Oracle Application Server Destinations, Notifications Data Sources Report Definition User Access Oracle Developer Suite

  34. How to access the Server Oracle9iAS Reports Services

  35. Reducing complexityOut-of-the-box Integration • Oracle9i JDeveloper • Oracle Application Server Portal • Oracle BI beans • Oracle Forms Developer • Oracle Application Server Discoverer • Oracle Enterprise Manager Application Server Console • Oracle Application Server Single Signon • Oracle Applciation Server Containers for J2EE • Oracle SCM • ……

  36. XML Out-of-the-box IntegrationOracleAS Discoverer Enterprise Reporting Adhoc Query & Analysis

  37. Migration fromOracleAS Portal – Report Component

  38. Oracle Reports Portlets

  39. Oracle OLAP Data Source • Unleash the power of the Oracle9i Database with built-in OLAP • Wizard-based interface to pick Business Areas, Dimensions, and Measures

  40. Oracle JDeveloper Integration • Create, Run, Debug JSP’s • Create new Destinations • Registered JSP Tag Library

  41. Oracle Workflow Integration • Reports available as Workflow Activity

  42. Single Sign-On • Application Security • Secure report resources • Data Security • Secure data source access • User logs on ONCE and canSECURELY run a report against any numberof data sources

  43. Open Infrastructure Oracle9iReports Security Service Destinations Plug-In Interface Engines Notifications Cache Manager

  44. OracleAS Reports ServicesScheduling • Any job can be scheduled for • Delayed execution schedule=last_weekday_before_15_from_15:53_Oct_23,_2001_retry_after_1_hour • Repeated execution schedule=every_first_fri_of_month_from_15:53_Oct_23,_2001_retry_3_after_1_hour

  45. Email, Wireless ? Pluggable Notifications • Open Java API • Create your own notification mechanisms

  46. Enterprise Manager Integration • Start/Stop/Restart • Performance metrics • Queue Information • Trace Information • Modify Configuration

  47. D E M O N S T R A T I O N

  48. Summary • Access the data that is important to you • Create output in any Format • Securely Publish Anywhere • Tightly Integrated Component of OracleApplication Server and Oracle Developer Suite

  49. Next Steps…. • Recommended sessions • Integrated Business Intelligence • Recommended demos and/or hands-on labs • Integrated Business Intelligence Hands-On lab • Oracle Reports on the DEMOgrounds • See Your Business in Our Software • Visit the DEMOgrounds for more information. • Relevant web sites to visit for more information • http://otn.oracle.com/products/reports

More Related