slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Everbody Needs Publishing Oracle Reports is what you need! PowerPoint Presentation
Download Presentation
Everbody Needs Publishing Oracle Reports is what you need!

Loading in 2 Seconds...

play fullscreen
1 / 53

Everbody Needs Publishing Oracle Reports is what you need! - PowerPoint PPT Presentation


  • 86 Views
  • Updated on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - 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